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 20 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 20 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 List¹	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 20 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 20 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 20 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 20 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