| Insurance Data Model |
Description | A value or qualifier that is a member of a category of data.For example, the Codes 'Single', 'Married' and 'Divorced' are all values or qualifiers of the category (or Code scheme) 'Marital Status'. Similarly, 'Phone', 'Mail', 'Email' and 'Fax' are Codes of the Code scheme 'Communication medium'.'French', 'English', 'Dutch' are Codes of the Code scheme 'Language'. The purpose of the Code entity is to provide a means by which the insurance company may categorise information in the warehouse.Each Code is identified by a combination of a Code scheme and a Code Value. Each scheme is itself also stored in the Code Table (since Code schemes are themselves Codes).Each attribute with a domain of type 'Code identifier' refers to the Code id attribute of the Code entity. The relationship between an attribute and the Code entity is not defined in the model to avoid heaviness. It is assumed that each attribute with a 'Code identifier' domain refers to the Code entity.The code scheme of a CODE is identified by the foreign key Code scheme id. Code scheme is a Code that classifies an instance of Code, such as 'Marital status', 'Communication medium' or 'Language' into sets; the set of available values for an attribute is identified by the Code scheme associated with that attribute. A Code may also be grouped into a Code group (for example Object make are grouped by Object made). The sub-category entities of the Code entity are defined as Logical only for clarity and readiness of the graphics when they are involved in the fact entities as foreign keys. e.g. Code #001 (Scheme: 'Marital status', Code label: 'Married') e.g. Code #002 (Scheme: 'Marital status', Code label: 'Single') e.g. Code #003 (Scheme: 'Gender'', Code label: 'Male') e.g. Code #004 (Scheme: 'Gender'', Code label: 'Female') e.g. Code #011 (Scheme: 'Communication medium', Code label: 'Fax') e.g. Code #013 (Scheme: 'Payment method', Code label: 'Cash') |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Code |
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 | Any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history. |
Data Type | BIGINT |
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 word or phrase for the group of a Code in the default language of the warehouse. |
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 | Code indicating the 'meaningful' mnemonic external expression assigned to the group of a Code in the default language of the warehouse. For instance, Policy event type codes are grouped by policy event type categories, Object make are grouped by Object made. |
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 word or phrase for the code in the default language of the warehouse. |
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 maximum length of the values of a code.The code scheme 'Marital Status', for example, could have a length of '1', identifying that all martial status values are to be recorded as one character long; for example S for Single, M for Married, and so on. The maximum length allowed is the defined length of the Code value attribute of code. |
Data Type | INTEGER |
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 Code scheme of a Code. |
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 | Code indicating the 'meaningful' mnemonic external expression assigned to the scheme or a Code in the default language of the warehouse. |
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 | Code indicating the 'meaningful' mnemonic external expression assigned to each code occurrence for identification, one for each language of the warehouse environment. |
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 unique sequence number of the code value within the code scheme. |
Data Type | INTEGER |
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 textual representation of information about an occurrence of code. |
Data Type | VARCHAR(256) |
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 effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
Data Type | TIMESTAMP |
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 effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
Data Type | TIMESTAMP |
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 date and time from which an occurrence of code is no longer valid. |
Data Type | DATE |
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 | Flag indicating whether only numeric values are used for values of a code scheme. |
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 date and time from which an occurrence of code is valid. |
Data Type | DATE |
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 transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system. |
Data Type | TIMESTAMP |
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 transaction time that represents the end of the time period during which the values of this recorded data are true in the source system. |
Data Type | TIMESTAMP |
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 Code |
Member | CODE_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |