Table Description
Employment: Work in which a person is engaged.

A person may hold one or more employments.

Example

John Smith is employed by ACME Industries as an engineer. John has worked with ACME Industries since 1/1/2000.

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::Core::Reference Model::Concern::Entity Objects::Employment::Employment
Controlling File: core\model\Packages\Concern\Employment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
employmentIDkeynoUnique reference number assigned by the system.EMPLOYMENT_ID SVR_INT64
concernRoleIDdetailsnoThe concern role ID of the person.CONCERN_ROLE_ID SVR_INT64
employerConcernRoleIDdetailsnoThe concern role ID of the employer.CONCERN_ROLE_ID SVR_INT64
fromDatedetails Date from which the employment commenced.CURAM_DATE SVR_DATE
toDatedetails Date upon which the employment ended.CURAM_DATE SVR_DATE
statusdetails Code value to indicate the status of the employment.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
occupationTypedetails Code value to indicate the occupation type of the employment.OCCUPATION_TYPE_CODEOccupationTypeSVR_STRING<10>
primaryCurrentInddetails Indicator which is true for the primary current employer of the person, and false for all others for that person.CURAM_INDICATOR SVR_BOOLEAN
commentsdetails Any relevant comments about this employment.COMMENTS SVR_STRING<300>
Foreign Keys (6)
ChildParent
Employment.concernRoleIDConcernRole.concernRoleID
EmploymentWorkingHour.employmentIDEmployment.employmentID
PaidEmployment.employmentIDEmployment.employmentID
SelfEmployment.employmentIDEmployment.employmentID
UnpaidEmployment.employmentIDEmployment.employmentID
VoluntaryQuit.employmentIDEmployment.employmentID
Indices (3)
Index NameAttributes
EmploymentIndex3employerConcernRoleID, status
EmploymentIndex1concernRoleID, employerConcernRoleID, occupationType, toDate
EmploymentIndex2concernRoleID, primaryCurrentInd, status
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
Standard Operation 
readCurrentnsread returns the concern role's current employment 
searchEmploymentsByConcernRolensmulti Retrieves a list of employment details for the specified concern role.SQL
removeremovePOST_DATA_ACCESS: yes
Standard Operation 
searchForDupEmploymentnsmulti Check whether there is a duplicate employment record foundSQL
searchForEmploymentnsmulti Search for an existing employmentSQL
readEmployerEmployeeNamens Returns the employer name and employee name for an employment.SQL
readEmploymentFromToDatens Returns the employment start date.SQL
searchEmploymentsAndIndustryByConcernRoleIDnsmulti Retrieves a list of employment details and the employer industry type for the specified concern role.SQL
searchActiveEmploymentsByConcernRolensmultiPRE_DATA_ACCESS: yes
 
