Table Description

Absence: This evidence captures details of a household member's absence from the household.

Absence from the household may be temporary or permanent. If a household member indicates that they do not intend to return home, the absence is considered permanent. A household member may be absent for a number of reasons, for example, educational training or seeking medical treatment.

Example

Linda Smith is temporarily absent from the household because she is getting medical treatment in hospital. She intends to return home once the medical treatment is complete. The case worker creates an 'Absence' record for Linda Smith and indicates an intention to return home.
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::Absence::Absence
Controlling File: Evidence\model\ServiceLayer\entity\Household\Absence\Absence_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the household member who is temporarily away from the household. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails 

The date from which the member is temporarily absent from the household. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The last date until which the member was temporarily absent from the household. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
absenceReasondetails 

The reason the individual is temporarily absent from the household. A list of reasons is populated from the 'TemporaryAbsenceReason' code table. The UI field name for this attribute is 'Absence Reason'.

EVD_TEMPORARY_ABSENCE_REASONTemporaryAbsenceReasonSVR_STRING<10>
treatmentFacilTypedetails 

This refers to the type of facility where the treatment is being done. Examples include Hospital, Intermediate Care Facility, Institution, etc. This will be provided only if the reason for absence is 'Treatment'. This is populated from the 'TreatmentFacilityType' code table. The UI field name for this attribute is 'Treatment Facility'.

EVD_TREATMENT_FACILITY_TYPETreatmentFacilityTypeSVR_STRING<10>
commentsdetails 

Details relating to the absence. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
addressIDdetails 

The address where the absent member is staying, while he/she is away from the household. The appropriate address fields (depending on the Admin settings) are displayed in the UI, under the section named 'Address'.

ADDRESS_ID SVR_INT64
intentToReturnInddetails 

Indicates whether a household member who is absent, intends to return home. The UI field name for this attribute is 'Intention To Return Home'.

EVD_INTENT_TO_RETURN_IND SVR_BOOLEAN
outOfStateInddetails 

Indicates whether the absent member is residing out of state, during the absence period. The UI field name for this attribute is 'Out of State'.

CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (1)
ChildParent
Absence.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_1388408626caseParticipantRoleID
Operations (5)
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 
transferEvidence    
Related Pages (15)