Table FS_PRODUCT_MINI_DIMENSION

LabelFS product mini dimension
DescriptionGrouping of attributes used to perform analysis on instances of Financial services product that share the same characteristics.

Columns
FINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_IDFINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID
MARKET_VALUE_ADJUSTMENT_INDICATORMARKET_VALUE_ADJUSTMENT_INDICATOR
ONLY_RULE_DRIVENONLY_RULE_DRIVEN
RENEWABLERENEWABLE
REPLICABLEREPLICABLE
STATUSSTATUS
STATUS_REASONSTATUS_REASON
THIRD_PARTY_PRODUCTTHIRD_PARTY_PRODUCT
UNITISED_STATUSUNITISED_STATUS
WITH_PROFIT_INDICATORWITH_PROFIT_INDICATOR
PRODUCT_GROUPPRODUCT_GROUP
CLASS_OF_BUSINESSCLASS_OF_BUSINESS
SOURCE_OF_BUSINESSSOURCE_OF_BUSINESS
LINE_OF_BUSINESSLINE_OF_BUSINESS

Primary Key
FS_PRODUCT_MINI_DIMENSION_PKFS_PRODUCT_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 FINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Financial services product mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARKET_VALUE_ADJUSTMENT_INDICATOR
DescriptionIndicates whether the market value adjustment (MVA) technique is applicable to this product component. Market value adjustment is a way for the insurer to make sure that the amount of money paid out to an investor is a fair reflection of that investor's share of the with-profits fund, and any growth which has been achieved on the fund. Typically, this technique may apply to profit sharing components.
Data TypeCHAR(1)
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



 RENEWABLE
DescriptionIndicates whether the product component is renewable.
Is derived from the presence of an agreement request specification of kind 'policy renewal' as one of the allowed requests for this product component.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REPLICABLE
DescriptionIndicates if the product is replicable by a financial instrument i.e. hedgeable.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionThe position of a specification within a life-cycle model consisting of a number of statuses.
The position of a financial services product within a life-cycle model consisting of a number of statuses.
The position of the insurance policy within a life-cycle model consisting of a number of statuses.

e.g. Effective
e.g. Suspended
e.g. Under development
e.g. Withdrawn
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe reason explaining why there was a status change.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 THIRD_PARTY_PRODUCT
DescriptionIndicates if a product specification is administered by a third party or by the modelled organisation
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNITISED_STATUS
DescriptionCategorisation of Financial services products according to whether the premium is used in the context of unitised business.

e.g. Non-unitized component
e.g. Unitised with-profit component (UWF)
e.g. Unit-linked component
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 WITH_PROFIT_INDICATOR
DescriptionIndicator specifying whether the financial services product (component) entitles beneficiaries to a share of the insurer's profits.

e.g. With profit
e.g. Without profit
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_GROUP
DescriptionA group or classification of a product into standard groups based on the characteristics of the product.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLASS_OF_BUSINESS
DescriptionA category of insurance products within one line of business, grouped by subject matter of risk, or nature of cover provided.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_OF_BUSINESS
DescriptionUsed to determine whether the insurance product is direct, reinsurance or some other form of risk transfer product.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LINE_OF_BUSINESS
DescriptionThe line of business classification code applicable for a product.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 FS_PRODUCT_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Financial services product mini dimension
MemberFINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation