| 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 Gray Number |
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 20 characters |
Staffing_Detail_Ch |
StaffingDetailCh |
| Account code |
max 30 characters |
Staffing_Account_Ch |
StaffingAccountCh |
| Duration |
0.00 (2 decimal places) |
|
{StaffingDurationIn,0.00} |
| Calendar Date |
mm/dd/yyyy |
Staffing_Calendar_Da |
{StaffingCalendarDa_mm_dd_yyyy} |
| Start Date/Time |
mm/dd/yyyy hh:mm:ss |
Staffing_Start_Dt |
{StaffingStartDt_mm_dd_yyyy_hh_nn_ss} |
| End Date/Time |
mm/dd/yyyy hh:mm:ss |
Staffing_End_Dt |
{StaffingEndDt_mm_dd_yyyy_hh_nn_ss} |
| Work Code Working? |
one number
|
Wstat_IsWorkingChk_Si |
WStatIsWorkingGm |
| Note |
max 100 characters
*max 255 characters as of v5.4.6+, v6.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 |
max10 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 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 |