Payroll Export File Output Properties
Additional data sets for the Payroll Export Output Property file are available
| Payroll Export Field | Payroll Export Field Name | Format | Description |
|---|---|---|---|
| Pay Range From | payRangeFrom | DATE | The from date passed to this script. |
| Pay Range Through | payRangeThrough | DATE | The through date passed to this script. |
| Institution Name | institutionName | CHAR(40) | The institution where the staffing record took place. |
| Institution Abbreviation | institutionAbbreviation | CHAR(10) | The abbreviation of the institution where the staffing record took place. |
| Institution External ID | institutionExternal ID | CHAR(40) | The institution external ID where the staffing record took place. |
| Agency Name | agencyName | CHAR(40) | The agency where the staffing record took place. |
| Agency Abbreviation | agencyAbbreviation | CHAR(10) | The agency abbreviation where the staffing record took place. |
| Agency External ID | agencyExternalID | CHAR( |
The agency external ID where the staffing record took place. |
| Region Name | regionName | CHAR(40) | The region where the staffing record took place. |
| Region Abbreviation | regionAbbreviation | CHAR(10) | The region abbreviation where the staffing record took place. |
| Region External ID | regionExternalID | CHAR( |
The region external ID where the staffing record took place. |
| Station Name | stationName | CHAR(40) | The station where the staffing record took place. |
| Station Abbreviation | stationAbbreviation | CHAR(10) | The station abbreviation where the staffing record took place. |
| Station External ID | stationExternalID | CHAR( |
The station external ID where the staffing record took place. |
| Unit Name | unitName | CHAR(40) | The unit where the staffing record took place. |
| Unit Abbreviation | unitAbbreviation | CHAR(10) | The unit abbreviation where the staffing record took place. |
| Unit External ID | unitExternalID | CHAR( |
The unit external ID where the staffing record took place. |
| Vehicle Name | vehicleName | CHAR(40) | The physical unit or vehicle where the staffing record took place. |
| Vehicle Abbreviation | vehicleAbbreviation | CHAR(10) | The physical unit or vehicle abbreviation where the staffing record took place. |
| Position Rank Level | positionRankLevel | INTEGER | The position's rank level for which the staffing record was entered. |
| Position Rank | positionRank | CHAR(40) | The position's rank for which the staffing record was entered. |
| Position Rank Abbreviation | positionRankAbbreviation | CHAR(10) | The position rank abbreviation for which the staffing record was entered. |
| Position External ID | positionExternalID | CHAR( |
The position External ID where the staffing record took place. |
| Position Specialties | positionSpecialties | CHAR(100) | The position specialties for which the staffing record was entered. |
| Position Shift Name | positionShiftName | CHAR(40) | The shift for which the staffing record was entered. |
| Position Shift Abbreviation | positionShiftAbbreviation | CHAR(10) | The shift abbreviation for which the staffing record was entered. |
| Position Shift From | positionShiftFrom | DATETIME | The start date and time for the Shift for which the staffing record was entered. |
| Position Shift Through | positionShiftThrough | DATETIME | The end date and time for the shift for which the staffing record was entered. |
| Calendar Date | calendarDate | DATE | The calendar date for which the staffing record was entered. |
| From | from | DATETIME | The from date and time for which the staffing record was entered. |
| Through | through | DATETIME | The through date and time for which the staffing record was entered. |
| Employee Payroll ID | employeePayrollID | CHAR(30) | The payroll ID of the staff member for which the staffing record was entered. |
| Employee Wage | employeeWage | DOUBLE | The hourly wage of the staff member for which the staffing record was entered. |
| Employee ID | employeeID | CHAR(30) | The employee ID of the staff member for which the staffing record was entered. |
| Employee Name | employeeName | CHAR(40) | The name of the staff member for which the staffing record was entered. |
| Shift Name | shiftName | CHAR(40) | The shift of the staff member for which the staffing record was entered. Returns blank value in this application. Field replaced by Position Shift Name. |
| Shift Abbreviation | shiftAbbreviation | CHAR(2) | The shift abbreviation of the staff member for which the staffing record was entered. Returns blank value in this application. Field replaced by Position Shift Abbreviation. |
| Rank Level | rankLevel | INTEGER | The rank level of the staff member for which the staffing record was entered. |
| Rank Name | rankName | CHAR(40) | The rank of the staff member for which the staffing record was entered. |
| Rank Abbreviation | rankAbbreviation | CHAR(10) | The rank abbreviation of the staff member for which the staffing record was entered. |
| Specialties | specialties | CHAR(100) | The specialties of the staff member for which the staffing record was entered. |
| Hours | hours | DOUBLE | The hours or duration of the staffing record. |
| Hours Left of Shift (LOS) | hoursLeftOfShift | DOUBLE | The hours or duration of the staffing record to the left of the shift split definition. |
| Hours Right of Shift (ROS) | hoursRightOfShift | DOUBLE | The hours or duration of the staffing record to the right of the shift split definition. |
| Roster Symbol | rosterSymbol | CHAR(100) | The roster code name of the staffing record exactly how it appears on the roster. |
| Roster Name | rosterName | CHAR(40) | The roster code name of the staffing record. |
| Roster Abbreviation | rosterAbbreviation | CHAR(10) | The roster code abbreviation of the staffing record. |
| Payroll Code | payrollCode | CHAR(30) | The payroll code of the staffing record. |
| Roster Note | rosterNote | CHAR(100) | The note stored with the Roster code. |
| Wage Factor | wageFactor | DOUBLE | The wage factor of the payroll code of the staffing record. |
| Cost | cost | DOUBLE | cost = hours * wage * wage factor of the payroll code of the staffing record. |
| Detail Code | detailCode | CHAR(20) | The roster detail code associated with this staffing record. |
| Log Opportunity | logOpportunity | CHAR(1) | This staffing record is logged to the opportunity #'s for the person. |
| Log List | logList | CHAR(1) | This staffing record is logged to the list hrs for the person. |
| Log Work Code | logWorkCode | CHAR(1) | This staffing record is logged to the work code hrs for the person. |
| Account Code | accountCode | CHAR(30) | The account code of the staffing record. |
| Caused By Employee Name | causedByEmployeeName | CHAR(40) | The name of the staff member who's vacancy caused the need for this staffing record. |
| Caused By Employee ID | causedByEmployeeID | CHAR(30) | The employee ID of the staff member who's vacancy caused the need for this staffing record. |
| Cause By Payroll ID | causedByPayrollID | CHAR(30) | Payroll ID of the staff member who's vacancy caused the need for this staffing record. |
| Caused By Wage Factor | causedByWageFactor | DOUBLE | Hourly wage of the staff member who's vacancy caused the need for this staffing record. |
| Caused By Rank Level | causedByRankLevel | INTEGER | Rank level of the staff member who's vacancy caused the need for this staffing record. |
| Caused by Rank | causedByRank | CHAR(40) | Rank of the staff member who's vacancy caused the need for this staffing record. |
| Caused By Rank Abbreviation | causedByRankAbbreviation | CHAR(10) | The Rank abbreviation of the staff member whose vacancy caused the need for this staffing record. |
| Caused By Specialties | causedBySpecialties | CHAR(100) | The Specialty of the staff member whose vacancy caused the need for this staffing record. |
| Caused By Hours | causedByHours | DECIMAL(11,4) | The Hours or Duration of the staffing record that caused the need for this staffing record. |
| Caused By Roster Name | causedByRosterName | CHAR(40) | The work code name of the staffing record on the Roster that caused the need for this staffing record. |
| Caused By Roster Abbreviation | causedByRosterAbbreviation | CHAR(10) | The work code abbreviation of the staffing record on the Roster that caused the need for this staffing record. |
| Caused By Payroll Code | causedByPayrollCode | CHAR(30) | The Payroll code of the staffing record that caused the need for this staffing record. |
| Caused By Wage Factor | causedByWageFactor | DOUBLE | The Wage factor of the Payroll code associated with the staffing record that caused the need for this staffing record. |
| Caused By Cost | causedByCost | DOUBLE | cost = hours * wage * wage factor of payroll code of the staffing record that caused the need for this staffing record. |
| Caused By Detail Code | causedByDetailCode | CHAR(10) | The Detail Code of the staffing record that caused the need for this staffing record. |
| FLSA Hours | flsaHours | DOUBLE | The total number of FLSA hours for the person over the given period. |
| RSC No In | rscNoIn | INTEGER | The Internal ID of this application for profile of NAME person above. |
| RSC Master No In | rscMasterNoIn | INTEGER | The Internal ID of this application for the person referenced in rscNoIn. |
| Staffing No In | staffingNoIn | INTEGER | The Internal ID of this application for this staffing record. |
| Hole Staffing No In | holeStaffingNoIn | INTEGER | The Internal ID of this application for the staffing record that caused the need for this staffing record. |
| Staff By | staffBy | CHAR(50) | The name of the person who last modified this staffing record. |
| Toward FLSA Hours | towardFlsaHours | CHAR(1) | Y=YES; indicates that this staffing record should be totaled into the FLSA hours. |
| FLSA Hours Shift | flsaHoursShift | DOUBLE | The threshold for FLSA hours for the SHIFT above. |
| FLSA Hours Total | flsaHoursTotal | DOUBLE | The total FLSA hours summed for the given period. To show a value in this field the person must exceed their FLSA threshold for the period. FLSA is defined in Setup > Pay Information, and applied to the person’s Profile in Pay Group. |
| Record Count | recordCount | The count of records over the given period for the person above. |