Entity ShiftMember

Description of Entity ShiftMember

Shows the employees who does shift work. It also shows which shift table they are in and its rate.


List of all Dependencies of the Entity ShiftMember

Name

Code

Class Name

Ref_5161

Ref_5161

Reference

Ref_5125

Ref_5125

Reference


List of Attributes of the Entity ShiftMember

Name

Code

Formula ID

FormulaId

Shift Table ID

ShiftTableId


Entity Attribute Formula ID of the Entity ShiftMember

Card of Attribute Formula ID of the Entity ShiftMember

Name

Formula ID

Code

FormulaId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Formula ID of the Entity ShiftMember

Shows the formula on what leave / deduction / allowance etc, the employee has taken. This is the primary key for the Formula table.
Example: ANL (Annual leave) / Deduction of Sick leave / HOL (Paid Holiday)


Entity Attribute Shift Table ID of the Entity ShiftMember

Card of Attribute Shift Table ID of the Entity ShiftMember

Name

Shift Table ID

Code

ShiftTableId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Shift Table ID of the Entity ShiftMember

Shows the identity of the shift table. This also acts as a primary key for the Shift table.
Example: Standard Shift Table