Table Description

Child Support Expense: A periodic support payment made by a Household Member, in respect of a child who does not live with that member.

A child support payment is made by a non-custodial parent for the care and support of a child from a relationship or marriage that has been terminated.
The non-custodial parent is the Household Member and the recipient (who receives the payment on behalf of the child) and the child are not Household Members. Child support payments may be court ordered, or as a result of an agreement between the Household Member and recipient.

Example

John Smith is divorced from his former spouse Linda Smith. John and Linda Smith are no longer residing in the same household. John and Linda Smith have a dependent child who resides with Linda Smith. John Smith is making support payments to Linda Smith in respect of their dependent child. A case worker creates a Child Support Expense for John Smith, with details of their dependent child and the payment being made to Linda 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::ChildSupport::ChildSupportExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\ChildSupport\ChildSupport_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Child Support Expense. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
chdCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the child, for whom the support payments are being made. The UI field name for this attribute is 'Child Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
recipientCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the person who receives the child support payments, on behalf of the child. The UI field name for this attribute is 'Recipient Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
amountdetails 

The amount of the Child Support Expense. The UI field name for this attribute is 'Amount'.

CURAM_AMOUNT SVR_MONEY
obligatedAmountdetails 

The amount of the Child Support Expense that the member is obliged, by law, to pay. The UI field name for this attribute is 'Obligated Amount'.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

The frequency of occurrence of the 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>
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the household member who is making the child support payments. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
commentsdetails 

Additional details related to Child Support Expense. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
reimbursedAmountdetails 

The amount which was reimbursed to the Household Member. The UI field name for this attribute is 'Reimbursed Amount'.

CURAM_AMOUNT SVR_MONEY
reimbursementTypedetails 

The type of reimbursement. Examples include: Insurance Company, State 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 start date of the Child Support Expense. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

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

CURAM_DATE SVR_DATE
Foreign Keys (3)
ChildParent
ChildSupportExpense.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
ChildSupportExpense.recipientCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
ChildSupportExpense.chdCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (3)
Index NameAttributes
IND_1185558714caseParticipantRoleID
IND_898578709recipientCaseParticipantRoleID
IND__503937585chdCaseParticipantRoleID
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 
readCaseParticipantsByEvidenceIDnsread Method to return any case participant Role ID associated with the entity 
Related Pages (16)