Table Description

Deprivation: This evidence captures details of a child's lack of parental support in the household.

Deprivation means that at least one of the child's natural or adoptive parents is absent, incapacitated, underemployed/unemployed, or deceased.

Example

Susan Smith is a dependent child who resides with her mother. Susan Smith's father does not reside in the household as her parents are divorced. A case worker creates a Deprivation record for Susan Smith to record the fact that Susan lacks the parental support of her father.
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::Deprivation::Deprivation
Controlling File: Evidence\model\ServiceLayer\entity\Household\Deprivation\Deprivation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the minor Household Member who is deprived of parental support of one or more parents. The UI field name for this attribute is 'Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
deprivationReasondetails 

The reason the child is deprived of parental support. Examples include: Birth Out of Wedlock, Divorce, etc. This is populated from the 'DeprivationReason' code table. The UI field name for this attribute is 'Deprivation Reason'.

EVD_DEPRIVATION_REASONDeprivationReasonSVR_STRING<10>
parCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the parent depriving the child of parental support. The UI field name for this attribute is 'Parent Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
commentsdetails 

Additional details relating to the Deprivation. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
startDatedetails 

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

CURAM_DATE SVR_DATE
endDatedetails 

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

CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
Deprivation.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Deprivation.parCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND_495790394caseParticipantRoleID
IND__1730936179parCaseParticipantRoleID
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)