Time & Attendance Field Definitions

Modified on Wed, Nov 25, 2020 at 1:08 AM

The following tables describe the data sources under Time & Attendance. They list the fields available and provide a brief description of contents. Included are:

Attendance
Processed Time
Processed Time And Shifts
Time
Time and Shifts

Attendance

Field	Description of contents
Active	Shows employee is available and able to be assigned to shifts.
All	Shows all entries.
By	Who made any changes to the shift information.
Confirmed	Timestamp of when attendance was created (Local).
Count	How many shifts the employee is assigned to.
Date	Date of the attendance occurring.
Inactive	Shows employee is not available and cannot be assigned to shifts.
Location	Name of location for shift or time entry.
Message	Any errors or notifications like if the employee was absent.
Minutes	For some attendance records, how many minutes they were late or early.
Name	The name of the employee assigned to the shifts.
Notes	Notes on the attendance record.
Open	Shows only open shifts.
Points	Points for the attendance record, as defined on the attendance setup in the policy.
Status	Status of the shift such as open, closed, etc.
Updated	When the shift information was updated.
Void	Shows only shifts that have been voided.

Processed Time

Processed Time is the calculated data for payroll. It's based on time entries, but contains additional information and records depending on overtime, differentials, and other policy configurations.

You can report on processed time data. Reports gather information from the following sources:

Employee information is specified in the Add or Edit Employee window.
Location information is specified in the Add or Edit Location window.
Billing information is specified in the Time > Configuration windows. See Time > Configuration and go to Pay Periods, Projects and Tasks, and Pay Rates.

Field	Description of contents
BillAmount	The product of the Bill Rate and the billable hours.
BillRate	Rate stored on the time entry. (Is set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.)
BreakHours	Number of hours in breaks.
BusinessExternalId	External ID of location. The External Id is used to coordinate TeamWork with external systems. It is blank unless your company integrates data with an external system.
BusinessName	The name of a location. (Entered in Name in the Location information window.)
Crew	Name employee’s crew assignment.
Date	Date of the calculated hours. If entries span the “start of day” (usually midnight) there will be a processed time record for each date.
EmployeeFullName	Employee full name. Displayed as “Last, First”.
EmployeeId	Unique ID for the employee/location, set by ScheduleSource.
EmployeeNote	Textual note related to the Employee.
EnterpriseEmployeeId	Unique ID for employee, set by ScheduleSource.
EntryId	Unique ID for a time entry, set by ScheduleSource.
EstimatedPayAmount	Calculated Hours. Employee’s estimated Pay Rate.
EstimatedPayRate	Pay rate entered in the Employee Information window in the Location portal. Go to Edit Employee > Scheduling > Pay Rate.
ExternalId	Employee ID for use with an external system, such as HR or Payroll.
FirstName	Employee’s first name.
HolidayHours	Calculated Holiday hours.
LastName	Employee’s last name.
LeaveHours	Calculated Leave hours.
LocationUserDefined1 - LocationUserDefined6	Custom field(s) identified in Admin > Custom Fields > Location.
OverTimeHours	Calculated Overtime hours.
OvertimePlusPremiumours	Calculated Overtime plus double time (premium) hours.
PayAmount	Bill rate * calculated hours total. (Is set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.)
PayPeriodId	Unique ID for the pay period, set by ScheduleSource.
PayRate	Pay rate from calculated time hours (Is set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.)
PremiumHours	Calculated Double-time hours.
RegularHours	Calculated Regular hours.
RestBreakHours	Calculated Rest Break hours.
ScheduleDate	Date of the calculated hours. (Not time entry nor shift date.)
ScheduleDateMonth	Month of the schedule date.
ScheduleDateQuarter	Quarter of the schedule date.
ScheduleDateWeek	Week of the schedule date.
ScheduleDateYear	Year of the schedule date.
ScheduleDateYearMonth	The Year/Month of the schedule date.
ScheduleDateYearQuarter	The Year/Quarter of the schedule date.
ScheduleDateYearWeek	The Year/Week of the schedule date.
TotalHours	All calculated hours, minus Rest Breaks.
UnPaidHours	Calculated Unpaid hours.
UserDefined1 - UserDefined6	Custom field(s) identified in Admin > Custom Fields > Employee.
BreakHoursTotal	Sum of calculated break hours.
EntryCount	Count of all processed records.
HolidayHoursTotal	Sum of calculated Holiday hours.
HoursTotal	summary of the total hours per a set filter
LeaveHoursTotal	Sum of calculated Leave hours.
OvertimeHoursTotal	Sum of calculated Overtime hours.
PremiumHoursTotal	Sum of calculated Premium hours.
RegularHoursTotal	Sum of calculated Regular hours.
RestBreakHoursTotal	Sum of calculated Rest Break hours.
TotalBillAmount	Sum of Bill Amount.
TotalCalcHours	Sum of calculated Regular, Overtime, Premium, Leave, Break, Holiday, & Unpaid hours.
TotalCalcPaidHours	Sum of calculated Regular, Overtime, Premium, Leave, Break, & Holiday hours.
TotalCalcWorkHours	Sum of calculated Regular, Overtime, Premium, & Break hours.
TotalEstimatedPayAmount	Sum of estimated Pay Amount.
TotalPayAmount	Sum of Pay Amount.
UnPaidHoursTotal	Sum of calculated UnPaid Hours.

Processed Time And Shifts

This data source joins scheduled shifts to the time hour's data. Any shift that overlaps the time entry that is the source of the hours will be joined.

Note: There may be multiple shifts per hour and or time entry, which will produce duplicates in the report.

Use this data source for analysis, i.e., finding issues versus summarization (reporting totals). An example is to report on how many hours employees were paid (time data) by each station (schedule shift data).

Reports on Processed Time and Shifts gather information from the following sources:

Employee information is specified in the Add or Edit Employee window.
Location information is specified in the Add or Edit Location window.
Billing information is specified in the Time > Configuration windows. See Time > Configuration and go to Pay Periods, Projects and Tasks, and Pay Rates.

Field	Description of contents
ActivityCode	Accounting code for a given activity entered in Time > Configuration > Activities. It is the code that identifies the activity.
ActivityName	Name of an activity entered in Time > Configuration > Activities. It is the name that identifies the activity.
ActualBreakHours	Break hours stored on the time entry.
ActualHours	Original clocked hours on time entry. (Before edits, rounding, etc.)
ActualOff	Original clock off time on time entry.
ActualOn	Original clock on time on time entry.
BillAmount	The product of the Bill Rate and the billable hours.
BillRate	Rate stored on the time entry. Is set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.
BreakHours	Number of hours in breaks.
BusinessExternalId	External ID of location. The External Id is used to coordinate TeamWork with external systems. It is blank unless your company integrates data with an external system.
BusinessName	The name of a location. (Entered in Name in the Location information window.)
ClientFirstName	First name of client assigned to shift. (Optional, only available If Client Management Module is activated.)
ClientFullName	Full name of client assigned to shift, displayed as “Last, First”.
ClientLastName	Last name of client assigned to shift. (Optional, only available If Client Management Module is activated.)
ClockOffUserId	Unique ID of User who clocked the employee off.
ClockOnUserId	Unique ID of User who clocked the employee on.
CreatedDate	Date the time entry was created.
Date	Date of the shift start, or schedule date on time entry.
DiffHolidayHours	Total calculated differential Holiday hours.
DiffOTHours	Total calculated differential Overtime hours.
DiffPremiumHours	Total calculated differential Premium hours.
DiffRegHours	Total calculated Regular Holiday hours.
EmpAlert	A flag for the employee to alert manager of note.
EmployeeFullName	Employee full name. Displayed as “Last, First”.
EmployeeId	Unique ID for the employee/location, set by ScheduleSource.
EmpNotes	Employee entered note on time entry.
EnterpriseRoundOff	Rounded Off time of time entry, in Enterprise time zone.
EnterpriseRoundOn	Rounded On time of time entry, in Enterprise time zone.
EnterpriseUpdated	Timestamp of last update, in Enterprise time zone.
EntryId	Unique ID for time entry, set by ScheduleSource.
FinalHours	Final Hours on time entry, after adjustments.
FinalOff	Final (same as rounded) Off time for time entry, in UTC.
FinalOn	Final (same as rounded) On time for time entry, in UTC.
FirstName	Employee’s first name.
HolidayHours	Calculated Holiday hours.
IsBillable	Flag that indicates whether the project/task used in the time entry is billable.
IsBreak	Flag that indicates whether the project/task used in the time entry is a break.
IsError	Flag that indicates if the time entry has been flagged as an error.
IsLeave	Flag that indicates whether the project/task used in the time entry is a leave.
IsPaid	Flag that indicates whether the project/task used in the time entry is paid.
IsVoid	Flag that indicates if the time entry is an error and has been reviewed.
LastName	Employee’s last name.
LeaveHours	Calculated Leave hours.
LocalRoundOff	Rounded Off time of time entry, in Location time zone.
LocalRoundOn	Rounded On time of time entry, in Location time zone.
LocalUpdated	Timestamp of last update, in Location time zone.
LocationOff	A string that stores a value that determines where the clock Off occurred. It might be an IP address, phone number, or the ID of a physical clock.
LocationOn	A string that stores a value that determines where the clock On occurred. It might be an IP address, phone number, or the ID of a physical clock.
MgrNotes	A note added to a time entry by the manager.
OverTimeHours	Calculated Overtime hours.
OverTimePlusPremiunHours	Calculated Overtime plus double time (premium) hours.
PayAmount	Bill rate * calculated hours total. Rate stored on the time entry. Is set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.
PayRate	Pay rate from calculated time hours. Rate stored on the time entry. Is set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.
PremiumHours	Calculated Double-time hours.
ProjectCode	The unique code for the Project of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
ProjectName	The name for the Project of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
RegularHours	Calculated Regular hours.
RestBreakHours	Calculated Rest Break hours.
SchDate	Date of the shift start, or schedule date on time entry. (This is the same as Date.)
ScheduleDate	Shift start date and time or date of time entry.
SchHours	Hours of the shift.
SchShiftBreak	Break hours of the shift.
SchShiftEnd	End time of shift. Only the time portion is returned.
SchShiftStart	Start time of shift. Only the time portion is returned.
ShiftId	Unique ID for a shift. Set by ScheduleSource.
ShiftNote	A comment added to shift.
ShiftOverlapEnd	The end time of overlapping time entry and shift segment.
ShiftOverlapHours	The hours within the time entry and shift overlapping segment.
ShiftOverlapStart	The start time of overlapping time entry and shift segment.
StationAllowSwap	Displays True if allow swap is chosen for this station in Enterprise; False if not allowed to swap.
StationCost	Displays estimated cost of the shift based on the station’s rate and shift hours.
StationId	Unique ID for station, set by ScheduleSource.
StationName	Name of Station.
StationOverlap	UNUSED
StationPayRate	Estimated pay for station.
StationRank	Priority of station versus other stations. 1-9 with 9 being the highest.
StationUserDefined1 - StationUserDefined6	Custom field(s) identified in Admin > Custom Fields > Station.
TaskCode	The unique code for the Task of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
TaskName	The name for the Task of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
TimeCost	Estimated cost of time entry, based on time entry hours.
TimePayRate	Estimated pay rate, as stored on time entry.
TimeReason	Reason code for clocking.
TotalHours	All calculated hours, minus Rest Breaks.
Type	Type of time sheet entry, either a clock, card, or admin entry.
UnPaidHours	Calculated Unpaid hours.
UpdatedDate	Date of an update to an entry in a time sheet.
UpdateUserId	User ID of the person who made the update.
ActualHoursTotal	Sum of all hours clocked with no rounding or other adjustments. This is purely clocked hours (no rounding). If someone alters the entry, it is not reflected here.
BreakHoursTotal	Sum of BreakHours on time entries.
BusinessCount	Count of distinct locations for records selected.
EntryCount	Count of records selected.
FinalHoursTotal	Sums all hours clocked with adjustments per rounding rules and shift differentials. This is for all hours, i.e., clocked, admin, card, etc.
HoursTotal	Sums all hours clocked with only adjustments per rounding rules. This is total hours from the rule engine, i.e., regular, overtime, shift differentials, etc.
OrgStationCount	Count of distinct stations on associated shifts.
OvertimeHoursTotal	Sum of calculated Overtime hours.
OvertimePremiumHoursTotal	Sum of calculated Premium hours.
RegularHoursTotal	Sum of calculated Regular hours.
SchHoursTotal	Sum of shift hours.
ShiftOverlapHoursTotal	Sum of the overlapping hours of time entries and shifts.
StationCostTotal	Sum of estimated cost of shifts based on station pay rate.
StationCount	Count of distinct stations/locations.
TimeCostTotal	Sum of time entry estimated cost, based on pay rate and final hours of entry.

Time

You can report on time-related entries. Reports gather information from the following sources:

Employee information is specified in the Add or Edit Employee window.
Location information is specified in the Add or Edit Location window.
Billing information is specified in the Time > Configuration windows. See Time > Configuration and go to Pay Periods, Projects and Tasks, and Pay Rates.

Field	Description of Contents
ActivityCode	Accounting code for a given activity entered in Time > Configuration > Activities. It is the code that identifies the activity.
ActivityName	Name of an activity entered in Time > Configuration > Activities. It is the name that identifies the activity.
ActualHours	Original clocked hours on time entry. (Before edits, rounding, etc.)
ActualOff	Original clock off time on time entry.
ActualOn	Original clock on time on time entry.
BillAmount	The product of the Bill Rate and the billable hours.
BillRate	Rate stored on the time entry. Is set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.
BreakHours	Number of hours in breaks.
BusinessExternalId	External ID of location. The External Id is used to coordinate TeamWork with external systems. It is blank unless your company integrates data with an external system.
BusinessName	The name of a location. (Entered in Name in the Location information window.)
CalcBreakHours	Calculated Break hours associated with time entry.
CalcDate	Date associated with calculated hours.
CalcHolidayHours	Calculated Holiday hours associated with time entry.
CalcLeaveHours	Calculated Leave hours associated with time entry.
CalcOverTimeHors	Calculated Overtime hours associated with time entry.
CalcOvertimePlusPremiumHours	Calculated Overtime and Premium hours associated with time entry.
CalcPremiumHours	Calculated Premium hours associated with time entry.
CalcRegularHours	Calculated Regular hours associated with time entry.
CalcUnPaidHours	Calculated UnPaid hours associated with time entry.
ClockOffUserId	Unique ID of User who clocked the employee off.
ClockOnUserId	Unique ID of User who clocked the employee on.
CreatedDate	Date the time entry was created.
Crew	Name employee’s crew assignment.
EMail	Employee’s email address.
EmpAlert	A flag for the employee to alert manager of note.
EmployeeFullName	Employee full name. Displayed as “Last, First”.
EmployeeId	Unique ID for the employee/location, set by ScheduleSource.
EmployeeNote	Employee entered note on time entry.
EmpNotes	Notes related to the Employee entered on Employee Information window
EnterpriseEmployeeId	Unique ID of employee, set by ScheduleSource.
EntryId	Unique ID for time entry, set by ScheduleSource.
EstimatedPayAmount	Final Hours times Estimated Pay Rate, for non-error entries. If error, then is zero.
EstimatedPayRate	Employee estimated hourly rate of pay. PayRate is assigned to an employee in the Location portal under the Scheduling tab in the Employee Information window.
ExternalId	Employee ID for use with an external system, such as HR or Payroll.
FinalEnterpriseOff	Rounded Off time of time entry, in Enterprise time zone.
FinalEnterpriseOn	Rounded On time of time entry, in Enterprise time zone.
FinalHours	Final Hours on time entry, after adjustments.
FinalLocalOff	Rounded Off time of time entry, in Location time zone.
FinalLocalOn	Rounded On time of time entry, in Location time zone.
FinalOff	Final (same as rounded) Off time for time entry, in UTC.
FinalOn	Final (same as rounded) On time for time entry, in UTC.
FirstName	Employee’s first name.
IsBillable	Flag that indicates whether the project/task used in the time entry is billable.
IsEmployeeApproved	Flag that indicates whether the employee has approved the time sheet.
IsError	Flag that indicates if the time entry has been flagged as an error.
IsLeave	Flag that indicates whether the project/task used in the time entry is a leave.
IsPaid	Flag that indicates whether the project/task used in the time entry is paid.
IsReviewed	Flag that indicates whether the time entry has been reviewed. If still an error and is reviewed, then the IsVoid flag is set.
IsSheetApproved	Flag that indicates if the employee time sheet has been approved at the location.
IsSheetEnterpriseLocked	Flag that indicates if the time sheet has been locked at the enterprise.
IsSheetLocked	Flag that indicates if the employee time sheet has been locked at the location.
IsVoid	Flag that indicates if the time entry is an error and has been reviewed.
LastName	Employee’s last name.
LocationOff	A string that stores a value that determines where the clock Off occurred. It might be an IP address, phone number, or the ID of a physical clock.
LocationOn	A string that stores a value that determines where the clock On occurred. It might be an IP address, phone number, or the ID of a physical clock.
LocationUserDefined1 - LocationUserDefined6	Custom field(s) identified in Admin > Custom Fields > Location.
OuterDate	UNUSED
PayAmout	Estimated pay based on time entry pay rate and final hours.
PayPeriodEnd	End date of the pay period.
PayPeriodId	Unique ID of the pay period, set by ScheduleSource.
PayPeriodStart	Start date of the pay period.
PayRate	Rate stored on the time entry. IIs set from the Time/Pay Rates configuration, with fallback to the Employee’s estimated Pay Rate.
Phone1	Employee’s phone number.
Phone2	Additional employee phone number.
Phone3	Additional employee phone number.
ProjectCode	The unique code for the Project of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
ProjectName	The name for the Project of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
ScheduleDate	Date of start of time entry, in location time zone (date portion only).
ScheduleDateMonth	Month of the schedule date.
ScheduleDateQuarter	Quarter of the schedule date.
ScheduleDateWeek	Week of the schedule date.
ScheduleDateYear	Year of the schedule date.
ScheduleDateYearMonth	Year/Month of the schedule date.
ScheduleDateYearQuarter	Year/Quarter of the schedule date.
ScheduleDateYearWeek	Year/Week of the schedule date.
SchNotes	Manager entered notes on the time entry.
SheetEmployeeFullName	The full name of the employee in the time sheet.
SheetEmployeeId	Employee Id from the time sheet.
TaskCode	The unique code for the Task of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
TaskName	The name for the Task of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
TimeReason	Reason code for clocking.
TimeSheetId	Unique ID of time sheet, set by ScheduleSource.
TimeZoneOffset	Location’s time zone number of minutes offset from UTC.
TimeZoneUsDay	Flag to indicate that the Location’s time zone honors daylight savings.
Type	Type of time sheet entry, either a clock, card, or admin entry.
UpdatedDate	Date of an update to an entry in a time sheet.
UpdateUserId	User ID of the person who made the update.
UserDefined1 - UserDefined6	Custom field(s) identified in Admin > Custom Fields > Employee.
UserName	Employee's username as entered in Username/ID in Employee Information window.
BillableHoursTotal	Sum of hours on time entries for Billable tasks, not including errors.
BusinessCount	Count of distinct locations.
EntryCount	Count of time entries.
HoursTotal	Sum of all time entry hours, including errors.
LeaveHoursTotal	Sum of hours on time entries for Leave tasks, not including errors.
NotLeaveHoursTotal	Sum of hours on time entries for non-Leave tasks, not including errors.
PaidHoursTotal	Sum of hours on time entries for Paid tasks, not including errors.
SheetCount	Count of distinct time sheets the time entries are associated with.
TotalBillAmount	Sum of Billable hours times billable rate.
TotalCalcHours	Sum of calculated Regular, Overtime, Premium, Leave, Break, Holiday, & Unpaid hours.
TotalCalcPaidHours	Sum of calculated Regular, Overtime, Premium, Leave, Break, & Holiday hours.
TotalCalcWorkHours	Sum of calculated Regular, Overtime, Premium, & Break hours.
TotalEstimatedPayAmount	Sum of estimated Pay Amount.
TotalPayAmount	Sum of Pay Amount.
UnBillableHoursTotal	Sum of hours on time entries for non-Billable tasks, not including errors.
UnPaidHoursTotal	Sum of hours on time entries for non-Paid tasks, not including errors.
ValidHoursTotal	Sum of hours on non-Error time entries.

