Table PRODUCT_DIMENSION

DescriptionProduct identifies goods and services that can be offered, sold, or purchased by the Financial Institution, its competitors, and other Involved Parties, or in which the Financial Institution has an interest during the normal course of its business activity. For example; 'Product#220 (Xyz Bank's Private Banking Residential Mortgage Loan)', 'Product #988 (Personal Checking Account)', 'Product #440 (Securities Trading Service)'.

Columns
PRODUCT_DIMENSION_IDPRODUCT_DIMENSION_ID
COMMON_FULL_NAMECOMMON_FULL_NAME
COMMON_SHORT_NAMECOMMON_SHORT_NAME
DESCRIPTIONDESCRIPTION
MARKETING_NAMEMARKETING_NAME
PARENT_PRODUCT_CODEPARENT_PRODUCT_CODE
PARENT_PRODUCT_SHORT_NAMEPARENT_PRODUCT_SHORT_NAME
POOL_NAMEPOOL_NAME
PRODUCT_CODEPRODUCT_CODE
TRADEMARKTRADEMARK
TRADING_NAMETRADING_NAME
ANCHOR_IDANCHOR_ID
CURRENT_ROW_INDICATORCURRENT_ROW_INDICATOR
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
POPULATION_DATEPOPULATION_DATE
POPULATION_TIMEPOPULATION_TIME
POPULATION_DESCRIPTIONPOPULATION_DESCRIPTION
SOURCE_SYSTEM_NAMESOURCE_SYSTEM_NAME
SOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE
UNIQUE_ID_IN_SOURCE_SYSTEMUNIQUE_ID_IN_SOURCE_SYSTEM

Primary Key
PRODUCT_DIMENSION_PKPRODUCT_DIMENSION_PK

Indexes
PRODUCT_DIMENSION_PKPRODUCT_DIMENSION_PK

Column Details

 PRODUCT_DIMENSION_ID
DescriptionThe unique identifier of the Product Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COMMON_FULL_NAME
DescriptionCommon Full Name indicates the long name given to the Product for familiar usage.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COMMON_SHORT_NAME
DescriptionCommon Short Name indicates the short name given to the Product for familiar usage. It is a label given to the Product to identify or distinguish it from other Products. For example; XYZ Bank Special Car Loan.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription indicates a textual explanation or free form comments about a Product.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARKETING_NAME
DescriptionMarketing Name indicates a label by which the Product is publicly recognized and used.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARENT_PRODUCT_CODE
DescriptionParent Product Code indicates a mnemonic or highly abbreviated name for the Parent Product.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARENT_PRODUCT_SHORT_NAME
DescriptionParent Product Short Name indicates the short name given to the Parent Product for familiar usage. It is a label given to the Product to identify or distinguish it from other Products
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POOL_NAME
DescriptionPool Name indicates a pool name for a given Product. Pools can be based on Product maturity and/or repricing characteristics.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_CODE
DescriptionProduct Code indicates a mnemonic or highly abbreviated name for the Product. For example; IBMC is the mnemonic for International Business Machines Corporation Common Stock.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRADEMARK
DescriptionTrademark indicates a Product Name that is a legally protected identification that belongs to an Involved Party.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRADING_NAME
DescriptionTrading Name indicates a Product Name that is utilized to project its image or products to the market place.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAnchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_ROW_INDICATOR
DescriptionCurrent Row Indicator indicates whether or not, among the different versions of this dimension, this row holds the values that are currently valid in the business reality. This indicator enables the current values of the dimension to be retrieved quickly.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionEffective From Date indicates the effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionEffective To Date indicates the effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionValid From Date indicates the transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionValid To Date indicates the transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DATE
DescriptionPopulation Date indicates the date on which the instance of the entity was last updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIME
DescriptionPopulation Time indicates the time on which the instance of the entity was last updated.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DESCRIPTION
DescriptionPopulation Description indicates the textual description of the population cycle.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_NAME
DescriptionSource System Name indicates the textual name by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_CODE
DescriptionSource System Code indicates the code by which the Source System is known.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIQUE_ID_IN_SOURCE_SYSTEM
DescriptionUnique Id In Source System indicates the unique identifier of the populated instance in the Source System.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 PRODUCT_DIMENSION_PK
MemberPRODUCT_DIMENSION_ID [BIGINT]

Index Details

 PRODUCT_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberPRODUCT_DIMENSION_ID [BIGINT] Ascending