-
Print
-
DarkLight
-
PDF
Grants (GMC001)
-
Print
-
DarkLight
-
PDF
Conversion 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. The conversion process is needed to ensure current and active grant information is properly migrated from the existing state approved business systems to the Florida PALM system.
Grant data will be extracted from FLAIR, formatted to align with the conversion layout detailed in this design document, and uploaded for processing as defined in the Updated Data Conversion and Migration Strategy (D638). Agencies will be responsible for ensuring that the data to be converted is accurate and ready for conversion. This functional design document is intended to provide clarity of the file layout and the data elements that are expected to be received.
Click below to view the conversion file layout and sample data file.
Business Process Models
This conversion can be found in the following business processes:
Source Data
The table below details the files from the integrating systems that will provide the source data for this conversion.
File Name | Source System | Description |
FLAIR | This file will contain grants with FACTS indicator = “Y” and a Grant record status of “A”. The file will also contain all active grants for agencies exempt from use of FACTS where the FACTS indicator = “N” and the Grant status of “A”. |
Conversion Layout
The layout of the conversion is listed below.
Data Field | Record Type | Data Field Description |
---|---|---|
Record Code | Grant Header | Indicates Grant Header information. This field is the row identifier and should be added at the start of each header row. |
Business Unit | Grant Header | Business unit. |
Grant ID | Grant Header | Grant ID used to identify grant for Financial Tracking. |
FACTS Indicator | Grant Header | Flag is designed to signify where grant was created, and secruity access to custom page GME001. |
Grant Type | Grant Header | The type of grant |
Grant Status | Grant Header | The status of grant |
ChartField Status | Grant Header | ChartField Status |
Short Title | Grant Header | A short title for the Grant |
Long Title | Grant Header | A long title for the Grant |
Grant Amount | Grant Header | Amount for the Grant |
Agency Reference Number | Grant Header | Open field for agency to record the reference number from Agencies\FACTS |
Grant Award Date | Grant Header | Award Date of the Grant |
Grant Start Date | Grant Header | Start Date of the Grant |
Grant End Date | Grant Header | End Date of the Grant |
Description | Grant Header | A long description for the Grant |
Grantor ID | Grant Header | State Assigned Grantor ID used to identify grant managed by Agencies. |
Grantor Name | Grant Header | Name of grantor derived from the Supplier record for the Grantor ID supplied. |
Grantor Type | Grant Header | Type of Grantor derived from the Supplier record's 'Type of Contractor' field for the Grantor ID supplied. |
Grant Award Reference | Grant Header | Award Reference Details for Grant |
Grant Manager | Grant Header | Grant Manager for Grant |
LOC ID | Grant Header | Letter of Credit |
Filler1 | Grant Header | This field is reserved for future use in Florida PALM. |
Filler2 | Grant Header | This field is reserved for future use in Florida PALM. |
Filler3 | Grant Header | This field is reserved for future use in Florida PALM. |
Filler4 | Grant Header | This field is reserved for future use in Florida PALM. |
Filler5 | Grant Header | This field is reserved for future use in Florida PALM. |
Record Code | Grant SubAccount Line | Indicates LOC (Letter of Credit) SubAccount information. This field is the row identifier and should be added at the start of each LOC row. |
Business Unit | Grant SubAccount Line | Business unit. |
Grant ID | Grant SubAccount Line | Grant ID used to identify grant for Financial Tracking. |
SubAccount | Grant SubAccount Line | SubAccount Information |
Filler1 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler2 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler3 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler4 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler5 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler6 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler7 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler8 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler9 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Filler10 | Grant SubAccount Line | This field is reserved for future use in Florida PALM. |
Record Code | Grant ALN Line | Indicates Assistance Listing (ALN). This field is the row identifier and should be added at the start of each ALN Line row. |
Business Unit | Grant ALN Line | Business unit. |
Grant ID | Grant ALN Line | Grant ID used to identify grant for Financial Tracking. |
ALN | Grant ALN Line | Assistance Listing Number for Grant |
ALN Primary Flag | Grant ALN Line | Primary Flag for ALN |
Filler1 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler2 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler3 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler4 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler5 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler6 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler7 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler8 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler9 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Filler10 | Grant ALN Line | This field is reserved for future use in Florida PALM. |
Record Code | Grant CSFA Line | Indicates Assistance Listing (ALN) or Catalog for State Financial Assistance (CSFA) information. This field is the row identifier and should be added at the start of each ALN or CSFA row. |
Business Unit | Grant CSFA Line | Business unit. |
Grant ID | Grant CSFA Line | Grant ID used to identify grant for Financial Tracking. |
CSFA | Grant CSFA Line | Catalog for State Financial Assistance for Grant |
CSFA Primary Flag | Grant CSFA Line | Primary Flag for CSFA |
Filler1 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler2 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler3 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler4 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler5 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler6 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler7 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler8 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler9 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Filler10 | Grant CSFA Line | This field is reserved for future use in Florida PALM. |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
04/19/2024 | Updated field descriptions |
05/07/2024 | Updated file layout to include separate record codes for ALN and CSFA to support one to many relationships of the values to a grant. |
06/21/2024 | Removed GMI001 reference |