Table Description

Living Arrangement: This evidence captures details about a Household Member's place of residence.

Types of living arrangements include:Home, Homeless, Institution, etc. Facility details are captured for Household Members residing in institutions.

Example

A case worker creates a Living Arrangement record for Linda Smith who is residing in her home on a permanent basis.

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::LivingArrangement::LivingArrange
Controlling File: Evidence\model\ServiceLayer\entity\Household\LivingArrangement\LivingArrangement_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Living Arrangement. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member for whom the Living Arrangement record is created. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
livingArrangeTypedetails 

The type of Living Arrangement. Examples include: Home, Foster Care, Adult Relative, etc. This is populated from the 'livingArrangementType' code table. The UI field name for this attribute is 'Arrangement Type'.

EVD_LIVING_ARRANGEMENT_TYPELivingArrangementTypeSVR_STRING<10>
livingArrangeStatusdetails 

The individual's Living Arrangement status. Examples include: Permanent, Temporary, etc. This is populated from the 'LivingArrangementStatus' code table. The UI field name for this attribute is 'Arrangement Status'.

EVD_LIVING_ARRANGEMENT_STATUSLivingArrangementStatusSVR_STRING<10>
facCaseParticipantRoleIDdetailsyes

The Case Participant Role ID for the facility. The UI field name for this attribute is 'Facility Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
numMealsPerDaydetails 

The number of meals received per day, as part of the Living Arrangement. The UI field name for this attribute is 'Number of Meals per Day'.

EVD_NUMBER_OF_MEALS SVR_INT16
drugAlcAddictInddetails 

Indicates whether the individual is a drug addict or an alcoholic. The UI field name for this attribute is 'Addicted to Drugs or Alcohol'.

CURAM_INDICATOR SVR_BOOLEAN
startDatedetails 

The start date of the Living Arrangement. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
probableEndDatedetails 

The probable end date of the Living Arrangement type. The UI field name for this attribute is 'Probable End Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Living Arrangement type. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
commentsdetails 

Additional details related to the Living Arrangement. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
LivingArrange.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
LivingArrange.facCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND__935586504caseParticipantRoleID
IND_2026318280facCaseParticipantRoleID
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 (13)