| Insurance Data Model |
Description | Grouping of attributes used to perform analysis on instances of Channel role that share the same characteristics. |
Columns | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Channel role 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 | The operational authority of the channel role for selling, servicing and marketing products. e.g. Selling e.g. Servicing |
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 degree to which the channel role is independent of an organisation for which it conducts business. e.g. Employed e.g. Fully independent e.g. Limited independence e.g. Tied |
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 level of seniority of the channel role. |
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 relative priority of the party role against other party roles of the same type. For example, it indicates whether a person considers a particular job to be a primary or alternative source of income. e.g. Primary e.g. Secondary |
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 position of the party role within a life-cycle model consisting of a number of statuses. e.g. Active e.g. Ex-Customer e.g. Prospect e.g. Suspect |
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. e.g. Commenced e.g. Leave of absence e.g. Misconduct e.g. Resignation e.g. Retirement e.g. Temporary reassignment |
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 how long an agent has been an Insurance agent registered with an Agent license. |
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 level of insurance business education successfully completed by the party playing this role. |
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 restrictions that apply to the channel role with respect to deciding the terms on which an financial services agreement will be accepted. e.g. L (Limited) e.g. N (None) e.g. P (Preferred) |
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 Channel role mini dimension |
Member | CHANNEL_ROLE_MINI_DIMENSION_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |