A report that details the clearance pattern for designated projects.
The report calculates the difference in payment issuance dates and payment clearance dates to provide average clearance patterns for Federal Grants by ALN number. This enterprise report will be used by Treasury to support the submission of the CMIAreport.
The report data can be filtered by the following report prompts:
Parameter Name
Default Value
Column in Subject Area
Required (Y/N)
User Input
Payment Date (From)
N
Financials – AP Transactions.Payables Payment Voucher Details.Payment Date
Y
Y
Payment Date (To)
N
Financials – AP Transactions.Payables Payment Voucher Details.Payment Date
Y
Y
Business Unit
N
Financials – AP Transactions.AP Voucher Business Unit.Business Unit
N
Y
ALN Number
N
Financials – AP Transactions.Account Payables Identifiers.ALN Number
N
Y
Report Columns
The layout of the report is listed below.
Column Name
Column in Subject Area or TableName.ColumnName
Business Unit
Financials – AP Transactions.AP Voucher Business Unit.Business Unit
ALN Number
Financials – AP Transactions.Account Payables Identifiers.ALN Number
Account
Financials – AP Transactions.GL Account.Account
Fund
Financials – AP Transactions.GL Account.Fund
Budget Entity
Financials – AP Transactions.GL Account.Budget Entity
Category
Financials – AP Transactions.GL Account.Category
Budget Date
Financials – AP Transactions.Payables Payment Voucher Details.Budget Date
Payment Reference ID
Financials – AP Transactions.Account Payables Identifiers.Payment Reference ID
Payment Date
Financials – AP Transactions.Payables Payment Voucher Details.Payment Date
Payment Method
Financials – AP Transactions.Payables Payment Voucher Details.Payment Method
Settlement Date
Financials – AP Transactions.Payables Payment Voucher Details.Settlement Date
Number of Days Outstanding (Bank Date – Payment Date)
Financials – AP Transactions.Payment Voucher Insights.Number Of Days Outstanding(Bank Date – Payment Date)
Payment Amount
Financials – AP Transactions.Fact – Fins – AP Transaction Custom.Payment Amount
Payment Amount Multiplied Number of Days Outstanding
Financials – AP Transactions.Fact – Fins – AP Transaction Custom. Payment Amount Multiplied by Number of days outstanding
Average of the Number Days Outstanding
Financials – AP Transactions.Payment Voucher Insights.Number Of Days Outstanding(Bank Date – Payment Date)
Clearance Pattern
Financials – AP Transactions.Fact – Fins – AP Transaction Custom. Payment Amount Multiplied by Number of days outstanding / Financials – AP Transactions.Fact – Fins – AP Transaction Custom.Payment Amount
Classification Code
Financials – AP Transactions.Account Payables Identifiers.FLP Class Code
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the ChartField and related values is included in the Chart of Accounts Design.
Version History
Date
Revision Description
01/31/2025
Original Version
Assistance Listing Number (ALN) is formally known as the CFDA number. Assistance listings are detailed public descriptions of federal programs that provide grants, loans, scholarships, insurance, and other types of assistance awards.
Cash Management Improvement Act (CMIA) of 1990 prescribes the regulations for the exchange of federal funds between the U.S. Department of Treasury and the State Treasury.
A Data Warehouse is a central repository of data, reports and reporting tools available to meet the State’s information needs.
The Florida PALM field that stores COA information and provides the basic structure to segregate and categorize transactional and budget data.
Was this article helpful?
Thank you for your feedback! Our team will get back to you
