Table Description
Employment Working Hour: 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.
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::Service Layer::EmploymentWorkingHour::Entity::EmploymentWorkingHour
Controlling File: core\model\Packages\Reference Model\Service Layer\EmploymentWorkingHour\EmploymentWorkingHour_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
employmentWorkingHourIDkeynoThe 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
Foreign Keys (1)
ChildParent
EmploymentWorkingHour.employmentIDEmployment.employmentID
Indices (1)
Index NameAttributes
EWHEmpIDIdxemploymentID
Operations (13)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: employmentWorkingHourID
PRE_DATA_ACCESS: yes
Entity operation to insert an employment working hour record for a person employment. 
readread Entity operation to read an employment working hour record for a person employment. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Entity operation to modify an employment working hour record for a person employment. 
searchByEmploymentIDnsreadmultiORDER_BY: fromDate
Entity operation to read a list of employment working hour records for a person employment. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Entity operation to cancel an employment working hour record for a person employment, sets the record status to canceled. 
readRecordStatusnsread Entity operation to read the record status of an employment working hour record. 
validateCancel  Entity operation called from cancel operation to validate cancel details. 
validate  Entity operation called from insert and modify to validate employment working hour details. 
countDuplicatesnsPRE_DATA_ACCESS: yes
 		 SQL
readFromDatensread   
searchForDuplicateRecord  @superseded - replaced by countDuplicates 
searchByConcernRoleIDAndStatusnsmulti  SQL
searchByEmploymentIDAndVersionNonsreadmultiORDER_BY: fromDate
Entity operation to read a list of employment working hour records for a person employment. 
Related Pages (13)