Stores information about the timesheet.

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 time sheet. It holds the primary key for the TimeSheet table.
Example: A5 / A24 / A32

Shows the type of Time Management System.
Example: SummarizedTMS

Shows the year of the Time Management System.
Example: 2012

Shows the period of the Time Management System.
Example: January = "1" / February = "2" / March = "3" etc

Shows the sub period of the Time Management System.

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)

Shows the date of the Time Management System.
It is usually in the format: DD-MM-YYYY.

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

Shows the status.
Example: Active (Unlocked) / Locked

Shows the date with time of when the record was last processed.
Example: 2013-02-19 14:33:45.115

Shows the date with time of when the payroll was last processed.
Example: 2013-02-19 14:33:45.115