Defining Source Filter Options for PeopleSoft Enterprise Financial Management Source Systems

When defining data load rule details, you can specify various data extraction options as described below.

To define the source filter options for PeopleSoft Enterprise Financial Management source systems:

1. On the Workflow tab, under Data Load, select Data Load Rule.
2. In Data Load Rule, select a data load rule or click Add.
3. Select the Source Options tab.
4. Select the Amount Type:

   • Monetary

   • Statistical—The balance selection of entered or functional currency does not apply.

   • Monetary and Statistical

5. In Signage Method, select the method to flip the sign of amounts when data is loaded.

   Available methods:

   • Absolute—Loads the default debit or credit sign.

     Table 3-13 Absolute Signage rules

     Account Type	GL (GAAP)	EPM (Absolute)
     Revenue	Naturally negative	Signage flipped
     Liability	Naturally negative	Signage flipped
     Equity	Naturally negative	Signage flipped
     Expense	Naturally positive	Signage unchanged
     Asset	Naturally positive	Signage unchanged

   • Same as source—Loads the same sign as recorded in the source system.

   • Reverse from source—Loads the reverse of the sign as recorded in the source system.

6. Select the Amount for Balance Sheet Accounts and Amount for Income Statement Accounts:

   • YTD—Year-to-date account balance, where account balances are accumulated from the beginning of the year to the current period. Typically, balance sheet accounts (assets, liabilities, and equities) are specified with a YTD balance.

   • Periodic—Account balance for the specific period. Typically, income statement accounts (revenues and expenses) are specified with a periodic balance.

7. From Currency Type, select the currency type by which to extract balances:

   • Functional—Balances stored in the base currency of the selected ledger or business unit (local currency)

   • Entered—Balances associated with a currency attached to primary ledger other than the functional/local currency that you specify in the Currency Code field.

   Note:

   The default when Oracle Hyperion Financial Data Quality Management, Enterprise Edition pulls from PeopleSoft is POSTED_TOTAL_AMT. If you select an entered currency, FDMEE pulls from POSTED_TRAN_AMT. If you want the BASE amount, then create an alternate schema and create a view PS_LEDGER to switch the amount.

8. From Currency Code, select the ISO 4217 currency code to use with an entered currency type.

   For example, enter: EUR to select the euro currency code.

9. Select the Ledger Group.
10. Select the Ledger.

    In PeopleSoft, a business unit may have multiple ledger groups. In this list, FDMEE displays only the ledger groups associated with the ledger.

11. Optional: To select book code values, click , select book code values, and then click OK.

    To clear a book code, click . Then, in the Select Book Code dialog box, clear book codes, and then click OK.

12. To select budget values, click , select budget values, and then click OK.

    You specify the budget values when the ledger that you selected has the data table "Ledger_Budg."

    To deselect budget values, click . Then, in Select Budget Scenario values, clear values, and then click OK.

13. Click Save.
14. Define target filter options.

    After you define target filter options, run the data rule. See Running Data Load Rules.