SHEET table

 

SHEET – this table contains all Timesheets that have been submitted but not approved.

Ÿ      ID – The Unique ID for the Timesheet. (PK)

Ÿ      EMPLOYEE – The Employee ID for the timesheet. (FK)

Ÿ      MANAGER – The Employee ID for the manager that has to approve the timesheet. (FK)

Ÿ      WORKFLOW – The Workflow ID for the timesheet.

Ÿ      STATUS – The current status of the timesheet. (N = "Not Submitted", U = "Under Review", R = "Rejected")

Ÿ      TITLE – The title for the timesheet.

Ÿ      DESC – The description for the timesheet.