Table Description

Dependent Care Expense: A payment made by a household member, in respect of the care of a dependent.

Example

Linda Smith has a dependent child Susan Smith. Linda Smith is working full time and has placed Susan Smith in a creche while she is working. Linda Smith must pay the creche for providing care to Susan Smith. A case worker creates a Dependent Care Expense for Linda Smith, in respect of Susan Smith.
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::Expenses::DependentCare::DependentCareExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\DependentCare\DependentCare_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Dependent Care Expense. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
recipientCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the person for whom the Dependent Care Expense payment is being made. The UI field name for this attribute is 'Care Recipient Name'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
amountdetails 

The amount of the Dependent Care Expense. The UI field name for this attribute is 'Amount'.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

The frequency of the Dependent Care Expense payments. Examples include: Weekly, Monthly, etc. This is populated from the 'FrequencyCode' code table. The UI field name for this attribute is 'Frequency'.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
dependCareReasondetails 

The reason due to which the dependent care is required. Examples include: Accept/Continue Employment, Seek/Attend School/Training, etc. This is populated from the 'DependentCareReason' code table. The UI field name for this attribute is 'Reason'.

EVD_DEPENDENT_CARE_REASONDependentCareReasonSVR_STRING<10>
totalHoursPerWeekdetails 

The number of hours per week that the dependent is in care. The UI field name for this attribute is 'Total Hours Per Week'.

EVD_HOURS SVR_INT16
lastPaymentDatedetails 

The date on which the last Dependent Care Expense payment was made. The UI field name for this attribute is 'Last Payment Date'.

CURAM_DATE SVR_DATE
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member who is making the Dependent Care Expense payments. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
commentsdetails 

Additional details related to dependent care. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
pvdCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the care provider. The UI field name for this attribute is 'Care Provider'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
reimbursedAmountdetails 

The amount which was reimbursed to the Household Member for the Dependent Care Expense payment he/she has made. The UI field name for this attribute is 'Reimbursed Amount'.

CURAM_AMOUNT SVR_MONEY
reimbursementTypedetails 

The type of reimbursement. Examples include: Insurance Company, Federal Assistance Program, etc. This is populated from the 'ReimbursementType' code table. The UI field name for this attribute is 'Reimbursement Type'.

EVD_EXPENSE_REIMBURSEMENT_TYPEReimbursementTypeSVR_STRING<10>
startDatedetails 

The date from which the Dependent Care Expense started. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date until which the Dependent Care Expense ended. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (3)
ChildParent
DependentCareExpense.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
DependentCareExpense.recipientCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
DependentCareExpense.pvdCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (3)
Index NameAttributes
IND__138865027caseParticipantRoleID
IND__1704780110recipientCaseParticipantRoleID
IND_828688397pvdCaseParticipantRoleID
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)