Table Description

Work Requirements: This evidence captures the details of a household member's compliance with work requirements.

Work requirements are designed to strengthen the incentive to move from welfare to work. All able bodied adults and individuals 16/17 years of age who are not attending school are required to register for work and accept suitable work unless they have good cause. Failure to comply with the work requirements may lead to a sanction being imposed on the household member.

Example

A case worker creates a Work Requirement evidence record for Linda Smith. Linda Smith is not currently employed but is registered for work.
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::WorkRequirements::WorkRequirements
Controlling File: Evidence\model\ServiceLayer\entity\Household\WorkRequirements\WorkRequirements_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the household member who must register for work. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
failedWorkRegInddetails 

Indicates if the individual failed to register for work or be registered by the State agency at the time of application. The UI field name for this attribute is 'Registered for Work'.

CURAM_INDICATOR SVR_BOOLEAN
failedWorkProgInddetails 

Indicates if the individual failed to participate in work program when assigned by the State agency. The UI field name for this attribute is 'Failed to Report to Work Program'.

CURAM_INDICATOR SVR_BOOLEAN
failedWkfarePrgInddetails 

Indicates if the individual failed to participate in a workfare program when assigned by the State agency. The UI field name for this attribute is 'Failed to Participate in Workfare Program'.

CURAM_INDICATOR SVR_BOOLEAN
insuffInfoInddetails 

Indicates if the individual failed to provide the State agency with sufficient information regarding employment status or availability for work. The UI field name for this attribute is 'Insufficient Status Information'.

CURAM_INDICATOR SVR_BOOLEAN
failedEmprRepInddetails 

Indicates if the individual failed to report to an employer to whom he/she was referred by the State agency. The UI field name for this attribute is 'Failed to Report to Employer'.

CURAM_INDICATOR SVR_BOOLEAN
nonComplianceReasdetails 

The reason the member has not complied with the work requirements. This is populated from the 'WorkNonCompliance' code table. The UI field name for this attribute is 'Non-Compliance Reason'.

EVD_NON_COMPLIANCE_REASONWorkNonComplianceReasonSVR_STRING<10>
descriptiondetails 

Used if the non compliance reason of 'Other' is selected, to record why the member did not meet the work requirements. The UI field name for this attribute is 'Description'.

DESCRIPTION SVR_STRING<300>
commentsdetails 

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

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