Tables & Views

TABLE: OHF_ETS_ET_ATTRIBUTES

Comment:

ETS attributes that may be attached to versions, concepts, descriptions, or relationships.

Primary Key
PK NameColumn
OHF_ETS_ET_ATTRIBUTES_PK ATTRIBUTE_NAME
  ATTRIBUTE_VALUE
  OWNER_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_ATTRIBUTES_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_ATTRIBUTES_U1 UNIQUE ATTRIBUTE_NAME
    ATTRIBUTE_VALUE
    OWNER_ID
OHF_ETS_ET_ATTRIBUTES_N2 NONUNIQUE ATTRIBUTE_NAME
    ATTRIBUTE_VALUE
    VERSION_ID
OHF_ETS_ET_ATTRIBUTES_N1 NONUNIQUE ATTRIBUTE_NAME
    VERSION_ID

Columns
ColumnComment
ATTRIBUTE_NAME

Name of this attribute.

ATTRIBUTE_VALUE

Value of this attribute.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

OWNER_ID

ETS identifier of the owner.

VERSION_ID

ETS identifier for the version of the owner.

TABLE: OHF_ETS_ET_BASELANG_DESCS_V

Comment:

Used to identify the terminology concept descriptions which have the same language as the ETS base language.

Columns
ColumnComment
CONCEPT_ID

ETS identifier for the concept.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DESCRIPTION_ID

ETS identifier of the description.

ET_LANGUAGE_CODE

Language code of the terminology concept description.

EXTENDED_TYPE_CODE

A terminology defined extended metadata code. ETS does not process or alter its behavior based on extended type codes in any way; it simply provides them to applications.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

PREFERRED_FLAG

Specifies whether this is the preferred description.

RETIRED_DATE

Date when retired.

STATUS_CODE

Status of the concept description indicating whether it is active, retired or invalid.

TERM_TXT

The actual word/phrase used for the description.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_BASELANG_LDESCS_V

Comment:

Used to identify the terminology concept local descriptions which have the same language as the ETS base language.

Columns
ColumnComment
CONCEPT_ID

ETS identifier for the concept.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DEFAULT_FLAG

Flag to indicate whether the local description is the default for the concept.

ET_LANGUAGE_CODE

Language code of the terminology concept description.

LAST_UPDATED_BY

Standard who column - user who last updated this row..

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

LOCAL_DESCRIPTION_ID

ETS Identifier for the local description.

RETIRED_DATE

Retired date of this local description.

STATUS_CODE

Status of the local description.

TERM_TXT

The actual word or phrase used for the local description.

USAGE_CONTEXT_ID

ETS identifier for the Usage Context associated with this local description.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_CLSSFCTN_DCLRNS

Comment:

Stores the contents of a classification. Concepts can be acted upon in different manners in a classification.

Primary Key
PK NameColumn
OHF_ETS_ET_CLSSFCTN_DCLRNS_PK BUILD_NUM
  CLASSIFICATION_ID
  CONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CLSSFCTN_DCLRNS_FK1

CLASSIFICATION_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_CLSSFCTN_DCLRNS_FK2

CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_CLSSFCTN_DCLRNS_U1 UNIQUE BUILD_NUM
    CLASSIFICATION_ID
    CONCEPT_ID

Columns
ColumnComment
BUILD_NUM

Integer value used by the builder program to compute the contents of the classification.

CLASSIFICATION_ID

ETS identifier for the classification.

CONCEPT_ID

ETS identifier for the concept associated with the classification.

CREATED_BY

Standard who column - user who created this row..

CREATION_DATE

Standard who column - date when this row was created.

INSERT_OPTION_CODE

A code to specify the manner in which the concept is being acted upon in the classification. E.g. CONCEPT, DIRECT_CHILDREN_ONLY, ALL_DESCENDANT etc.

LAST_UPDATED_BY

Standard who column - user who last updated this row..

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row..

TABLE: OHF_ETS_ET_CLSSFCTN_MAPPINGS

Comment:

The pre-computed contents of a classification. All concepts associated with the same clique-id are in a classification.

Primary Key
PK NameColumn
OHF_ETS_ET_CLSSFCTN_MAP_PK BUILD_NUM
  CLASSIFICATION_ID
  CLIQUE_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CLSSFCTN_MAP_FK1

CLASSIFICATION_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_CLSSFCTN_MAPNGS_U1 UNIQUE BUILD_NUM
    CLASSIFICATION_ID
    CLIQUE_ID

Columns
ColumnComment
BUILD_NUM

Integer value used by the builder program to compute the contents of the classification.

CLASSIFICATION_ID

ETS identifier for the classification.

CLIQUE_ID

The CLIQUE_ID of the concept associated with the classification.

CREATED_BY

Standard who column - user who created this row..

CREATION_DATE

Standard who column - date when this row was created.

EQUIVALENCE_TYPE_CODE

A code to indicate whether a concept is in the classification through semantic (S) or mapping (M) equivalence.

LAST_UPDATED_BY

Standard who column - user who last updated this row..

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row..

TABLE: OHF_ETS_ET_CNCPTLIST_ASSGNS

Comment:

The concepts assigned to a concept list.

Primary Key
PK NameColumn
OHF_ETS_ET_CNCPTLIST_ASSGNS_PK CONCEPT_ID
  CONCEPTLIST_ID
  CONCEPT_ACTIVATION_DATE

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CNCPTLIST_ASSG_FK1

CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_CNCPTLIST_ASSG_FK2

CONCEPTLIST_ID

OHF_ETS_ET_CONCEPTLISTS

CONCEPTLIST_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_CNCPTLIST_ASSGNS_U1 UNIQUE CONCEPTLIST_ID
    CONCEPT_ACTIVATION_DATE
    CONCEPT_ID
    CONCEPT_RETIRED_DATE
    MEMBERSHIP_CODE
OHF_ETS_ET_CNCPTLIST_ASSGNS_N2 NONUNIQUE CONCEPTLIST_ID
    CONCEPT_ACTIVATION_DATE
    CONCEPT_ID
    CONCEPT_RETIRED_DATE
    CORE_SET_FLAG
OHF_ETS_ET_CNCPTLIST_ASSGNS_N1 NONUNIQUE CONCEPTLIST_ID
    CONCEPT_ACTIVATION_DATE
    CONCEPT_ID
    CONCEPT_RETIRED_DATE

Columns
ColumnComment
CONCEPTLIST_ID

ID of the concept list with which the concept is being associated.

CONCEPT_ACTIVATION_DATE

The date when the concept becomes active.

CONCEPT_ID

ETS ID of a concept with membership in the concept list.

CONCEPT_RETIRED_DATE

The date when the concept retires from its concept list.

CORE_SET_FLAG

This flag indicates whether or not the concept is a core member of the concept list.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DEFAULT_FLAG

True for 0 or 1 members of a concept list, designates a default choice within the concept list. Allowed values are Y or N.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

LOCALLY_PREFERRED_DESC

The locally preferred description for the concept.

LOCALLY_PREFERRED_DESC_ID

This column is for future use.

LONG_NAME

A complete or descriptive name of the lookup value.

LONG_NAME_DESC_ID

This column is for future use.

MEMBERSHIP_CODE

A code for a concept that is unique among active or pending members of the concept list.

PRINT_NAME

A name for printing purposes such as for documentation.

PRINT_NAME_DESC_ID

This column is for future use.

SHORT_NAME

A shortened or abbreviated version of the lookup value name.

SHORT_NAME_DESC_ID

This column is for future use.

SYSTEM_FLAG

This flag indicates whether or not the concept was seeded by the system or created by the user.

TERMINOLOGY_PREFERRED_DESC

The terminology preferred description for the concept.

TERMINOLOGY_PREFERRED_DESC_ID

This column is for future use.

TABLE: OHF_ETS_ET_CNCPTLIST_VLDT_V

Comment:

Used to validate a concept or any of its equivalent concepts in a concept list.

Columns
ColumnComment
CODINGSCHEME_NAME

Name of the coding scheme associated with the concept.

CONCEPTLIST_ID

ETS Identifier for the concept list

CONCEPTLIST_NAME

Name of the concept list (or HL7 Vocabulary Domain Name)

CONCEPT_CODE

Source specified code for this concept.

CONCEPT_ID

ETS identifier for the concept.

EQUIVALENT_CODINGSCHEME_NAME

Name of the coding scheme associated with the equivalent concept.

EQUIVALENT_CONCEPT_CODE

Source specified code for the equivalent concept.

EQUIVALENT_CONCEPT_ID

ETS identifier for the equivalent concept.

EQUIVALENT_VERSION_ID

ETS identifier of the coding scheme version associated with the equivalent concept.

EQUIVALENT_VERSION_NAME

Name of the coding scheme version associated with the equivalent concept.

EQUIV_VERSION_DEFAULT_FLAG

Indicates whether the version is the default version within its coding scheme of the equivalent concept.

GROUP_NAME

The name of the domain to which the concept list belongs.

VERSION_DEFAULT_FLAG

A flag designating the version as the default within its coding scheme.

VERSION_ID

ETS identifier of the coding scheme version associated with the concept.

VERSION_NAME

Name of the coding scheme version associated with the concept.

TABLE: OHF_ETS_ET_CNCPTLST_MEMBRS_V

Comment:

Used to identify members and their descriptions in a given concept list.

Columns
ColumnComment
CONCEPTLIST_DESC

Description of the concept list.

CONCEPTLIST_NAME

Name of the concept list (or HL7 Vocabulary Domain Name)

CONCEPT_ACTIVATION_DATE

The date when the concept becomes active.

CONCEPT_ID

ETS ID of a concept with membership in the concept list.

CONCEPT_RETIREMENT_DATE

The date when the concept retires from its concept list.

GROUP_NAME

The GROUP_NAME is the domain to which the concept list belongs. For example, group names could represent user-defined, temporary and system.

MEMBERSHIP_CODE

A code for a concept that is unique among active or pending members of the concept list.

PREFERRED_DESCRIPTION

Preferred description of the concept in the concept list.

TERMINOLOGY_DESC

Terminology description of the concept in the concept list.

TABLE: OHF_ETS_ET_CODINGSCHEME_V

Comment:

The view OHE_ETS_ET_CODINGSCHEME_V stores information about coding schemes that are loaded into ETS such as SNOMED, HL7 and ICD-9.

Columns
ColumnComment
CODINGSCHEME_DESC

Coding scheme description.

CODINGSCHEME_ID

ETS identifier for the coding scheme

CODINGSCHEME_NAME

Name of the coding scheme as specified by a standard list such as HL7, LN for LOINC.

CODINGSCHEME_OID

HL7 specified ISO OID for this coding scheme

DEFAULT_FLAG

A flag designating the version as the default within its coding scheme. Only one version may be designated as default for a coding scheme, and that version must have a status of active or retired.

STATUS_CODE

The status of the version. Allowed values are Quarantined (Q), Active (A), Retired (R), or Invalid (X).

VERSION_ID

ETS identifier for the source version of the concept, description or relationship

VERSION_NAME

Version name for this source

TABLE: OHF_ETS_ET_CODING_SCHEMES

Comment:

Stores information about all the coding schemes.

Primary Key
PK NameColumn
OHF_ETS_ET_CODING_SCHEMES_PK CODINGSCHEME_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CODING_SCHEMES_FK1

MODEL_NAME

OHF_ETS_ET_MODELS

MODEL_NAME

Indexes
IndexTypeColumn
OHF_ETS_ET_CODING_SCHEMES_U2 UNIQUE CODINGSCHEME_OID
OHF_ETS_ET_CODING_SCHEMES_U1 UNIQUE CODINGSCHEME_ID
OHF_ETS_ET_CODING_SCHEMES_N1 NONUNIQUE CODINGSCHEME_NAME

