Inbound Agency Position Funding Spreadsheet Upload (PRI038)
-
Print
-
DarkLight
-
PDF
Inbound Agency Position Funding Spreadsheet Upload (PRI038)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
To support payroll distribution, all active positions must have valid Position Funding in Florida PALM. Position Funding will initially be loaded into Florida PALM through Department Budget Position Funding Load (PRC017). Afterwards, position funding will be updated manually on the delivered Department Budget Earnings Page or via the Inbound Agency Position Funding Spreadsheet Upload.
This interface will allow agencies to upload new or updated Position Funding in a spreadsheet format. Position Funding sent in this interface will be validated and then loaded into the Department Budget tables. The program will log any warnings or errors in an error log for the agency to review.
In Florida PALM, Position Funding is associated to a Fiscal Year and will need to be reloaded at the beginning of each new Fiscal Year. The Position Funding Data Report (PRR051) can be used to download an agency’s existing Position Funding in spreadsheet format. This report can be modified and then uploaded to complete this process.
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 can be filtered by the following selection criteria:
Data Field | Data Field Details |
|---|---|
Run Control ID | Required |
Attached File | Required |
File Layout
Field names and descriptions from the interface layout are provided below.
Data Field Name | Record Type | Data Field Description |
|---|---|---|
Business Unit | Detail | This field is used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions. It identifies the agency tied to the position number/appointment ID given. The business unit was previously the Operating Level Organization (OLO). The source system must send a valid business unit that exists in the Florida PALM General Ledger. Valid business units must be maintained in the source system as needed. |
Effective Date | Detail | This field is the effective date of the position funding being established. |
Position Number | Detail | This field is the unique number assigned to a position. Florida PALM assumes this number is unique across the interfacing system. An active position number is required to establish position funding in Florida PALM. |
Department ID | Detail | This field is the ORG Code and identifies the organizational structure for payroll and is the primary key to sort employee warrants. The source system must send a valid ORG Code that exists in the Florida PALM General Ledger and must be maintained in the source system as needed. |
SpeedKey | Detail | This field is the valid SpeedKey (accounting) that will establish the funding information for the given position. |
Distribution Percentage | Detail | This field is the percentage of the position's funding distribution that should be assigned to the SpeedKey. The distribution percentage across all SpeedKeys sent for a position should total to 100. |
Primary Funding Indicator | Detail | This field indicates whether the SpeedKey should be the primary funding distribution for the position. All positions must have one primary funding distribution. |
Version History
Date | Revision Description |
|---|---|
| 5/21/2024 | Original Version |
Was this article helpful?
