| Insurance Data Model |
Label | FS product mini dimension |
Description | Grouping of attributes used to perform analysis on instances of Financial services product that share the same characteristics. |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Financial services product mini dimension |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Indicates 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 Type | CHAR(1) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Indicates whether a business model object may belong to the category regardless of whether they fulfil the category definition rule. |
Data Type | CHAR(1) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Indicates 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 Type | CHAR(1) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Indicates if the product is replicable by a financial instrument i.e. hedgeable. |
Data Type | CHAR(1) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The 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 Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The reason explaining why there was a status change. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Indicates if a product specification is administered by a third party or by the modelled organisation |
Data Type | CHAR(1) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Categorisation 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 Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Indicator 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 Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A group or classification of a product into standard groups based on the characteristics of the product. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A category of insurance products within one line of business, grouped by subject matter of risk, or nature of cover provided. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Used to determine whether the insurance product is direct, reinsurance or some other form of risk transfer product. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The line of business classification code applicable for a product. |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Description | The unique identifier of the Financial services product mini dimension |
Member | FINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |