Defining Source Filter Options for PeopleSoft Enterprise Financial Management Source Systems

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

1. Select the Amount Type:

   • Monetary

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

   • Monetary and Statistical

2. In Signage Method, select the method for flipping the sign of amounts when data is loaded.

   Available methods:

   • Absolute—Loads the default debit or credit sign.

     Table 29. 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.

3. 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.

4. 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.

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

   For example, enter EUR to select the EURO currency code.

6. Select the Ledger Group.

7. 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.

8. 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.

9. 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 the Select Budget Scenario Values dialog box, clear values, and then, click OK.

10. Click Save.

11. Define target filter options.

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