Roster Export Types and File Properties

Roster 02 (Zoll) Export Properties

This message format was originally designed for Zoll, which requires a binary file format. To apply and convert a binary file format, the file name must be prefixed with bin. See Roster 02 Export in Binary File Format (.bin*) for details. The following is the list of fields that are included for each record sent using the Roster 02 Export task type:

IMPORTANT - Read before executing task type Roster 02
The application default date format is ISO XML compliant. To automatically convert the dates to the initial agreed upon vendor format use the Transform File Using Template (.ftl) in task type Roster 02.
Lay Term Format DB Column Name ROS02 Field Name
Region Abbreviation max 10 characters Region_Abrv_Ch RegionAbrvCh
Station Abbreviation max 10 characters Station_Abrv_Ch StationAbrvCh
Phy. Unit Abbreviation max 10 characters PUnit_Abrv_Ch PUnitAbrvCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Work code Abbreviation max 10 characters Wstat_Abrv_Ch WstatAbrvCh
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WStatIsWorkingGm
Duration 0.00 (2 decimal places)   StaffingDurationIn
Start Date/Time
  • CSV Output: yyyy-MM-dd HH:mm as of v 6.4.3
  • Prior to v6.4.3 CSV Output: HH:mm
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_Start_Dt StaffingStartDt,hh:mm±hh:mm
End Date/Time
  • CSV Output: yyyy-MM-dd HH:mm as of v 6.4.3
  • Prior to v6.4.3 CSV Output: HH:mm
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_End_Dt StaffingEndDt,hh:mm±hh:mm
Display Number # (integer)   DisplayOrderGm
Note max 100 characters


*max 255 characters as of v5.4.6+, v6.3.1+

 Staffing_Note_Vc StaffingNoteGm

Roster 03 (Firehouse) Export Properties

This message format was originally designed for Firehouse.The following is the list of fields that are included for each record sent using the Roster 03 Export task type:

Lay Term Format DB Column Name ROS03Field Name
Shift Abbreviation max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Agency Abbreviation max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Region Abbreviation max 10 characters Region_Abrv_Ch RegionAbrvCh
Station Abbreviation max 10 characters Station_Abrv_Ch StationAbrvCh
Phy. Unit Abbreviation max10 characters PUnit_Abrv_Ch PUnitAbrvCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Work code Abbreviation max 10 characters Wstat_Abrv_Ch WstatAbrvCh
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WStatIsWorkingGm
Duration 0.00 (2 decimal places)   StaffingDurationIn
Start Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_Start_Dt StaffingStartDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
End Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_End_Dt StaffingEndDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
Display Number # (integer)   DisplayOrderGm

Roster 04 (Tiburon) Export Properties

This message format was originally designed for Tiburon RMS. The following is the list of fields that are included for each record sent using the Roster 04 Export task type. The following is the list of fields that are included for each record sent using the Roster 04 Export task type:

IMPORTANT - Read before executing task type Roster 04
The application default date format is ISO XML compliant. To automatically convert the dates to the initial agreed upon vendor format use the Transform File Using Template (.ftl) in task type Roster 04.
Lay Term Format DB Column Name ROS04 Field Name
Shift Abbreviation max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Agency Abbreviation max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Region Abbreviation max 10 characters Region_Abrv_Ch RegionAbrvCh
Station Abbreviation max 10 characters Station_Abrv_Ch StationAbrvCh
Phy. Unit Abbreviation max10 characters PUnit_Abrv_Ch PUnitAbrvCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Work code Abbreviation max 10 characters Wstat_Abrv_Ch WstatAbrvCh
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WStatIsWorkingGm
Duration 0.00 (2 decimal places)   StaffingDurationIn
Start Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_Start_Dt StaffingStartDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
End Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_End_Dt StaffingEndDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
Display Number # (integer)   DisplayOrderGm
Note max 100 characters


*max 255 characters as of v5.4.6+, v6.3.1+

 Staffing_Note_Vc StaffingNoteGm
Detail code max 10 characters Staffing_Detail_Ch StaffingDetailCh

Roster 05 (Target Solutions) Export Properties

This message format was originally designed for Target Solutions. The following is the list of fields that are included for each record sent using the Roster 05 Export task type:

IMPORTANT - Read before executing task type Roster 05
The application default date format is ISO XML compliant. To automatically convert the dates to the initial agreed upon vendor format use the Transform File Using Template (.ftl) in task type Roster 05.
Lay Term Format DB Column Name ROS05 Field Name
Shift Abbreviation max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Agency Abbreviation max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Region Abbreviation max 10 characters Region_Abrv_Ch RegionAbrvCh
Station Abbreviation max 10 characters Station_Abrv_Ch StationAbrvCh
Phy. Unit Abbreviation max10 characters PUnit_Abrv_Ch PUnitAbrvCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Work code Abbreviation max 10 characters Wstat_Abrv_Ch WstatAbrvCh
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WStatIsWorkingGm
Duration 0.00 (2 decimal places)   StaffingDurationIn
Start Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_Start_Dt StaffingStartDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
End Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_End_Dt StaffingEndDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
Display Number # (integer)   DisplayOrderGm
Shift Start
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Shift_Start_Dt ShiftStartDt
Note max 100 characters


*max 255 characters as of v5.4.6+, v6.3.1+

 Staffing_Note_Vc StaffingNoteGm
Detail code max 10 characters Staffing_Detail_Ch StaffingDetailCh
Person FormulaID max 500 characters FormulaID_Name_Ch RscFormulaIDCh
Person Attachment max 200 characters Attach_Name_Ch RscDispatchAttachCh
Position Formula ID max 500 characters FormulaID_Name_Ch PosFormulaIDCh
Shift Attachment max 200 characters Attach_Name_Ch ShiftDispatchAttachCh
Agency Attachment max 200 characters Attach_Name_Ch AgencyDispatchAttachCh
Region Attachment max 200 characters Attach_Name_Ch RegionDispatchAttachCh
Station Attachment max 200 characters Attach_Name_Ch StationDispatchAttachCh
Phy. Unit Attachment max 200 characters Attach_Name_Ch PunitDispatchAttachCh
Position Attachment max 200 characters Attach_Name_Ch PosDispatchAttachCh

Roster 06 (Intergraph) Export Properties

This message format was originally designed for Intergraph. The following is the list of fields that are included for each record sent using the Roster 06 Export task type:

Lay Term Format DB Column Name ROS06 Field Name
Employee Payroll ID max 30 characters RscMaster_PayrollID_Ch RscPayrollIDCh
Shift Abbreviation max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Agency Abbreviation max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Employee’s Specialty Abbreviation List1 Max 100 characters   RscXSpecNames
Duration 0.00 (2 decimal places)   StaffingDurationIn
Shift Start
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Shift_Start_Dt ShiftStartDt
Note max 100 characters


*max 255 characters as of v5.4.6+, v6.3.1+

 Staffing_Note_Vc StaffingNoteGm
Phy. Unit Abbreviation max10 characters PUnit_Abrv_Ch PUnitAbrvCh
Position Formula ID max 500 characters FormulaID_Name_Ch PosFormulaIDCh

Roster 08 (Tritech) Export Properties

This message format was originally designed for Tritech. The following is the list of fields that are included for each record sent using the Roster 08 Export (Tritech) task type:

IMPORTANT - Read before executing task type Roster 08
The application default date format is ISO XML compliant. To automatically convert the dates to the initial agreed upon vendor format use the Transform File Using Template (.ftl) in task type Roster 08.
Lay Term Format DB Column Name ROS08 Field Name
Shift Abbreviation max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Agency Abbreviation max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Region Abbreviation max 10 characters Region_Abrv_Ch RegionAbrvCh
Station Abbreviation max 10 characters Station_Abrv_Ch StationAbrvCh
Phy. Unit Abbreviation max10 characters PUnit_Abrv_Ch PUnitAbrvCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Work code Abbreviation max 10 characters Wstat_Abrv_Ch WstatAbrvCh
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WStatIsWorkingGm
Duration 0.00 (2 decimal places)   StaffingDurationIn
Start Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_Start_Dt StaffingStartDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
End Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_End_Dt StaffingEndDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
Display Number # (integer)   DisplayOrderGm
Note max 100 characters


*max 255 characters as of v5.4.6+, v6.3.1+

 Staffing_Note_Vc StaffingNoteGm
Detail code max 10 characters Staffing_Detail_Ch StaffingDetailCh
Phy. Unit name max 40 characters PUnit_Name_Ch PUnitNameCh

Roster 09 (Intergraph iLeads) Export Properties

This message format was originally designed for Intergraph iLeads. The following is the list of fields that are included for each record sent using the Roster 09 Export task type:

Lay Term Format DB Column Name ROS09 Field Name
Employee Payroll ID max 30 characters RscMaster_PayrollID_Ch RscPayrollIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Shift Abbreviation max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Agency Abbreviation max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Region Abbreviation max 10 characters Region_Abrv_Ch RegionAbrvCh
Station Abbreviation max 10 characters Station_Abrv_Ch StationAbrvCh
Phy. Unit Abbreviation max10 characters PUnit_Abrv_Ch PUnitAbrvCh

Roster Export 10 (ImageTrend) Export Properties

This message format was originally designed for ImageTrend. The following is the list of fields that are included for each record sent using the Roster 10 Export task type:

Lay Term Format DB Column Name ROS10 Field Name
Employee Payroll ID max 30 characters RscMaster_PayrollID_Ch RscPayrollIDCh
Employee Name max 40 characters RscmaxMaster_Name_Ch RscMasterNameCh
Employee Formula ID max 500 characters   RscFormulaIDCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
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.00 (2 decimal places)   StaffingDurationIn
Start Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_Start_Dt StaffingStartDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
End Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_End_Dt StaffingEndDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WstatIsWorkingGm
Note max 100 characters


*max 255 characters as of v5.4.6+, v6.3.1+

 Staffing_Note_Vc StaffingNoteGm
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
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 max 10 characters PUnit_Abrv_Ch PUnitAbrvCh
Unit External ID max 40 characters Unit_ExternalID_Ch UnitExternalIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Position External ID max 40 characters Pos_ExternalID_Ch PosExternalIDCh
Staffing Gray Number number Staffing_No_In StaffingNoIn
Last modified date/time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_CreateDate_Dt StaffingCreateDateDt
Removed? one number
  • True=removed
  • False=not-removed
   Removed
Record Type one number
  • -1=scheduled
  • 1=assigned
  • 3=exception
   RecordType
Display Number # (integer)   DisplayOrderGm

Roster Export 11 Properties

The following is the list of fields that are included for each record sent using the Roster 11 Export task type:

Lay Term Format DB Column Name ROS11 Field Name
Employee Payroll ID max 30 characters RscMaster_PayrollID_Ch RscPayrollIDCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Employee Name max 40 characters RscmaxMaster_Name_Ch RscMasterNameCh
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; 50 characters as of v7.0.1+ Staffing_Account_Ch StaffingAccountCh
Calendar Date mm/dd/yyyy Staffing_Calendar_Da StaffingCalendarDa,mm/dd/yyyy
Duration 0.00 (2 decimal places)   StaffingDurationIn
Start Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_Start_Dt StaffingStartDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
End Date/Time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_End_Dt StaffingEndDt,YYYY-MM-DDThh:mm:ss.sss±hh:mm
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WStatIsWorkingGm
Note max 100 characters


*max 255 characters as of v5.4.6+, v6.3.1+

 Staffing_Note_Vc StaffingNoteGm
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
AgencyExternal 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 max 10 characters PUnit_Abrv_Ch PUnitAbrvCh
Unit External ID max 40 characters Unit_ExternalID_Ch UnitExternalIDCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Position External ID max 40 characters Pos_ExternalID_Ch PosExternalIDCh
Staffing Gray Number number Staffing_No_In StaffingNoIn
Last modified date/time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_CreateDate_Dt StaffingCreateDateDt
Removed? one number
  • True=removed
  • False=not-removed
   Removed
Record Type one number
  • -1=scheduled
  • 1=assigned
  • 3=exception
   RecordType
Display Number # (integer)   DisplayOrderGm

Roster Export Properties

The following is the list of fields that are included for each record sent using the Roster Export task type available as of application version 7.1.8, and 7.2.1:

Lay Term Format DB Column Name ROSTER EXPORT Field Name
Record Type one number
  • -1=scheduled
  • 1=assigned
  • 3=exception
   RecordType
