Projects Life-to-Date Balances (PCC002)
- 18 Sep 2024
- 3 Minutes to read
-
Print
-
DarkLight
-
PDF
Projects Life-to-Date Balances (PCC002)
- Updated on 18 Sep 2024
- 3 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Conversion Description
The conversion of Life to Date project balances for active projects is an optional tool provided to agencies wishing to establish access to historical financial information at a summary level within Florida PALM. This 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. This conversion will allow agency users to readily obtain summarized transactional information about projects from inception to current date. This conversion will consume and summarize all the financial data pertaining to projects within the FLAIR Master GL Balance File and insert the data into the Florida PALM Project Costing records. The conversion data can be a very helpful tool for the transition from the current FLAIR operating system/agency business systems to the Florida PALM operation system for projects. Agencies will need to verify project accounting data before providing information for conversion.
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
The table below details the files from the integrating systems that will provide the source data for this conversion.
| File Name | Source System | Description |
|---|---|---|
TBD | Agency Business Systems and FLAIR GL master data | File which contains project items that will be loaded in Florida PALM. |
Conversion Layout
The layout of the conversion is listed below.
| Data Feild | Record Type | Description |
|---|---|---|
| Record Code | Project Detail Header | Indicates Project Detail Header information. This field is the row identifier and should be added at the start of each header row. |
| PC Business Unit | Project Detail Header | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions |
| Project | Project Detail Header | 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 |
| Filler 1 | Project Detail Header | This field is reserved for future use in Florida PALM. |
| Filler 2 | Project Detail Header | This field is reserved for future use in Florida PALM. |
| Filler 3 | Project Detail Header | This field is reserved for future use in Florida PALM. |
| Filler 4 | Project Detail Header | This field is reserved for future use in Florida PALM. |
| Filler 5 | Project Detail Header | This field is reserved for future use in Florida PALM. |
| Record Code | Project Detail Line | Indicates Project Detail Line information. This field is the row identifier and should be added at the start of each header row. |
| GL Business Unit | Project Detail Line | GL Business Unit represents an organization/agency at an appropriation level and is used to define a financial reporting entity for General Ledger reporting. |
| Account | Project Detail Line | General Ledger Account, specified as balance sheet account (e.g., asset, liability, equity) or operating account (e.g., expenditure, revenue). |
| Fund | Project Detail Line | Fund is used to segregate and capture specific activities or classify certain objectives in accordance with special regulations, restrictions, or limitations. |
| Budget Entity | Project Detail Line | Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. |
| Category | Project Detail Line | Category ChartField represents both appropriation categories and revenue source codes. |
| Grant | Project Detail Line | Grant ID value used to track financial assistance that provides support or stimulation to accomplish a public purpose. |
| Analysis Type | Project Detail Line | Analysis Type used to identify transactions on the Project Resource table. |
| Accounting Date | Project Detail Line | Accounting date of transactions being loaded. |
| Transaction Date | Project Detail Line | Transaction date of transactions being loaded. |
| Budget Date | Project Detail Line | The funding date of the transaction |
| Amount | Project Detail Line | Summary Amount of Transaction |
| Filler 1 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 2 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 3 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 4 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 5 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 6 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 7 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 8 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 9 | Project Detail Line | This field is reserved for future use in Florida PALM. |
| Filler 10 | Project Detail Line | This field is reserved for future use in Florida PALM. |
Version History
| Date | Revision Description |
|---|---|
| 06/04/2024 | Original Version |
| 09/18/2024 | Updated per 06/18/2024 Version History: Removed internal comments. Removed a duplicate line for the date/time stamp. |
Was this article helpful?
