Table Description

Paid Employment: Details of the gainful employment that a participant is involved in. Paid Employment can only be recorded for a participant who has an employment record.

Example

Linda Smith is currently employed full time. Linda Smith's employer is the Midway Emporium. A case worker creates a record of Linda Smith's employer, and creates a Paid Employment record for Linda Smith as a full time employee of the Midway Emporium.
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::PaidEmployment::PaidEmployment
Controlling File: Evidence\model\ServiceLayer\entity\Income\PaidEmployment\PaidEmployment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

The system generated unique identifier for the Paid Employment. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
employmentIDdetailsyes

The system generated unique identifier for the linked employment. There is no UI field for this attribute.

EMPLOYMENT_ID SVR_INT64
employmentTypedetails 

The type of the employment. Examples include: Part-Time, Full-Time. This is populated from the 'PaidEmploymentType' code table. The UI field name for this attribute is 'Employment Type'.

EVD_EMPLOYMENT_TYPEPaidEmploymentTypeSVR_STRING<10>
firstPayDatedetails 

The date of the first payment from this employment. The UI field name for this attribute is 'First Pay Date'.

CURAM_DATE SVR_DATE
hoursTravelToWorkdetails 

The number of hours required for the participant to make a round trip to work. The UI field name for this attribute is 'Daily Commute Hours'.

EVD_HOURS SVR_INT16
parentalLeaveInddetails 

Indicates if the participant is currently on parental leave. The UI field name for this attribute is 'On Parental Leave'.

CURAM_INDICATOR SVR_BOOLEAN
paidParentLeaveInddetails 

Indicates if the household member is paid while on parental leave. The UI field name for this attribute is 'Paid Parental Leave'.

CURAM_INDICATOR SVR_BOOLEAN
contactEmployerInddetails 

Indicates if the organization has permission to contact the participant's employer. The UI field name for this attribute is 'Contact Employer'.

CURAM_INDICATOR SVR_BOOLEAN
outstandingAmountdetails 

Indicates the amount of wages that are yet to be paid to the participant. The UI field name for this attribute is 'Outstanding Wage'.

CURAM_AMOUNT SVR_MONEY
outstandWageReasondetails 

Reason why wages are outstanding to the participant. This is populated from the 'OutstandingWageReason' code table. The UI field name for this attribute is 'Outstanding Wage Reason'.

EVD_OUTSTANDING_WAGE_REASONOutstandingWageReasonSVR_STRING<10>
dismissalReasondetails 

Reason why the participant was dismissed from their employment. Examples include: Participation in a strike, Others, etc. This is populated from the 'DismissalReason' code table. The UI field name for this attribute is 'Dismissal Reason'.

EVD_DISMISSAL_REASONDismissalReasonSVR_STRING<10>
commentsdetails 

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

COMMENTS SVR_STRING<300>
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the participant who is in Paid Employment. This may or may not be a Household Member. The UI field name for this attribute is 'Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
empCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the Employer associated with this Paid Employment. This is populated from the employment record linked with this Paid Employment evidence. The UI field name for this attribute is 'Employer'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
Foreign Keys (4)
ChildParent
PaidEmployment.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
PaidEmployment.empCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
PaidEmployment.employmentIDEmployment.employmentID
TradeDispute.paidEmploymentIDPaidEmployment.evidenceID
Indices (2)
Index NameAttributes
searchDupPaidEmIdxemploymentID, employmentType, caseParticipantRoleID
IND__269343149empCaseParticipantRoleID
Operations (11)
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 a paid employment record. 
readEmploymentFromToDatesByPaidEmploymentIDns Reads the start and end dates of the employment record corresponding to a paid-employment instance.SQL
readEmploymentDetailsByPaidEmploymentIDns Reads the employmentID, concernRoleID, start and end dates of the employment record corresponding to a paid-employment instance.SQL
readEmploymentWorkingHourDetailsByPaidEmploymentIDnsmulti Reads the employmentWorkingHourID, employmentID, concernRoleID and the caseParticipantRoleID of the employment working hour record corresponding to a paid-employment instance.SQL
countCurrentActivePaidEmploymentEmploymentsns This method counts the number of active employment records for a participant on a case evidence tree.SQL
readPaidEmploymentEmpWorkingHoursns Reads the number of hours worked on active records for an employment based on the paidEmploymentID and a searchDate. Current functionality ensures that only one value will be returned for each searchDate.SQL
searchPaidEmploymentsByEmploymentIDnsmulti Searches for all paid employments based on an employmentIDSQL
Related Pages (22)