Time and Labor 12 Export File Properties

Time and Labor 12

The following is the list of fields that are included for each record sent using the Time and Labor 12 task type:
Lay Term Format DB Column Name TnL12 Field Name
Employee Payroll ID max 30 characters RscMaster_PayrollID_Ch RscPayrollIDCh
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
Duration 0.00 (2 decimal places)   {StaffingDurationIn,0.00}
Work Code Account Max 30 characters wstat_account_Ch wstat_account_Ch
Work code Group Number     WstatGroupNumberIn
Calendar Date mm/dd/yyyy Staffing_Calendar_Da {StaffingCalendarDa,mm/dd/yyyy}
Institution External ID max 40 characters Institution_ExternalID_Ch InstitutionExternalIDCh
Agency External 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
Note max 100 characters


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

 Staffing_Note_Vc StaffingNoteVc
Last modified date/time mm/dd/yyyy hh:mm:ss Staffing_CreateDate_Dt StaffingCreateDateDt
Removed? one number
  • True=removed
  • False=not-removed
   Removed
Record Type one number
  • -1=scheduled
  • 1=assigned
  • 3=exception
   RecordType
The Payroll ID of the person who finalized the Roster record max 30 characters RscMaster_PayrollID_Ch FinalizedByRscPayrollIDCh
The External ID of the Unit on the Finalized By Person’s Assignment TAB max 40 characters Unit_ExternalID_Ch FinalizedByAssignmentUnitExternalId
The External ID of the Unit on the Finalized By Person’s Staffing Record (Roster) max 40 characters Unit_ExternalID_Ch FinalizedByRostertUnitExternalId
Finalized by Person Work Code Working? Used to indicate whether the approver was working or not at the time the record was finalized. one number
  • 1=working
  • 0=nonworking
 FinalizedByWstat_IsWorkingChk_Si FinalizedByWStatIsWorkingGm
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
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}
Parent topic: Task Manager