Inbound Earnings Spreadsheet Upload (PRI046)
- 29 Jul 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Inbound Earnings Spreadsheet Upload (PRI046)
- Updated on 29 Jul 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
Agency users will complete this inbound spreadsheet for the Bureau of State Payroll (BOSP) to upload payroll earnings transactions into the Paysheet Transaction Table (PSHUP_TXN). This functionality encompasses the creation of On-cycle/Off-cycle earning rows in Payroll within Florida PALM and ensures that PSHUP_TXN has loaded in a manner that will result in the successful creation and load of paysheets. The use of this spreadsheet requires BOSP approval and is intended to be used minimally.
Click below to view the interface file layout and sample data file.
Business Process Model
This interface can be found in the following business processes:
Selection Criteria
The interface data selection criteria includes the following:
Data Field | Data Field Details |
|---|---|
TBD | Payroll transaction details |
File Layout
Field names and descriptions from the interface layout are provided below.
| Data Field Name | Record Type | Data Field Description |
|---|---|---|
| Employee ID | Detail | This field is a unique system employee identifier. This employee ID, along with associated personal data and at least one row of job data, must already have been established in Florida PALM. |
| Position Number | Detail | This field is the unique number assigned to a position. Florida PALM assumes this number is unique across the interfacing system. |
| Appointment ID | Detail | It represents a distinct record for an employee within the system, encompassing essential details such as job assignments, compensation, and other relevant employment information. |
| Earnings Begin Date | Detail | This field is the begin date of the period for which the earnings apply. |
| Earnings End Date | Detail | This field is the end date of the period for which the earnings apply. |
| Pay Period End Date | Detail | The Pay Period End Date refers to the conclusion of a specific time frame during which an employee's work hours and related transactions are recorded for payroll processing |
| Earning Code | Detail | This field is the earning code that indicates the type of earnings/wages made by the employee. |
| Earning Pay Amount | Detail | This field is the earning pay amount, associated with the earning code provided, that will load to Florida PALM's Paysheet Transaction Table before paysheets are created during payroll processing. This amount is the employee's gross payment amount. |
| Earning Hours | Detail | This field is the hours the employee actually worked and is due earnings for. This field must be sent in conjunction with the associated hourly rate. |
| Hourly Rate | Detail | This field is the hourly rate of pay associated to the actual hours the employee worked and is due earnings for. This field must be sent in conjunction with the associated earning hours. |
| SpeedKey | Detail | This field is the valid SpeedKey (accounting) for funding information. |
| Contracted Hours | Detail | This field is the contracted hours the employee was available to work for the given pay period. |
| Intradepartment Number | Detail | This field is an intra-agency code that is used in conjunction with the ORG Code as a sort sequence for warrant distributions. |
| Filler1 | Detail | This field is reserved for future use in Florida PALM. |
| Filler2 | Detail | This field is reserved for future use in Florida PALM. |
| Filler3 | Detail | This field is reserved for future use in Florida PALM. |
| Filler4 | Detail | This field is reserved for future use in Florida PALM. |
| Filler5 | Detail | This field is reserved for future use in Florida PALM. |
| Filler6 | Detail | This field is reserved for future use in Florida PALM. |
| Filler7 | Detail | This field is reserved for future use in Florida PALM. |
| Filler8 | Detail | This field is reserved for future use in Florida PALM. |
| Filler9 | Detail | This field is reserved for future use in Florida PALM. |
| Filler10 | Detail | This field is reserved for future use in Florida PALM. |
Version History
Date | Revision Description |
|---|---|
03/12/2024 | Original Version |
Was this article helpful?
