Understanding Regulatory Ledger Reporting

Regulatory Ledger Reports restate ledger balances that are stored in the PS_LEDGER table based on external regulatory requirements. This means that you can restate ledger balances based on PeopleSoft ChartFields (such as Account and Department ID) as ledger balances based on external ChartFields that a regulatory body (such as a government organization) mandates for reporting purposes. You can use the Regulatory Ledger Reporting feature to:

  • Generate ledger file extracts that are specifically designed for the Ontario Provincial Ministry of Health in Canada.

  • Build a regulatory ledger.

  • Review the translated data.

  • Review the translation errors.

To accomplish this, you:

  • Define the regulatory ledger and associated external ChartFields.

  • Set up ChartField attributes and attach them to PeopleSoft ChartField values.

  • Set up a regulatory ledger ChartField mapping structure and define rules that translate PeopleSoft ChartField values into external ChartField values.

Note: For organizations that are required to report to other regulatory bodies, you could use the ledger file extract that is provided specifically for the Ontario Provincial Ministry of Health in Canada as the basis of creating new customized ledger file extracts.

For regulatory reporting, you must set up the:

  • SetID for the target PeopleSoft ChartField values that is used in ChartField value mapping.

  • Account types for any new SetIDs.