Table Description

Child Support Enforcement: This evidence captures details of a Household Member's willingness to cooperate with the Child Support Enforcement Division (CSED) in locating the absent parent.

Cooperation means that the Household Member names the absent parent of any child for whom they are seeking aid and that the Household Member gives information needed to locate and obtain support from the absent parent. The Child Support Enforcement program is a Government program which ensures parents support their children when they do not live together.

Example

A case worker creates a Child Support Enforcement record for Linda Smith who has a dependent child Susan Smith. Susan Smith's father is absent from the household. Linda Smith is cooperating with the CSED so they can try to collect child support payments from the absent 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::ChildSupportEnforcement::ChildSupportEnforcement
Controlling File: Evidence\model\ServiceLayer\entity\Household\ChildSupportEnforcement\ChildSupportEnforcement_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsyes

The Case Participant Role ID of the Household Member providing the information. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
childCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the child who needs to be supported. The UI field name for this attribute is 'Child Name'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
assignSupportRightsInddetails 

Indicates if the Household Member is willing to assign all rights to support (both child and spousal). Assignment of support rights means that a person transfers their rights to receive some or all of their child/spousal support payments to the State. This is to pay the State back for public assistance benefits received. The UI field name for this attribute is 'Assign Support Rights'.

CURAM_INDICATOR SVR_BOOLEAN
cooperWithCSEDInddetails 

Indicates if the Household Member is willing to cooperate with the Child Support Enforcement Division (CSED). The UI field name for this attribute is 'Cooperate With Child Support Enforcement Division'.

CURAM_INDICATOR SVR_BOOLEAN
nonComplyReasondetails 

The reason the Household Member is refusing to cooperate with the Child Support Enforcement Division (CSED). This is populated from the 'NonCompliance' code table. The UI field name for this attribute is 'Non Compliance Reason'.

EVD_CSED_NON_COMPLIANCE_REASONCSEDNonComplianceReasonSVR_STRING<10>
commentsdetails 

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

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
ChildSupportEnforcement.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1673474014caseParticipantRoleID
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 (15)