Workforce Ready Roster Exports... File Properties

The Workforce Ready Roster exports are used to send roster staffing records to a Workforce Ready (WFR) timesheet or schedule. This export task is an add-on feature that enables within the Task Manager when sourced.

The Roster to Workforce Ready Export Settings are used to map roster time and labor entries from this application to WFR cost centers for the purposes of feeding and automatically populating WFR employee timesheets1 or schedules2.

Task Type WFR TLM Timecard WFR TLM Basic Schedules
Roster Export to Workforce Ready Time Entry

Used when employees are paid from Schedule.

X  
Workforce Ready Roster Export to Employee Schedules

Used when employees are paid from Punch.

  X

Workforce Ready Roster Export...

The following is the list of fields that may be mapped in the Workforce Ready Timeoff to Workcode Mapping area located Setup > System > Import Manager...Integration Type Workforce Ready
Lay Term Format DB Column Name WFR ROS Export Field Name
Employee Payroll ID Max 30 characters RscMaster_PayrollID_Ch RscPayrollIDCh
Employee ID Max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Employee External ID Max 30 characters RscMaster_ExternalID_Ch RscExternalCh
Employee General Unique Identifier number RsMaster_No_In RscMasterNoIn
Employee Profile Unique Identifier number Rsc_No_In Rsc_No_In
Employee Formula ID Max 500 characters   RscFormulaIDCh
Work code payroll ID Max 30 characters WstatPayroll_Ch WstatPayrollCh
Work code Abbreviation Max 10 characters Wstat_Abrv_Ch WstatAbrvCh
Detail code Max 10 characters Staffing_Detail_Ch StaffingDetailCh
Account code Max 30 characters Staffing_Account_Ch StaffingAccountCh
Duration 0.0### (1-4 decimal places)   StaffingDurationIn
Work Code Working? one number
  • 1=working
  • 0=nonworking
  WstatIsWorkingGm
Note Max 100 characters


*Max 255 characters as of v5.4.6+, 6.3.1+

Staffing_Note_Vc StaffingNoteVc
Position Formula ID Max 500 characters FormulaID_Name_Ch PosFormulaIDCh
Position Formula ID Override Max 40 characters Staffing_FormulaID_Ch StaffingFormulaIDCh
Shift Abbreviation Max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Institution Abbreviation Max 10 characters Institution_Abrv_Ch InstitutionAbrvCh
Institution External ID Max 40 characters Institution_ExternalID_Ch InstitutionExternalIDCh
Agency Abbreviation Max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Agency External ID Max 40 characters Agency_ExternalID_Ch AgencyExternalIDCh
Region Abbreviation Max 10 characters Region_Abrv_Ch RegionAbrvCh
Region External ID Max 40 characters Region_ExternalID_Ch RegionExternalIDCh
Station Abbreviation Max 10 characters Station_Abrv_Ch StationAbrvCh
Station External ID Max 40 characters Station_ExternalID_Ch StationExternalIDCh
Phy. Unit Abbreviation up to10 characters PUnit_Abrv_Ch PUnitAbrvCh
Unit External ID Max 40 characters Unit_ExternalID_Ch UnitExternalIDCh
Pos’ Rank Abbreviation Max 10 characters JobAbrv_Ch PosJobAbrvCh
Position External ID Max 40 characters Pos_ExternalID_Ch PosExternalIDCh
Staffing Unique Identifier number Staffing_No_In StaffingNoIn
Record Type one number
  • -1=scheduled
  • 1=assigned
  • 3=exception
  RecordType
Display Number # (integer)   DisplayOrderGm
Duration Respect Shift Break Hours 0.0### (1-4 decimal places)   PayDurationIn
Institution Unique Identifier number Institution_No_In InstitutionNoIn
Region Unique Identifier number Region_No_In RegionNoIn
Shift Unique Identifier number Shift_No_In ShiftNoIn
Blueprint field information enable and available as of version 6.6 when using Blueprints.
Lay Term Format DB Column Name WFR ROS Export Fields
Order Information Max 40 characters   BlueprintOrderInformation
Blueprint Labels Max 40 characters   BlueprintLabels
Blueprint SKU     BlueprintSKU
Blueprint Name Max 40 characters   BlueprintName
Blueprint External ID Max 40 characters   BlueprintExternalId
Blueprint Job Abbrev. (Job meaning Blueprint position) Max 10 characters   BlueprintJobAbrv
Blueprint Job Account (Job meaning Blueprint position) Max 10 characters   BlueprintJobAccount
Blueprint Job Specialties (Job meaning Blueprint position) Max 40 characters   BlueprintJobSpecialties
Blueprint Job Group (Job meaning Blueprint position) Max 40 characters   BlueprintJobGroup
1 Available as of application version 6.4.1.
2 Available as of application version 6.6