Overview
When Timesheet Shifts is selected in Requested Data, the report will return the following details in the TimesheetSplit sheet:
| Field Name | Data Type | Information |
|---|---|---|
|
TimesheetSplit_TS_SID |
Integer (Unsigned) |
The ID of the timesheet shift |
|
Timesheet_TSID |
Integer (Unsigned) |
The ID of the timesheet to which this TimesheetSplit belongs |
|
Date |
Date |
The date of the timesheet shift |
|
Job_UID |
Integer (Unsigned) |
The Job ID linked to the timesheet shift |
|
PayCat_PCID |
Integer |
The ID of the pay item to which this shift belongs 0 = base unit |
|
HourlyStart |
Integer (Unsigned) |
If this is an hourly Timesheet Type, this field will contain the number of second in the day at which this shift starts eg 32400 second = 9:00am |
|
HourlyFinish |
Integer (Unsigned) |
If this is an hourly Timesheet Type, this field will contain the number of seconds in the day at which this split ends eg 61200 seconds = 5:00pm |
|
DailyUnits |
Decimal (Unsigned) |
If this is a daily Timesheet Type, this field will contain the fraction of the day that was worked eg 0.5 = half day, 1 = full day |
|
BreakUnits |
Decimal (Unsigned) |
If this is an hourly Timesheet Type, this field will contain the number of units that were taken on a break If this is a daily Timesheet Type, this field will contain the fraction of the day that a break was taken eg 0.25 = quarter day, 0.5 = half day |
|
LeaveManagementType_LM _type_id |
Integer (Unsigned) |
The foreign key of the leave type to which this shift belongs If <= 0 then this shift does not denote leave taken |
|
LeaveManagementRequestEnty _LM_requestEntry_id |
Integer (Unsigned) |
The foreign key of the leave request entry to which this shift belongs If <= 0 then this shift does not denote leave taken |
|
Notes |
String |
Any additional notes that may have been entered against this shift |
Comments
0 comments
Please sign in to leave a comment.