Outbound ChartField Values (GLI001)
- 29 May 2024
- 16 Minutes to read
-
Print
-
DarkLight
-
PDF
Outbound ChartField Values (GLI001)
- Updated on 29 May 2024
- 16 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
ChartField values configured in Florida PALM are used for budgetary and financial reporting. The Outbound ChartField Values interface file contains Florida PALM Chart of Accounts (COA) values. This file is made available to Agency Business Systems, and Enterprise partners.
This Interface will provide Statewide ChartField values and Agency Specific ChartField values. This interface will create separate files for each agency and one consolidated file for Enterprise partners.
Click below to view the interface file layout and sample data file.
Business Process Model
This interface can be found in the following business processes:
- 10.1.1 Agency Add or Modify ChartField Values
- 10.1.2 Enterprise Add or Modify Statewide ChartField Values
- 10.1.3 Enterprise Add or Modify Fund Values
Selection Criteria
The interface data selection criteria includes the following:
| Data Field | Data Field Details |
|---|---|
Agency of All(%) (Required) | This field is used to reference the population of values to extract. If an agency BU is selected, then extract agency specific ChartField values for the agency selected and statewide ChartField values. If % is selected, then extract all statewide and all agency specific values in Florida PALM. |
ChartField Status (Optional) | ChartField status is selected as Active or Inactive if COA for a specific status to be extracted. In case of blank, both the statuses (Active and Inactive) will be extracted. Before a selection is made, ChartField Status value should be defaulted to ‘Blank’ on run control page. |
Data Extract (Required)
| Full extract (Agencies): It will extract data for all available max effective dated COA values from Florida PALM. Delta extract (Enterprise Partners): It will extract data for all COA values which are newly added or updated in Florida PALM from last batch run to current date time. Before a selection is made, Data Extract value should be defaulted to ‘Full Extract’ on run control page.
One batch run control ID should be setup as follows:
To produce all statewide and agency specific ChartField values per outbound file to be sent to respective agency subfolders.
To produce one consolidated file with changes to statewide and agency specific ChartFields values for applicable Enterprise (STMS, PCard Works)
File Path and File Name can be configured using custom Interface Configuration page. |
File Layout
The layout of the interface is listed below.
| Data Field | Record Type | Data Field Description |
|---|---|---|
| Record Code | 1 | Record Code for GL Business Unit ChartField details. |
| GL Business Unit | 1 | GL Business Unit represents an organization/agency at an appropriation level and is used to define a financial reporting entity for General Ledger reporting. |
| GL Business Unit Description | 1 | GL Business Unit Description |
| GL Business Unit Short Description | 1 | GL Business Unit Short Description |
| Filler1 | 1 | This field is reserved for future use in Florida PALM |
| Filler2 | 1 | This field is reserved for future use in Florida PALM |
| Filler3 | 1 | This field is reserved for future use in Florida PALM |
| Filler4 | 1 | This field is reserved for future use in Florida PALM |
| Filler5 | 1 | This field is reserved for future use in Florida PALM |
| Record Code | 2 | Record Code for Organization details. |
| SetID | 2 | 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 | 2 | Organization ChartField tracks information according to a breakdown of your organization. |
| Effective Date | 2 | Designates the date the Organization value is available for use within Florida PALM. |
| Effective Status | 2 | 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. |
| Organization Description | 2 | Organization Description |
| Organization Short Description | 2 | Organization Short Description |
| Organization Long Description | 2 | Identifies the long description which may contain historical details regarding the Organization value. |
| Budgetary Only | 2 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 2 | This field is reserved for future use in Florida PALM |
| Filler2 | 2 | This field is reserved for future use in Florida PALM |
| Filler3 | 2 | This field is reserved for future use in Florida PALM |
| Filler4 | 2 | This field is reserved for future use in Florida PALM |
| Filler5 | 2 | This field is reserved for future use in Florida PALM |
| Record Code | 3 | Record Code for Account details. |
| SetID | 3 | 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 | 3 | Specified as balance sheet account or operating account. |
| Effective Date | 3 | Designates the date the Account value is available for use within Florida PALM. |
| Effective Status | 3 | 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. |
| Account Description | 3 | Account Description |
| Account Short Description | 3 | Account Short Description |
| Account Long Description | 3 | Identifies the long description which may contain historical details regarding the Account value. |
| Account Type | 3 | 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"). |
| Statistics Account | 3 | A flag that indicates whether or not an account is used to track statistical amounts rather than monetary amounts. Statistical amounts represent information such as square footage, head count, or number of units. |
| Control Flag | 3 | This flag in used to designate an Account as a Control Account. |
| Budgetary Only | 3 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 3 | This field is reserved for future use in Florida PALM |
| Filler2 | 3 | This field is reserved for future use in Florida PALM |
| Filler3 | 3 | This field is reserved for future use in Florida PALM |
| Filler4 | 3 | This field is reserved for future use in Florida PALM |
| Filler5 | 3 | This field is reserved for future use in Florida PALM |
| Record Code | 4 | Record Code for Fund details. |
| SetID | 4 | 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 | 4 | Fund is used to segregate and capture specific activities or classify certain objectives in accordance with special regulations, restrictions, or limitations (e.g., restricted Fund).Legacy Mapping: GAAFR, SF, FID |
| Effective Date | 4 | Designates the date the Fund value is available for use within Florida PALM. |
| Effective Status | 4 | 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. |
| Fund Description | 4 | Fund Description |
| Fund Short Description | 4 | Fund Short Description |
| Fund Long Description | 4 | Identifies the long description which may contain historical details regarding the Fund value. |
| Budgetary Only | 4 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 4 | This field is reserved for future use in Florida PALM |
| Filler2 | 4 | This field is reserved for future use in Florida PALM |
| Filler3 | 4 | This field is reserved for future use in Florida PALM |
| Filler4 | 4 | This field is reserved for future use in Florida PALM |
| Filler5 | 4 | This field is reserved for future use in Florida PALM |
| Record Code | 5 | Record Code for Budget Entity details. |
| SetID | 5 | 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 | 5 | 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 | 5 | Designates the date the Budget Entity value is available for use within Florida PALM. |
| Effective Status | 5 | 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. |
| Budget Entity Description | 5 | Budget Entity Description |
| Budget Entity Short Description | 5 | Budget Entity Short Description |
| Budget Entity Long Description | 5 | Identifies the long description which may contain historical details regarding the Budget Entity value. |
| Budgetary Only | 5 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 5 | This field is reserved for future use in Florida PALM |
| Filler2 | 5 | This field is reserved for future use in Florida PALM |
| Filler3 | 5 | This field is reserved for future use in Florida PALM |
| Filler4 | 5 | This field is reserved for future use in Florida PALM |
| Filler5 | 5 | This field is reserved for future use in Florida PALM |
| Record Code | 6 | Record Code for Category details. |
| SetID | 6 | 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 | 6 | Category represents both appropriation categories and revenue source codes. Category in PALM is mapped one-one with the current business system |
| Effective Date | 6 | Designates the date the Category value is available for use within Florida PALM. |
| Effective Status | 6 | 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. |
| Category Description | 6 | Category Description |
| Category Short Description | 6 | Category Short Description |
| Category Long Description | 6 | Identifies the long description which may contain historical details regarding the Category value. |
| Budgetary Only | 6 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 6 | This field is reserved for future use in Florida PALM |
| Filler2 | 6 | This field is reserved for future use in Florida PALM |
| Filler3 | 6 | This field is reserved for future use in Florida PALM |
| Filler4 | 6 | This field is reserved for future use in Florida PALM |
| Filler5 | 6 | This field is reserved for future use in Florida PALM |
| Record Code | 7 | Record Code for State Program details |
| SetID | 7 | 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 | 7 | 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 | 7 | Designates the date the State Program value is available for use within Florida PALM. |
| Effective Status | 7 | 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. |
| State Program Description | 7 | State Program Description |
| State Program Short Description | 7 | State Program Short Description |
| State Program Long Description | 7 | Identifies the long description which may contain historical details regarding the Contract value. |
| Budgetary Only | 7 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 7 | This field is reserved for future use in Florida PALM |
| Filler2 | 7 | This field is reserved for future use in Florida PALM |
| Filler3 | 7 | This field is reserved for future use in Florida PALM |
| Filler4 | 7 | This field is reserved for future use in Florida PALM |
| Filler5 | 7 | This field is reserved for future use in Florida PALM |
| Record Code | 8 | Record Code for Grant details |
| SetID | 8 | 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 |
| Grant | 8 | Grant ID value used to track financial assistance that provides support or stimulation to accomplish a public purpose. |
| Effective Date | 8 | Designates the date the Contract value is available for use within Florida PALM. |
| Effective Status | 8 | 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. |
| Grant Description | 8 | Grant Description |
| Grant Short Description | 8 | Grant Short Description |
| Grant Long Description | 8 | Identifies the long description which may contain historical details regarding the Grant value. |
| Budgetary Only | 8 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 8 | This field is reserved for future use in Florida PALM |
| Filler2 | 8 | This field is reserved for future use in Florida PALM |
| Filler3 | 8 | This field is reserved for future use in Florida PALM |
| Filler4 | 8 | This field is reserved for future use in Florida PALM |
| Filler5 | 8 | This field is reserved for future use in Florida PALM |
| Record Code | 9 | Record Code for Contract details. |
| SetID | 9 | 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 |
| Contract | 9 | Contract ChartField captures expenditure and revenue transactions for two party agreements. |
| Effective Date | 9 | Designates the date the Contract value is available for use within Florida PALM. |
| Effective Status | 9 | 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. |
| Contract Description | 9 | Contract Description |
| Contract Short Description | 9 | Contract Short Description |
| Contract Long Description | 9 | Identifies the long description which may contain historical details regarding the Contract value. |
| Budgetary Only | 9 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 9 | This field is reserved for future use in Florida PALM |
| Filler2 | 9 | This field is reserved for future use in Florida PALM |
| Filler3 | 9 | This field is reserved for future use in Florida PALM |
| Filler4 | 9 | This field is reserved for future use in Florida PALM |
| Filler5 | 9 | This field is reserved for future use in Florida PALM |
| Record Code | 10 | Record Code for OA1 details. |
| SetID | 10 | 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 | 10 | OA1 is a flexible ChartField reserved for tracking for optional reporting or specific use.Legacy Mapping: None |
| Effective Date | 10 | Designates the date the OA1 value is available for use within Florida PALM. |
| Effective Status | 10 | 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. |
| OA1 Description | 10 | OA1 Description |
| OA1 Short Description | 10 | OA1 Short Description |
| OA1 Long Description | 10 | Identifies the long description which may contain historical details regarding the OA1 value. |
| Budgetary Only | 10 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 10 | This field is reserved for future use in Florida PALM |
| Filler2 | 10 | This field is reserved for future use in Florida PALM |
| Filler3 | 10 | This field is reserved for future use in Florida PALM |
| Filler4 | 10 | This field is reserved for future use in Florida PALM |
| Filler5 | 10 | This field is reserved for future use in Florida PALM |
| Record Code | 11 | Record Code for OA2 details. |
| SetID | 11 | 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 | 11 | OA2 is a flexible ChartField reserved for tracking for optional reporting or specific use.Legacy Mapping: None |
| Effective Date | 11 | Designates the date the OA2 value is available for use within Florida PALM. |
| Effective Status | 11 | 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. |
| OA2 Description | 11 | OA2 Description |
| OA2 Short Description | 11 | OA2 Short Description |
| OA2 Long Description | 11 | Identifies the long description which may contain historical details regarding the OA2 value. |
| Budgetary Only | 11 | Budgetary Only Indicator which identifies values that are limited to use in budgetary transactions |
| Filler1 | 11 | This field is reserved for future use in Florida PALM |
| Filler2 | 11 | This field is reserved for future use in Florida PALM |
| Filler3 | 11 | This field is reserved for future use in Florida PALM |
| Filler4 | 11 | This field is reserved for future use in Florida PALM |
| Filler5 | 11 | This field is reserved for future use in Florida PALM |
| Record Code | 12 | Record Code for Project details |
| Project Costing Business Unit | 12 | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions |
| Project | 12 | Project is used to capture a planned undertaking, having a finite beginning and a finite ending, can cross fiscal years, for which expenditures/costs and revenues are to be tracked |
| Effective Status | 12 | 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. |
| Project Description | 12 | Description |
| Filler1 | 12 | This field is reserved for future use in Florida PALM |
| Filler2 | 12 | This field is reserved for future use in Florida PALM |
| Filler3 | 12 | This field is reserved for future use in Florida PALM |
| Filler4 | 12 | This field is reserved for future use in Florida PALM |
| Filler5 | 12 | This field is reserved for future use in Florida PALM |
| Record Code | 13 | Record Code for Activity details |
| SetID | 13 | 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 |
| Activity | 13 | Activity tracks specific tasks that make up a Project and records transactional details; a Project must have at least one associated Activity ID. |
| Activity Description | 13 | Activity Description |
| Filler1 | 13 | This field is reserved for future use in Florida PALM |
| Filler2 | 13 | This field is reserved for future use in Florida PALM |
| Filler3 | 13 | This field is reserved for future use in Florida PALM |
| Filler4 | 13 | This field is reserved for future use in Florida PALM |
| Filler5 | 13 | This field is reserved for future use in Florida PALM |
| Record Code | 14 | Record Code for Source Type details. |
| SetID | 14 | 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 |
| Source Type | 14 | The Source Type ChartField identifies the purpose or origin of a Project-related transaction. Legacy Mapping: None |
| Effective Date | 14 | Designates the date the Source Type value is available for use within Florida PALM. |
| Effective Status | 14 | 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. |
| Source Type Description | 14 | Source Type Description |
| Filler1 | 14 | This field is reserved for future use in Florida PALM |
| Filler2 | 14 | This field is reserved for future use in Florida PALM |
| Filler3 | 14 | This field is reserved for future use in Florida PALM |
| Filler4 | 14 | This field is reserved for future use in Florida PALM |
| Filler5 | 14 | This field is reserved for future use in Florida PALM |
| Record Code | 15 | Record Code for Proj. Category details. |
| SetID | 15 | 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 |
| Proj Category | 15 | The Proj. Category ChartField provides more flexibility and granularity in tracking and analyzing financial activity associated with a Project. Legacy Mapping: None |
| Effective Date | 15 | Designates the date the Proj. Category value is available for use within Florida PALM. |
| Effective Status | 15 | 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. |
| Proj Category Description | 15 | Proj. Category Description |
| Filler1 | 15 | This field is reserved for future use in Florida PALM |
| Filler2 | 15 | This field is reserved for future use in Florida PALM |
| Filler3 | 15 | This field is reserved for future use in Florida PALM |
| Filler4 | 15 | This field is reserved for future use in Florida PALM |
| Filler5 | 15 | This field is reserved for future use in Florida PALM |
| Record Code | 16 | Record Code for Subcategory details. |
| SetID | 16 | An identification code that represents a set of control table information or table sets. SetIDs enable the sharing of a set of control table information across two or more Business Units. |
| Subcategory | 16 | The Subcategory ChartField provides more flexibility and granularity in tracking and analyzing financial activity associated with a Project. |
| Effective Date | 16 | Format "MM/DD/YYYY": Designates the date the Subcategory value is available for use within Florida PALM. |
| Effective Status | 16 | 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. |
| Subcategory Description | 16 | Subcategory Description |
| Filler1 | 16 | This field is reserved for future use in Florida PALM |
| Filler2 | 16 | This field is reserved for future use in Florida PALM |
| Filler3 | 16 | This field is reserved for future use in Florida PALM |
| Filler4 | 16 | This field is reserved for future use in Florida PALM |
| Filler5 | 16 | This field is reserved for future use in Florida PALM |
| Record Code | 17 | Record Code for Filler Field. |
| Filler1 | 17 | This field is reserved for future use in Florida PALM |
| Filler2 | 17 | This field is reserved for future use in Florida PALM |
| Filler3 | 17 | This field is reserved for future use in Florida PALM |
| Filler4 | 17 | This field is reserved for future use in Florida PALM |
| Filler5 | 17 | This field is reserved for future use in Florida PALM |
| Record Code | 18 | Record Code for Filler Field. |
| Filler1 | 18 | This field is reserved for future use in Florida PALM |
| Filler2 | 18 | This field is reserved for future use in Florida PALM |
| Filler3 | 18 | This field is reserved for future use in Florida PALM |
| Filler4 | 18 | This field is reserved for future use in Florida PALM |
| Filler5 | 18 | This field is reserved for future use in Florida PALM |
Version History
| Date | Revision Description |
|---|---|
| 12/01/2023 | Original Version |
| 05/28/2024 | Administrative update completed to include Record Type 17 and 18. |
Was this article helpful?
