Table Description

Absent Parent Child Support: This evidence captures child support payments given by the absent parent, for the benefit of his/her child, who is living in the household.

The child support payments are considered part of household income and may affect household eligibility for certain programs. Failure to provide details of child support payments can result in the loss of benefit or sanctions against a household member. This evidence is related to the Child Support Enforcement record of a household member. Absenteeism is a child record that can share a parent / child relationship with both an Absent Parent, and a Child Support Enforcement record.

Example

Linda Smith has a dependent child, Susan Smith. Susan Smith's father John Smith is an absent parent from the home. Linda Smith has complied with the Child Support Enforcement Department and John Smith is now making child support payments to Linda Smith in respect of Susan Smith. A case worker creates an Absent Parent Child Support record for the payments that Linda Smith is receiving from John 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::Income::AbsentParentChildSupport::AbParChildSupport
Controlling File: Evidence\model\ServiceLayer\entity\Income\AbsentParentChildSupport\AbsentParentChildSupport_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (16)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

The system generated unique identifier for the Absent Parent Child Support.

EVIDENCE_ID SVR_INT64
chdCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the child, for whom the payments are being made.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
childSupportTypedetails 

This refers to whether the absent parent is making the child support payments on a voluntary basis, or due to a Court Order. Examples include: Voluntary, Court Order, etc. This is populated from the 'ChildSupportType' code table. The UI field name for this attribute is 'Child Support Type'.

EVD_CHILD_SUPPORT_TYPEChildSupportTypeSVR_STRING<10>
courtOrderNumberdetails 

If there is a Court Order, then the Court Order Number is specified here. The UI field name for this attribute is 'Court Order Number'.

EVD_AP_COURT_ORDER_NUMBER SVR_STRING<30>
courtOrderDatedetails 

If there is a Court Order, then the date on which the Court Order was passed is specified here. The UI field name for this attribute is 'Court Order Date'.

CURAM_DATE SVR_DATE
childSupportPmtAmountdetailsyes

The amount of the child support payment received from the absent parent. The UI field name for this attribute is 'Payment Amount'.

CURAM_AMOUNT SVR_MONEY
childSupportPmtFrequencydetailsyes

This refers to how often the child support payments are received from the absent parent. The Examples include: Monthly, Weekly, Bi-weekly, etc. This is populated from the 'FrequencyCode' code table. The UI field name for this attribute is 'Payment Frequency'.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
childSupportPmtMethoddetails 

The method by which this particular Absent Parent Child Support payment was made. The options can be: Cash, Check, etc. The UI field name for this attribute is 'Payment Method'.

EVD_AP_PAYMENT_METHOD SVR_STRING<10>
childSupportPmtDueDatedetails 

If the payment (for that cycle) is yet to be received, the date by which the payment is expected will be entered here. The UI field name for this attribute is 'Payment Due Date'.

CURAM_DATE SVR_DATE
childSupportLastPmtAmountdetails 

The amount received towards child support in the previous payment cycle. The UI field name for this attribute is 'Last Payment Amount'.

CURAM_AMOUNT SVR_MONEY
childSupportLastPmtDatedetails 

The date on which the previous Absent Parent Child Support Payment was received. The UI field name for this attribute is 'Last Payment Date'.

CURAM_DATE SVR_DATE
commentsdetails 

Details related to the Absent Parent Child Support Payments. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
repCaseParticipantRoleIDdetails 

The Case Participant Role ID of the household member who receives the Child Support Payment from the absent parent on behalf of the child. The UI field name for this attribute is 'Absent Parent Name Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
obligatedAmountdetails 

The amount that the absent parent is obliged to pay, or has been ordered to pay by the Court, towards child support. The UI field name for this attribute is 'Obligated/Court Ordered Amount'.

CURAM_AMOUNT SVR_MONEY
startDatedetails 

The date on which the first Absent Parent Child Support Payment was received. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date on which the very last Absent Parent Child Support Payment was received. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
AbParChildSupport.chdCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_586799969chdCaseParticipantRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
transferEvidence    
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified Absent Parent Child Support ID. 
Related Pages (3)