Scheduled Extract Report - Timesheet Entities

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 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
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 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
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 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
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 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
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