Columns
ColumnComment
CODINGSCHEME_DESC

Coding scheme description.

CODINGSCHEME_ID

ETS identifier for the coding scheme

CODINGSCHEME_NAME

Name of the coding scheme as specified by a standard list such as HL7, LN for LOINC.

CODINGSCHEME_OID

HL7 specified ISO OID for this coding scheme

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

EDITABLE_FLAG

Denotes whether the coding scheme is editable or not.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MODEL_NAME

Model name of the coding scheme.

TABLE: OHF_ETS_ET_CONCEPTLISTS

Comment:

An unordered non-redundant set of ETS concepts.

Primary Key
PK NameColumn
OHF_ETS_ET_CONCEPTLISTS_PK CONCEPTLIST_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CONCEPTLISTS_FK1

USAGE_CONTEXT_ID

OHF_ETS_ET_USAGE_CONTEXTS

USAGE_CONTEXT_ID

OHF_ETS_ET_CONCEPTLISTS_FK2

PARENT_ID

OHF_ETS_ET_CONCEPTLISTS

CONCEPTLIST_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_CONCEPTLISTS_U1 UNIQUE CONCEPTLIST_ID
OHF_ETS_ET_CONCEPTLISTS_N2 NONUNIQUE CONCEPTLIST_NAME
    GROUP_NAME
    PARENT_ID
OHF_ETS_ET_CONCEPTLISTS_N1 NONUNIQUE CONCEPTLIST_NAME
    GROUP_NAME

Columns
ColumnComment
CONCEPTLIST_DESC

Concept list description.

CONCEPTLIST_ID

ETS Identifier for this concept list

CONCEPTLIST_NAME

Name of the concept list (or HL7 Vocabulary Domain Name)

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

EXTENSIBILITY_CODE

This indicates at which level a lookup type is defined and therefore which access restrictions apply to that particular lookup type.

GROUP_NAME

The GROUP_NAME is the domain to which the concept list belongs. For example, group names could represent user-defined, temporary and system.

INHERITANCE_ADD_FLAG

This Flag indicates whether the child concept list inherits all additions to its parent concept list.

INHERITANCE_SUB_FLAG

This flag indicates whether the child concept list inherits deletions to its parent concept list.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

PARENT_ID

This identifies the id of the parent concept list.

RESTRICTED_FLAG

The RESTRICTED flag is a boolean that indicates whether the concept list contains concepts that belong to its parent concept list. If RESTRICTED is true, then the child concept list contains only concepts that actively belong to its parent concept l ist.

STATUS_FLAG

This flag identifies the status of the concept list.

USAGE_CONTEXT_ID

This identifies the id of the usage context. The USAGE_CONTEXT links this concept list as a specialization of its parent concept. The usage context would represent the specialization linking the parent and child concept lists.

TABLE: OHF_ETS_ET_CONCEPTLISTS_V

Comment:

This view represents information about concept lists and its descriptions.

Columns
ColumnComment
CONCEPTLIST_DESC

Description of the concept list.

CONCEPTLIST_ID

ETS Identifier for the concept list

CONCEPTLIST_NAME

Name of the concept list (or HL7 Vocabulary Domain Name)

EXTENSIBILITY_CODE

This indicates at which level a lookup type is defined and therefore which access restrictions apply to that particular lookup type.

GROUP_NAME

The GROUP_NAME is the domain to which the concept list belongs. For example, group names could represent user-defined, temporary and system.

INHERITANCE_ADD_FLAG

This Flag indicates whether the child concept list inherits all additions to its parent concept list.

INHERITANCE_SUB_FLAG

This flag indicates whether the child concept list inherits all deletions to its parent concept list.

PARENT_ID

This identifies the id of the parent concept list.

RESTRICTED_FLAG

The RESTRICTED flag is a boolean that indicates whether the concept list contains concepts that belong to its parent concept list. If RESTRICTED is true, then the child concept list contains only concepts that actively belong to its parent concept l ist.

STATUS_FLAG

This flag identifies the status of the concept list.

USAGE_CONTEXT_ID

This identifies the id of the usage context. The USAGE_CONTEXT links this concept list as a specialization of its parent concept. The usage context would represent the specialization linking the parent and child concept lists.

TABLE: OHF_ETS_ET_CONCEPTS

Comment:

Stores information about ETS Concepts (units of thought represented by codes and strings).

Primary Key
PK NameColumn
OHF_ETS_ET_CONCEPTS_PK CONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CONCEPTS_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

OHF_ETS_ET_CONCEPTS_FK2

REASSIGNED_TO_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_CONCEPTS_FK3

CLIQUE_ID

OHF_ETS_ET_EQVLNC_CLIQUES

CLIQUE_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_CONCEPTS_U2 UNIQUE CONCEPT_CODE
    VERSION_ID
OHF_ETS_ET_CONCEPTS_U1 UNIQUE CONCEPT_ID
OHF_ETS_ET_CONCEPTS_N7 NONUNIQUE CLIQUE_ID
    CONCEPT_ID
OHF_ETS_ET_CONCEPTS_N6 NONUNIQUE REASSIGNED_TO_ID
OHF_ETS_ET_CONCEPTS_N5 NONUNIQUE EXTENDED_TYPE_CODE
    VERSION_ID
OHF_ETS_ET_CONCEPTS_N4 NONUNIQUE STATUS_CODE
    VERSION_ID
OHF_ETS_ET_CONCEPTS_N3 NONUNIQUE RELATIONSHIP_TYPE_FLAG
    VERSION_ID
OHF_ETS_ET_CONCEPTS_N1 NONUNIQUE CLIQUE_ID
    CONCEPT_ID

Columns
ColumnComment
BUILD_NUM

Integer value used by the builder program to compute the contents of the classification.

CLASSIFICATION_STATUS_CODE

Status of the classification indicating whether it is definition, pending, active, dirty or retired.

CLIQUE_ID

The CLIQUE_ID of the concept.

CONCEPT_CODE

Source specified code for this concept. Usually something like 114.20 in ICD-9-CM or 2458006 in SNOMED-RT. In the absence of such codes, this might be the preferred description itself.

CONCEPT_ID

ETS Identifier of the concept

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DOMAIN_TXT

The domain with which the classification is associated.

EXTENDED_TYPE_CODE

A terminology defined extended metadata code. ETS does not process or alter its behavior based on extended type codes in any way; it simply provides them to applications.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

REASSIGNED_TO_ID

The ETS identifier to which it has been reassigned.

RELATIONSHIP_TYPE_FLAG

True for concepts that are Relationship Types. The data length of the column is updated to 30 to represent classification relationships as well.

RETIRED_DATE

Retired date of the concept.

STATUS_CODE

Status of the concept indicating whether it is active, retired or invalid.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_CONCEPTS_V

Comment:

This view represents collective information about concepts and their associated coding scheme and version.

Columns
ColumnComment
CODINGSCHEME_NAME

Name of the coding scheme associated with the concept.

CODINGSCHEME_OID

HL7 specified ISO OID for the coding scheme associated with the concept.

CONCEPT_CODE

Source specified code for this concept.

CONCEPT_ID

ETS identifier for the concept.

CONCEPT_STATUS_CODE

Status of the concept indicating whether it is active, retired or invalid.

VERSION_DEFAULT_FLAG

A flag designating the version as the default within its coding scheme.

VERSION_ID

ETS identifier of the coding scheme version associated with the concept.

VERSION_NAME

Name of the coding scheme version associated with the concept.

VERSION_STATUS_CODE

The status of the coding scheme version associated with the concept.

TABLE: OHF_ETS_ET_DESCRIPTIONS

Comment:

Human-readable strings representation of a concept.

Primary Key
PK NameColumn
OHF_ETS_ET_DESCRIPTIONS_PK DESCRIPTION_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_DESCRIPTIONS_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

OHF_ETS_ET_DESCRIPTIONS_FK2

CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_DESCRIPTIONS_FK3

VERSION_ID,ET_LANGUAGE_CODE

OHF_ETS_ET_LANG_TER_MAPPINGS

VERSION_ID,ET_LANGUAGE_CODE

Indexes
IndexTypeColumn
OHF_ETS_ET_DESCS_U1 UNIQUE DESCRIPTION_ID
OHF_ETS_ET_DESCS_N4 NONUNIQUE CONCEPT_ID
    EXTENDED_TYPE_CODE
OHF_ETS_ET_DESCS_N3 NONUNIQUE CONCEPT_ID
    STATUS_CODE
OHF_ETS_ET_DESCS_N2 NONUNIQUE CONCEPT_ID
    PREFERRED_FLAG
OHF_ETS_ET_DESCS_N1 NONUNIQUE CONCEPT_ID
    VERSION_ID
OHF_ETS_ET_DESCS_I1 NONUNIQUE TERM_TXT

Columns
ColumnComment
CONCEPT_ID

ETS identifier for the concept.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DESCRIPTION_ID

ETS identifier of the description.

ET_LANGUAGE_CODE

Language code of the terminology concept description.

EXTENDED_TYPE_CODE

A terminology defined extended metadata code. ETS does not process or alter its behavior based on extended type codes in any way; it simply provides them to applications.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

PREFERRED_FLAG

Specifies whether this is the preferred description

RETIRED_DATE

Date when retired

STATUS_CODE

Status of the concept description indicating whether it is active, retired or invalid.

TERM_TXT

The actual word/phrase used for the description.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_DESCRIPTIONS_V

Comment:

This view represents information about concepts and their descriptions.

Columns
ColumnComment
CONCEPT_ID

ETS identifier for the concept.

DESCRIPTION_ID

ETS identifier of the Description

LOCAL_PREFERRED_FLAG

Specifies whether this is the local preferred description.

STATUS_CODE

Status of the concept indicating whether it is active, retired or invalid.

TERMINOLOGY_PREFERRED_FLAG

Specifies whether this is the preferred description.

TERM_TXT

The actual word/phrase used for the description.

TABLE: OHF_ETS_ET_EQVLNC_CLIQTRANS

Comment:

Stores the log of the concept linking provided by the vendor.

Primary Key
PK NameColumn
OHF_ETS_ET_EQVLNC_CLIQTRANS_PK CLIQTRANS_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_EQVLNC_CLIQ_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_EQVLNC_CLIQTRANS_U1 UNIQUE CLIQTRANS_ID
OHF_ETS_ET_EQVLNC_CLIQTRANS_N1 NONUNIQUE LINK_TYPE_CODE
    SOURCE_CONCEPT_ID
    TARGET_CONCEPT_ID
    VERSION_ID

Columns
ColumnComment
CLIQTRANS_ID

Unique identifier for the concept link.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

LINK_TYPE_CODE

Code to indicate a linking type for concepts.

SOURCE_CONCEPT_ID

The clique id of the source concept.

TARGET_CONCEPT_ID

The clique id of the target concept.

VERSION_ID

ETS version identifier.

TABLE: OHF_ETS_ET_EQVLNC_CLIQUELNKS

Comment:

Concept equivalence service between the existing clique groups.

Primary Key
PK NameColumn
OHF_ETS_ET_EQVLNC_CLIQLNKS_PK EQUIVALENCE_TYPE_CODE
  SOURCE_CLIQUE_ID
  TARGET_CLIQUE_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_EQVLNC_CLIQLNKS_FK1

SOURCE_CLIQUE_ID

OHF_ETS_ET_EQVLNC_CLIQUES

CLIQUE_ID

OHF_ETS_ET_EQVLNC_CLIQLNKS_FK2

TARGET_CLIQUE_ID

OHF_ETS_ET_EQVLNC_CLIQUES

CLIQUE_ID

OHF_ETS_ET_EQVLNC_CLIQLNKS_FK3

DELETED_VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

OHF_ETS_ET_EQVLNC_CLIQLNKS_FK4

CREATED_VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_EQVLNC_CLIQLNKS_U1 UNIQUE EQUIVALENCE_TYPE_CODE
    SOURCE_CLIQUE_ID
    TARGET_CLIQUE_ID
OHF_ETS_ET_EQVLNC_CLIQLNKS_N1 NONUNIQUE CREATED_VERSION_ID
    DELETED_VERSION_ID
    EQUIVALENCE_TYPE_CODE
    SOURCE_CLIQUE_ID
    TARGET_CLIQUE_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATED_VERSION_ID

The ETS version identifier of the version that declared this link invalid.

CREATION_DATE

Standard who column - date when this row was created.

DELETED_VERSION_ID

The ETS version identifier of the version that created this link.

EQUIVALENCE_TYPE_CODE

The type of equivalence.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

SOURCE_CLIQUE_ID

The clique id of the source clique.

TARGET_CLIQUE_ID

The clique id of the target clique.

TABLE: OHF_ETS_ET_EQVLNC_CLIQUES

Comment:

Grouping of semantically equivalent concepts.

Primary Key
PK NameColumn
OHF_ETS_ET_EQVLNC_CLIQUES_PK CLIQUE_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_EQVLNC_CLIQUES_U1 UNIQUE CLIQUE_ID

Columns
ColumnComment
CLIQUE_ID

ETS Identifier of the clique.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

TABLE: OHF_ETS_ET_EQVLNC_CRSMAPLNKS

Comment:

Cross maps between cliques in different Coding Schemes.

Primary Key
PK NameColumn
OHF_ETS_ET_EQVLNC_CRSMAPLNK_PK EQUIVALENCE_CONTEXT
  MAP_SET_ID
  SOURCE_CLIQUE_ID
  TARGET_CLIQUE_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_EQVLNC_CRSMAP_FK1

SOURCE_CLIQUE_ID

OHF_ETS_ET_EQVLNC_CLIQUES

CLIQUE_ID

OHF_ETS_ET_EQVLNC_CRSMAP_FK2

TARGET_CLIQUE_ID

OHF_ETS_ET_EQVLNC_CLIQUES

CLIQUE_ID

OHF_ETS_ET_EQVLNC_CRSMAP_FK3

MAP_SET_ID

OHF_ETS_ET_MAP_MAP_SETS

MAP_SET_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_EQVLNC_CRSMAPLNK_U1 UNIQUE EQUIVALENCE_CONTEXT
    MAP_SET_ID
    SOURCE_CLIQUE_ID
    TARGET_CLIQUE_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

EQUIVALENCE_CONTEXT

The equivalence context of the equivalence link.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MAP_SET_ID

The map set id of the cross map equivalence.

SOURCE_CLIQUE_ID

The clique id of the source clique.

TARGET_CLIQUE_ID

The clique id of the target clique.

TABLE: OHF_ETS_ET_EQVLNC_MAP_CONS_V

Comment:

This view represents information about concepts and their equivalent concepts.

Columns
ColumnComment
CODINGSCHEME_NAME

Name of the coding scheme associated with the concept.

CONCEPT_CODE

Source specified code for this concept.

CONCEPT_ID

ETS identifier for the concept.

EQUIVALENT_CODINGSCHEME_NAME

Name of the coding scheme associated with the equivalent concept.

EQUIVALENT_CONCEPT_CODE

Source specified code for the equivalent concept.

EQUIVALENT_CONCEPT_ID

ETS identifier for the equivalent concept.

EQUIVALENT_VERSION_ID

ETS identifier of the coding scheme version associated with the equivalent concept.

EQUIVALENT_VERSION_NAME

Name of the coding scheme version associated with the equivalent concept.

EQUIV_VERSION_DEFAULT_FLAG

Indicates whether the version is the default version within its coding scheme of the equivalent concept.

VERSION_DEFAULT_FLAG

Indicates whether the version is the default version within its coding scheme.

VERSION_ID

ETS identifier of the coding scheme version associated with the concept.

VERSION_NAME

Name of the coding scheme version associated with the concept.

TABLE: OHF_ETS_ET_FDB_CLSSFCTNS

Comment:

Peer table to OHF_ETS_ET_CONCEPTS to store additional FDB classification attributes.

Primary Key
PK NameColumn
OHF_ETS_ET_FDB_CLSSFCTNS_PK ETSCONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_FDB_CLSSFCTNS_FK1

ETSCONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_FDB_CLSSFCTNS_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_FDB_CLSSFCTNS_U1 UNIQUE ETSCONCEPT_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

ETC_DRUG_CONCEPT_LINK_IND

Indicates that at least one GCNSEQNO is associated.

ETC_FORMULARY_LEVEL_IND

Indicates whether it is a suggested level for building formularies.

ETC_HIERARCHY_LEVEL

Level of the Classification in the hierarchy.

ETC_PRESENTATION_SEQNO

Sort order for presentation of siblings.

ETC_SORT_NUMBER

Recommended order for presentation (regardless of parents); may change from version to version.

ETC_ULTIMATE_CHILD_IND

Indicator to denote if this is the ultimate child.

ETSCONCEPT_ID

ETS identifier for the FDB classification.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

VERSION_ID

ETS identifier for the version associated with the FDB classification.

TABLE: OHF_ETS_ET_FDB_MEDNAME_ATTRS

Comment:

Peer table to OHF_ETS_ET_CONCEPTS to store additional medication name attributes.

Primary Key
PK NameColumn
OHF_ETS_ET_FDB_MEDNAME_ATT_PK ETSCONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_FDB_MEDNAME_ATT_FK1

ETSCONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_FDB_MEDNAME_ATT_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_FDB_MEDNAME_ATTR_U1 UNIQUE ETSCONCEPT_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

ETSCONCEPT_ID

ETS identifier for the medication name.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MED_NAME_TYPE_CODE

Code for the type of medication name.

MED_STATUS_CODE

Status code of the medication name indicating whether it is live, replaced or retired.

VERSION_ID

ETS identifier for the version associated with the medication name.

TABLE: OHF_ETS_ET_FDB_MED_CONCEPTS

Comment:

Peer table to OHF_ETS_ET_CONCEPTS to store additional medication concept attributes.

Primary Key
PK NameColumn
OHF_ETS_ET_FDB_MED_CONCEPTS_PK ETSCONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_FDB_MED_CON_FK1

ETSCONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_FDB_MED_CON_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_FDB_MED_CONCEPTS_U1 UNIQUE ETSCONCEPT_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

ETSCONCEPT_ID

ETS identifier for the medication concept.

GCN_SEQNO_TXT

Generic Code Number Sequence Number (GCN_SEQNO) is used to identify unique combinations of ingredient, strength, dose form and route.

GENERIC_MED_ID

Generic medication Identifier.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MED_GCNSEQNO_ASSIGN_CODE

Medication GCN_SEQNO assignment code.

MED_REF_DEA_CODE

Medication Reference Federal DEA Class code.

MED_REF_FED_LEGEND_IND

Medication Reference Federal Legend indicator.

MED_REF_GEN_DRUG_NAME_CODE

Medication Reference Generic Medication Name Code. Used to distinguish drugs (=1) from non-drugs (=0).

MED_STATUS_CODE

Status code of the medication concept indicating whether it is live, replaced or retired.

MED_STRENGTH_TXT

Text to represent the strength of the medication.

MED_STRENGTH_UON_TXT

Text to represent the unit of measurement of the medication strength.

VERSION_ID

ETS identifier for the version associated with the medication concept.

TABLE: OHF_ETS_ET_FDB_NDC_CONCEPTS

Comment:

Peer table to HCT_ET_CONCEPTS to store additional NDC concept attributes.

Primary Key
PK NameColumn
OHF_ETS_ET_FDB_NDC_CONCEPTS_PK ETSCONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_FDB_NDC_CON_FK1

ETSCONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_FDB_NDC_CON_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_FDB_NDC_CONCEPTS_U1 UNIQUE ETSCONCEPT_ID

Columns
ColumnComment
ADD_DATE

The date on which a drug record was added to the FDB NDC file.

BN_TXT

Text to indicate the brand name.

CL_CODE

Text to indicate the drug class code.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DEA_CODE

Text to indicate the DEA code.

ETSCONCEPT_ID

ETS identifier for the NDC concept.

GCN_SEQNO_NUM

Generic Code Number Sequence Number.

GCN_SEQNO_TC_NUM

The Standard Therapeutic Class Code of the GCNSEQNO associated with the NDC.

GNI_IND

Generic Named Drug Indicator.

HCPC_CODE

Text to indicate the HCFA Common Procedure Code.

HICL_SEQNO_NUM

Hierarchical Ingredient Code List Sequence Number.

HOSP_IND

Hospital Selection Indicator

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

NDCFI_IND

NDC Format Indicator.

PNDC_TXT

Text to indicate the previous national drug code (NDC).

REPNDC_TXT

Text to indicate the replacement national drug code (NDC).

SKEY_NUM

Text to indicate the smart key number.

VERSION_ID

ETS identifier for the version associated with the NDC concept

TABLE: OHF_ETS_ET_HL7_EXTERNAL_MAP

Comment:

Maps HL7 value sets to concepts in external (non-HL7) terminologies.

Primary Key
PK NameColumn
OHF_ETS_ET_HL7_EXTERNAL_MAP_PK TARGET_CONCEPT_ID
  VALUE_SET_CONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_HL7_EXT_MAP_FK1

VALUE_SET_CONCEPT_ID

OHF_ETS_ET_HL7_EXT_VALUE_SETS

VALUE_SET_CONCEPT_ID

OHF_ETS_ET_HL7_EXT_MAP_FK2

TARGET_CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_HL7_EXTERNAL_MAP_U1 UNIQUE TARGET_CONCEPT_ID
    VALUE_SET_CONCEPT_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

TARGET_CONCEPT_ID

Identifier for a non-HL7 ETS concept to be associated with the HL7 value set.

VALUE_SET_CONCEPT_ID

Unique identifier for the HL7 value set.

TABLE: OHF_ETS_ET_HL7_EXT_VALUE_SETS

Comment:

Associates HL7 external value sets with non-HL7 CodingSchemeVersions.

Primary Key
PK NameColumn
OHF_ETS_ET_HL7_EXT_VAL_SET_PK VALUE_SET_CONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_HL7_EXT_VAL_SET_FK1

VALUE_SET_CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_HL7_EXT_VAL_SET_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_HL7_EXT_VALSETS_U1 UNIQUE VALUE_SET_CONCEPT_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MAPPED_FLAG

Indicates that this HL7 external value set is mapped to individual concepts within the target version, instead of mapping to the entire target version. Y/N.

VALUE_SET_CONCEPT_ID

Unique identifier for the HL7 (external) value set concept.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_LANG_TER_MAPPINGS

Comment:

Maintains a mapping of the ISO language code,ISO territory code and the language code of the terminology concept description for a given coding scheme.

Primary Key
PK NameColumn
OHF_ETS_ET_LANG_TER_MAPPING_PK ISO_LANGUAGE
  ISO_TERRITORY
  STATUS
  VERSION_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_LANG_TER_MAPPINGS_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_LANG_TER_MAPNGS_U1 UNIQUE ISO_LANGUAGE
    ISO_TERRITORY
    STATUS
    VERSION_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

ET_LANGUAGE_CODE

Language code of the terminology concept description.

ISO_LANGUAGE

ISO Language Code that is mapped to the language of the terminology concept description. XX denotes all ISO_LANGUAGE other than specified explicitly.

ISO_TERRITORY

ISO territory Code which is mapped to the language of the terminology concept description. XX denotes all ISO_ TERRITORY other than specified explicitly

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

STATUS

Status of the mapping. Y/N

VERSION_ID

ETS identifier for the coding scheme version.

TABLE: OHF_ETS_ET_LOCAL_DESCS

Comment:

User defined descriptions of concepts.

Primary Key
PK NameColumn
OHF_ETS_ET_LOCAL_DESCS_PK LOCAL_DESCRIPTION_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_LOCAL_DESCS_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

OHF_ETS_ET_LOCAL_DESCS_FK2

USAGE_CONTEXT_ID

OHF_ETS_ET_USAGE_CONTEXTS

USAGE_CONTEXT_ID

OHF_ETS_ET_LOCAL_DESCS_FK3

CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_LOCAL_DESCS_FK4

VERSION_ID,ET_LANGUAGE_CODE

OHF_ETS_ET_LANG_TER_MAPPINGS

VERSION_ID,ET_LANGUAGE_CODE

Indexes
IndexTypeColumn
OHF_ETS_ET_LOCAL_DESCS_U1 UNIQUE LOCAL_DESCRIPTION_ID
OHF_ETS_ET_LOCAL_DESCS_N4 NONUNIQUE CONCEPT_ID
    STATUS_CODE
OHF_ETS_ET_LOCAL_DESCS_N3 NONUNIQUE USAGE_CONTEXT_ID
OHF_ETS_ET_LOCAL_DESCS_N2 NONUNIQUE CONCEPT_ID
    VERSION_ID
OHF_ETS_ET_LOCAL_DESCS_N1 NONUNIQUE CONCEPT_ID
    DEFAULT_FLAG
OHF_ETS_ET_LOCAL_DESCS_I1 NONUNIQUE TERM_TXT

Columns
ColumnComment
CONCEPT_ID

ETS identifier for the concept.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DEFAULT_FLAG

Flag to indicate whether the local description is the default for the concept.

ET_LANGUAGE_CODE

Language code of the terminology concept description.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

LOCAL_DESCRIPTION_ID

ETS Identifier for the local description.

RETIRED_DATE

Retired date of this local description.

STATUS_CODE

Status of the local description.

TERM_TXT

The actual word or phrase used for the local description.

USAGE_CONTEXT_ID

ETS identifier for the Usage Context associated with this local description.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_LOINC_CONCEPTS

Comment:

Peer table to OHF_ETS_ET_CONCEPTS to support additional Loinc concept attributes.

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_LOINC_CONCEPTS_FK1

ETSCONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_LOINC_CONCEPTS_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_LOINC_CONCEPTS_N9 NONUNIQUE LOINC_SYSTEM_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N8 NONUNIQUE LOINC_TIME_ASPECT_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N7 NONUNIQUE LOINC_SCALE_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N6 NONUNIQUE LOINC_PROPERTY_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N5 NONUNIQUE LOINC_METHOD_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N4 NONUNIQUE LOINC_COMPONENT_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N3 NONUNIQUE LOINC_CLASS_TYPE_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N2 NONUNIQUE LOINC_CLASS_CODE
OHF_ETS_ET_LOINC_CONCEPTS_N1 NONUNIQUE ETSCONCEPT_ID
    ROW_TYPE_CODE

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

ETSCONCEPT_ID

ETS identifier for the LOINC concept.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

LOINC_ACSSYN_TXT

Chemical name synonyms, alternative name synonyms, and chemical formulae supplied by the Chemical Abstract Society.

LOINC_ANSWERLIST_TXT

The list of answers for results those are reportable from a multiple-choice list.

LOINC_ASTM_CODE

The ASTM codes apply to only a few of the tests such as cell count, antibiotic sensitivities.

LOINC_BASE_NAME_TXT

Chemical base name from CAS.

LOINC_CDC_CODE

Code from CDC Complexity file that maps laboratory tests to the instruments used to perform them.

LOINC_CHNG_REAS_TXT

Reason term was changed.

LOINC_CHNG_TYPE_TXT

Change Type Code such as DEL, ADD, NAM, MAJ, MIN.

LOINC_CLASS_CODE

An arbitrary classification of the terms for grouping related observations together.

LOINC_CLASS_TYPE_CODE

Categorization of LOINC_CLASS_CODE: 1=Laboratory class; 2=Clinical class; 3=Claims attachments;4=Surveys.

LOINC_CODE_TABLE_TXT

Examples on CR0050 Cancer Registry.

LOINC_COMMENTS_TXT

Free-text comments relating to the test result.

LOINC_COMPONENT_CODE

The LOINC component name.

LOINC_CSCQ_FRNCH_NM_TXT

French name for LOINC term.

LOINC_CSCQ_GRMN_NM_TXT

German name for LOINC term.

LOINC_CSGQ_ITLN_NM_TXT

Italian name for LOINC term.

LOINC_DEEDS_CODE

Data elements for Emergency Department Systems Codes (CDC). This field contains the DEEDS code value which maps to the LOINC code in question.

LOINC_DT_LAST_CH_TXT

Date last changed, in the format YYYYMMDD.

LOINC_EUCLIDE_CODE

The Euclides code identifies the analyte (the first subpart of the first part of the name.

LOINC_EXACT_CMP_SYS_TXT

Exact core component synonym.

LOINC_EXMPL_ANSWERS_TXT

For some tests and measurements, we have supplied examples of valid answers, such as 1:64 negative @ 1:16 or 55. This differs from the ANSWERLIST field, which details possible choices for nominal scale terms.

LOINC_EX_US_UNITS_TXT

Example units used in the US. The terms have been standardized to more closely resemble HL7 version3.

LOINC_FINAL_TXT

Internal LOINC use field.

LOINC_FORMULA_TXT

Regression equation details for many OB.US calculated terms.

LOINC_GENE_ID_TXT

OMIM (Online Mendelian Inheritance in Man) names.

LOINC_GPI_CODE

GPI Code. For drugs, this field contains a map to the Medispan GPI codes, a hierarchical system of classifying pharmaceutical products.

LOINC_HCFA_CODE

HCFA code.

LOINC_IPCC_UNITS_TXT

Example units used by IUPAC/IFCC.

LOINC_IUPAC_CODE

The IUPAC code identifies the component, kind of property, and system.

LOINC_IUPC_ANLT_CODE

IUPAC analyte code. This column contains the Chemical Abstract service number or the Enzyme Nomenclature number for the chemical components for chemical and/or enzymes.

LOINC_METHOD_CODE

The LOINC method code.

LOINC_METPATH_CODE

Metpath code.

LOINC_MOLAR_MASS_TXT

Molecular weights: This field contains the molecular weights of chemical moieties when they are provided to us.

LOINC_MOLEID_TXT

Molecular structure ID, usually CAS number.

LOINC_MULTUM_CODE

Maps to Multum Inc. database of codes for drugs.

LOINC_NAACCR_ID_TXT

Maps to North American Association of Central Cancer Registries Identification Number.

LOINC_NORM_RANGE_TXT

Normal Range - Example answers from real tests.

LOINC_PANELELEMENTS_TXT

List of individual tests that comprise a panel.

LOINC_PROPERTY_CODE

The LOINC property name.

LOINC_REFERENCE_TXT

Contains references to medical literature, product announcements, or other written sources of information on the test or measurement described by the LOINC record.

LOINC_RELATEDNAMES_2_TXT

It contains synonyms for all parts of the fully specified LOINC name.

LOINC_RELAT_NMS_TXT

One or more synonyms, separated by semicolons (;).

LOINC_SCALE_CODE

The LOINC scale code.

LOINC_SCOPE_TXT

Not currently used.

LOINC_SETROOT_TXT

Currently used for claims attachments. Yes in this field signifies that this record is the root of a set of LOINC codes.

LOINC_SNOMED_CODE

SNOMED Code.

LOINC_SOURCE_TXT

Source text is for LOINC internal use.

LOINC_SPECIES_TXT

Codes detailing which non-human species the term applies to. If blank, human is assumed.

LOINC_SPNSH_NM_TXT

For future use.

LOINC_STATUS_TXT

Used to mark terms as the database evolves. Deprecated or superseded status indicated by DEL in this field otherwise blank.

LOINC_SUBMITTED_UNITS_TXT

Example units as submitted by original requester.

LOINC_SURVEY_QUEST_SRC_TXT

Exact name of the survey instrument and the item/question number.

LOINC_SURVEY_QUEST_TXT

Verbatim question from the survey instrument.

LOINC_SYSTEM_CODE

The LOINC system code.

LOINC_TIME_ASPECT_CODE

The LOINC time aspect.

LOINC_UNITS_REQUIRED_TXT

Y/N field that indicates that units are required when this LOINC is included as an OBX segment in a HIPPA attachment.

LOINC_VA_CODE

VA Code.

ROW_TYPE_CODE

A code denoting the type of row being represented. Valid values are Normal (N) or Supplemental (S). Supplemental rows are used to store synonyms for name parts which are used in LOINC search template matching.

VERSION_ID

ETS identifier for the version associated with the LOINC concept.

TABLE: OHF_ETS_ET_MAP_CROSS_MAPS

Comment:

Mapping between concepts in different Coding Schemes.

Primary Key
PK NameColumn
OHF_ETS_ET_MAP_CROSS_MAPS_PK MAP_OPTION_NUM
  MAP_SET_ID
  SOURCE_CONCEPT_ID
  TARGET_CODE

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_MAP_CROSS_MAPS_FK1

SOURCE_CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_MAP_CROSS_MAPS_FK2

MAP_SET_ID,TARGET_CODE

OHF_ETS_ET_MAP_MAP_TARGETS

MAP_SET_ID,TARGET_CODE

Indexes
IndexTypeColumn
OHF_ETS_ET_MAP_CROSS_MAPS_U1 UNIQUE MAP_OPTION_NUM
    MAP_SET_ID
    SOURCE_CONCEPT_ID
    TARGET_CODE
OHF_ETS_ET_MAP_CROSS_MAPS_N2 NONUNIQUE MAP_SET_ID
    TARGET_CODE
OHF_ETS_ET_MAP_CROSS_MAPS_N1 NONUNIQUE DEFAULT_FLAG
    MAP_SET_ID
    SOURCE_CONCEPT_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

CROSS_MAP_ADVICE_TXT

Textual advice to support manual mapping decisions between this cross map and other options for mapping the same concept.

CROSS_MAP_RULE_TXT

A machine processable expression of rules that determine whether this is an appropriate cross map.

DEFAULT_FLAG

Designates this cross map as the default mapping for the source concept.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MAP_OPTION_NUM

An integer that distinguishes between alternative mappings for a single concept. If automatic rules are used to determine which option is applicable, the options are tested in the order specified by this value, lowest Map Option first.

MAP_SET_ID

Unique SNOMED CT identifier for the Map Set.

PRIORITY_NUM

Indication of the suggested order in which to present a series of options for mapping a concept for manual assessment. The first of these is the default option for mapping the concept.

SOURCE_CONCEPT_ID

The ETS Concept ID of the source concept for this cross map.

TARGET_CODE

The code for the map target to which the source concept maps. Unique within a map set.

TABLE: OHF_ETS_ET_MAP_MAP_SETS

Comment:

A Map Set is a set of Cross Maps. Each Map Set enables mapping between two Coding Schemes.

Primary Key
PK NameColumn
OHF_ETS_ET_MAP_MAP_SETS_PK MAP_SET_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_MAP_MAP_SETS_FK1

SOURCE_VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

OHF_ETS_ET_MAP_MAP_SETS_FK2

TARGET_VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_MAP_MAP_SETS_U1 UNIQUE MAP_SET_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MAP_SET_CODE

A vendor defined code for this map set. Should be unique within map sets of a vendor.

MAP_SET_DESC

Map set description.

MAP_SET_ID

Unique identifier for the Map Set.

MAP_SET_MULTIPLICITY_CODE

A code designating the multiplicity of the mappings within this map set. See the javadocs for more information.

MAP_SET_NAME

A name that describes the map set.

MAP_SET_RULE_TYPE_CODE

An indication of the types of rules used in the cross maps and cross map targets.

REALM_CODE

The identifier of the realm within which this mapping table is applicable.

SOURCE_VERSION_ID

Version identifier of the source scheme.

STATUS_CODE

The status of the map set. Choices are Active (A), Retired (R) or Invalid (X).

TARGET_VERSION_ID

Version identifier of the target scheme.

VENDOR_NAME

The name of the vendor that provided this map set.

TABLE: OHF_ETS_ET_MAP_MAP_TARGETS

Comment:

Targets for a map set.

Primary Key
PK NameColumn
OHF_ETS_ET_MAP_MAP_TARGETS_PK MAP_SET_ID
  TARGET_CODE

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_MAP_MAP_TARGETS_FK1

MAP_SET_ID

OHF_ETS_ET_MAP_MAP_SETS

MAP_SET_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_MAP_MAP_TARGETS_U1 UNIQUE MAP_SET_ID
    TARGET_CODE

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MAP_SET_ID

Unique identifier for the cross map set of which this cross map is a member.

TARGET_ADVICE_TXT

Textual advice expressing the combinations of conditions to which the cross map target applies.

TARGET_CODE

The code for the map target within this map set that the source concept maps to.

TARGET_RULE_TXT

A machine processable expression of rules that determine the combinations of conditions to which the cross map target applies.

TABLE: OHF_ETS_ET_MAP_TARG_CON_MAP

Comment:

Mapping of targets and the concepts that they consist of.

Primary Key
PK NameColumn
OHF_ETS_ET_MAP_TARG_CON_MAP_PK CONCEPT_ID
  MAP_SET_ID
  TARGET_CODE

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_MAP_TG_CON_MAP_FK1

CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_MAP_TG_CON_MAP_FK2

MAP_SET_ID,TARGET_CODE

OHF_ETS_ET_MAP_MAP_TARGETS

MAP_SET_ID,TARGET_CODE

Indexes
IndexTypeColumn
OHF_ETS_ET_MAP_TARG_CON_MAP_U1 UNIQUE CONCEPT_ID
    MAP_SET_ID
    TARGET_CODE

Columns
ColumnComment
CONCEPT_ID

A concept code of a mapped concept for this target.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MAP_SET_ID

Unique identifier for the cross map set of which this cross map is a member.

TARGET_CODE

The code for the map target within this map set that the source concept maps to.

TABLE: OHF_ETS_ET_MODELS

Comment:

Represents a common set of behaviors and attributes for a terminology or set of terminologies. Essentially, represents a java code base responsible for dealing with the data of a model.

Primary Key
PK NameColumn
OHF_ETS_ET_MODELS_PK MODEL_NAME

Indexes
IndexTypeColumn
OHF_ETS_ET_MODELS_U1 UNIQUE MODEL_NAME

Columns
ColumnComment
CACHE_CODE_BASE

Designates the cache to be used for the caching implementation.

CLIENT_CODE_BASE

Designates the factory code responsible for generating client side components. (Internal use only).

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

IMPORTER_CODE_BASE

Designates the terminology importer responsible for loading data into stage tables.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

LOADER_CODE_BASE

Designates the terminology loader responsible for loading data into stage tables.

MODEL_DESC

Description of the model.

MODEL_NAME

Name of the terminology model.

SERVER_CODE_BASE

Designates the factory code responsible for generating server side components. (Internal use only).

TABLE: OHF_ETS_ET_PRI_EQVLN_CNCPT_V

Comment:

This view HCT_ET_PRI_EQVLN_CNCPT_V collects collective information about concepts and their equivalent primary concepts.

Columns
ColumnComment
CONCEPT_ID

ETS identifier for the concept.

PRIMARY_EQUIVALENT_CONCEPT_ID

ETS identifier for the primary equivalent concept.

TABLE: OHF_ETS_ET_RELATIONSHIPS

Comment:

Association between concepts.

Primary Key
PK NameColumn
OHF_ETS_ET_RELATIONSHIPS_PK RELATIONSHIP_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_RELATIONSHIPS_FK1

RELATIONSHIP_CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_RELATIONSHIPS_FK2

SOURCE_CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_RELATIONSHIPS_FK3

TARGET_CONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_RELATIONSHIPS_FK4

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_RELATIONSHIPS_U1 UNIQUE RELATIONSHIP_ID
OHF_ETS_ET_RELATIONSHIPS_N3 NONUNIQUE RELATIONSHIP_CONCEPT_ID
    SOURCE_CONCEPT_ID
    STATUS_CODE
    TARGET_CONCEPT_ID
OHF_ETS_ET_RELATIONSHIPS_N2 NONUNIQUE RELATIONSHIP_CONCEPT_ID
OHF_ETS_ET_RELATIONSHIPS_N1 NONUNIQUE RELATIONSHIP_CONCEPT_ID
    SOURCE_CONCEPT_ID
    STATUS_CODE
    TARGET_CONCEPT_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

RELATIONSHIP_CONCEPT_ID

ETS identifier for the relationship type concept.

RELATIONSHIP_ID

ETS identifier for the relationship.

RETIRED_DATE

Retired date of the relationship.

SOURCE_CONCEPT_ID

ETS identifier for the source concept.

STATUS_CODE

The status of the relationship. Valid values are Active (A) and Retired (R).

TARGET_CONCEPT_ID

ETS identifier for the target concept.

VERSION_ID

ETS version identifier.

TABLE: OHF_ETS_ET_SCHEME_LOV_V

Comment:

Used to displays all the coding schemes that can be selected by the Healthcare ETS Terminology Loader Concurrent Program UI in a drop down list (LOV).

Columns
ColumnComment
CODINGSCHEME_DESC

Coding scheme description.

CODINGSCHEME_NAME

Name of the coding scheme as specified by a standard list such as HL7, LN for LOINC.

TABLE: OHF_ETS_ET_SNOMED_CONCEPTS

Comment:

Peer table to HCT_ET_CONCEPTS to support additional Snomed concept attributes.

Primary Key
PK NameColumn
OHF_ETS_ET_SNOMED_CONCEPTS_PK ETSCONCEPT_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_SNOMED_CONCEPTS_FK1

ETSCONCEPT_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

OHF_ETS_ET_SNOMED_CONCEPTS_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_SNOMED_CONCEPTS_U1 UNIQUE ETSCONCEPT_ID
OHF_ETS_ET_SNOMED_CONCEPTS_N4 NONUNIQUE PRIMITIVE_FLAG
OHF_ETS_ET_SNOMED_CONCEPTS_N3 NONUNIQUE SNOMED_STATUS_NUM
OHF_ETS_ET_SNOMED_CONCEPTS_N2 NONUNIQUE RTID_CODE
    VERSION_ID
OHF_ETS_ET_SNOMED_CONCEPTS_N1 NONUNIQUE CTV3ID_CODE
    VERSION_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

CTV3ID_CODE

The clinical terms version 3 identifier for the concept.

EFFECTIVE_TIME

null

ETSCONCEPT_ID

Unique SNOMED CT identifier.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MODULE_ID

null

PRIMITIVE_FLAG

Indicates whether a concept is primitive or fully defined by its current set of defining characteristics.

RTID_CODE

The SNOMED RT identifier for the concept.

SNOMED_STATUS_NUM

Status whether the concept is in use.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_SNOMED_DESCS

Comment:

Peer table to HCT_ET_DESCRIPTIONS to support additional Snomed concept description attributes.

Primary Key
PK NameColumn
OHF_ETS_ET_SNOMED_DESCS_PK ETS_DESCRIPTION_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_SNOMED_DESCS_FK1

ETS_DESCRIPTION_ID

OHF_ETS_ET_DESCRIPTIONS

DESCRIPTION_ID

OHF_ETS_ET_SNOMED_DESCS_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_SNOMED_DESCS_U1 UNIQUE ETS_DESCRIPTION_ID
OHF_ETS_ET_SNOMED_DESCS_N4 NONUNIQUE LANGUAGE_CODE
OHF_ETS_ET_SNOMED_DESCS_N3 NONUNIQUE INITIAL_CAPITAL_STATUS_CODE
OHF_ETS_ET_SNOMED_DESCS_N2 NONUNIQUE SNOMED_STATUS_NUM
OHF_ETS_ET_SNOMED_DESCS_N1 NONUNIQUE SNOMED_DESC_ID
    VERSION_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

EFFECTIVE_TIME

null

ETS_DESCRIPTION_ID

ETS identifier for the SNOMED description.

INITIAL_CAPITAL_STATUS_CODE

An indication of whether the initial capitalization of the term is significant.

LANGUAGE_CODE

The code for the language or dialect in which this description is valid.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MODULE_ID

null

SNOMED_DESC_ID

Unique SNOMED CT identifier for the description.

SNOMED_STATUS_NUM

Indicate whether the description is in use.

TYPE_ID

null

VERSION_ID

ETS identifier for the version

TABLE: OHF_ETS_ET_SNOMED_RELS

Comment:

Peer table to HCT_ET_RELATIONSHIPS to support additional Snomed concept relation attributes.

Primary Key
PK NameColumn
OHF_ETS_ET_SNOMED_RELS_PK ETS_RELATIONSHIP_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_SNOMED_RELS_FK1

ETS_RELATIONSHIP_ID

OHF_ETS_ET_RELATIONSHIPS

RELATIONSHIP_ID

OHF_ETS_ET_SNOMED_RELS_FK2

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_SNOMED_RELS_U1 UNIQUE ETS_RELATIONSHIP_ID
OHF_ETS_ET_SNOMED_RELS_N4 NONUNIQUE RELATIONSHIP_GROUP_NUM
OHF_ETS_ET_SNOMED_RELS_N3 NONUNIQUE REFINABILITY_NUM
OHF_ETS_ET_SNOMED_RELS_N2 NONUNIQUE CHARACTERISTIC_TYPE_NUM
OHF_ETS_ET_SNOMED_RELS_N1 NONUNIQUE SNOMED_RELATIONSHIP_ID
    VERSION_ID

Columns
ColumnComment
CHARACTERISTIC_TYPE_NUM

An indication of whether a relationship specifies a defining characteristic of the source concept or a possible qualifying characteristic of that concept.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

CTYPE_ID

null

EFFECTIVE_TIME

null

ETS_RELATIONSHIP_ID

ETS identifier for the SNOMED CT relationship.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MODIFIER_ID

null

MODULE_ID

null

REFINABILITY_NUM

An indication of whether it is possible to refine the target concept when this relationship is used as a template for clinical data entry.

RELATIONSHIP_GROUP_NUM

An integer value that links together relationships which are part of a logically associated relationship group.

SNOMED_RELATIONSHIP_ID

Unique SNOMED CT identifier for the relationship.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_SNOMED_SBST_MEMS

Comment:

Members of a SNOMED subset.

Primary Key
PK NameColumn
OHF_ETS_ET_SNOMED_SBST_MEMS_PK ETS_SUBSET_ID
  MEMBER_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_SNOMED_SBST_MEM_FK1

ETS_SUBSET_ID

OHF_ETS_ET_SNOMED_SUBSETS

ETS_SUBSET_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_SNOMED_SBST_MEMS_U1 UNIQUE ETS_SUBSET_ID
    MEMBER_ID

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

EFFECTIVE_TIME

null

ETS_SUBSET_ID

ETS identifier for the SNOMED CT subset.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

MEMBER_ID

The unique SNOMED CT identifier for this member of the subset.

MEMBER_IND

A positive integer specifying the status, type, or order of this member.

MODULE_ID

null

STATUS_FLAG

null

VALUE_STRING

null

TABLE: OHF_ETS_ET_SNOMED_SUBSETS

Comment:

Defines the nature of a subset.

Primary Key
PK NameColumn
OHF_ETS_ET_SNOMED_SUBSETS_PK ETS_SUBSET_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_SNOMED_SUBSETS_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_SNOMED_SUBSETS_U1 UNIQUE ETS_SUBSET_ID
OHF_ETS_ET_SNOMED_SUBSETS_N1 NONUNIQUE SUBSET_NUM
    VERSION_ID

Columns
ColumnComment
CONTEXT_CODE

For context subsets, identifies the context domain to which the subset applies.

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

ETS_SUBSET_ID

ETS identifier for the SNOMED CT subset.

LANGUAGE_CODE

Identifies the language, and optionally the dialect, to which the subset applies.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

REALM_CODE

Identifies the realm to which the subset applies. ISO 6523-format four character code, followed by an optional series of concatenated subdivision codes defined by the registered organization.

SUBSET_NAME

A name that describes the purpose or usage of the subset.

SUBSET_NUM

Unique SNOMED CT identifier for the subset.

SUBSET_ORIGINAL_NUM

The unique SNOMED CT identifier for the original subset of which this subset is a version.

SUBSET_TYPE_NUM

Indicates the nature of the subset and the type of SNOMED CT component that may be a member of the subset.

SUBSET_VERSION_NUM

An integer incremented for each release of a subset.

VERSION_ID

ETS identifier for the version.

TABLE: OHF_ETS_ET_USAGE_CONTEXTS

Comment:

Used in combination with Local Descriptions.

Primary Key
PK NameColumn
OHF_ETS_ET_USAGE_CONTEXTS_PK USAGE_CONTEXT_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_USAGE_CONTEXTS_U1 UNIQUE USAGE_CONTEXT_ID
OHF_ETS_ET_USAGE_CONTEXTS_N1 NONUNIQUE USAGE_CONTEXT_NAME

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

USAGE_CONTEXT_DESC

Description of the usage context.

USAGE_CONTEXT_ID

Unique identifier for the usage context.

USAGE_CONTEXT_NAME

Name of the usage context.

TABLE: OHF_ETS_ET_USGCONTXT_ASSCTNS

Comment:

Intersection table between usage contexts and external identifiers.

Primary Key
PK NameColumn
OHF_ETS_ET_USGCONTXT_ASSCTS_PK OWNER_ID
  OWNER_TYPE_CODE

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_USGCONTXT_ASS_FK1

USAGE_CONTEXT_ID

OHF_ETS_ET_USAGE_CONTEXTS

USAGE_CONTEXT_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_USGCNTXT_ASSCTNS_U1 UNIQUE OWNER_ID
    OWNER_TYPE_CODE

Columns
ColumnComment
CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

OWNER_ID

Unique external identifier

OWNER_TYPE_CODE

Application that owns the external identifier.

USAGE_CONTEXT_ID

Usage context identifier.

TABLE: OHF_ETS_ET_VERSIONS

Comment:

Stores version information of coding schemes.

Primary Key
PK NameColumn
OHF_ETS_ET_VERSIONS_PK VERSION_ID

Foreign Keys

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_VERSIONS_FK1

CODINGSCHEME_ID

OHF_ETS_ET_CODING_SCHEMES

CODINGSCHEME_ID

Indexes
IndexTypeColumn
OHF_ETS_ET_VERSIONS_U1 UNIQUE VERSION_ID
OHF_ETS_ET_VERSIONS_N2 NONUNIQUE CODINGSCHEME_ID
OHF_ETS_ET_VERSIONS_N1 NONUNIQUE VERSION_NAME

Columns
ColumnComment
CODINGSCHEME_ID

ETS identifier for the parent coding scheme this source belongs to

CREATED_BY

Standard who column - user who created this row.

CREATION_DATE

Standard who column - date when this row was created.

DEFAULT_FLAG

A flag designating the version as the default within its coding scheme. Only one version may be designated as default for a coding scheme, and that version must have a status of active or retired.

HISTORY_TYPE_CODE

Indicates the type of history information supplied with the terminology version at load time. Allowed values are INTRATERMINOLOGY, INTERTERMINOLOGY, and NONE.

LAST_UPDATED_BY

Standard who column - user who last updated this row.

LAST_UPDATE_DATE

Standard Who column - date when a user last updated this row.

LAST_UPDATE_LOGIN

Standard who column - operating system login of user who last updated this row.

LOAD_DATE

The date on which this version was loaded into the staging tables.

RETIRED_DATE

Date when retired

STATUS_CODE

The status of the version. Allowed values are Quarantined (Q), Active (A), Retired (R), or Invalid (X).

VERSION_DESC

Description of the version.

VERSION_ID

ETS identifier for the source version of the concept, description or relationship

VERSION_NAME

Version name for this source

TABLE: OHF_ETS_ST_ATTRIBUTES

Comment:

Staging table for ETS attributes that may be attached to versions, concepts, descriptions, or relationships.

Indexes
IndexTypeColumn
OHF_ETS_ST_ATTRIBUTES_N1 NONUNIQUE ATT_SEQ
    LOAD_SEQ

Columns
ColumnComment
ATT_SEQ

Attribute sequence number.

LOAD_SEQ

Load sequence identifier.

NAME

Name of the attribute.

VALUE

Value of the attribute.

TABLE: OHF_ETS_ST_CLSSFCTN_DCLRNS

Comment:

Staging table to represent the contents of a classification. Concepts can be acted upon in different manners in a classification.

Indexes
IndexTypeColumn
OHF_ETS_ST_CLSSFCTN_DCLRNS_N1 NONUNIQUE ATT_SEQ
    LOAD_SEQ

Columns
ColumnComment
ATT_SEQ

Attribute sequence number.

CLASSIFICATION_CODE

Code specified for the classification.

CLASSIFICATION_ID

ETS identifier for the classification.

CODING_SCHEME_NAME

Name of the coding scheme associated with the classification.

CODING_SCHEME_VERSION

Version of the coding scheme associated with the classification.

CONCEPT_CODE

Source defined code for the concept associated with the classification.

CONCEPT_ID

ETS identifier for the concept associated with the classification.

INSERT_OPTION

A code to specify the manner in which the concept is being acted upon in the classification. E.g. CONCEPT, DIRECT_CHILDREN_ONLY, ALL_DESCENDANT etc.

LOAD_SEQ

Load sequence identifier.

TABLE: OHF_ETS_ST_CLSSFCTN_VERSIONS

Comment:

Staging table to represent the versions of a classification.

Columns
ColumnComment
LOAD_SEQ

Load sequence identifier.

LOAD_STATUS_CODE

A code specifying the status of the load.

TABLE: OHF_ETS_ST_CODING_SCHEMES

Comment:

Staging table to store the information about all the coding schemes.

Columns
ColumnComment
LOAD_DATE

Load date of the coding scheme.

LOAD_SEQ

Load sequence identifier.

NAME

Name of the coding scheme.

TABLE: OHF_ETS_ST_CONCEPTS

Comment:

Staging table to store the information about ETS Concepts (units of thought represented by codes and strings).

Indexes
IndexTypeColumn
OHF_ETS_ST_CONCEPTS_N3 NONUNIQUE CONCEPT_CODE
    LOAD_SEQ
OHF_ETS_ST_CONCEPTS_N2 NONUNIQUE LOAD_SEQ
    REASSIGNED_TO
OHF_ETS_ST_CONCEPTS_N1 NONUNIQUE ATT_SEQ
    LOAD_SEQ

Columns
ColumnComment
ATT_SEQ

Attribute sequence number.

CONCEPT_CODE

Vendor specified code for this concept. For example, 114.2 in ICD-9-CM or 2458006 in SNOMED-CT. In the absence of such codes, the code might be invented or derived from other information about the concept. Concept codes are unique within a versi on.

CONCEPT_ID

Concept identifier.

DATE_RETIRED

Retired date of the concept.

EXTENDED_TYPE_CODE

A terminology defined extended metadata code. ETS does not process or alter its behavior based on extended type codes in any way; it simply provides them to applications.

LOAD_SEQ

Load sequence identifier.

REASSIGNED_TO

The identifier to which it has been reassigned

RELATIONSHIP_TYPE_FLAG

True for concepts that are Relationship Types. The data length of the column is updated to 30 to represent classification relationships as well.

STATUS_FLAG

Status of the concept indicating whether it is active, retired or invalid.

TABLE: OHF_ETS_ST_DESCRIPTIONS

Comment:

Staging table for human-readable strings representation of a concept.

Indexes
IndexTypeColumn
OHF_ETS_ST_DESCS_N2 NONUNIQUE CONCEPT_CODE
    LOAD_SEQ
OHF_ETS_ST_DESCS_N1 NONUNIQUE ATT_SEQ
    LOAD_SEQ

Columns
ColumnComment
ATT_SEQ

Attribute sequence number.

CONCEPT_CODE

Concept code associated with the description.

DATE_RETIRED

Date when retired.

DESCRIPTION_ID

Description identifier.

ET_LANGUAGE_CODE

Language code of the terminology concept description.

EXTENDED_TYPE_CODE

A terminology defined extended metadata code. ETS does not process or alter its behavior based on extended type codes in any way; it simply provides them to applications.

LOAD_SEQ

Load sequence identifier.

PREFERRED_FLAG

Specifies whether this is the preferred description.

STATUS_FLAG

Status of the concept description indicating whether it is active, retired or invalid.

TERM

The actual word/phrase used for the description.

TABLE: OHF_ETS_ST_EQVLNC_CLIQTRANS

Comment:

Staging table to store the log of the concept linking provided by the vendor.

Indexes
IndexTypeColumn
OHF_ETS_ST_EQVLNC_CLIQTRANS_N1 NONUNIQUE LINK_TYPE_CODE
    LOAD_SEQ
    SOURCE_CONCEPT_CODE
    TARGET_CONCEPT_CODE

Columns
ColumnComment
LINK_TYPE_CODE

Code to indicate a linking type for concepts.

LOAD_SEQ

Load Sequence identifier.

SOURCE_CONCEPT_CODE

Vendor specified code for the source concept.

TARGET_CONCEPT_CODE

Vendor specified code for the target concept.

TABLE: OHF_ETS_ST_FDB_CLSSFCTNS

Comment:

Staging peer table to HCT_ST_CONCEPTS to store additional FDB classification attributes.

Primary Key
PK NameColumn
OHF_ETS_ST_FDB_CLSSFCTNS_PK CONCEPT_CODE
  LOAD_SEQ

Indexes
IndexTypeColumn
OHF_ETS_ST_FDB_CLSSFCTNS_U1 UNIQUE CONCEPT_CODE
    LOAD_SEQ

Columns
ColumnComment
CONCEPT_CODE

Vendor specified code for a concept.

ETC_DRUG_CONCEPT_LINK_IND

Indicates that atleast one GCNSEQNO is associated.

ETC_FORMULARY_LEVEL_IND

Indicates whether it is a suggested level for building formularies.

ETC_HIERARCHY_LEVEL

Level of the Classification in the hierarchy.

ETC_PRESENTATION_SEQNO

Sort order for presentation of siblings.

ETC_SORT_NUMBER

Recommended order for presentation (regardless of parents); may change from version to version.

ETC_ULTIMATE_CHILD_IND

Indicator to denote if this is the ultimate child.

LOAD_SEQ

Load Sequence identifier.

TABLE: OHF_ETS_ST_FDB_ID_MAPPING

Comment:

Staging table to store cross mapping of IDs for loading purposes.

Primary Key
PK NameColumn
OHF_ETS_ST_FDB_ID_MAPPING_PK LOAD_SEQ
  MAPPING_SOURCE_ID
  MAPPING_TARGET_ID
  RECORD_TYPE_CODE

Indexes
IndexTypeColumn
OHF_ETS_ST_FDB_ID_MAPPING_U1 UNIQUE LOAD_SEQ
    MAPPING_SOURCE_ID
    MAPPING_TARGET_ID
    RECORD_TYPE_CODE

Columns
ColumnComment
LOAD_SEQ

Load Sequence identifier.

MAPPING_SOURCE_ID

Identifier for the source record.

MAPPING_TARGET_ID

Identifier for the target record.

RECORD_TYPE_CODE

Type of record.

TABLE: OHF_ETS_ST_FDB_MEDNAME_ATTRS

Comment:

Staging table to store additional medication name attributes.

Primary Key
PK NameColumn
OHF_ETS_ST_FDB_MEDNAME_ATTR_PK CONCEPT_CODE
  LOAD_SEQ

Indexes
IndexTypeColumn
OHF_ETS_ST_FDB_MEDNAME_ATTR_U1 UNIQUE CONCEPT_CODE
    LOAD_SEQ

Columns
ColumnComment
CONCEPT_CODE

Source specified code for a concept.

LOAD_SEQ

Load Sequence identifier.

MED_NAME_TYPE

Code for the type of medication name.

MED_STATUS_CODE

Status code of the medication name indicating whether it is live, replaced or retired.

TABLE: OHF_ETS_ST_FDB_MED_CONCEPTS

Comment:

Staging peer table to OHF_ETS_ST_CONCEPTS to store additional medication concept attributes.

Primary Key
PK NameColumn
OHF_ETS_ST_FDB_MED_CONCEPTS_PK CONCEPT_CODE
  LOAD_SEQ

Indexes
IndexTypeColumn
OHF_ETS_ST_FDB_MED_CONCEPTS_U1 UNIQUE CONCEPT_CODE
    LOAD_SEQ

Columns
ColumnComment
CONCEPT_CODE

Source specified code for a concept.

GCN_SEQNO_TXT

Generic Code Number Sequence Number (GCN_SEQNO) is used to identify unique combinations of ingredient, strength, dose form and route.

GENERIC_MED_ID

Generic medication Identifier.

LOAD_SEQ

Load Sequence identifier.

MED_GCNSEQNO_ASSIGN_CODE

Medication GCN_SEQNO assignment code.

MED_REF_DEA_CODE

Medication Reference Federal DEA Class code.

MED_REF_FED_LEGEND_IND

Medication Reference Federal Legend indicator.

MED_REF_GEN_DRUG_NAME_CODE

Medication Reference Generic Medication Name Code. Used to distinguish drugs (=1) from non-drugs (=0).

MED_STATUS_CODE

Status code of the medication concept indicating whether it is live, replaced or retired.

MED_STRENGTH_TXT

Text to represent the strength of the medication.

MED_STRENGTH_UON_TXT

Text to represent the unit of measurement of the medication strength.

TABLE: OHF_ETS_ST_FDB_NDC_CONCEPTS

Comment:

Staging peer table to OHF_ETS_ST_CONCEPTS to store additional NDC concept attributes.

Primary Key
PK NameColumn
OHF_ETS_ST_FDB_NDC_CONCEPTS_PK CONCEPT_CODE
  LOAD_SEQ

Indexes
IndexTypeColumn
OHF_ETS_ST_FDB_NDC_CONCEPTS_U1 UNIQUE CONCEPT_CODE
    LOAD_SEQ
OHF_ETS_ST_FDB_NDC_CONCEPTS_N2 NONUNIQUE GEN_SEQNO_TXT
    LOAD_SEQ
OHF_ETS_ST_FDB_NDC_CONCEPTS_N1 NONUNIQUE BN_TXT
    LOAD_SEQ

Columns
ColumnComment
ADD_DATE

The date on which a drug record was added to the FDB NDC file.

BN_TXT

Text to indicate the brand name.

CL_CODE

Text to indicate the drug class code.

CONCEPT_CODE

Source specified code for a concept.

DEA_CODE

Text to indicate the DEA code.

GEN_SEQNO_TC

The Standard Therapeutic Class Code of the GCNSEQNO associated with the NDC.

GEN_SEQNO_TXT

Generic Code Number Sequence Number.

GNI_IND

Generic Named Drug Indicator.

HCPC_CODE

Text to indicate the HCFA Common Procedure Code.

HICL_SEQNO

Hierarchical Ingredient Code List Sequence Number.

HOSP_IND

Hospital Selection Indicator.

LOAD_SEQ

Load Sequence identifier.

NDCFI_IND

NDC Format Indicator.

PNDC_TXT

Text to indicate the previous national drug code (NDC).

REPNDC_TXT

Text to indicate the replacement national drug code (NDC).

SKEY_NUM

Text to indicate the smart key number.

TABLE: OHF_ETS_ST_HL7_EXTERNAL_MAP

Comment:

Staging table to map HL7 value sets to concepts in external (non-HL7) terminologies.

Columns
ColumnComment
EXTERNAL_ID

Unique identifier for the HL7 external map.

LOAD_SEQ

Load sequence identifier.

TARGET_CONCEPT_CODE

Unique identifier for the HL7 target concept.

TABLE: OHF_ETS_ST_HL7_EXT_VALUE_SETS

Comment:

Staging table to associate HL7 external value sets with non-HL7 CodingSchemeVersions.

Columns
ColumnComment
EXTERNAL_ID

Unique identifier for the HL7 external value set.

LOAD_SEQ

Load sequence identifier.

MAPPED_FLAG

Indicates that this HL7 external value set is mapped to individual concepts within the target version, instead of mapping to the entire target version. Y/N.

SCHEME_NAME

Name of the scheme.

VERSION_ID

Version identifier.

TABLE: OHF_ETS_ST_LANG_TER_MAPPINGS

Comment:

Staging table to maintain a mapping of ISO language code,ISO territory code and the language code of the terminology concept description for a given coding scheme.

Columns
ColumnComment
ET_LANGUAGE_CODE

Language code of the terminology concept description.

ISO_LANGUAGE

ISO Language code.

ISO_TERRITORY

ISO Territory code.

LOAD_SEQ

Load sequence identifier.

STATUS

Status of the mapping. Y/N.

TABLE: OHF_ETS_ST_LOINC_CONCEPTS

Comment:

Staging peer table to OHF_ETS_ST_CONCEPTS to support additional Loinc concept attributes.

Indexes
IndexTypeColumn
OHF_ETS_ST_LOINC_CONCEPTS_N2 NONUNIQUE LOAD_SEQ
OHF_ETS_ST_LOINC_CONCEPTS_N1 NONUNIQUE CONCEPT_CODE

Columns
ColumnComment
CONCEPT_CODE

LOINC concept code.

LOAD_SEQ

Load sequence identifier.

LOINC_ACSSYN_TXT

Chemical name synonyms, alternative name synonyms, and chemical formulae supplied by the Chemical Abstract Society.

LOINC_ANSWERLIST_TXT

The list of answers for results those are reportable from a multiple-choice list.

LOINC_ASTM_CODE

The ASTM codes apply to only a few of the tests such as cell count, antibiotic sensitivities.

LOINC_BASE_NAME_TXT

Chemical base name from CAS.

LOINC_CDC_CODE

Code from CDC Complexity file that maps laboratory tests to the instruments used to perform them.

LOINC_CHNG_REAS_TXT

Reason term was changed.

LOINC_CHNG_TYPE_TXT

Change Type Code such as DEL, ADD, NAM, MAJ, MIN.

LOINC_CLASS_CODE

An arbitrary classification of the terms for grouping related observations together.

LOINC_CLASS_TYPE_CODE

Categorization of LOINC_CLASS_CODE: 1=Laboratory class; 2=Clinical class; 3=Claims attachments;4=Surveys.

LOINC_CODE_TABLE_TXT

Examples on CR0050 Cancer Registry.

LOINC_COMMENTS_TXT

Free-text comments relating to the test result.

LOINC_COMPONENT_CODE

The LOINC component name.

LOINC_CSCQ_FRNCH_NM_TXT

French name for LOINC term.

LOINC_CSCQ_GRMN_NM_TXT

German name for LOINC term

LOINC_CSGQ_ITLN_NM_TXT

Italian name for LOINC term.

LOINC_DEEDS_CODE

Data elements for Emergency Department Systems Codes (CDC). This field contains the DEEDS code value which maps to the LOINC code in question.

LOINC_DT_LAST_CH_TXT

Date last changed, in the format YYYYMMDD.

LOINC_EUCLIDE_CODE

The Euclides code identifies the analyte (the first subpart of the first part of the name.

LOINC_EXACT_CMP_SYS_TXT

Exact core component synonym.

LOINC_EXMPL_ANSWERS_TXT

For some tests and measurements, we have supplied examples of valid answers, such as 1:64, negative @ 1:16, or 55. This differs from the ANSWERLIST field, which details possible choices for nominal scale terms.

LOINC_EX_US_UNITS_TXT

Example units used in the US. The terms have been standardized to more closely resemble HL7 version3.

LOINC_FINAL_TXT

Internal LOINC use field.

LOINC_FORMULA_TXT

Regression equation details for many OB.US calculated terms.

LOINC_GENE_ID_TXT

OMIM (Online Mendelian Inheritance in Man) names.

LOINC_GPI_CODE

GPI Code. For drugs, this field contains a map to the Medispan GPI codes, a hierarchical system of classifying pharmaceutical products.

LOINC_HCFA_CODE

HCFA code.

LOINC_IPCC_UNITS_TXT

Example units used by IUPAC/IFCC.

LOINC_IUPAC_CODE

The IUPAC code identifies the component, kind of property, and system.

LOINC_IUPC_ANLT_CODE

IUPAC analyte code. This column contains the Chemical Abstract service number or the Enzyme Nomenclature number for the chemical components for chemical and/or enzymes.

LOINC_METHOD_CODE

The LOINC method code.

LOINC_METPATH_CODE

Metpath code.

LOINC_MOLAR_MASS_TXT

Molecular weights: This field contains the molecular weights of chemical moieties when they are provided to us.

LOINC_MOLEID_TXT

Molecular structure ID, usually CAS number.

LOINC_MULTUM_CODE

Maps to Multum Inc. database of codes for drugs.

LOINC_NAACCR_ID_TXT

Maps to North American Association of Central Cancer Registries Identification Number.

LOINC_NORM_RANGE_TXT

Normal Range - Example answers from real tests.

LOINC_PANELELEMENTS_TXT

List of individual tests that comprise a panel.

LOINC_PROPERTY_CODE

The LOINC property name.

LOINC_REFERENCE_TXT

Contains references to medical literature, product announcements, or other written sources of information on the test or measurement described by the LOINC record.

LOINC_RELATEDNAMES_2_TXT

It contains synonyms for all parts of the fully specified LOINC name.

LOINC_RELAT_NMS_TXT

One or more synonyms, separated by semicolons (;).

LOINC_SCALE_CODE

The LOINC scale code.

LOINC_SCOPE_TXT

Not currently used.

LOINC_SETROOT_TXT

Currently used for claims attachments. Yes in this field signifies that this record is the root of a set of LOINC codes.

LOINC_SNOMED_CODE

SNOMED Code.

LOINC_SOURCE_TXT

Source text is for LOINC internal use.

LOINC_SPECIES_TXT

Codes detailing which non-human species the term applies to. If blank, human is assumed.

LOINC_SPNSH_NM_TXT

For future use.

LOINC_STATUS_TXT

Used to mark terms as the database evolves. Deprecated or superseded status indicated by DEL in this field otherwise blank.

LOINC_SUBMITTED_UNITS_TXT

Example units as submitted by original requester.

LOINC_SURVEY_QUEST_SRC_TXT

Exact name of the survey instrument and the item/question number.

LOINC_SURVEY_QUEST_TXT

Verbatim question from the survey instrument.

LOINC_SYSTEM_CODE

The LOINC system code.

LOINC_TIME_ASPECT_CODE

The LOINC time aspect.

LOINC_UNITS_REQUIRED_TXT

Y/N field that indicates that units are required when this LOINC is included as an OBX segment in a HIPPA attachment.

LOINC_VA_CODE

VA Code.

ROW_TYPE_CODE

A code denoting the type of row being represented. Valid values are Normal (N) or Supplemental (S). Supplemental rows are used to store synonyms for name parts which are used in LOINC search template matching.

TABLE: OHF_ETS_ST_LOINC_PARTS

Comment:

Staging table to store the parts information of LOINC name

Indexes
IndexTypeColumn
OHF_ETS_ST_LOINC_PARTS_N2 NONUNIQUE PART_ID
OHF_ETS_ST_LOINC_PARTS_N1 NONUNIQUE LOAD_SEQ

Columns
ColumnComment
LOAD_SEQ

Load sequence identifier.

PART_ID

LOINC part identifier.

PART_TYPE

LOINC part type.

TABLE: OHF_ETS_ST_LOINC_SYNONYMS

Comment:

Staging table to store the synonyms of LOINC parts.

Indexes
IndexTypeColumn
OHF_ETS_ST_LOINC_SYNONYMS_N3 NONUNIQUE SYNONYM_ID
OHF_ETS_ST_LOINC_SYNONYMS_N2 NONUNIQUE SOURCE_CONCEPT
OHF_ETS_ST_LOINC_SYNONYMS_N1 NONUNIQUE LOAD_SEQ

Columns
ColumnComment
LOAD_SEQ

Load sequence identifier.

PART_SYNONYM

Synonym of loinc parts.

SOURCE_CONCEPT

Concept identifier.

SYNONYM_ID

Synonym identifier.

TABLE: OHF_ETS_ST_LOINC_SYNONYM_MAP

Comment:

Staging table to store LOINC synonym map information.

Indexes
IndexTypeColumn
OHF_ETS_ST_LOINC_SYNYM_MAP_N3 NONUNIQUE SYNONYM_ID
OHF_ETS_ST_LOINC_SYNYM_MAP_N2 NONUNIQUE PART_ID

Columns
ColumnComment
LOAD_SEQ

Load sequence identifier.

PART_ID

LOINC part identifier.

SYNONYM_ID

LOINC synonym identifier.

TABLE: OHF_ETS_ST_MAP_CROSS_MAPS

Comment:

Staging table for mapping between concepts in different Coding Schemes.

Columns
ColumnComment
CROSS_MAP_ADVICE_TXT

Textual advice to support manual mapping decisions between this cross map and other options for mapping the same concept.

CROSS_MAP_RULE_TXT

A machine processable expression of rules that determine whether this is an appropriate cross map.

DEFAULT_FLAG

Designates this cross map as the default mapping for the source concept.

EQUIVALENCE_CONTEXT

The equivalence context of the cross map.

LOAD_SEQ

Load sequence identifier.

MAP_OPTION_NUM

An integer that distinguishes between alternative mappings for a single concept. If automatic rules are used to determine which option is applicable, the options are tested in the order specified by this value, lowest Map Option first.

PRIORITY_NUM

Indication of the suggested order in which to present a series of options for mapping a concept for manual assessment. The first of these is the default option for mapping the concept.

SOURCE_CONCEPT_CODE

Source concept for this cross map.

TARGET_CODE

The code for the map target to which the source concept maps. Unique within a map set.

TABLE: OHF_ETS_ST_MAP_MAP_SETS

Comment:

Staging table to store defining information about Map Sets (sets of Cross Maps).

Columns
ColumnComment
LOAD_SEQ

Load sequence identifier.

LOAD_STATUS

Load status of the map sets.

MAP_SET_CODE

A vendor defined code for this map set. Should be unique within the map set of a vendor.

MAP_SET_DESC

Map set description.

MAP_SET_MULTIPLICITY_CODE

A code designating the multiplicity of the mappings within this map set. See the javadocs for more information.

MAP_SET_NAME

A name that describes the map set.

MAP_SET_RULE_TYPE_CODE

An indication of the types of rules used in the cross maps and cross map targets.

REALM_CODE

The identifier of the realm within which this mapping table is applicable.

SOURCE_VERSION_ID

Version identifier of the source scheme.

TARGET_VERSION_ID

Version identifier of the target scheme.

VENDOR_NAME

The name of the vendor that provided this map set.

TABLE: OHF_ETS_ST_MAP_MAP_TARGETS

Comment:

Staging table defining targets for a map set.

Columns
ColumnComment
LOAD_SEQ

Load sequence identifier.

TARGET_ADVICE_TXT

Textual advice expressing the combinations of conditions to which the cross map target applies.

TARGET_CODE

The code for the map target within this map set that the source concept maps to.

TARGET_RULE_TXT

A machine processable expression of rules that determine the combinations of conditions to which the cross map target applies.

TABLE: OHF_ETS_ST_MAP_TARG_CON_MAP

Comment:

Staging table to map Targets and the Concepts they consist of.

Columns
ColumnComment
CONCEPT_CODE

Vendor specified code for the concept.

LOAD_SEQ

Load sequence identifier.

TARGET_CODE

The code for the map target within this map set that the source concept maps to.

TABLE: OHF_ETS_ST_RELATIONSHIPS

Comment:

Staging table to store association between concepts.

Indexes
IndexTypeColumn
OHF_ETS_ST_RELATNSHIPS_N4 NONUNIQUE LOAD_SEQ
    RELATIONSHIP_CONCEPT_CODE
OHF_ETS_ST_RELATNSHIPS_N3 NONUNIQUE LOAD_SEQ
    SOURCE_CONCEPT_CODE
OHF_ETS_ST_RELATNSHIPS_N2 NONUNIQUE LOAD_SEQ
    TARGET_CONCEPT_CODE
OHF_ETS_ST_RELATNSHIPS_N1 NONUNIQUE ATT_SEQ
    LOAD_SEQ

Columns
ColumnComment
ATT_SEQ

Attribute sequence number.

DATE_RETIRED

Retired date of the relationship.

LOAD_SEQ

Load sequence identifier.

RELATIONSHIP_CONCEPT_CODE

Identifier of the relationship concept.

RELATIONSHIP_ID

Relationship identifier.

SOURCE_CONCEPT_CODE

Identifier of the source concept.

STATUS_FLAG

The status of the relationship. Valid values are Active (A) and Retired (R)

TARGET_CONCEPT_CODE

Identifier of the target concept.

TABLE: OHF_ETS_ST_SNOMED_CONCEPTS

Comment:

Staging peer table to OHF_ETS_ST_CONCEPTS to support additional Snomed concept attributes.

Columns
ColumnComment
CONCEPTID

SNOMED CT concept identifier.

CONCEPT_STATUS

Status whether the concept is in use.

CTV3ID

The clinical terms version 3 identifier for the concept.

EFFECTIVE_TIME

null

FULLY_SPECIFIED_NAME

Fully specified name of the concept.

ISPRIMITIVE

Indicates whether a concept is primitive or fully defined by its current set of defining characteristics.

LOAD_SEQ

Load sequence identifier.

MODULE_ID

null

SNOMEDID

The current SNOMED identifier for the concept.

TABLE: OHF_ETS_ST_SNOMED_DESCRIPTIONS

Comment:

Staging peer table to OHF_ETS_ST_DESCRIPTIONS to support additional Snomed concept description attributes.

Columns
ColumnComment
EFFECTIVE_TIME

null

INITIAL_CAPITAL_STATUS

An indication of whether the initial capitalization of the term is significant.

LANGUAGE_CODE

The code for the language or dialect in which this description is valid.

LOAD_SEQ

Load sequence identifier.

MODULE_ID

null

SNOMED_DESC_ID

SNOMED description identifier.

SNOMED_STATUS_NUM

Status whether the description is in use.

TYPE_ID

null

TABLE: OHF_ETS_ST_SNOMED_RELATNSHIPS

Comment:

Staging peer table to OHF_ETS_ST_RELATIONSHIPS to support additional Snomed concept relation attributes.

Columns
ColumnComment
CHARACTERISTIC_TYPE_NUM

An indication of whether a relationship specifies a defining characteristic of the source concept or a possible qualifying characteristic of that concept.

CTYPE_ID

null

EFFECTIVE_TIME

null

LOAD_SEQ

Load sequence identifier.

MODIFIER_ID

null

MODULE_ID

null

REFINABILITY_NUM

An indication of whether it is possible to refine the target concept when this relationship is used as a template for clinical data entry.

RELATIONSHIP_GROUP_NUM

An integer value that links together relationships which are part of a logically associated relationship group.

SNOMED_RELATIONSHIP_ID

SNOMED relationship identifier.

TABLE: OHF_ETS_ST_SNOMED_SBST_MEMS

Comment:

Staging table to store members of a SNOMED subset.

Columns
ColumnComment
EFFECTIVE_TIME

null

ETS_SUBSET_ID

ETS identifier for the SNOMED CT subset.

LOAD_SEQ

load sequence identifier.

MEMBER_ID

The unique SNOMED CT identifier for this member of the subset.

MEMBER_STATUS

A positive integer specifying the status, type, or order of this member.

MODULE_ID

null

STATUS_FLAG

null

SUBSET_ID

Identifier for the SNOMED subset.

VALUE_STRING

null

TABLE: OHF_ETS_ST_SNOMED_SUBSETS

Comment:

Staging table to define the nature of a subset.

Columns
ColumnComment
CONTEXT_CODE

For context subsets, identifies the context domain to which the subset applies.

ETS_SUBSET_ID

ETS identifier for the SNOMED CT subset.

LANGUAGE_CODE

Identifies the language, and optionally the dialect, to which the subset applies.

LOAD_SEQ

Load sequence identifier.

REALM_CODE

Identifies the realm to which the subset applies. ISO 6523-format four character code, followed by an optional series of concatenated subdivision codes defined by the registered organization.

SUBSET_NAME

A name that describes the purpose or usage of the subset.

SUBSET_NUM

Unique SNOMED CT identifier for the subset.

SUBSET_ORIGINAL_NUM

The unique SNOMED CT identifier for the original subset of which this subset is a version.

SUBSET_TYPE_NUM

Indicates the nature of the subset and the type of SNOMED CT component that may be a member of the subset.

SUBSET_VERSION_NUM

An integer incremented for each release of a subset.

TABLE: OHF_ETS_ST_VERSIONS

Comment:

Staging table to store version information of coding schemes.

Indexes
IndexTypeColumn
OHF_ETS_ST_VERSIONS_N1 NONUNIQUE ATT_SEQ
    LOAD_SEQ

Columns
ColumnComment
ATT_SEQ

Attribute sequence number.

CREATION_DATE

Standard who column - date when this row was created.

DESCRIPTION

Description of the version.

HISTORY_AVAILABLE_FLAG

This column is for future use.

HISTORY_TYPE_CODE

This column is for future use.

LOAD_DATE

Load date of the version.

LOAD_SEQ

Load sequence identifier.

LOAD_STATUS

Load status of the coding scheme version.

NAME

Version name for this source.

OVERWRITE_FLAG

A flag to control the load behavior. Valid values are Y for yes and N for no. Y means that the data in the data files will replace the data in the database. The default case is to insert new data.

VERSION_ID

Version identifier.

Scripting on this page enhances content navigation, but does not change the content in any way.