Primary Tables
The PeopleSoft Financial Services Industry environment has several primary tables that it uses for processing and storing data for the PeopleSoft Financial Services Industry environment and applications. These tables store historical data, including closed contracts (that is, instruments with a zero balance). The historical data is used for reporting, as well as forecasting purposes.
Some of the tables are required (indicated below with an asterisk). Others are optional and used for reporting purposes or for building user-defined constraints, which can be used throughout PeopleSoft Financial Services Industry applications when defining business rules and processes performed on subsets of data. These tables store historical data, including closed contracts (that is, instruments with a zero balance)
Table |
Description |
Used By/For |
---|---|---|
FI_INSTR_F00* |
This is the primary record for the instrument family of tables. This functions as the parent record that stores many of the mandatory contractual instrument attributes, such as payment terms, interest rates, customer ID, and so on. |
PeopleSoft Financial Services Industry applications and environment |
FI_IBAL_R00* |
Stores any number of balance amounts for the instruments. The balance type code is used to define the type of balance information that is supplied. |
PeopleSoft Financial Services Industry applications and environment |
FI_ISTATUS_R00* |
Stores current status information about the instrument such as whether it's closed, sold, or non-performing, the risk rating, and current interest rate. |
PeopleSoft Financial Services Industry applications and environment |
FI_IEVENT_R00 |
Stores information on the contractual or planned cash flow events, such as draw-downs and payments, usually used for large commercial loans. Used in the cash flow calculations. |
Cash Flow Generator |
FI_ITRNHST_R00 |
Stores transaction history such as prepayments, cancelled draw-downs (both of which are used to calculate break funding charges in PeopleSoft Funds Transfer Pricing). It can also store a variety of statistics, such as number of ATM transactions that are for reporting purposes. |
Cash Flow Generator |
FI_IDX_RT_H00 |
Stores historic interest rates. |
Cash Flow Generator |
FI_POOLINST_F00 |
Stores instrument pool information created by the Stratification application engine process as part of the Financial Performance Measures process. |
FPM |
FI_POOLBAL_R00 |
Stores aggregated balance amounts for the instrument pools. |
FPM |
FI_POOLCALC_R00 |
Stores financial measures calculated for the instrument pools. |
FPM |
FI_POOL_CF_R00 |
Stores projected cash flows calculated for the instrument pools. |
FPM |
FI_ICALC_R00 |
Stores financial measures at the instrument level. |
FPM |
FI_ICSTAT_R00 |
Stores intermediary process-instance information. |
FPM |
FI_IFCRULE_R00 |
Stores intermediary process-instance information. |
FPM |
FI_RCN_BS_F00 |
Stores reconciliation differences found by the Reconciliation process. |
Reconciliation (balance sheet) |
FI_RCN_DIM_F00 |
Stores the reconciliation differences by enterprise dimensions. This table can be used by Data Manager to allocate funds transfer pricing charges that result from reconciliation differences. |
Reconciliation (balance sheet) |
FI_NIM_F00 |
Stores summarized information for the Net Interest Margin Report process. The data are derived from the instrument pools, and from the Balance Sheet Reconciliation process (based on the balance sheet categories defined in the balance sheet rules). |
Reconciliation (balance sheet) |
FI_IOPTION_R00 |
Stores information concerning options embedded in the instruments, such as prepayment options. |
Reporting |
FI_IOTHER_R00 |
Stores any additional elements or customized instrument attributes, such as prepayment options. |
Reporting |
FI_IDEMOG_R00 |
Stores demographic information about customers. |
Reporting |
FI_IPRTCP_R00 |
Stores information about loan participations, syndications, and servicing. |
Reporting |