3.9 User Defined Properties
User Defined Properties are set for tables and columns within ERwin.
Table Level User Defined Properties
The following user defined properties can be set for the table:
UDP Name | Description | List of values |
Instrument | Property to identify if the table is classified as a basic instrument table. (that is, Instrument table classification code 20) | YES / NO |
TP Cash Flow | Property to identify if the table is classified as 'TP Cash Flow' for the purpose of generating Transfer Pricing rates using cash flow methods. | YES / NO |
TP Non Cash Flow | Property to identify if the table is classified as 'TP Non-Cash Flow' for the purpose of generating Transfer Pricing rates using non cash flow methods. | YES / NO |
Transaction Profitability | Property to identify if the table is classified as 'Transaction' for the purpose of executing allocation rules. | YES / NO |
Portfolio | Property to identify if the table is classified as 'Portfolio'. | YES / NO |
User Defined | Property to identify if the table is classified as 'User Defined' table for storing multi-lingual descriptions for codes. | YES / NO |
Ledger Stat | Property to identify if the table is classified as 'Ledger Stat' for the purpose of executing allocation rules. | YES / NO |
ALM Standard | Property to identify if the table is classified as 'ALM Standard' for the purpose of executing ALM cash flow engine to generate cash flows. | YES / NO |
TP Option Costing | Property to identify if the table is classified as 'TP Option Costing' for the purpose of generating Transfer Pricing rates with option costing. | YES / NO |
Break Funding | Property to identify if the table is classified as 'Break Funding' for the purpose of generating Break funding charges using Transfer Pricing engine. | YES / NO |
MLS Descriptions Reserved | Property to identify if the table is classified as 'Reserved' table for storing multi-lingual descriptions for codes. | YES / NO |
Codes Reserved (base tbl) | Property to identify if the table is classified as 'Reserved' table for storing codes of simple dimensions. | YES / NO |
Codes User Defined (base tbl) | Property to identify if the table is classified as 'User-defined' table for storing codes of simple dimensions. | YES / NO |
PA Lookup Tables | Property to identify if the table is classified as 'Lookup Table' for the purpose of defining lookup table allocation rules. | YES / NO |
Instrument Profitability | Property to identify if the table is classified as 'Instrument' for the purpose of executing allocation rules. | YES / NO |
Derivative Instruments | Property to identify if the table is classified as 'Derivatives' for the purpose of executing ALM cash flow engine to generate cash flows for derivative instruments. | YES / NO |
Data Correction Processing | Property to identify if the table is classified as 'Data Correction Processing' for the purpose of executing Cash Flow Edits engine. | YES / NO |
Column Level User Defined Properties
The following user defined properties can be set for the column:
UDP Name | Description | List of values |
Balance Range | Property to identify if the column within a table classified as 'PA Lookup Table' must be displayed under 'Range' within Lookup table definition. | YES / NO |
Balance | Property to identify if the column is of type 'Balance'. | YES / NO |
Standard Rate | Property to identify if the column is of type 'Standard Rate'. | YES / NO |
Balance Weighted Object | Property to identify if the column is of type 'Balance Weighted Object'. | YES / NO |
Processing Key | Property to identify if this column is used as a 'Processing Key' within the instrument, transaction and ledger_stat table. | YES / NO |
Frequency Multiplier | Property to identify if the column is used to store 'Frequency'. This property is used in Filters UI within OFSAAI. | YES / NO |
Multiplier Related Field | Property to specify the name of the column that is used to store the multiplier for the corresponding 'Frequency' column. This property is used in Filters UI within OFSAAI. | Text |
Related Field | Property to specify the name of the column that is used to store the multiplier for the corresponding 'Term' column. This property is used in Filters UI within OFSAAI. | Text |
Term Multiplier | Property to identify if the column is used to store 'Term'. This property is used in Filters UI within OFSAAI. | YES / NO |
Column Alias | Property to specify an alias for the column. This is used within the staging loader program for loading LEDGER_STAT table. | Text |
Statistic | Property to identify if the column is of type 'Statistic'. | YES / NO |
Transfer Pricing Output | Property to identify if the column must be set as an alternate output column for writing transfer rates by transfer pricing engine. | YES / NO |
Option Cost Output | Property to identify if the column must be set as an alternate output column for writing option costing output by transfer pricing engine. | YES / NO |
Other Adj Spread Output | Property to identify if the column must be set as an alternate output column for writing other adjustment spread by transfer pricing engine. | YES / NO |
Other Adj Amount Output | Property to identify if the column must be set as an alternate output column for writing other adjustment amount by transfer pricing engine. | YES / NO |
UDP_LOOKUP_RANGE_MINIMUM | Property to identify minimum range column within a table classified as 'PA Lookup Table'. | YES / NO |
For eg: LOOKUP_TEMPLATE_TABLE.AVERAGE_BALANCE_MIN column. | ||
UDP_LOOKUP_RANGE_MAXIMUM | Property to identify maximum range column within a table classified as 'PA Lookup Table'. | YES / NO |
For eg: LOOKUP_TEMPLATE_TABLE.AVERAGE_BALANCE_MAX column. | ||
UDP_EXPORT_PFT_OUTPUT | Property to identify PFT Output Columns in instrument tables and FSI_D_INST_SUMMARY table. | YES / NO |
For eg: CALL_CENTER_EXP, COMPLAINCE_EXP etc. | ||
UDP_EXPORT_FTP_OUTPUT | Property to identify FTP Output Columns in instrument tables and FSI_D_INST_SUMMARY table | YES / NO |
For eg: OTHER_ADJUSTMENTS_AMT, OTHER_ADJUSTMENTS_RATE etc. | ||
UDP_EXPORT_FTP_OTHERS | Property to identify columns used by FTP in instrument tables and FSI_D_INST_SUMMARY table | YES / NO |
For eg: AVG_BOOK_BAL, CUR_BOOK_BAL etc. | ||
UDP_EXPORT_EPM_KEY_DIMS | Property to identify EPM Key Processing dimension columns in instrument tables and FSI_D_INST_SUMMARY table. | YES / NO |
For eg: COMMON_COA_ID, PRODUCT_ID etc. | ||
UDP_EXPORT_EPM_KEY_COLUMNS | Property to identify mandatory key columns for EPM in instrument tables and FSI_D_INST_SUMMARY table. | YES / NO |
For eg: AS_OF_DATE, ISO_CURRENCY_CD, IDENTITY_CODE, INSTRUMENT_TYPE_CD etc. | ||
UDP_EXPORT_EPM_OTHERS | Property to identify other columns for EPM in instrument tables and FSI_D_INST_SUMMARY table. | YES / NO |
For eg: ACCOUNT_OFFICER_CD, INTEREST_INC_EXP etc. |