Retrieves a list of active employment details for the specified concern role.SQL
readRepresentativeEmployeeNamens Returns the employer name and employee name for an employment where the employer is registered as a representative.SQL
readEmploymentsAndIndustryByConcernRoleID  @superseded - replaced by searchEmploymentsAndIndustryByConcernRoleID 
searchActiveEmploymentsByEmployerConcernRoleIDreadmulti Retrieves a list of active employment details for the specified employer concern role. 
Related Pages (154)
Add Client (Application_AddClientConfirmation)
Application_ClientDetails
Edit Date Added (Application_editClientDetails)
New Email Communication (Application_getEmailCorrespondent)
New MS Word Communication (Application_getMSWordCorrespondentCaseMember)
New Pro Forma Communication (Application_getProFormaCorrespondent)
Record Communication (Application_getRecordCommCorrespondent)
Communications (Application_listCommunication)
Match Client (Application_matchClientConfirmation)
Clients (ApplicationClients)
ApplicationContextPanel
Sample Benefit Overpayment Evidence (BenefitSampleOverpayment_viewEvidence)
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
Integrated Case Prospect Person Home (DefaultICProspectPerson_home)
New Employment Expense Evidence (EVD_addToCaseEmploymentExpenseEvidence_wzSelAllCreEmpOnly)
New Paid Employment Evidence (EVD_addToCasePaidEmploymentEvidence_wzSelAllCreEmpOnly)
New Evidence (EVD_addToCaseSelectEmpEmploymentExpenseEvidence_only)
New Evidence (EVD_addToCaseSelectEmpPaidEmploymentEvidence_only)
New Evidence (EVD_addToCaseSelectEmpSelfEmploymentEvidence_only)
New Evidence (EVD_addToCaseSelectEmpUnpaidEmploymentEvidence_only)
New Evidence (EVD_addToCaseSelectEmpVoluntaryQuitEvidence_only)
New Self Employment Evidence (EVD_addToCaseSelfEmploymentEvidence_wzSelAllCreEmpOnly)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePRE)
New Unpaid Employment Evidence (EVD_addToCaseUnpaidEmploymentEvidence_wzSelAllCreEmpOnly)
New Voluntary Quit Evidence (EVD_addToCaseVoluntaryQuitEvidence_wzSelAllCreEmpOnly)
New Business Asset Evidence (EVD_createBusinessAssetEvidence_sa)
New Business Asset Evidence (EVD_createBusinessAssetEvidence_wzSelAllCre)
New Employer Evidence Details: (EVD_createEmployment)
New Employment Expense Evidence (EVD_createEmploymentExpenseEvidence_wzSelAllCreEmpOnly)
New Gross Receipt Evidence (EVD_createGrossReceiptEvidence_sa)
New Gross Receipt Evidence (EVD_createGrossReceiptEvidence_wzSelAllCre)
New Ownership Evidence (EVD_createOwnershipEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_wzSelAllCre)
New Paid Employment Evidence (EVD_createPaidEmploymentEvidence_wzSelAllCreEmpOnly)
New Self Employment Evidence (EVD_createSelfEmploymentEvidence_wzSelAllCreEmpOnly)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_sa)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePRE)
New Unpaid Employment Evidence (EVD_createUnpaidEmploymentEvidence_wzSelAllCreEmpOnly)
New Voluntary Quit Evidence (EVD_createVoluntaryQuitEvidence_wzSelAllCreEmpOnly)
Edit Transfer To Trust Evidence (EVD_incomingModifyTransferToTrustEvidence)
Employment: (EVD_listCoreEmploymentEvidenceDetails)
Employment: (EVD_listCoreEmploymentEvidenceDetails_fromActive)
Employment: (EVD_listCoreEmploymentEvidenceDetails_fromInEdit)
Edit Business Asset Evidence (EVD_modifyBusinessAssetEvidence)
Edit Employment Expense Evidence (EVD_modifyEmploymentExpenseEvidence)
Edit Gross Receipt Evidence (EVD_modifyGrossReceiptEvidence)
Edit Ownership Evidence (EVD_modifyOwnershipEvidence)
Edit Paid Employment Evidence (EVD_modifyPaidEmploymentEvidence)
Edit Transfer To Trust Evidence (EVD_modifyTransferToTrustEvidence)
Edit Voluntary Quit Evidence (EVD_modifyVoluntaryQuitEvidence)
New Evidence (EVD_selectEmpEmploymentExpenseEvidence_only)
New Evidence (EVD_selectEmpPaidEmploymentEvidence_only)
New Evidence (EVD_selectEmpSelfEmploymentEvidence_only)
New Evidence (EVD_selectEmpUnpaidEmploymentEvidence_only)
New Evidence (EVD_selectEmpVoluntaryQuitEvidence_only)
Delete Employment Details: (EVDEvidence_cancelEmployment)
Modify Employment Details: (EVDEvidence_modifyEmployment)
View Employment Details: (EVDEvidence_viewEmployment)
Employment: (HCR_listCoreEmploymentEvidenceDetails)
Employment: (HCR_listCoreEmploymentEvidenceDetails_fromActive)
Employment: (HCR_listCoreEmploymentEvidenceDetails_fromInEdit)
Delete Employment Details: (HCREvidence_cancelEmployment)
Modify Employment Details: (HCREvidence_modifyEmployment)
View Employment Details: (HCREvidence_viewEmployment)
Integrated Case Prospect Person Home (ICSample_prospectPersonHome)
Confirm Prospect Person Not Already Registered as Person (Individual_duplicateProspectPersonRegistrationCheck)
Prospect Information (Individual_prospectHomePage)
New Interview (Intake_createInterview)
Withdraw Program Request (Intake_createProgramWithdrawalRequest)
Withdraw Program Request (Intake_createProgramWithdrawalRequest1)
Register Prospect as Person (Intake_duplicateCheckForRegisterProspectPerson)
Invite Attendees (Intake_inviteAttendee)
Client Merge Wizard (Intake_MergeProspecrToPersonWizard)
Add Household Member (ISAddMemberWizard_summaryDetails)
Employment: (ISP_listCoreEmploymentProductEvidenceDetails)
Employment: (ISP_listCoreEmploymentProductEvidenceDetails_fromActive)
Employment: (ISP_listCoreEmploymentProductEvidenceDetails_fromInEdit)
Guided Change (ISPApplication_listGuidedChange)
Participant Details (ISPPerson_editProspectPersonParticipantDetails)
Participant Details (ISPPerson_listProspectPersonParticipantDetails)
Delete Employment Details: (ISPProductEvidence_cancelEmployment)
Modify Employment Details: (ISPProductEvidence_modifyEmployment)
View Employment Details: (ISPProductEvidence_viewEmployment)
Mark Duplicate (Participant_markDuplicate)
Merge Duplicate (Participant_mergeEmployment)
Client Merge Wizard (Participant_mergeWizard)
Client Merge Wizard (Participant_mergeWizardForViewDuplicate)
View Employment (Participant_viewMergeEmployment)
Delete Employment (Person_cancelEmployment)
Delete Employment Working Hours (Person_cancelEmploymentWorkingHour)
New Employment (Person_createEmployment)
New Employment Working Hours (Person_createEmploymentWorkingHour)
View Employment (Person_evidenceViewEmployment)
Employment (Person_evidenceViewEmploymentObject)
View Employment Working Hours (Person_evidenceViewEmpWorkHr)
Employment Working Hours (Person_evidenceViewEmpWorkHrObject)
Employment (Person_listEmployment)
Employment (Person_listEmploymentHistory)
Employment (Person_listEmploymentWorkingHour)
Employment (Person_listEmploymentWorkingHour1)
Employment Working Hours (Person_listEmploymentWorkingHourHistory)
Person_modifyEmployment
Edit Employment (Person_modifyEmploymentFromList)
Edit Employment (Person_modifyEmploymentFromView)
Edit Employment Working Hours (Person_modifyEmploymentWorkingHour)
Edit Employment Working Hours (Person_modifyEmploymentWorkingHourFromList)
Edit Employment Working Hours (Person_modifyEmploymentWorkingHourFromView)
Employment (Person_viewEmployment)
Employment Change Details (Person_viewEmploymentFromHistory)
Employment Change Details (Person_viewEmploymentSnapshotFromHistory)
View Employment (Person_viewEmploymentTransaction)
Employment Working Hours (Person_viewEmploymentWorkingHour)
Employment Working Hours Change Details (Person_viewEmploymentWorkingHourFromHistory)
Employment Working Hours Change Details (Person_viewEmploymentWorkingHourSnapshotFromHistory)
Delete Employment (Prospect_cancelEmployment)
New Employment (Prospect_createEmployment)
Home (Prospect_homePage)
Employment (Prospect_listEmployment)
Edit Employment (Prospect_modifyEmploymentFromList)
Edit Employment (Prospect_modifyEmploymentFromView)
Edit Prospect (Prospect_modifyProspect)
View Employment (Prospect_viewEmployment)
Delete Employment (ProspectPerson_cancelEmployment)
Delete Employment Working Hours (ProspectPerson_cancelEmploymentWorkingHour)
New Employment (ProspectPerson_createEmployment)
New Employment Working Hours (ProspectPerson_createEmploymentWorkingHour)
Register Prospect as Person (ProspectPerson_duplicateCheckForPDCWizard)
Register Prospect as Person (ProspectPerson_duplicateCheckWizard)
Confirm Prospect Person Not Already Registered as Person (ProspectPerson_duplicatePersonRegistrationCheck)
Confirm Prospect Person Not Already Registered as Person (ProspectPerson_duplicatePersonRegistrationCheck1)
View Prospect Person Details (ProspectPerson_evidenceView)
Prospect Person Details (ProspectPerson_evidenceViewObject)
Home (ProspectPerson_homePage)
Home (ProspectPerson_homePagePDC)
Employment (ProspectPerson_listEmployment)
Employment Working Hours (ProspectPerson_listEmploymentWorkingHour)
Employment Working Hours (ProspectPerson_listEmploymentWorkingHour1)
ProspectPerson_modifyEmploymentFromList
ProspectPerson_modifyEmploymentFromView
Edit Employment Working Hours (ProspectPerson_modifyEmploymentWorkingHourFromList)
Edit Employment Working Hours (ProspectPerson_modifyEmploymentWorkingHourFromView)
View Employment (ProspectPerson_viewEmployment)
View Employment Working Hours (ProspectPerson_viewEmploymentWorkingHour)
Prospect Person Home (ProspectPersonRegisteredAsPerson_home)
ProviderManagement_viewEmploymentHistory
View Employment History: (ProviderManagement_viewEmploymentHistoryForProviderGroupMember)
Employment History (ProviderManagement_viewEmploymentHistoryForProviderMember)
Employment History (ProviderManagement_viewEmploymentHistoryForProviderMemberForFacilityManager)