Table PRODUCT_GROUP

DescriptionA grouping of financial services products or product components with similar characteristics. A sample use is to categorise products by line of business (for example, life, health, property and casualty).

Example:

Third party liability in car insurance
Death coverage in life insurance
Car insurance.
Individual insurance
Group insurance
General (P&C) insurance
Health insurance
Life insurance

Columns
CATEGORY_IDCATEGORY_ID
ANCHOR_IDANCHOR_ID
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
END_DATEEND_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
MAXIMUM_SIZEMAXIMUM_SIZE
CATEGORY_NAMECATEGORY_NAME
ONLY_RULE_DRIVENONLY_RULE_DRIVEN
REFRESH_DATEREFRESH_DATE
START_DATESTART_DATE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
CATEGORY_ROWCATEGORY_ROW
LINE_OF_BUSINESS_SUB_GROUP_NAMELINE_OF_BUSINESS_SUB_GROUP_NAME
LINE_OF_BUSINBESS_SUB_GROUP_ROWLINE_OF_BUSINBESS_SUB_GROUP_ROW
LINE_OF_BUSINESS_NAMELINE_OF_BUSINESS_NAME
LINE_OF_BUSINBESS_ROWLINE_OF_BUSINBESS_ROW

Primary Key
PRODUCT_GROUP_PKPRODUCT_GROUP_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 CATEGORY_ID
DescriptionThe unique identifier of the Category
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 DESCRIPTION
DescriptionA free-text statement used to explain the meaning of the category.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 END_DATE
DescriptionThe date from which the category can no longer be used to qualify a business model object.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code used for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MAXIMUM_SIZE
DescriptionThe maximum number of members at any point in time.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CATEGORY_NAME
DescriptionThe word or phrase that identifies (but not uniquely) the category.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ONLY_RULE_DRIVEN
DescriptionIndicates whether a business model object may belong to the category regardless of whether they fulfil the category definition rule.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REFRESH_DATE
DescriptionThe date on which the membership in the category was most recently updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 START_DATE
DescriptionThe date from which the category can be used to qualify a business model object.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Category.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CATEGORY_ROW
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LINE_OF_BUSINESS_SUB_GROUP_NAME
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LINE_OF_BUSINBESS_SUB_GROUP_ROW
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LINE_OF_BUSINESS_NAME
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LINE_OF_BUSINBESS_ROW
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 PRODUCT_GROUP_PK
DescriptionThe unique identifier of the Category
MemberCATEGORY_ID [BIGINT]

Dependency Details

 AWM - Transformation