Contracts (For Accounting Purposes) (CTC001)
  • Dark
    Light
  • PDF

Contracts (For Accounting Purposes) (CTC001)

  • Dark
    Light
  • PDF

Article summary

Conversion Description

Conversion of titling and administrative information is required to manage financial activity for active contracts. The conversion process is needed to migrate current and active contract information from FLAIR to the Florida PALM system.

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

Below details the files from the integrating systems that will provide the source data for this conversion.

  • FACTS and FLAIR hold the data to be converted; however, only data in FLAIR will be converted. Agencies are responsible for reconciling the two sources of information and ensuring that FLAIR represents the accurate and complete information and representing that the data to be converted from FLAIR is ready for conversion.
  • The conversion layout includes fields for Assistance Listing Number (ALN) and Catalog of State Financial Assistance (CSFA). 
Source System
Description
FLAIR

The conversion file will contain contracts with FACTS indicator = “Y” and a Contract record status of “A”. The conversion file will also contain all active contracts for agencies exempt from use of FACTS where the FACTS indicator = “Y” or “N” and the Contract status of “A”.

Conversion Layout

The layout of the conversion is listed below.

Data Field
Record Type
Description
Record CodeContract HeaderIndicates Contract Header information. This field is the row identifier and should be added at the start of each header row.
Business UnitContract HeaderBusiness unit.
 Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Contracts.
Contract IDContract HeaderContract ID used to identify Contract managed by agencies in FLAIR.
FACTS IndicatorContract HeaderFACTS indicator
Contract TypeContract HeaderThe type of Contract
Contract StatusContract HeaderThe status of Contract
ChartField StatusContract HeaderChartField Status
Short TitleContract HeaderA short title for the Contract
Long TitleContract HeaderA long title for the Contract
Contract AmountContract HeaderAmount for the Contract
Contractor IDContract HeaderState Assigned Contractor ID used to identify Contract managed by Agencies.
Filler1Contract HeaderThis field is reserved for future use in Florida PALM
Filler2Contract HeaderThis field is reserved for future use in Florida PALM
Filler3Contract HeaderThis field is reserved for future use in Florida PALM
Filler4Contract HeaderThis field is reserved for future use in Florida PALM
Filler5Contract HeaderThis field is reserved for future use in Florida PALM
Record CodeContract ALN LineIndicates 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 UnitContract ALN LineBusiness unit.
 Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Contracts.
Contract IDContract ALN LineContract ID used to identify Contract managed by agencies in FLAIR.
ALNContract ALN LineAssistance Listing Number for Contract
ALN Primary FlagContract ALN LinePrimary Flag for ALN
Filler1Contract ALN LineThis field is reserved for future use in Florida PALM
Filler2Contract ALN LineThis field is reserved for future use in Florida PALM
Filler3Contract ALN LineThis field is reserved for future use in Florida PALM
Filler4Contract ALN LineThis field is reserved for future use in Florida PALM
Filler5Contract ALN LineThis field is reserved for future use in Florida PALM
Filler6Contract ALN LineThis field is reserved for future use in Florida PALM
Filler7Contract ALN LineThis field is reserved for future use in Florida PALM
Filler8Contract ALN LineThis field is reserved for future use in Florida PALM
Filler9Contract ALN LineThis field is reserved for future use in Florida PALM
Filler10Contract ALN LineThis field is reserved for future use in Florida PALM
Record CodeContract CSFA LineIndicates 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 UnitContract CSFA LineBusiness unit.
 Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Contracts.
Contract IDContract CSFA LineContract ID used to identify Contract managed by agencies in FLAIR.
CSFAContract CSFA LineCatalog for State Financial Assistance for Contract
CSFA Primary FlagContract CSFA LinePrimary Flag for CSFA
Filler1Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler2Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler3Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler4Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler5Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler6Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler7Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler8Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler9Contract CSFA LineThis field is reserved for future use in Florida PALM
Filler10Contract CSFA LineThis field is reserved for future use in Florida PALM

Version History

DateRevision Description

11/28/2023

Original Version

1/15/2024Administrative updates completed to document the revised naming convention of inbound interface and conversion files
05/16/2024Administrative updates to apply the following changes based on layout update dated 05/07/2025:
Updated File Formats to separate ALN and CSFA to support one contract to many ALN or CSFA values.




Was this article helpful?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.