Table Description

Head of Household: This evidence captures details about the case member who is responsible for the household in relation to that program.

Example

A case worker creates a Head of Household record for Linda Smith. Linda Smith is the mother of Susan Smith who is a dependent child. Linda and Susan Smith reside in the same household and are eligible for Cash Assistance.
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::Evidence::Service Layer::Entity::Household::HeadOfHousehold::HeadOfHousehold
Controlling File: Evidence\model\ServiceLayer\entity\Household\HeadOfHousehold\HeadOfHousehold_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Head of Household record. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Head of Household. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
commentsdetails 

Additional details related to the Head Of Household record. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
startDatedetails 

The date on which that member started acting as the Head of Household. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date until which that member acted as the Head of Household. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
programdetails 

The program under which the household is requesting benefits. Examples include: Food Assistance, Cash Assistance, etc. This is populated from the 'AssistanceType' code table. The UI field name for this attribute is 'Program Type'.

EVD_ASSISTANCE_TYPE_CODEAssistanceTypeSVR_STRING<10>
Foreign Keys (1)
ChildParent
HeadOfHousehold.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_802705533caseParticipantRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
Related Pages (19)