## Overview

When Timesheets is selected in Requested Data, the report will return the following details:

Field Name | Data Type | Information |
---|---|---|

Timesheet_TSID |
Integer (Unsigned) |
The Timesheet ID |

DateFrom |
Date |
The first date that appears on this timesheet |

DateTo |
Date |
The last date that appears on this timesheet |

Job_UID |
Integer (Unsigned) |
The Job ID linked to the timesheet |

MasterTimesheet_MTS_id |
Integer (Unsigned) |
The Master Timesheet ID, if any If <= 0, this is a variable timesheet or a daily timesheet |

Sequence |
Integer (Unsigned) |
The sequence of the timesheet The sequence is incremented when an adjustment timesheet is created, either internally or through the action of a user We use the DateFrom and Job_UID fields to determine which original timesheet the sequence belongs to |

IsLatestSequence |
Boolean (Yes/No) |
Whether or not this sequence is the latest sequence in the chain Provides faster SQL data lookup |

Status |
String |
The status of this sequence of the timesheet |

Notes |
String |
Any additional notes that appear on the timesheet |

PayRun_payrun_id |
Integer (Unsigned) |
The Pay Run ID to which this timesheet belongs, if any |

IsExcludedFromPayroll |
Boolean (Yes/No) |
Whether or not this sequence of the timesheet is excluded from the payroll module |

SubmittedDateTime |
Date/Time (Local) |
The local portal date/time at which this sequence of the timesheet was submitted, if it has been submitted |

ApprovedDateTime |
Date/Time (Local) |
The local portal date/time at which this sequence of the timesheet was approved, if it has been approved |

ApprovedBy-User_UID |
Integer (Unsigned) |
The foreign key of the user that approved this timesheet, if it has been approved |

PaidDateTime |
Date/Time (Local) |
The local portal date/time at which this sequence of the timesheet was paid, if it has been paid |

MondayStart |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee started working at this job on Monday |

MondayFinish |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee finished working at this job of Monday |

MondayBreak |
String |
If the timesheet is hourly, this will denote the number of hours and minutes between the MondayStart and MondayFinish that the employee was not working at this job This is the total of the amount of time the employee spent on break (as logged on the timesheet) plus the amount of time between shifts, if applicable |

MondayWork |
Decimal |
If the timesheet is hourly, this will denote the total number of hours the employee work at this job on Monday If the timesheet is daily, this will denote the fraction of the day the employee worked at this job on Monday (where 1 = full day) |

MondayNotes |
String |
Any specific notes entered against this job for Monday |

TuesdayStart |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee started working at this job on Tuesday |

TuesdayFinish |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee finished working at this job of Tuesday |

TuesdayBreak |
String |
If the timesheet is hourly, this will denote the number of hours and minutes between the TuesdayStart and TuesdayFinish that the employee was not working at this job This is the total of the amount of time the employee spent on break (as logged on the timesheet) plus the amount of time between shifts, if applicable |

TuesdayWork |
Decimal |
If the timesheet is hourly, this will denote the total number of hours the employee work at this job on Tuesday If the timesheet is daily, this will denote the fraction of the day the employee worked at this job on Tuesday (where 1 = full day) |

TuesdayNotes |
String |
Any specific notes entered against this job for Tuesday |

WednesdayStart |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee started working at this job on Wednesday |

WednesdayFinish |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee finished working at this job of Wednesday |

WednesdayBreak |
String |
If the timesheet is hourly, this will denote the number of hours and minutes between the WednesdayStart and WednesdayFinish that the employee was not working at this job This is the total of the amount of time the employee spent on break (as logged on the timesheet) plus the amount of time between shifts, if applicable |

WednesdayWork |
Decimal |
If the timesheet is hourly, this will denote the total number of hours the employee work at this job on Wednesday If the timesheet is daily, this will denote the fraction of the day the employee worked at this job on Wednesday (where 1 = full day) |

WednesdayNotes |
String |
Any specific notes entered against this job for Wednesday |

ThursdayStart |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee started working at this job on Thursday |

ThursdayFinish |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee finished working at this job of Thursday |

ThursdayBreak |
String |
If the timesheet is hourly, this will denote the number of hours and minutes between the ThursdayStart and ThursdayFinish that the employee was not working at this job |

ThursdayWork |
Decimal |
If the timesheet is hourly, this will denote the total number of hours the employee work at this job on Thursday If the timesheet is daily, this will denote the fraction of the day the employee worked at this job on Thursday (where 1 = full day) |

ThursdayNotes |
String |
Any specific notes entered against this job for Thursday |

FridayStart |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee started working at this job on Friday |

FridayFinish |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee finished working at this job of Friday |

FridayBreak |
String |
If the timesheet is hourly, this will denote the number of hours and minutes between the FridayStart and FridayFinish that the employee was not working at this job |

FridayWork |
Decimal |
If the timesheet is hourly, this will denote the total number of hours the employee work at this job on Friday If the timesheet is daily, this will denote the fraction of the day the employee worked at this job on Friday (where 1 = full day) |

FridayNotes |
String |
Any specific notes entered against this job for Friday |

SaturdayStart |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee started working at this job on Saturday |

SaturdayFinish |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee finished working at this job of Saturday |

SaturdayBreak |
String |
If the timesheet is hourly, this will denote the number of hours and minutes between the SaturdayStart and SaturdayFinish that the employee was not working at this job |

SaturdayWork |
Decimal |
If the timesheet is hourly, this will denote the total number of hours the employee work at this job on Saturday If the timesheet is daily, this will denote the fraction of the day the employee worked at this job on Saturday (where 1 = full day) |

SaturdayNotes |
String |
Any specific notes entered against this job for Saturday |

SundayStart |
String |
If the timesheet is hourly, this will denote the time (n 24 hour format) that the employee started working at this job on Sunday |

SundayFinish |
String |
If the timesheet is hourly, this will denote the time (in 24 hour format) that the employee finished working at this job of Sunday |

SundayBreak |
String |
If the timesheet is hourly, this will denote the number of hours and minutes between the SundayStart and SundayFinish that the employee was not working at this job |

SundayWork |
Decimal |
If the timesheet is hourly, this will denote the total number of hours the employee work at this job on Sunday If the timesheet is daily, this will denote the fraction of the day the employee worked at this job on Sunday (where 1 = full day) |

SundayNotes |
String |
Any specific notes entered against this job for Sunday |

RemoteID |
String |
The remote ID used to integrate this timesheet to/from other system |

## Comments

0 comments

Please sign in to leave a comment.