Timesheets
The table below describes the Timesheets table in the PayrollAUS database schema.
This table contains the following virtual table:
This table contains the following foldable column:
- Timesheet_ID
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
Timesheet_ID Primary Key |
SQL_VARCHAR(8192) | False | False |
|
Employee_ID Foreign Key linked to column Employee_ID in EmployeesComplete table |
SQL_VARCHAR(8192) | False | False |
|
End_Date |
SQL_DATE | True | True |
|
Hours |
SQL_VARCHAR(8192) | True | True |
|
Start_Date |
SQL_DATE | True | True |
|
Status |
SQL_VARCHAR(8192) | True | True |