Employee General Unique Identifier number RsMaster_No_In RscMasterNoIn
Employee Name max 40 characters RscmaxMaster_Name_Ch RscMasterNameCh
Employee ID max 30 characters Rsc_Master_EmployeeID_Ch RscEmployeeIDCh
Employee External ID Max 30 characters RscMaster_ExternalID_Ch RscExternalCh
Employee Payroll ID max 30 characters RscMaster_PayrollID_Ch RscPayrollIDCh
Employee Formula ID max 500 characters   RscFormulaIDCh
Shift Abbreviation max 10 characters Shift_Abrv_Ch ShiftAbrvCh
Institution Abbreviation max 10 characters Institution_Abrv_Ch InstitutionAbrvCh
Agency Abbreviation max 10 characters Agency_Abrv_Ch AgencyAbrvCh
Region Abbreviation max 10 characters Region_Abrv_Ch RegionAbrvCh
Station Abbreviation max 10 characters Station_Abrv_Ch StationAbrvCh
Phy. Unit Abbreviation max 10 characters PUnit_Abrv_Ch PUnitAbrvCh
Pos’ Rank Abbreviation max 10 characters Job_Abrv_Ch PosJobAbrvCh
Duration 0.0### (1-4 decimal places)   StaffingDurationIn
Start Date/Time mm/dd/yyyy hh:mm:ss Staffing_Start_Dt StaffingStartDt
End Date/Time mm/dd/yyyy hh:mm:ss Staffing_End_Dt StaffingEndDt
Display Order string   DisplayOrder
Note Max 100 characters


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

 Staffing_Note_Vc StaffingNoteVc
Detail code max 10 characters Staffing_Detail_Ch StaffingDetailCh
Person Attachment max 200 characters Attach_Name_Ch RscDispatchAttachCh
Position Formula ID max 500 characters FormulaID_Name_Ch PosFormulaIDCh
Shift Attachment max 200 characters Attach_Name_Ch ShiftDispatchAttachCh
Institution Attachment max 200 characters   InstitutionDispatchAttach
Agency Attachment max 200 characters Attach_Name_Ch AgencyDispatchAttachCh
Region Attachment max 200 characters Attach_Name_Ch RegionDispatchAttachCh
Station Attachment max 200 characters Attach_Name_Ch StationDispatchAttachCh
Phy. Unit Attachment max 200 characters Attach_Name_Ch PunitDispatchAttachCh
Position Attachment max 200 characters Attach_Name_Ch PosDispatchAttachCh
Institution External ID max 40 characters Institution_ExternalID_Ch InstitutionExternalIDCh
AgencyExternal ID max 40 characters Agency_ExternalID_Ch AgencyExternalIDCh
Region External ID max 40 characters Region_ExternalID_Ch RegionExternalIDCh
Station External ID max 40 characters Station_ExternalID_Ch StationExternalIDCh
Unit External ID max 40 characters Unit_ExternalID_Ch UnitExternalIDCh
Position External ID max 40 characters Pos_ExternalID_Ch PosExternalIDCh
Position Formula ID Override max 40 characters Staffing_FormulaID_Ch StaffingFormulaIDCh
Account code max 30 characters Staffing_Account_Ch StaffingAccountCh
Work code Abbreviation max 10 characters Wstat_Abrv_Ch WstatAbrvCh
Work code Payroll ID max 30 characters WstatPayroll_Ch WstatPayrollCh
Shift Start
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Shift_Start_Dt ShiftStartDt
Shift End
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Shift_End_Dt ShiftEndDt
Employee’s Specialty Abbreviation List Max 100 characters   RscXSpecNames
Phy. Unit name max 40 characters PUnit_Name_Ch PUnitNameCh
Staffing Record Unique Identifier number Staffing_No_In StaffingNoIn
Last modified date/time
  • CSV Output: mm/dd/yyyy hh:mm:ss
  • XML output ISO 8601: YYYY-MM-DDThh:mm:ss.sss
 Staffing_CreateDate_Dt StaffingCreateDateDt
Record Type one number
  • -1=scheduled
  • 1=assigned
  • 3=exception
   RecordType
Removed? one number
  • True=removed
  • False=not-removed
   Removed
Staffing Record Request Status String
  • TRUE = Request
  • FALSE = Not a Request
   Request
Employee Profile Unique Identifier Number   RscNoIn
Calendar Date mm/dd/yyyy Staffing_Calendar_Da StaffingCalendarDa,mm/dd/yyyy
Checked-In dateTime

<! -- DERIVED -->

   CheckInTimestamp
Work Code Working? one number
  • 1=working
  • 0=nonworking
 Wstat_IsWorkingChk_Si WStatIsWorkingGm
Display Number # (integer)   DisplayOrderGm
Parent topic: Task Manager
1 ROS06 includes skills and certification type specialties as of v7.3.3, 7.4+.