- 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
CRA Activity Statement (CMR028)
- Updated on 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Report Description
The report will provide activity and balance details for the Treasury managed Consolidated Revolving Accounts (CRA). The report will provide Treasury and agencies with transactional bank details and available balances for the applicable bank accounts. The GL and Bank details will be available for reconciliation in the report.
This implementation differs from prior implementations as this version follows the new ChartField Sequencing standards, and two new ChartFields have been added: State Program and Organization.
Report Navigation: Main Menu → PALM Processes → PALM Reports → CM → Reports → CRA Activity Statement Report
Click below to view the sample report layout.
Business Roles
The following business roles have access to this report:
- Agency CRA Reporter
Business Process Models
This report can be found in the following business processes:
- N/A
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
---|---|
Business Unit | Single business unit from prompt table required |
Fund | Single fund from prompt table required |
Transaction From Date: | Calendar prompt/edit required |
Transaction To Date: | Calendar prompt/edit required |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD Mapping |
---|---|
Report Detail Section 1 | CRA Balance Summary |
CRA Fund Balance | Sum lines from JRNL_LN for all CRA Fund values JRNL_LN. MONETARY_AMT where the account equals CRA Node and Inter-unit account 101013 in the account reporting tree and journal date, Accounting Period, and Fiscal Year equal the values defined on the run control page. Sum all lines to create CRA FUND Balance amount for that period. |
GL Transactions Total | Sum of Amount from GL transaction details section for the period specified in the prompt |
Bank Transactions Total | Sum of Amount from Bank transaction details section for the period specified in the prompt |
Interest Apportionment Total | Sum of Amount from Interest Apportionment Transaction details section for the period specified in the prompt |
Report Detail Section 2 | CRA Transaction History |
Business Unit | PS_JRNL_HEADER.BUSINESS_UNIT |
Journal ID | PS_JRNL_HEADER.JOURNAL_ID |
Date | |
Year | PS_JRNL_HEADER.FISCAL_YEAR |
Period | PS_JRNL_HEADER.ACCOUNTING_PERIOD |
Status | PS_JRNL_HEADER.JRNL_HDR_STATUS |
Ledger | PS_JRNL_LN.LEDGER |
Organization | PS_JRNL_LN.ORGANIZATION |
Account | PS_JRNL_LN.ACCOUNT |
Account Description | PS_GL_ACCOUNT_TBL.DESCR |
Fund Code | PS_JRNL_LN.FUND_CODE |
Budget Entity | PS_JRNL_LN.BUDGET_REF |
Category | PS_JRNL_LN.PRODUCT |
State Program | PS_JRNL_LN.STATE_PROGRAM |
Journal Line Description | PS_JRNL_LN.LINE_DESCR |
Transaction Amount | PS_JRNL_LN.MONETARY_AMOUNT |
Report Detail Section 3 | Bank Transactions (Reconciled) |
Bank Account # | PS_BANK_STMT_TBL.BANK_ACCOUNT_NUM |
Statement ID | PS_BANK_STMT_TBL.RECON_STYLE_NBR |
Reference | PS_BANK_STMT_TBL.RECON_REF_ID |
Bank Date | PS_BANK_STMT_TBL.RECON_BANK_DT |
Reconciliation Status | PS_BANK_STMT_TBL.RECON_STATUS |
BAI Code | PS_BANK_STMT_TBL.STMT_ACTIVITY_TYPE |
BAI Description | PS_STMT_CODE_TBL.DESCR50 |
Organization | PS_BANK_ACCT_CHRT.ORGANIZATION |
Account | PS_BANK_ACCT_CHRT.ACCOUNT |
Account Description | PS_GL_ACCOUNT_TBL.DESCR |
Fund Code | PS_BANK_ACCT_CHRT.FUND_CODE |
Budget Entity | PS_BANK_ACCT_CHRT.BUDGET_REF |
Category | PS_BANK_ACCT_CHRT.PRODUCT |
State Program | PS_BANK_ACCT_CHRT.STATE_PROGRAM |
Statement Description | PS_BANK_STMT_TBL.DESCRLONG |
Transaction Amount | PS_BANK_STMT_TBL.RECON_TRAN_AMT |
Report Detail Section 4 | Bank Transactions (Unreconciled) |
Bank Account # | PS_BANK_STMT_TBL.BANK_ACCOUNT_NUM |
Statement ID | PS_BANK_STMT_TBL.RECON_CYCLE_NBR |
Reference | PS_BANK_STMT_TBL.RECON_REF_ID |
Bank Date | PS_BANK_STMT_TBL.RECON_BANK_DT |
Reconciliation Status | PS_BANK_STMT_TBL.RECON_STATUS |
BAI Code | PS_BANK_STMT_TBL.STMT_ACTIVITY_TYPE |
BAI Description | PS_STMT_CODE_TBL.DESCR50 |
Organization | PS_BANK_ACCT_CHRT.ORGANIZATION |
Account | PS_BANK_ACCT_CHRT.ACCOUNT |
Account Description | PS_GL_ACCOUNT_TBL.DESCR |
Fund Code | PS_BANK_ACCT_CHRT.FUND_CODE |
Budget Entity | PS_BANK_ACCT_CHRT.BUDGET_REF |
Category | PS_BANK_ACCT_CHRT.PRODUCT |
State Program | PS_BANK_ACCT_CHRT.STATE_PROGRAM |
Statement Description | PS_BANK_STMT_TBL.DESCRLONG |
Transaction Amount | PS_BANK_STMT_TBL.RECON_TRAN_AMT |
Report Detail Section 5 | Interest Apportionment Transaction History |
Business Unit | PS_JRNL_HEADER.BUSINESS_UNIT |
Journal ID | PS_JRNL_HEADER.JOURNAL_ID |
Date | PS_JRNL_HEADER.JOURNAL_DATE |
Year | PS_JRNL_HEADER.FISCAL_YEAR |
Period | PS_JRNL_HEADER.ACCOUNTING_PERIOD |
Status | PS_JRNL_HEADER.JRNL_HDR_STATUS |
Ledger | PS_JRNL_LN.LEDGER |
Organization | PS_JRNL_LN.ORGANIZATION |
Account | PS_JRNL_LN.ACCOUNT |
Account Description | PS_GL_ACCOUNT_TBL.DESCR |
Fund Code | PS_JRNL_LN.FUND_CODE |
Budget Entity | PS_JRNL_LN.BUDGET_REF |
Category | PS_JRNL_LN.PRODUCT |
State Program | PS_JRNL_LN.STATE_PROGRAM |
Journal Line Description | PS_JRNL_LN.LINE_DESCR |
Transaction Amount | PS_JRNL_LN.MONETARY_AMOUNT |
Version History
Date | Revision Description |
---|---|
02/01/2024 | Original Version |