Inbound ChartField Mass Spreadsheet Upload (GLI039)

Print
Share
Dark

Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Interface Description

This interface was implemented in CMS Wave and will be updated in Financials Wave. The information in this article is the planned design for Financials Wave.

Florida PALM’s Chart of Accounts (COA) will consist of multiple ChartField (data elements) and corresponding values, which will be used for budgetary and financial reporting needs.

Once a ChartField value request has been appropriately approved, the inbound ChartField Mass-Upload Interface can be used. This interface allows mass-upload functionality for entering the values for ChartFields – Account, Fund, Organization, Budget Entity, Category, State Program, Other Accumulator 1 (OA1), Other Accumulator 2 (OA2). These values will be uploaded using CSV (comma-separated values) templates defined for each ChartFieldconfiguration.

Click below to view the interface file layout and sample data files.

GLI039-Inbound ChartField Mass Spreadsheet Upload_Financials.xlsx

GLI039-Sample Data_Financials.zip

Business Process Model

This interface can be found in the following business processes:

Interface Selection Criteria

The interface data selection criteria includes the following:

ChartField Data Name	Data Field Details (Required Fields)
Account	Account, Effective Date, Status, Description, Short Description, Account Type
Fund	Fund, Effective Date, Status, Description, Short Description
State Program	State Program, Effective Date, Status, Description, Short Description
Budget Entity	Budget Entity, Effective Date, Status, Description, Short Description
Category	Category, Effective Date, Status, Description, Short Description
Organization	SetID, Organization, Effective Date, Status, Description, Short Description
Other Accumulator 1 (OA1)	SetID, Other Accumulator 1, Effective Date, Status, Description, Short Description
Other Accumulator 2 (OA2)	SetID, Other Accumulator 2, Effective Date, Status, Description, Short Description

File Layout

The layout of the interface is listed below.

Data Field	Record Type		Data Field Description
Account ChartField
SetID		Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
Account		Detail		Provides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account.
Effective Date		Detail		Designates the date the Account value is available for use within Florida PALM.
Effective Status		Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description		Detail		Account Description
Short Description		Detail		Account Short Description
General Ledger Account		Detail		GL Account flag is used to designate an Account as a transaction-based account.
Account Type		Detail		Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account is associated with an account type (also called a "monetary account type").
Control Flag		Detail		This flag in used to designate an Account as a Control Account.
Budgetary Only		Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions
Commitment Control Override		Detail		It is used to designate the account with an automatic override
Fund ChartField
SetID		Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
Fund		Detail		Fund is used to segregate and capture specific activities or classify certain objectives in accordance with special regulations, restrictions, or limitations.
Effective Date		Detail		Designates the date the Fund value is available for use within Florida PALM.
Effective Status		Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description		Detail		Fund Description
Short Description		Detail		Fund Short Description
Budgetary Only		Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions
State Program ChartField
SetID		Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
State Program		Detail		State Program is used to identify the plan for an organization and use of resources to meet specified objectives of the State. Legacy Mapping: State Program Component
Effective Date		Detail		Designates the date the State Program value is available for use within Florida PALM.
Effective Status		Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description		Detail		State Program Description
Short Description		Detail		State Program Short Description
Budgetary Only		Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions
Budget Entity ChartField
SetID		Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
Budget Entity		Detail		Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. Budget Entity will retain the same value as in the current business system
Effective Date		Detail		Designates the date the Budget Entity value is available for use within Florida PALM.
Effective Status		Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description		Detail		Budget Entity Description
Short Description		Detail		Budget Entity Short Description
Budgetary Only		Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions
Other Accumulator 2 ChartField
SetID	Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
OA2	Detail		OA2 is a flexible ChartField reserved for tracking for optional reporting or specific use. Legacy Mapping: None
Effective Date	Detail		Designates the date the OA2 value is available for use within Florida PALM.
Effective Status	Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description	Detail		OA2 Description
Short Description	Detail		OA2 Short Description
Budgetary Only	Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions
Category ChartField
SetID		Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
Category		Detail		Category represents both appropriation categories and revenue source codes. Category in PALM is mapped one-one with the current business system
Effective Date		Detail		Designates the date the Category value is available for use within Florida PALM.
Effective Status		Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description		Detail		Category Description
Short Description		Detail		Category Short Description
Budgetary Only		Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions
Organization ChartField
SetID		Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
Organization		Detail		Organization ChartField tracks information according to a breakdown of your organization.
Effective Date		Detail		Designates the date the Organization value is available for use within Florida PALM.
Effective Status		Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description		Detail		Organization Description
Short Description		Detail		Organization Short Description
Budgetary Only		Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions
Other Accumulator 1 ChartField
SetID		Detail		SetID is a value used in Florida PALM to define setup data. It allows the sharing of common setup data across Business Units or specific to Business Unit
OA1		Detail		OA1 is a flexible ChartField reserved for tracking for optional reporting or specific use. Legacy Mapping: None
Effective Date		Detail		Designates the date the OA1 value is available for use within Florida PALM.
Effective Status		Detail		Effective status identifies whether the ChartField value is active or inactive. Effective status enables the system to select the appropriate effective-dated rows, when combined with the effective date field.
Description		Detail		OA1 Description
Short Description		Detail		OA1 Short Description
Budgetary Only		Detail		Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions

Version History

Date	Revision Description
12/01/2023	Original Version
10/25/2024	Updated per version history of 10/04/2024: Administrative update completed to Update the Business and Technical information

Was this article helpful?

What's Next

Inbound Combination Edit Spreadsheet Upload (GLI084)

Table of contents

Interface Description
Business Process Model
Interface Selection Criteria
File Layout
Version History