Table Description
Food Stamps Household Evidence: A member of the household.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Sample::Service Layer::Food Stamps Assessment::entity::FS Household Evidence::FSHouseholdEvidence
Controlling File: sample\model\Sample.emx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fsHouseholdEvidenceIDkeynoSystem generated unique identifier for the FSHouseholdEvidence recordFS_HOUSEHOLD_EVIDENCE_ID SVR_INT64
concernRoleIDdetailsnoThe ID of the household memberCONCERN_ROLE_ID SVR_INT64
citizenshipCodedetails The citizenship code of the household memberCITIZENSHIP_CODECitizenshipCodeSVR_STRING<10>
disabledInddetails Indicates if the household member is disabledCURAM_INDICATOR SVR_BOOLEAN
prepareMealsInddetails Indicates if the household member is preparing meals with the head of household.CURAM_INDICATOR SVR_BOOLEAN
rshipToHOHdetails The relationship of the household member to the head of household.RELATIONSHIP_TYPE_CODERelationshipTypeCodeSVR_STRING<10>
strikerInddetails Indicates if the household member is on strike.CURAM_INDICATOR SVR_BOOLEAN
statusCodedetails The status of the FSHouseholdEvidence recordRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
FSHouseholdEvidence.concernRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
FSHEvidenceIdxconcernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fsHouseholdEvidenceID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByKeyConcernRoleIDnsread To retrieve a FSHouseholdEvidence for a particular concernRoleID 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
To update the status of a fsHouseholdEvidence record 
Related Pages (35)
Delete Household Member: (IncomeScreening_cancelHouseholdMember)
New Benefit Evidence: (IncomeScreening_createBenefitEvidence)
Capture Head of Household Details: (IncomeScreening_createCase)
New Household Member: (IncomeScreening_createHouseholdMember)
New Income Evidence: (IncomeScreening_createIncomeEvidence)
New Medical Expense: (IncomeScreening_createMedicalExpenseEvidence)
New Resource Evidence: (IncomeScreening_createResourceEvidence)
New Shelter Expense: (IncomeScreening_createShelterExpenseEvidence)
Household Benefits: (IncomeScreening_enterBenefitEvidence)
Household Expenses: (IncomeScreening_enterExpenseEvidence)
Household Members: (IncomeScreening_enterHouseholdMembers)
Household Income: (IncomeScreening_enterIncomeEvidence)
Household Resources: (IncomeScreening_enterResourceEvidence)
Income Screening Home: (IncomeScreening_home)
Household Benefits: (IncomeScreening_listBenefitEvidence)
Household Expenses: (IncomeScreening_listExpenseEvidence)
Household Members: (IncomeScreening_listHouseholdMember)
Household Income: (IncomeScreening_listIncomeEvidence)
Household Resources: (IncomeScreening_listResourceEvidence)
Modify Benefit Evidence: (IncomeScreening_modifyBenefitEvidence)
Modify Household Member: (IncomeScreening_modifyHouseholdMemberFromList)
Modify Household Member: (IncomeScreening_modifyHouseholdMemberFromView)
Modify Income Evidence: (IncomeScreening_modifyIncomeEvidenceFromList)
Modify Income Evidence: (IncomeScreening_modifyIncomeEvidenceFromView)
Modify Medical Expense: (IncomeScreening_modifyMedicalExpenseEvidenceFromList)
Modify Medical Expense: (IncomeScreening_modifyMedicalExpenseEvidenceFromView)
Modify Resource Evidence: (IncomeScreening_modifyResourceEvidenceFromList)
Modify Resource Evidence: (IncomeScreening_modifyResourceEvidenceFromView)
Modify Shelter Expense: (IncomeScreening_modifyShelterExpenseEvidenceFromList)
Modify Shelter Expense: (IncomeScreening_modifyShelterExpenseEvidenceFromView)
View Household Member Details: (IncomeScreening_viewHouseholdMember)
View Income Evidence Details: (IncomeScreening_viewIncomeEvidence)
View Medical Expense Details: (IncomeScreening_viewMedicalExpenseEvidence)
View Resource Details: (IncomeScreening_viewResourceEvidence)
View Shelter Expense Details: (IncomeScreening_viewShelterExpenseEvidence)