Conversion Catalog

Prev Next

Conversions refer to the activities of transforming legacy data and loading it to Florida PALM. Florida PALM will use legacy data from FLAIR and Agency Business Systems to populate opening balances in the General Ledger and the data needed to support operations. As the conversion designs are completed, the Project will provide a list of new or updated conversions. 

Conversion Resources

As of Date: 08/29/2025 

As a helpful resource for understanding the Florida PALM Financials / Payroll conversions, a mapping spreadsheet is provided. Included in the spreadsheet are the mappings from the source system (e.g. FLAIR) to Florida PALM for the following conversions:

AMC001, APC001, ARC001, ARC002, CTC001, GLC001, GMC001, KKC001, PCC001, PCC002, and POC001.

Accounts Payable Module Conversions 

IDConversion NameConversion DescriptionAs of Date
APC001Suppliers
Conversion active suppliers/payees from the Statewide Vendor File (SWVF), to include EFT information from the FLAIR EFT File, as well as MFMP.Updated 06/23/2025


Accounts Receivable Conversions 

IDConversion NameConversion DescriptionAs of Date
ARC001CustomerConversion of active Customers from Agency Business Systems.Published 12/01/2023
ARC002Open Accounts ReceivableConversion of open customer level detail accounts receivable subject to collection or required to be tracked for other purposes.Published 02/01/2024


Asset Management Module Conversions 

IDConversion Name
Conversion Description
As of Date
AMC001Assets and PropertyConversion of all types of active depreciable and non-depreciable tangible personal property, intangible assets, buildings and real property, or attractive items that are tracked for custody and reporting purposes.Updated 06/05/2024


Budget Management & Cash Control Conversions

IDConversion Name
Conversion Description
As of Date
KKC001BudgetsCurrent fiscal year GAA/Adjusted Appropriations, Releases, and Reserves.Updated 08/13/2024


Contracts Management Module Conversions 

ID
Conversion Name
Conversion Description
As of Date
CTC001ContractsConversion of titling and administrative information required to manage financial activity for active contracts.
Enterprise Only


General Ledger Module Conversions

IDConversion NameConversion DescriptionAs of Date
GLC001LedgerConversion of beginning balances for statewide and agency level data.Published 08/07/2024


Grants Module Conversions 


IDConversion NameConversion DescriptionAs of Date
GMC001Grants (for Accounting Purposes)Conversion of titling and administrative information required to manage active grants, with details for applicable relationships.Updated 06/21/2024


Payroll Module Conversions 

ID
Conversion NameConversion DescriptionAs of Date
PRC004GarnishmentsConversion of garnishment data from PYRL.Enterprise Only
PRC017Department Budget Position Funding LoadConversion to load position funding to the department budget table.Enterprise Only
PRC021W-2 Employee TotalsConversion of Employee W-2 data from FLAIR PYRL for Calendar Year 2023, 2024 and 2025.Enterprise Only


Project Management Conversions 

IDConversion NameConversion DescriptionAs of Date
PCC001Projects (for Accounting Purposes)Conversion that will consume nonfinancial data pertaining to projects and insert the data into the Florida PALM Project Costing records. The data is imperative for the transition from the current FLAIR operating system/agency business systems to the Florida PALM operational system for projects. Agencies will need to verify project data before providing information for conversion.Published 06/04/2024
PCC002Projects Life-to-Date BalancesThis conversion will provide agencies with access to historical and current information within one database. Agency users will be able to access this information by running various reports and/or queries because the data will be loaded into the Florida PALM project transaction table.Updated 09/18/2024


Purchase Order Module Conversion

IDConversion NameConversion DescriptionAs of Date
POC001Open EncumbrancesConversion of open Encumbrance balances that are authorized for continued use.Updated 04/03/2024