Setting Up Miscellaneous Parameters

This section discusses how to:

Create business calendars for various countries.
Define ledger account codes.

Pages Used to Set Up Miscellaneous Parameters

Page Name	Definition Name	Navigation	Usage
Business Calendar	BUS_CALENDAR_TR	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Currency Calendar, then select Business Calendar	Create business calendars for various nations.
Market Exchange	FI_MARKET_EXCH	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Market Exchange	Create lookup codes for market securities exchanges. The system uses these for futures and reporting purposes only.
Funds ID	FI_FUND_ID_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Funds ID	Create fund IDs to track investment funds associated with a financial instrument or account.
Ledger Account Codes	FI_LDGRACCT_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Ledger Account Codes	Identify the revenue and expense accounts associated with an instrument. The ledger account codes differentiate between interest income and expenses, fee income and expenses, and any unearned income or fees waived. The system uses ledger account codes as a key to the instrument ledger table (FI_ILDGR_R00).
Treasury Position Code	FI_POS_SRC_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Treasury Position Code	Define treasury position codes. PeopleSoft Funds Transfer Pricing and PeopleSoft Risk-Weighted Capital do some of their processing on off-balance sheet treasury position accounts, such as foreign exchange derivatives, precious metals, or any other account position that is the result of trading room and treasury operations.
Demographics Codes	FI_DEMOGTYP_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Demographics Codes	Create codes to identify the demographic or statistical information about a customer or a financial instrument that is stored in the Instrument Demographic table (PS_FI_IDEMOG_R00).
Participation IDs	FI_PRTCP_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Participation ID, then select Participation IDs	Define participation ID codes. You can use these to identify the participants involved in, or responsible for, a financial instrument. For example, you might sell 30 percent of the balance of a particular loan to another bank or investor. Use participation ID codes to list your participants and provide lookup verification in your instrument tables. The system uses Participant ID as a key to the Participation table (FI_IPRTCP_R00).
External Source Systems	PF_SRC_SYS_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select External Source Systems	Identify the source system (transaction system) where the original instrument information is maintained. Source system is an attribute on the Instrument (FI_INSTR_F00) table. You may have more than one source system for entering data into the EPM Warehouse.
Balance Types	FI_BALTYPE_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Balance Types	Define the type of instrument balances stored in the warehouse and processed by PeopleSoft Financial Services Industry applications. The Instrument Balance table (PS_FI_IBAL_R00) is set up so that multiple balance types and balance amounts can be stored for each instrument. The Balance Type field in this table identifies the type of balance for a specific record. Examples of different balance types that you might want to set up are current balance, average daily balance, period ending balance, or commitment balance. You can modify these values, which might vary depending on your business needs.
Instrument Lookup Codes	FI_DIMTYPE_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Instrument Lookup Codes	Identify other attributes of an instrument that do not occur under one of the other categories. The system uses them as a key to the Instrument Other (FI_IOTHER_R00) table. For example, you could use the Instrument Other table to store demographic information or any other information that does not fit into one of the other instrument tables.
Option Types	FI_OPTION_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Option Codes, then select Option Types	Define the types of options that may be part of a financial instrument. Use Instrument Option table (PS_FI_IOPTION_R00) to store the options that are embedded in a financial instrument. Examples of instruments with embedded options are callable bonds, interest rate locks, and loans with prepayment options.
Risk Ratings	FI_RISKRATE_TBL	select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Risk Rating, then select Risk Ratings	Create a risk rating code.

Business Calendar Page

Use the Business Calendar page (BUS_CALENDAR_TR) to create business calendars for various nations.

Navigation

select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Currency Calendar, then select Business Calendar

Use the Business Calendar page to create calendars that affect the markets outside the organization's domestic operations. For instance, banks in the United States commonly trade in Eurodollar futures that derive their value from the London Inter Bank Offered Rates (LIBOR) index. The markets that handle Eurodollar futures are based in Chicago. The holiday schedule of the Chicago Mercantile Exchange (CME) typically coincides with the U.S. bank holidays, but not with Great Britain, where the LIBOR index rate is determined.

Two examples occur in the months of January and February. In those months, Martin Luther King Jr. and President's Day are U.S. bank holidays that occur in the middle of the month, and in observance of which the CME is closed. This is the time when the Eurodollar futures contracts close. The International Monetary Market (IMM) date is the Monday preceding the third Wednesday of each month, and this is the day that the Eurodollar futures contract (such as the January or February 1 month LIBOR 1MLB contract) values. Because the CME is closed on the IMM date, when the 1MLB contracts are valued, they must determine the value of their existing January or February 1MLB contracts the day after the holiday. If the system cannot determine that the exchange was closed on the IMM date, it provides the previous business day's closing price (the Friday preceding the holiday). Erroneous data is generated for reports such as (mark-to-market) income and activity reports that feature expired and closed futures contracts generating accounting (gain and loss) statements for hedge accounting entries.

The business calendar informs the system about the conflicting holiday schedule for financial instruments. The system allows the user to supply the information necessary to value the contract correctly based on user-defined offset rules (that is, the day after the holiday).

To set up business calendars:

Select the days of the week that are normal business days for this country.

The system selects Monday through Friday by default.
Select the date of the business holiday observed in that specific country and the holiday name.

Ledger Account Codes Page

Use the Ledger Account Codes page (FI_LDGRACCT_TBL) to identify the revenue and expense accounts associated with an instrument.

The ledger account codes differentiate between interest income and expenses, fee income and expenses, and any unearned income or fees waived. The system uses ledger account codes as a key to the instrument ledger table (FI_ILDGR_R00).

Navigation

select Financial Services Industries, then select Models and Parameters Setup, then select Miscellaneous Parameters, then select Ledger Account Codes

To define ledger account codes, specify the type of income or expense item identified by this ledger account code in the Account Type field. Values are:

Interest Income/Expense

Identifies instrument revenue or expense balances (or both) that are to be included when calculating the net interest margin on an instrument.

Fees Income/Expense

Identifies any fees charged or received for an instrument. Fees are included for profitability calculations but are excluded on any net interest margin calculations.

Other Income/Expense

Identifies other sources of income or expense items such as adjustments.

Fees Waived

Identifies any fees waived due to compensating balances or fees waived by an account officer.

Unearned Income/Expense

Identifies income or expenses generated by assets categorized as nonperforming.