Defining Performance Ledger Templates

This topic provides an overview of performance ledger templates and discusses how to:

Set up a performance ledger template.
Specify ledger template ChartFields.
Assign temporary tables to records.

Pages Used to Define Performance Ledger Templates

Page Name	Definition Name	Navigation	Usage
Ledger Template - Ledger Template	LEDGER_TEMPLATE1	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledger Template, then select Ledger Template	Set up a performance ledger template.
Ledger Template - ChartFields	LEDGER_TMPLT_CF	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledger Template, then select ChartFields	Specify ledger template ChartFields.
Ledger Template - Edit and Post Variables	LEDGER_TMPLT_EDPST	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledger Template, then select Edit and Post Variables	Assign temporary tables to records.

Understanding Performance Ledger Templates

A ledger template defines the physical attributes of a ledger and streamlines the ledger definition process. You define the template once and use it for all your ledgers.

When you create a ledger template, the system automatically identifies the list of ChartFields based on the ledger table selected. The ChartFields are identified based on the following criteria:

ChartField is equal to any field between the ACCOUNTING_PERIOD and CURRENCY_CD fields based on the selected ledger table's structure in the database

The currency code field is also always treated as a ChartField.

PeopleSoft provides a number of predefined ledger templates, which include default records and fields that support the ChartFields and other field and record definitions delivered with the system. (SetID does not key the template). If you want to create a new template or modify a template's records or fields, you need to follow the instructions in this topic.

You define performance ledger templates using the Ledger Template component.

Note: The last page in the Ledger Template component, Budget Variables, is used by PeopleSoft Planning and Budgeting and is described in PeopleSoft EPM: Planning and Budgeting documentation.

Ledger Template - Ledger Template Page

Use the Ledger Template - Ledger Template page (LEDGER_TEMPLATE1) to set up a performance ledger template.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledger Template, then select Ledger Template

Image: Ledger Template page

This example illustrates the fields and controls on the Ledger Template page. You can find definitions for the fields and controls later on this page.

Detail

Select this ledger type for ledgers containing detail ledger ChartFields which serve as keys.

Summary

Select this ledger type for ledgers to be used for reporting purposes.

EPM Ledger Type

Unless you're working with PeopleSoft Global Consolidations or Planning and Budgeting, you'll select Performance Measurement Ledger. If you change the EPM Ledger Type field, the system resets the values for the ledger records and ChartFields. Your selection here also determines what fields will be displayed on the Detail Ledger page so that the ledger data in the ledger table is uniquely identified.

Note: If you select an EPM ledger type of Consolidation Source Ledger, do not select a journal line table name as journal entries for these tables are not supported.

Used in Consolidations

Select this check box if this ledger template is used for consolidate information for reporting.

Ledger Record

Represents the ledger record that you use to store the balances for each ChartField combination that has posted activity.

Journal Line

Stores detail lines containing the monetary and statistical amounts for each journal entry.

Note: The ledger record and journal line prompts are based on PeopleSoft EPM record metadata. If your desired table is not returned in the prompt, define it in your PeopleSoft EPM record metadata first.

You can access the Record Metadata page for the ledger record or journal line currently selected directly from the Ledger Template page by selecting the link beside the Ledger Record and Journal Line fields. The link text varies based on the ledger record or journal line selected. In the example above, in the Ledger Record field, select the Performance Ledger link to access the Record Metadata page for the ALM_LEDGER_F00 performance ledger.

Ledger Template - ChartFields Page

Use the Ledger Template - ChartFields page (LEDGER_TMPLT_CF) to specify ledger template ChartFields.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledger Template, then select ChartFields

Image: Ledger Template - ChartFields page

This example illustrates the fields and controls on the Ledger Template - ChartFields page.

Select Edit Table and View - No Effective Date records to use for this template.

The page accesses a set of default edit table names and reporting views for the ChartFields in the ledger. The edit table value comes from the edit table specified in the Application Designer for this field on the ledger table. The View - No Effective Date field is used for reporting prompts when you do not want to limit the selection by effective date (because historical rows might contain ChartFields that are no longer active). You can change these values if you are modifying your system.

Ledger Template - Edit and Post Variables Page

Use the Ledger Template - Edit and Post Variables page (LEDGER_TMPLT_EDPST) to assign temporary tables to records.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledger Template, then select Edit and Post Variables

Image: Ledger Template - Edit and Post Variables page

This example illustrates the fields and controls on the Ledger Template - Edit and Post Variables page. You can find definitions for the fields and controls later on this page.

Temp Table 1 Name, Temp Table 2 Name, Temp Table 3 Name, and Temp Table 4 Name

Use to assign up to four temporary tables to the ledger template. Your temporary table selection must match those tables in your ledger template. Each of the four temporary tables represent the journal and ledger records that Profit Manger uses to process your ledgers and journals.

Run Edit for Profit Manager

Select this check box to run edit for the Profit Manager.

Note: The journal and ledger tables have ChartField subrecords. If you add ChartFields, you must modify these table subrecords