Table Description

Employment Offer: A Household Member's acceptance or refusal of an offer of employment. A Household Member who refuses a bona fide offer of employment without a good cause is ineligible to receive certain benefits and may be subject to sanctions.

Example

Linda Smith is physically capable of working and has received an offer of employment. Linda Smith refuses the employment offer as she has a dependent child and adequate child care facilities are not available. A case worker creates an Employment Offer record for Linda Smith with the details of the offer of employment, and Linda Smith's reason for refusal.
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::EmploymentOffer::EmploymentOffer
Controlling File: Evidence\model\ServiceLayer\entity\Income\EmploymentOffer\EmploymentOffer_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Employment Offer. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member who was offered the employment. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
hoursPerWeekdetails 

The number of hours the member will be contracted to work per week. The UI field name for this attribute is 'Hours Per Week'.

EVD_HOURS SVR_INT16
paymentAmountdetails 

The wages the member is contracted to receive. The UI field name for this attribute is 'Payment Amount'.

CURAM_AMOUNT SVR_MONEY
paymentFrequencydetails 

The frequency at which the member will be paid during the course of the employment. Examples include: Daily, 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>
pieceRateInddetails 

Indicates if an individual is paid on a 'piece rate basis' (for a farmer, this would mean per plant). The UI field name for this attribute is 'Piece Rate Ind'.

CURAM_INDICATOR SVR_BOOLEAN
averageHourlyYielddetails 

The average hourly amount that will be paid to the member. The UI field name for this attribute is 'Average Hourly Yield'.

CURAM_AMOUNT SVR_MONEY
employmentStartDatedetails 

The date on which the employment is due to start. The UI field name for this attribute is 'Employment Start Date'.

CURAM_DATE SVR_DATE
employmentAcceptedInddetails 

Indicates if the Household Member accepted the employment offered. The UI field name for this attribute is 'Employment Accepted Ind'.

CURAM_INDICATOR SVR_BOOLEAN
refusalReasondetails 

The reason the offer of employment was refused by the Household Member. Examples include: Care of Dependent Child, Illness, etc. This is populated from the 'EmploymentRefusalReason' code table. The UI field name for this attribute is 'Refusal Reason'.

EVD_EMPLOYMENT_REFUSAL_REASONEmploymentRefusalReasonSVR_STRING<10>
commentsdetails 

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

COMMENTS SVR_STRING<300>
dateOfOfferdetails 

The date that the Employment Offer was made. The UI field name for this attribute is 'Date Of Offer'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
EmploymentOffer.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1074862459caseParticipantRoleID
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 Reads all the case participants on an employment offer record. 
Related Pages (11)