Table Description
Employment Working Hour sSnapshot: The number of hours a week a participant works in an employment.

Employment working hours are recorded to ensure payments are made for a standard working week which will not included shift work, overtime or other bonus payments.

Example

John Smith is employed by ACME Industries as an engineer. John works 40 hours a week.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::EmploymentWorkingHour::Entity::EmploymentWorkingHourSnapshot
Controlling File: core\model\Packages\Reference Model\Service Layer\EmploymentWorkingHour\EmploymentWorkingHour_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
employWorkingHourSnapshotIDkeynoThe unique ID of the employment working hour snapshot record.EMPLOYMENT_WORKING_HOURS_SS_ID SVR_INT64
employmentWorkingHourIDdetails The unique ID of the employment working hour record.EMPLOYMENT_WORKING_HOURS_ID SVR_INT64
employmentIDdetailsnoThe unique ID of the associated employment record.EMPLOYMENT_ID SVR_INT64
fromDatedetailsnoThe date from which the employment working hour commences.CURAM_DATE SVR_DATE
noHoursWorkeddetailsnoThe standard weekly number of hours worked.NUMBER_OF_HOURS SVR_INT32
shiftWorkInddetails Shift work indicator.SHIFT_WORK_IND SVR_BOOLEAN
commentsdetails Comments on the employment working hour.COMMENTS SVR_STRING<300>
recordStatusdetailsnoThe record status of the employment working hour.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
noDaysWorkedPerWeekdetails Number of days worked per week.NUMBER_OF_DAYS SVR_INT32
creationDateTimedetails The date and time the snapshot was created.CURAM_DATETIME SVR_DATETIME
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: employWorkingHourSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByEmploymentWorkingHourIDnsmulti Retrieves a list of Employment Working Hour Snapshot details for the specified Employment Working Hour record.SQL
Related Pages (1)