- 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Inbound ALN/CSFA Spreadsheet Upload (GMI010)
- Updated on 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Interface Description
Assistance Listing Numbers (ALN) are assigned to each federal program that provides federal Financial Assistance. These values are assigned by the Federal Government and added, as needed, by the Department of Financial Services (DFS). These values are used for Single Audit compliance and reporting, such as the annual Cash Management Improvement Act (CMIA) and the Schedule of Expenditures of Federal Awards (SEFA) reporting processes.
The Catalog for State Financial Assistance (CSFA) is a unique number used within the State of Florida to track projects associated with state financial assistance and manage single audits from external entities. These CSFA values are assigned and maintained within Florida PALM, by the Department of Financial Services and are used for various reporting purposes including the completion of the Florida Single Audit Act Report report.
The Agency GM Processor may find that the ALN or CSFA that they need is not available in FACTS or Florida PALM and will need to request a new value or request an update to existing ALN or CSFA information. Once the request is approved, DFS GM Maintainer or DFS CMIA Processor will upload these changes for ALN or CSFA using the Spreadsheet upload process. Based on the details provided in the spreadsheet, the ALN/CFSA information will be added/updated in the Florida PALM system.
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:
Interface Selection Criteria
The interface data selection criteria includes 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 |
---|---|---|
ALN/CSFA Update Flag | Custom ALN/CSFA Header | Flag to validate Header or CMIA funding details required in file. |
ALN\CSFA | Custom ALN/CSFA Header | Assistance Listing Number and Catalog for State Financial Assistance for Grant |
Effective Date | Custom ALN/CSFA Header | Effective Date specifies the date from which the ALN/CSFA will be effective. |
Agency ID | Custom ALN/CSFA Header | Agency ID identifies the agency responsible for the ALN or CSFA program. |
Short Description | Custom ALN/CSFA Header | A short description for ALN\CSFA Information |
Program Title | Custom ALN/CSFA Header | A long title for the ALN\CSFA Information |
Status | Custom ALN/CSFA Header | The status of ALN\CSFA Information |
CMIA Indicator | Custom ALN/CSFA Header | Indicator for ALN Information |
Effective Date (CMIA) | Custom CMIA Detail | Effective Date specifies the date from which the CMIA details will be effective. |
GL BU | Custom CMIA Detail | Equivalent to the Florida PALM GL Business Unit for the Agency. Must be a valid value within Florida PALM. |
Fund Code | Custom CMIA Detail | Segregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations. |
Budget Entity | Custom CMIA Detail | Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. |
Category | Custom CMIA Detail | Category ChartField represents both appropriation categories and revenue source codes. |
Budget Period | Custom CMIA Detail | Budget Period (Appropriation year) |
Classification Code | Custom CMIA Detail | Types of Classification Code. |
Version History
Date | Revision Description |
---|---|
12/21/2023 | Original Version |