Table Description

Work Registration: This evidence captures details about a Household Member's Work Registration.

The eligibility rules shall determine if a client is required to register for work. Those clients who are not required to register for work do not need to register, but they can voluntarily register for work, if they wish to do so.

Example

Linda Smith is currently not employed. She applies for Food Assistance and is determined work eligible. Linda Smith registers for work with the agency. A case worker creates a Work Registration record for Linda Smith, and sets the registration status to 'Registered' and the Program type to 'Food Assistance'.
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::WorkRegistration::WorkRegistration
Controlling File: Evidence\model\ServiceLayer\entity\Household\WorkRegistration\WorkRegistration_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier of the Work Registration. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member for whom the Work Registration record is being created. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
programdetails 

The program for which the Work Registration is being recorded. Examples include: Cash Assistance, Food Assistance, etc. This is populated from the 'AssistanceType' code table. The UI field name for this attribute is 'Program'.

EVD_ASSISTANCE_TYPE_CODEAssistanceTypeSVR_STRING<10>
registrationStatusdetails 

The status of the Work Registration. Examples include: Registered, Failed to Register, etc. This is populated from the 'WorkRegistrationState' code table. The UI field name for this attribute is 'Work Registration Status'.

EVD_WORK_REGISTRATION_STATEWorkRegistrationStateSVR_STRING<10>
startDatedetails 

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

CURAM_DATE SVR_DATE
endDatedetails 

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

CURAM_DATE SVR_DATE
commentsdetails 

Additional details related to the Work Registration. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
WorkRegistration.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__973419553caseParticipantRoleID
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 (3)