Outbound Actuals Extract (GLI002)
- 29 May 2024
- 4 Minutes to read
-
Print
-
DarkLight
-
PDF
Outbound Actuals Extract (GLI002)
- Updated on 29 May 2024
- 4 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
The General Ledger (GL) module, within Florida PALM records, summarizes, and reports financial data. Ledger data is updated by creating and posting the journals within GL. The ledger data origins can be GL, source modules, external systems. Appropriate edits, budget (and cash) checks, approvals, and postings occur prior to ledger being updated to maintain the integrity of accounting consistently across agencies and accurate reporting of balances.
Currently in Florida PALM, all summarized financial balances are posted against ACTUALS ledger. The ACTUALS ledger is considered the book of record and is the primary ledger which holds the summarized balances. This outbound interface contains the summary balances by ChartField String (Organization, Account, Fund, Budget Entity, Category, State Program, Grant, Contract, Other Accumulator 1, Other Accumulator 2, Project) posted and unposted to the ‘ACTUALS’ ledger for use by Agency Business systems. Agencies can use this extract as a part of the ongoing reconciliation process.
The GLI002 program will consist of the following core functions:
- Generate an “Outbound Actuals Extract” flat file containing balances from the ‘ACTUALS’ ledger.
- Transfer the generated “Outbound Actuals Extract” flat file to the pre-defined file server location.
Click below to view the interface file layout and sample data files.
Business Process Model
This interface can be found in the following business processes:
Run Control Parameters
The interface data selection criteria includes the following:
| Data Field | Data Field Details |
|---|---|
| Business Unit (Required) | This field is used to define Business Unit selection for Outbound Actuals Extract program. The drop-down field has 2 options: All Values – The program will include ledger balances of all business units in the outbound file. Specify – The program will include ledger balances of the specified business unit in the outbound file. Once ‘Specify’ value is selected in drop-down, then additional field will get visible to select specific Business Unit value from the prompt. Business Unit drop-down and related prompt fields are required fields on run control page. In case of ‘Specify’ option, a file will be generated for the Agency specified and placed in the respective agency folder. |
| Ledger Group (Optional) | This field is allowing user to define Ledger Group selection for Outbound Actuals Extract program. This field is optional inputs on the run control page. Only ledger groups with ‘Standard’ template will be available for selection on run control page. If Ledger Group is left blank on run control page, then process will default it to ACTUALS. |
| As of Date (Required) | This field is allowing user to define As of Date selection for Outbound Actuals Extract program. This field is required on the run control page. Default to current date. |
| Include Adjustment Periods (Optional) | This field is used to include adjustment period (998) selection for Outbound Actuals Extract program. Checkbox will be editable and by default for selected on run control page. |
File Layout
The layout of the interface is listed below.
| Data Field | Record Type | Data Field Description |
|---|---|---|
| Business Unit | Detail | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions. |
| Ledger | Detail | Identifies where the journal entries will be recorded to impact financial balances. |
| Fiscal Year | Detail | Fiscal Year |
| As of Date | Detail | As of Date provided on run control page. |
| Organization | Detail | Organization ChartField tracks information according to a breakdown of your organization. |
| Account | Detail | Provides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account. |
| Fund | Detail | Segregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations. |
| Budget Entity | Detail | Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. |
| Category | Detail | Category ChartField represents both appropriation categories and revenue source codes. |
| 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. |
| Grant | Detail | Grant ID value used to track financial assistance that provides support or stimulation to accomplish a public purpose. |
| Contract | Detail | Contract ChartField captures expenditure and revenue transactions for two party agreements. |
| OA 1 | Detail | OA 1 is a flexible ChartField reserved for tracking for optional reporting or specific use. |
| OA 2 | Detail | OA 2 is a flexible ChartField reserved for tracking for optional reporting or specific use. |
| Project | Detail | Project ChartField is used to capture a planned undertaking of something to be accomplished or produced, having a beginning and ending date, for which expenditures/costs and revenues are to be tracked. |
| Posted Total Amount | Detail | Posted Total Amount for a ChartField combination against a Ledger. |
| Filler1 | Detail | This field is reserved for future use in Florida PALM. |
| Filler2 | Detail | This field is reserved for future use in Florida PALM. |
| Filler3 | Detail | This field is reserved for future use in Florida PALM. |
| Filler4 | Detail | This field is reserved for future use in Florida PALM. |
| Filler5 | Detail | This field is reserved for future use in Florida PALM. |
| Filler6 | Detail | This field is reserved for future use in Florida PALM. |
| Filler7 | Detail | This field is reserved for future use in Florida PALM. |
| Filler8 | Detail | This field is reserved for future use in Florida PALM. |
| Filler9 | Detail | This field is reserved for future use in Florida PALM. |
| Filler10 | Detail | This field is reserved for future use in Florida PALM. |
Version History
| Date | Revision Description |
|---|---|
| 12/01/2023 | Original Version |
Was this article helpful?
