TEMPTRANS – This table contains all unapproved timesheet entries.
Ÿ ID – The Unique ID for the time entry. (PK)
Ÿ SHEET – The Sheet ID that the time entry belongs to. (FK)
Ÿ PROJECT – The Project ID for the time entry. (FK)
Ÿ TASK – The Task ID for the time entry. (FK)
Ÿ EMPLOYEE – The Employee ID for the time entry. (FK)
Ÿ DATE – The Date for the time entry. START – The Start time for the time entry. (FK)
Ÿ START – The Start time for the time entry
Ÿ STOP – The Stop time for the time entry.
Ÿ TOTAL – The total hours of the time entry.
Ÿ OTCOSTID – The Client Overtime rate for the time entry.
Ÿ OTRATEID – The Overtime rate for the time entry.
Ÿ DESC – The Description of the time entry.