TimesheetsTimesheetLines
The table below describes the TimesheetsTimesheetLines table in the PayrollAUS database schema.
This is a virtual table, and is linked to the Timesheets table in the PayrollAUS database schema (see Timesheets).
None of the columns in this table are updatable.
None of the columns in this table are nullable.
This table contains the following foldable column:
- Timesheet_ID
This table does not contain Return Primary Key columns.
| Column Name | SQL Type |
|---|---|
|
Employee_ID Foreign Key linked to column Employee_ID in EmployeesComplete table |
SQL_VARCHAR(8192) |
|
Timesheet_ID Foreign Key linked to column Timesheet_ID in Timesheets table |
SQL_VARCHAR(8192) |
|
Earnings_Rate_ID |
SQL_VARCHAR(8192) |
|
Number_Of_Units |
SQL_VARCHAR(8192) |
|
Tracking_Item_ID |
SQL_VARCHAR(8192) |