3.7.2 Requirement For Table Classification

Specific column requirements for each table property can be obtained by querying REV_COLUMN_REQUIREMENTS table.

OFSAAI requires specific table structures, column names and column characteristics for OFSAA operations. These structures and requirements are embodied by the User-Assignable Table Classifications.

Each Table Classification comprises individual Table Properties that define the requirements for that classification. Table Properties are two distinct types: those encompassing specific column requirements and those encompassing logic requirements via stored procedures.

The following table provides the validation checks that are being done for each of the table classification:

TABLE_CLASSIFICATION_CD TABLE_CLASSIFICATION TABLE_PROPERTY DESCRIPTION Comments
50 Ledger Stat Ledger Leaf Column Class Fields that are part of core modeling dimensions for Fusion PFT Checks if columns of super-type Ledger Leaf Column Class is present
100 Portfolio Portfolio Requirements Dynamic list of Portfolio fields Checks if columns of super-type Portfolio Requirements is present
200 TP Cash Flow Basic Instrument Requirements Instrument Required fields Checks if columns of super-type Basic Instrument Requirements is present
200 TP Cash Flow Cash Flow Proc. Requirements Fields required by TP and ALM Cash Flow processing Checks if columns of super-type Cash Flow Proc. Requirements is present
Note, this is required if Conditional Assumptions are being defined against the table.
200 TP Cash Flow Cash Flow Edit Requirements Fields required by Cash Flow Edits in addition to Cash Flow fields Checks if columns of super-type Cash Flow Edit Requirements is present
200 TP Cash Flow Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of super-type Multi-Currency Requirements is present
200 TP Cash Flow TP Basic Requirements Non-cash flow Transfer Pricing fields Checks if columns of super-type TP Basic Requirements is present
200 TP Cash Flow Validate Instrument Leaves Validates that a table has all 'B' leaves Validation . Check if the table has all the key dimension leaf columns. The leaf columns should be of data type NUMBER
200 TP Cash Flow Validate Instrument Key Validate the unique key for Instrument (PA, TP, ALM) tables Validation . Instrument table should have index present on ID_NUMBER and IDENTITY_CODE column
210 TP Non-Cash Flow Basic Instrument Requirements Instrument Required fields Checks if columns of super-type Basic Instrument Requirements is present
210 TP Non-Cash Flow Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of super-type Multi-Currency Requirements is present
210 TP Non-Cash Flow TP Basic Requirements Non-cash flow Transfer Pricing fields Checks if columns of super-type TP Basic Requirements is present
210 TP Non-Cash Flow Validate Instrument Leaves Validates that a table has all 'B' leaves Validation . Check if the table has all the key dimension leaf columns. The leaf columns should be of data type NUMBER
210 TP Non-Cash Flow Validate Instrument Key Validate the unique key for Instrument (PA, TP, ALM) tables Validation . Instrument table should have index present on ID_NUMBER and IDENTITY_CODE column
300 Transaction Profitability Basic Instrument Requirements Instrument Required fields Checks if columns of super-type Basic Instrument Requirements is present
300 Transaction Profitability Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of super-type Multi-Currency Requirements is present
300 Transaction Profitability Validate Instrument Leaves Validates that a table has all 'B' leaves Validation . Check if the table has all the key dimension leaf columns. The leaf columns should be of data type NUMBER
300 Transaction Profitability Validate Transaction Key Validate the unique key for Transaction Profitability tables Transaction table should have composite index present on ID_NUMBER and IDENTITY_CODE and all the processing key columns.
310 Instrument Profitability Basic Instrument Requirements Instrument Required fields Checks if columns of super-type Basic Instrument Requirements is present
310 Instrument Profitability Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of super-type Multi-Currency Requirements is present
310 Instrument Profitability Validate Instrument Leaves Validates that a table has all 'B' leaves Validation . Check if the table has all the key dimension leaf columns. The leaf columns should be of data type NUMBER
310 Instrument Profitability Validate Instrument Key Validate the unique key for Instrument (PA, TP, ALM) tables Validation . Instrument table should have index present on ID_NUMBER and IDENTITY_CODE column
330 Data Correction Processing Validate Processing Key Validate the unique key for Processing tables Processing Key Column for a table have a matching unique index
360 ALM Standard Basic Instrument Requirements Instrument Required fields Checks if columns of super-type Basic Instrument Requirements is present
360 ALM Standard Cash Flow Proc. Requirements Fields required by TP and ALM Cash Flow processing Checks if columns of super-type Cash Flow Proc. Requirements is present
360 ALM Standard Cash Flow Edit Requirements Fields required by Cash Flow Edits in addition to Cash Flow fields Checks if columns of super-type Cash Flow Edit Requirements is present
360 ALM Standard Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of super-type Multi-Currency Requirements is present
360 ALM Standard Validate Instrument Leaves Validates that a table has all 'B' leaves Validation . Check if the table has all the key dimension leaf columns. The leaf columns should be of data type NUMBER
360 ALM Standard Validate Instrument Key Validate the unique key for Instrument (PA, TP, ALM) tables Validation . Instrument table should have index present on ID_NUMBER and IDENTITY_CODE column
370 TP Option Costing Basic Instrument Requirements Instrument Required fields Checks if columns of super-type Basic Instrument Requirements is present
370 TP Option Costing Cash Flow Edit Requirements Fields required by Cash Flow Edits in addition to Cash Flow fields Checks if columns of super-type Cash Flow Edit Requirements is present
370 TP Option Costing Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of super-type Multi-Currency Requirements is present
370 TP Option Costing TP Option Costing Requirements Fields required for Transfer Pricing Option Costing processing Checks if columns of super-type TP Option Costing Requirements is present
370 TP Option Costing TP Basic Requirements Non-cash flow Transfer Pricing fields Checks if columns of super-type TP Basic Requirements is present
370 TP Option Costing Validate Instrument Leaves Validates that a table has all 'B' leaves Validation . Check if the table has all the key dimension leaf columns. The leaf columns should be of data type NUMBER
370 TP Option Costing Validate Instrument Key Validate the unique key for Instrument (PA, TP, ALM) tables Validation. Instrument table should have index present on ID_NUMBER and IDENTITY_CODE column
500 PA Lookup Tables Validate PA Lookup Procedure to check if there is a primary key for the lookup tables. Validation. All Lookup table should have a primary key present
530 Break Funding Break Funding Requirements Fields required as part of TP break funding Checks if columns of super-type Break Funding Requirements is present
301 Insurance Transaction Profitability UDP Validate Policy Table Leaves Validates that a policy table has all 'B' leaves Validation. Check if the table has all the key dimension leaf columns. The leaf columns should be of data type NUMBER
301 Insurance Transaction Profitability UDP Validate Policy Trans Key Validate the unique key for Policy Transaction tables Transaction table should have composite index present on ID_NUMBER and IDENTITY_CODE and all the processing key columns.
301 Insurance Transaction Profitability UDP Basic Instrument Requirements Instrument Required fields Checks if columns of supertype Basic Instrument Requirements are present
301 Insurance Transaction Profitability UDP Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of supertype Multi-Currency Requirements are present
311 Insurance Policy Profitability UDP Multi-Currency Requirements Fields required for Multi-Currency Checks if columns of supertype Multi-Currency Requirements are present
311 Insurance Policy Profitability UDP Basic Instrument Requirements Instrument Required fields Checks if columns of supertype Basic Instrument Requirements are present
311 Insurance Policy Profitability UDP Validate Instrument Key Validate the unique key for Instrument (PA, TP, RM) tables Transaction table should have composite index present on ID_NUMBER and IDENTITY_CODE and all the processing key columns.
311 Insurance Policy Profitability UDP Validate Policy Table Leaves Validates that a policy table has all 'B' leaves Validation . Check if the table has all the key dimension leaf columns. The leaf columns must be of data type NUMBER
351 Insurance Profitability - Other Class UDP Profitability - Other Class Validate the unique key for Profitability - Other Class tables Validate the unique key for Profitability - Other Class tables