CRA Activity Statement (CMR028)
  • 29 May 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

CRA Activity Statement (CMR028)

  • Dark
    Light
  • PDF

Article summary

Report Description 

This report was implemented in CMS Wave and will be updated in Financials Wave. The information in this article is the planned design for Financials Wave.

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

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

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


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.