A record of the shift. Shows the current period and year and the frequency of the shift. Also includes any exchange rate and what type of payment group the employee belongs to.

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Shows the generating identity of the shift record. This is the primary key for the ShiftRecord table.
Example: A1 / A66 / A110

Shows the identity for the shift formula. This is also the foreign key for the ShiftRecord table.

Shows the year for the pay record.
Example: 2012

Shows the period for the pay record.
Example: January = "1", February = "2", March = "3" etc.

Holds the sub period for the pay record.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet

Shows the rate of when the employee works on a shift.

Shows the number of shifts the employee has worked.

Shows the amount for when an employee works overtime.

Shows who created the ShiftRecord.

Shows the foreign amount for when an employee works on a shift.

Shows the identity of the shift exchange rate.

Shows the shift exchange rate.