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 Code

Contract Header

Indicates Contract Header information. This field is the row identifier and should be added at the start of each header row.

Business Unit

Contract 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 Contracts.

Contract ID

Contract Header

Contract ID used to identify Contract managed by agencies in FLAIR.

FACTS Indicator

Contract Header

FACTS indicator

Contract Type

Contract Header

The type of Contract

Contract Status

Contract Header

The status of Contract

ChartField Status

Contract Header

ChartField Status

Short Title

Contract Header

A short title for the Contract

Long Title

Contract Header

A long title for the Contract

Contract Amount

Contract Header

Amount for the Contract

Contractor ID

Contract Header

State Assigned Contractor ID used to identify Contract managed by Agencies.

Filler1

Contract Header

This field is reserved for future use in Florida PALM

Filler2

Contract Header

This field is reserved for future use in Florida PALM

Filler3

Contract Header

This field is reserved for future use in Florida PALM

Filler4

Contract Header

This field is reserved for future use in Florida PALM

Filler5

Contract Header

This field is reserved for future use in Florida PALM

Record Code

Contract ALN 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

Contract ALN Line

Business 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 ID

Contract ALN Line

Contract ID used to identify Contract managed by agencies in FLAIR.

ALN

Contract ALN Line

Assistance Listing Number for Contract

ALN Primary Flag

Contract ALN Line

Primary Flag for ALN

Filler1

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler2

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler3

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler4

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler5

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler6

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler7

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler8

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler9

Contract ALN Line

This field is reserved for future use in Florida PALM

Filler10

Contract ALN Line

This field is reserved for future use in Florida PALM

Record Code

Contract 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

Contract CSFA Line

Business 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 ID

Contract CSFA Line

Contract ID used to identify Contract managed by agencies in FLAIR.

CSFA

Contract CSFA Line

Catalog for State Financial Assistance for Contract

CSFA Primary Flag

Contract CSFA Line

Primary Flag for CSFA

Filler1

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler2

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler3

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler4

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler5

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler6

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler7

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler8

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler9

Contract CSFA Line

This field is reserved for future use in Florida PALM

Filler10

Contract CSFA Line

This field is reserved for future use in Florida PALM

Version History

DateRevision Description

11/05/2024

Original Version




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.