Table Description
Employment Snapshot : 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.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Concern::Entity Objects::Employment::EmploymentSnapshot
Controlling File: core\model\Packages\Concern\Employment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
employmentSnapshotIDkeynoUnique reference number assigned by the system.EMPLOYMENT_SNAPSHOT_ID SVR_INT64
employmentIDdetails Unique reference number assigned by the system.EMPLOYMENT_ID SVR_INT64
concernRoleIDdetails The concern role ID of the person.CONCERN_ROLE_ID SVR_INT64
employerConcernRoleIDdetails The 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>
creationDateTimedetails The date and time the Snapshot was created. CURAM_DATETIME SVR_DATETIME
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: employmentSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByEmploymentIDnsmulti Method to return a list of all Employment Snapshot Records for an EmploymentID.SQL
Related Pages (1)