| Insurance Data Model |
Description | Grouping of attributes used to perform analysis on instances of Task that share the same characteristics. |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Task 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 main language in which the training course is conducted. |
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 setting, or format, of the training task. e.g. Conference e.g. E-learning e.g. On the job e.g. Seminar e.g. Workshop |
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 task happens or is planned to happen. Tasks can be recurrent. |
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 whether or not the task is considered to be insurable 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 | The means by which the assessment performed by the task is derived. e.g. Certified gemmologist appraisal e.g. Data mining algorithm e.g. Purchased demographic data e.g. Real estate appraisal e.g. Survey |
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 whether the task is performed by resources internal to the modelled organisation, or, by external resources.True when the task is performed by external resources. |
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 relative priority of the task with respect to other tasks of the same type. |
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 task. |
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 whether reinsurance has been taken into consideration when performing the actuarial calculations. |
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 | Names the set of parameters and their respective values that have been taken into consideration when calculating the analytical measures that scenarios govern. The set of assumptions that those parameters and their values represent is labelled as a 'valuation basis'. The labels are essentially arbitrary, and may be plain text set by business users, such as actuaries. |
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 whether the solvency margin has been taken into consideration when performing the actuarial calculations. |
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 taxation has been taken into consideration when performing the actuarial calculations. |
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 | Indication of the state of the values used as input into the task.It indicates the types of assumptions and data set(s) that were used to perform the task. |
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 distribution calculation method used. |
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 | Identifies the position of the organisation within a life-cycle model consisting of a number of statuses.It is used for all statuses other than foundation and dissolution. e.g. Active e.g. Closed out e.g. Compulsory liquidation e.g. Liquidation |
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 additional information to explain the latest status of the organisation. e.g. Risky investment |
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 Task mini dimension |
Member | TASK_MINI_DIMENSION_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |