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


Field

Description of contents

Active

A flag that indicates whether employee is available for use in scheduling shifts. Displays on reports as True if active and False if inactive. Status is active unless an inactive date is set on Employee Status window.

Address

Employee's street address. (Entered in Address in the Employee information window.)

Address2

Additional information for employee address. (Entered in Address2 in the Employee information window.)

AgreementType

Employee's agreement type as entered in Enterprise portal employee record. (Go to Edit Employees > Agreements.)

AttendanceId

Unique ID set by ScheduleSource on attendance entries.

BirthDate

Employee's birthdate. (Entered in Birth Date in the Employee information window.)

City

City of the employee address. (Entered in City in Employee information window.)

Country

Country of the employee address. (Entered in Country in Employee information window.)

Created

Timestamp of when attendance was created (UTC).

CreatedBy

If exception created manually, name of user creating it.

CreatedLocal

Timestamp of when attendance was created (Local).

Date

Date of the attendance occurring.

DefaultLocation

Name of employee’s default location.

DefaultLocationExternalId

External ID of employee’s default location.

DefaultLocationId

Unique ID of default location, set by ScheduleSource.

EMail

Email of the employee. (Entered in Email in Employee information window.)

ExternalId

Employee ID for use with an external system, such as HR or Payroll

FirstName

Employee’s first name. (Entered in First Name in Employee information window.)

FullName

Employee full name. Displayed as “Last, First”.

HireDate

Employee Start Date.

LastName

Employee last name. (Entered in Last Name in Employee information window.)

Location

Name of location for shift or time entry.

LocationExternalId

External ID of the location.

Minutes

For some attendance records, how many minutes they were late or early.

Note

Note on the attendance record.

OrgEmployeeId

Unique ID of employee, set by ScheduleSource.

PhoneNo

Employee’s phone number.

PhoneNo2

Additional employee phone number. (Entered in Ph2 (cell) in Employee Information window.)

PhoneNo3

Additional employee phone number. (Entered in Ph3 (other) in Employee Information window.)

Points

Points for the attendance record, as defined on the attendance setup in the policy.

Policy

Indicates policy name entered in Employee Policy window in Organization > Policies and assigned to an employee when you assign an employee agreement. Use Employees > Mass-Assign or add a new employee agreement in Employees > Agreements and designate a policy related to the agreement.

Position

Indicates position name entered into Admin > Lists > Employee Positions and assigned to an employee when you assign an employee agreement. Use Employees > Mass-Assign or add a new employee agreement in Employees > Agreements and designate a position related to the agreement.

PostalCode

Employee's zip code or postal code.

Rule

Indicating the reason for the Attendance record (Late In, Late Out).

RuleId

Unique ID for rule, generated by ScheduleSource.

State

Employee’s state (from Address settings).

TermDate

Termination or Inactive date of employee. (Entered in Inactive Date in Employee Status window.)

TimeZoneOffset

The hour difference between UTC time and the time zone setting for the employee. (Selected under Employee Information > Time & Attendance.)

TimeZoneUSDay

Indicates daylight savings for time zone: 1=Yes, i.e., Auto Adjust for daylight savings time or 0=No, i.e., do not adjust for daylight savings time.

UserDefined1 - UserDefined6

Custom field(s) identified in Admin > Custom Fields > Employee.

UserName

Employee's username. (Entered in Username/ID in Employee Information window.)

Valid

Confirmed =1, Open = 0, Void = -1.

Validated

Timestamp (UTC) for validation.

ValidatedBy

Name of user validating the record.

ValidatedLocal

Local timestamp for validation.

 Count

A count of the Attendance records, grouped by the other fields selected.

 MinutesAverage

Average of minutes of selected Attendance records, grouped by the other fields selected.

 MinutesTotal

Sum of minutes of selected Attendance records, grouped by the other fields selected.

 PointAverage

Average of points of selected Attendance records, grouped by the other fields selected.

 PointTotal

Sum of points of selected Attendance records, grouped by the other fields selected.


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.


Time Audit

You can report on time-related 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

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

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

Employee’s email address.

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.

FinalHours

Final Hours on time entry, after adjustments.

FinalOff

Rounded Off time of time entry, in Location time zone.

FinalOn

Rounded On time of time entry, in Location time zone.

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.

IsSheetApproved

Flag that indicates if the employee time sheet has been approved at the location.

IsSheetLocked

Flag that indicates if the employee time sheet has been locked at the location.

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

PayAmount

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

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

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.

UpdateReason

Internal code for the type of update.

UpdateUserFullName

Full name of user who last updated the time entry.

UserDefined1 - UserDefined6

Custom field(s) identified in Admin > Custom Fields > Employee. 

UserName

Employee's username. (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.

 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.