6.2 FSI_O_PROCESS_CASH_FLOWS Table

The relevant financial elements for each instrument record and the Cash Flow results are stored in the FSI_O_PROCESS_CASH_FLOWS table.

Table 6-1 Details of FSI_O_PROCESS_CASH_FLOWS table

Column	Description
Result Sys ID	The key column that corresponds to the Sys ID Num of the Process rule. All cash flow results for the processing run are stored with the same Result Sys ID value. See Determining the value of the Result Sys ID.
Calc Source Cd	The type of cash flow processing (selected in the Process Rule): 0 - ALM - Regular (scenario based processing) 1 - ALM - Stochastic processing 2 - TP - Regular 3 - TP - Forward Rates 4 - TP - Stochastic processing 5 – TP – Adjustments (Economic Cost) 6 - TP – Adjustments (Liquidity Premium) 7 - TP – Adjustments (Basis Risk Cost) 8 - TP – Adjustments (Pricing Incentive) 9 - TP – Adjustments (Other)
Record Sequence	The processing order of the records.
Cash Flow Sequence	The order of the events (cash flows, repricing events).
Scenario Num	The scenario number assigned in the Forecast Rates rule for scenario-based processing or the rate path number determined in stochastic processing.
Financial elem ID	The numeric code describing a piece of financial information described in the row of result data.
ID Number	The unique record identifier for the instrument records processed.
Cash Flow Date	The date of the event.
Cash Flow Cd	The code identifying the type of event.
Float Value	The value assigned to each financial element.
Product Leaf Node	The product leaf number.
Org Leaf Node	The organizational unit leaf member, an optional output dimension in Oracle ALM and always populated in Oracle FTP output.
Iso Currency Cd	A currency associated with cash flow values.