Inbound Grant Spreadsheet Upload (GMI008)
- 29 Apr 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Inbound Grant Spreadsheet Upload (GMI008)
- Updated on 29 Apr 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
Grant values within Florida PALM are used to track financial activity for federal, state, private, local, or other financial assistance that provides support or stimulation to accomplish a public purpose. Agencies exempt from recording the receipt of financial assistance in FACTS, as defined in 215.985, F.S., may utilize the Spreadsheet Upload tool or interface directly from their Agency Business System to establish Grant values within Florida PALM. All other Agencies must establish Grant values directly within FACTS.
With this spreadsheet upload interface, users can upload Grants in Florida PALM. The spreadsheet upload will be available for the Agencies exempt from FACTS. As part of this interface, users must create a Spreadsheet with Grant details and upload it on the run control page. The process will then load the Grant details into the Florida PALM system. The exact process will load it into the delivered Grant ChartField (PROGRAM_TBL) record.
You can also access the Interface Catalog to view the interface file layout and sample data file.
Business Process Model
This interface can be found in the following business process:
Interface Selection Criteria
The interface data selection criteria include the following:
| Data Field | Data Field Details |
|---|---|
| N/A |
File Layout
The layout of the interface is listed below.
| Data Field | Record Type | Data Field Description |
|---|---|---|
| Business Unit | Custom Grants Header | Business unit. Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Grants. |
| Grant ID | Custom Grants Header | Grant ID used to identify grant for Financial Tracking. |
| Grant Type | Custom Grants Header | The type of grant |
| Grant Status | Custom Grants Header | The status of grant |
| ChartField Status | Custom Grants Header | ChartField Status |
| Short Title | Custom Grants Header | A short title for the Grant |
| Long Title | Custom Grants Header | A long title for the Grant |
| Grant Amount | Custom Grants Header | Amount for the Grant |
| Agency Reference Number | Custom Grants Header | Open field for agency to record the reference number from Agencies |
| Grant Award Date | Custom Grants Header | Award Date of the Grant |
| Grant Start Date | Custom Grants Header | Start Date of the Grant |
| Grant End Date | Custom Grants Header | End Date of the Grant |
| Description | Custom Grants Header | A long description for the Grant |
| Grantor ID | Custom Grants Header | State Assigned Grantor ID used to identify grant managed by Agencies. |
| Grant Award Reference | Custom Grants Header | Award Reference Details for Grant |
| Grant Manager | Custom Grants Header | Grant Manager for Grant |
| LOC ID | Custom Grants Subaccount | Letter of Credit |
| SubAccount | Custom Grants Subaccount | Subaccount Information |
| ALN | Custom Grants ALN/CSFA | Assistance Listing Number for Grant |
| ALN Primary Flag | Custom Grants ALN/CSFA | Primary Flag for ALN |
| CSFA | Custom Grants ALN/CSFA | Catalog for State Financial Assistance for Grant |
| CSFA Primary Flag | Custom Grants ALN/CSFA | Primary Flag for CSFA |
Version History
| Date | Revision Description |
|---|---|
| 12/01/2023 | Original Version |
Was this article helpful?
