| Insurance Data Model |
Description | Grouping of attributes used to perform analysis on instances of Campaign that share the same characteristics. |
Columns | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Campaign 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 category to which the campaign belongs. e.g. Direct marketing e.g. Event triggered |
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 regularity with which the activity occurrence happens or is planned to happen. Activity occurrences can be recurrent. e.g. The radio-therapy |
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 activity with respect to other activities of the same type. For example, it distinguishes between a primary and secondary occupation. 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 explanation for the cessation of the activity e.g. Change of employment e.g. Injury e.g. Loss of interest |
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 campaign within a life-cycle consisting of a number of statuses. e.g. Initiated e.g. Ongoing e.g. Suspended e.g. Terminated |
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 Campaign mini dimension |
Member | CAMPAIGN_MINI_DIMENSION_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |