Table CODE

DescriptionA 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')

Columns
CODE_IDCODE_ID
ANCHOR_IDANCHOR_ID
CODE_GROUP_LABELCODE_GROUP_LABEL
CODE_GROUP_VALUECODE_GROUP_VALUE
CODE_LABELCODE_LABEL
CODE_LENGTHCODE_LENGTH
CODE_SCHEMECODE_SCHEME
CODE_SCHEME_VALUECODE_SCHEME_VALUE
CODE_VALUECODE_VALUE
CODE_VALUE_SEQUENCE_NUMBERCODE_VALUE_SEQUENCE_NUMBER
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
END_DATEEND_DATE
NUMERIC_CODE_FLAGNUMERIC_CODE_FLAG
START_DATESTART_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
CODE_PKCODE_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 CODE_ID
DescriptionThe unique identifier of the Code
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_GROUP_LABEL
DescriptionThe word or phrase for the group of a Code in the default language of the warehouse.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_GROUP_VALUE
DescriptionCode 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_LABEL
DescriptionThe word or phrase for the code in the default language of the warehouse.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_LENGTH
DescriptionThe 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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_SCHEME
DescriptionIdentifies the Code scheme of a Code.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_SCHEME_VALUE
DescriptionCode indicating the 'meaningful' mnemonic external expression assigned to the scheme or a Code in the default language of the warehouse.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_VALUE
DescriptionCode indicating the 'meaningful' mnemonic external expression assigned to each code occurrence for identification, one for each language of the warehouse environment.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE_VALUE_SEQUENCE_NUMBER
DescriptionThe unique sequence number of the code value within the code scheme.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionThe textual representation of information about an occurrence of code.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 END_DATE
DescriptionThe date and time from which an occurrence of code is no longer valid.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMERIC_CODE_FLAG
DescriptionFlag indicating whether only numeric values are used for values of a code scheme.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 START_DATE
DescriptionThe date and time from which an occurrence of code is valid.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CODE_PK
DescriptionThe unique identifier of the Code
MemberCODE_ID [BIGINT]

Dependency Details

 AWM - Transformation