Time and Shifts

You can report on processed time data. Reports gather information from the following sources:

Employee information is specified in the Add or Edit Employee window.
Location information is specified in the Add or Edit Location window.
Station information is specified in the Add or Edit Station window.
Billing information is specified in the Time > Configuration windows. See Time > Configuration and go to Pay Periods, Projects and Tasks, and Pay Rates.

Field	Description of contents
ActivityCode	Accounting code for a given activity entered in Time > Configuration > Activities. It is the code that identifies the activity.
ActivityName	Name of an activity entered in Time > Configuration > Activities. It is the name that identifies the activity.
ActualHours	Original clocked hours on time entry. (Before edits, rounding, etc.)
ActualOff	Original clock off time on time entry.
ActualOn	Original clock on time on time entry.
BreakHours	Number of hours in breaks.
BusinessExternalId	External ID of location. The External Id is used to coordinate TeamWork with external systems. It is blank unless your company integrates data with an external system.
BusinessName	The name of a location. (Entered in Name in the Location information window.)
BusinessNow	Current time at the location, when the report is run. (Useful in formulas)
ClientFirstName	First name of client assigned to shift. (Optional, only available If Client Management Module is activated.)
ClientFullName	Full name of client, displayed as “Last, First”.
ClientLastName	Last name of client assigned to shift. (Optional, only available If Client Management Module is activated.)
ClockOffUserId	Unique ID of User who clocked the employee off.
ClockOnUserId	Unique ID of User who clocked the employee on.
CreatedDate	Date the time entry was created.
EmpAlert	A flag for the employee to alert manager of note.
EmployeeFullName	Employee full name. Displayed as “Last, First”.
EmployeeId	Unique ID for the employee/location, set by ScheduleSource.
EmployeeRank	Rank of employee.
EmpNotes	Employee entered note on time entry.
EnterpriseRoundOff	Rounded Off time of time entry, in Enterprise time zone.
EnterpriseRoundOn	Rounded On time of time entry, in Enterprise time zone.
EnterpriseUpdated	Timestamp of last update, in Enterprise time zone.
EntryId	Unique ID for time entry, set by ScheduleSource.
FinalHours	Final Hours on time entry, after adjustments.
FinalOff	Final (same as rounded) Off time for time entry, in UTC.
FinalOn	Final (same as rounded) On time for time entry, in UTC.
FirstName	Employee’s first name.
IsBillable	Flag that indicates whether the project/task used in the time entry is billable.
IsError	Flag that indicates if the time entry has been flagged as an error.
IsLeave	Flag that indicates whether the project/task used in the time entry is a leave.
IsPaid	Flag that indicates whether the project/task used in the time entry is paid.
IsVoid	Flag that indicates if the time entry is an error and has been reviewed.
LastName	Employee’s last name.
LocalRoundOff	Rounded Off time of time entry, in Location time zone.
LocalRoundOn	Rounded On time of time entry, in Location time zone.
LocationOff	A string that stores a value that determines where the clock Off occurred. It might be an IP address, phone number, or the ID of a physical clock.
LocationOn	A string that stores a value that determines where the clock On occurred. It might be an IP address, phone number, or the ID of a physical clock.
MgrNotes	A note added to a time entry by the manager.
ProjectCode	The unique code for the Project of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
ProjectName	The name for the Project of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
SchDate	Schedule date of the time entry.
SchShiftBreak	Hours between break start and end.
SchShiftEnd	End time of shift. Only the time portion is returned.
SchShiftStart	Start time of shift. Only the time portion is returned.
ShiftId	Unique ID for a shift. Set by ScheduleSource.
ShiftNote	A comment added to shift.
ShiftOverlapEnd	The end time of overlapping time entry and shift segment.
ShiftOverlapHours	The hours within the time entry and shift overlapping segment.
ShiftOverlapStart	The start time of overlapping time entry and shift segment.
StationAllowSwap	Displays True if allow swap is chosen for this station in Enterprise; False if not allowed to swap.
StationCost	Displays estimated cost of the shift based on the station’s rate and shift hours.
StationId	Unique ID for station, set by ScheduleSource.
StationName	Name of Station.
StationOverlap	UNUSED
StationPayRate	Estimated pay for station.
StationRank	Priority of station versus other stations. 1-9 with 9 being the highest.
StationUserDefined1 - StationUserDefined6	Custom field(s) identified in Admin > Custom Fields > Station.
TaskCode	The unique code for the Task of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
TaskName	The name for the Task of the time entry. (Entered on the Add or Edit Project window under Time > Configuration > Project & Tasks.)
TimeCost	Estimated cost of time entry, based on time entry hours.
TimePayRate	Estimated pay rate, as stored on time entry.
TimeReason	Reason code for clocking.
Type	Type of time sheet entry, either a clock, card, or admin entry.
UpdatedDate	Date of an update to an entry in a time sheet.
UpdatedUserId	User ID of the person who made the update.
ActualHoursTotal	Sum of ActualHours on time entries.
BreakHoursTotal	Sum of BreakHours on time entries.
BusinessCount	Count of distinct locations for records selected.
EntryCount	Count of records selected.
FinalHoursTotal	Sum of FinalHours on time entries.
HoursTotal	Sum of calculated hours.
OrgStationCount	Count of distinct stations on associated shifts.
SchHoursTotal	Sum of shift hours.
ShiftOverlapHoursTotal	Sum of the overlapping hours of time entries and shifts.
StationCostTotal	Sum of estimated cost of shifts based on station pay rate.
StationCount	Count of distinct stations/locations.
TimeCostTotal	Sum of time entry estimated cost, based on pay rate and final hours of entry.