Asset Staging Report (AMR042)
-
Print
-
DarkLight
-
PDF
Asset Staging Report (AMR042)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
The purpose of this report is to review the asset data for the new interface transactions (new/existing assets) that are pending to be loaded in Florida PALM. Users with Agency AM Asset Processor role and Agency AM F&A Processor role can review and update the details on the ‘Review’ page (if required). Users with AM Reporter role or DFS AM Reporter role can only review the details on the ‘Review’ page.
Report Navigation: Main Menu > Reporting Tools > Query > Query Viewer
Query Name: FLP_AMR042_ASSET_STAGING_RPT
See the sample layout report below.
Business Roles
The following business roles have access to this report:
- Agency AM Asset Processor
- Agency AM F&A Processor
- AM Reporter
- DFS AM Reporter
Business Process Models
This report can be found in the following business processes:
- 40.1.1 Import Asset Add
- 40.1.2 Online Asset Add
- 40.2.1 Deploy and Maintain Assets
- 40.2.2 InterUnit Asset Transfer
- 40.2.3 IntraUnit Asset Transfer
- 40.2.4 Asset Disposal
- 40.2.5 Physical Inventory
- 40.4 Asset Management Pre-Period Close
Selection Criteria
The report data can be filtered by the following selection criteria:
Parameter Field Name | Data Field Details |
Business Unit | Required |
In Service Date From | Required |
In Service Date To | Required |
Load Status | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
Interface ID | PS_INTFC_FIN.INTFC_ID |
Interface Line Number | PS_INTFC_FIN.INTFC_LINE_NUM |
Business Unit | PS_INTFC_FIN.BUSINESS_UNIT |
Asset ID | PS_INTFC_FIN.ASSET_ID |
Voucher ID | PS_INTFC_FIN.VOUCHER_ID |
Voucher Line Number | PS_INTFC_FIN.VOUCHER_LINE_NUM |
Distrib Line Number | PS_INTFC_FIN.DISTRIB_LINE_NUM |
Invoice Date | PS_INTFC_FIN.INVOICE_DT |
Invoice ID | PS_INTFC_FIN.INVOICE_ID |
Transaction Date | PS_INTFC_FIN.TRANS_DT |
Accounting Date | PS_INTFC_FIN.ACCOUNTING_DT |
Purchase Order ID | PS_INTFC_PHY_A.PO_ID |
PO Line Number | PS_INTFC_PHY_A.PO_LINE_NBR |
PO Distrib Line Number | PS_INTFC_PHY_A.PO_DIST_LINE_NBR |
Vendor ID | PS_INTFC_PHY_A.VENDOR_ID |
Vendor Name | PS_INTFC_PHY_A.VENDOR_NAME |
Cost | PS_INTFC_FIN.TXN_COST |
Asset Profile | PS_INTFC_PHY_A.PROFILE_ID |
Asset Status | PS_INTFC_PHY_A.ASSET_STATUS |
Capitalized Asset | PS_INTFC_PHY_A.FINANCIAL_ASSET_SW |
Description | PS_INTFC_PHY_A.DESCR |
Acquisition Date | PS_INTFC_PHY_A.ACQUISITION_DT |
In Service Date | PS_INTFC_FIN.IN_SERVICE_DT |
Acquisition Code | PS_INTFC_PHY_A.ACQUISITION_CD |
Organization | PS_INTFC_FIN.DEPTID |
Fund | PS_INTFC_FIN.FUND_CODE |
Entity | PS_INTFC_FIN.BUDGET_REF |
Category | PS_INTFC_FIN.PRODUCT |
State Program | PS_INTFC_FIN.CHARTFIELD2 |
Grant | PS_INTFC_FIN.PROGRAM_CODE |
Contract | PS_INTFC_FIN.CHARTFIELD1 |
Other Accumulator 1 (OA1) | PS_INTFC_FIN.CLASS_FLD |
Other Accumulator 2 (OA2) | PS_INTFC_FIN.CHARTFIELD3 |
Project | PS_INTFC_FIN.PROJECT_ID |
Affiliate | PS_INTFC_FIN.AFFILIATE |
Fund Affiliate | PS_INTFC_FIN.AFFILIATE_INTRA1 |
Custodian | PS_INTFC_PHY_A.CUSTODIAN |
Asset Location | PS_INTFC_PHY_A.LOCATION |
Interface Type | PS_INTFC_FIN.INTFC_TYPE |
System Source | PS_INTFC_FIN.SYSTEM_SOURCE |
Interface Approval | PS_INTFC_FIN.APPROVAL_SW |
Interface Status | PS_INTFC_FIN.INTFC_STATUS |
Load Status | PS_INTFC_FIN.LOAD_STATUS |
OPRID | PS_INTFC_FIN.OPRID |
Physical Inventory ID | PS_INTFC_PHY_A.PI_ID |
Physical Inventory Date | PS_INTFC_PHY_A.INVENTORY_DT |
PI Performed By | PS_INTFC_PHY_A.PERFORMED_BY |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
| 11/13/2024 | Updated Sample Report Layout |
Was this article helpful?
