| Insurance Data Model |
Description | Grouping of attributes used to perform analysis on instances of Communication that share the same characteristics. |
Columns | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Communication 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 direction of a communication relative to the modelled organisation. e.g. External e.g. Inbound e.g. Internal e.g. Outbound |
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 numeric value that specifies the importance of this communication relative to other communications. e.g. 1 (High Priority) e.g. 5 (Low Priority) |
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 why a communication occurs or is planned to occur. e.g. Campaign mailing e.g. Claim coverage notification e.g. Complaint e.g. Demographic data e.g. Quotation request e.g. Regular statement e.g. Returned mail e.g. Sale |
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 communication within a life-cycle model consisting of a number of statuses. e.g. Awaiting further information e.g. Closed e.g. Open |
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 |
Primary Key Details |
Description | The unique identifier of the Communication mini dimension |
Member | COMMUNICATION_MINI_DIMENSION_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |