Comment: |
ETS attributes that may be attached to versions, concepts, descriptions, or relationships. |
PK Name | Column |
---|---|
OHF_ETS_ET_ATTRIBUTES_PK | ATTRIBUTE_NAME |
ATTRIBUTE_VALUE | |
OWNER_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_ATTRIBUTES_FK1 |
VERSION_ID |
OHF_ETS_ET_VERSIONS |
VERSION_ID |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Used to identify the terminology concept descriptions which have the same language as the ETS base language. |
Column | Comment |
---|---|
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. |
Comment: |
Used to identify the terminology concept local descriptions which have the same language as the ETS base language. |
Column | Comment |
---|---|
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. |
Comment: |
Stores the contents of a classification. Concepts can be acted upon in different manners in a classification. |
PK Name | Column |
---|---|
OHF_ETS_ET_CLSSFCTN_DCLRNS_PK | BUILD_NUM |
CLASSIFICATION_ID | |
CONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_CLSSFCTN_DCLRNS_U1 | UNIQUE | BUILD_NUM |
CLASSIFICATION_ID | ||
CONCEPT_ID |
Column | Comment |
---|---|
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.. |
Comment: |
The pre-computed contents of a classification. All concepts associated with the same clique-id are in a classification. |
PK Name | Column |
---|---|
OHF_ETS_ET_CLSSFCTN_MAP_PK | BUILD_NUM |
CLASSIFICATION_ID | |
CLIQUE_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_CLSSFCTN_MAP_FK1 |
CLASSIFICATION_ID |
OHF_ETS_ET_CONCEPTS |
CONCEPT_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_CLSSFCTN_MAPNGS_U1 | UNIQUE | BUILD_NUM |
CLASSIFICATION_ID | ||
CLIQUE_ID |
Column | Comment |
---|---|
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.. |
Comment: |
The concepts assigned to a concept list. |
PK Name | Column |
---|---|
OHF_ETS_ET_CNCPTLIST_ASSGNS_PK | CONCEPT_ID |
CONCEPTLIST_ID | |
CONCEPT_ACTIVATION_DATE |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Used to validate a concept or any of its equivalent concepts in a concept list. |
Column | Comment |
---|---|
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. |
Comment: |
Used to identify members and their descriptions in a given concept list. |
Column | Comment |
---|---|
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. |
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. |
Column | Comment |
---|---|
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 |
Comment: |
Stores information about all the coding schemes. |
PK Name | Column |
---|---|
OHF_ETS_ET_CODING_SCHEMES_PK | CODINGSCHEME_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_CODING_SCHEMES_FK1 |
MODEL_NAME |
OHF_ETS_ET_MODELS |
MODEL_NAME |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
An unordered non-redundant set of ETS concepts. |
PK Name | Column |
---|---|
OHF_ETS_ET_CONCEPTLISTS_PK | CONCEPTLIST_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
This view represents information about concept lists and its descriptions. |
Column | Comment |
---|---|
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. |
Comment: |
Stores information about ETS Concepts (units of thought represented by codes and strings). |
PK Name | Column |
---|---|
OHF_ETS_ET_CONCEPTS_PK | CONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
This view represents collective information about concepts and their associated coding scheme and version. |
Column | Comment |
---|---|
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. |
Comment: |
Human-readable strings representation of a concept. |
PK Name | Column |
---|---|
OHF_ETS_ET_DESCRIPTIONS_PK | DESCRIPTION_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
This view represents information about concepts and their descriptions. |
Column | Comment |
---|---|
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. |
Comment: |
Stores the log of the concept linking provided by the vendor. |
PK Name | Column |
---|---|
OHF_ETS_ET_EQVLNC_CLIQTRANS_PK | CLIQTRANS_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_EQVLNC_CLIQ_FK1 |
VERSION_ID |
OHF_ETS_ET_VERSIONS |
VERSION_ID |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Concept equivalence service between the existing clique groups. |
PK Name | Column |
---|---|
OHF_ETS_ET_EQVLNC_CLIQLNKS_PK | EQUIVALENCE_TYPE_CODE |
SOURCE_CLIQUE_ID | |
TARGET_CLIQUE_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Grouping of semantically equivalent concepts. |
PK Name | Column |
---|---|
OHF_ETS_ET_EQVLNC_CLIQUES_PK | CLIQUE_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_EQVLNC_CLIQUES_U1 | UNIQUE | CLIQUE_ID |
Column | Comment |
---|---|
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. |
Comment: |
Cross maps between cliques in different Coding Schemes. |
PK Name | Column |
---|---|
OHF_ETS_ET_EQVLNC_CRSMAPLNK_PK | EQUIVALENCE_CONTEXT |
MAP_SET_ID | |
SOURCE_CLIQUE_ID | |
TARGET_CLIQUE_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_EQVLNC_CRSMAPLNK_U1 | UNIQUE | EQUIVALENCE_CONTEXT |
MAP_SET_ID | ||
SOURCE_CLIQUE_ID | ||
TARGET_CLIQUE_ID |
Column | Comment |
---|---|
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. |
Comment: |
This view represents information about concepts and their equivalent concepts. |
Column | Comment |
---|---|
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. |
Comment: |
Peer table to OHF_ETS_ET_CONCEPTS to store additional FDB classification attributes. |
PK Name | Column |
---|---|
OHF_ETS_ET_FDB_CLSSFCTNS_PK | ETSCONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_FDB_CLSSFCTNS_U1 | UNIQUE | ETSCONCEPT_ID |
Column | Comment |
---|---|
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. |
Comment: |
Peer table to OHF_ETS_ET_CONCEPTS to store additional medication name attributes. |
PK Name | Column |
---|---|
OHF_ETS_ET_FDB_MEDNAME_ATT_PK | ETSCONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_FDB_MEDNAME_ATTR_U1 | UNIQUE | ETSCONCEPT_ID |
Column | Comment |
---|---|
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. |
Comment: |
Peer table to OHF_ETS_ET_CONCEPTS to store additional medication concept attributes. |
PK Name | Column |
---|---|
OHF_ETS_ET_FDB_MED_CONCEPTS_PK | ETSCONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_FDB_MED_CONCEPTS_U1 | UNIQUE | ETSCONCEPT_ID |
Column | Comment |
---|---|
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. |
Comment: |
Peer table to HCT_ET_CONCEPTS to store additional NDC concept attributes. |
PK Name | Column |
---|---|
OHF_ETS_ET_FDB_NDC_CONCEPTS_PK | ETSCONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_FDB_NDC_CONCEPTS_U1 | UNIQUE | ETSCONCEPT_ID |
Column | Comment |
---|---|
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 |
Comment: |
Maps HL7 value sets to concepts in external (non-HL7) terminologies. |
PK Name | Column |
---|---|
OHF_ETS_ET_HL7_EXTERNAL_MAP_PK | TARGET_CONCEPT_ID |
VALUE_SET_CONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_HL7_EXTERNAL_MAP_U1 | UNIQUE | TARGET_CONCEPT_ID |
VALUE_SET_CONCEPT_ID |
Column | Comment |
---|---|
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. |
Comment: |
Associates HL7 external value sets with non-HL7 CodingSchemeVersions. |
PK Name | Column |
---|---|
OHF_ETS_ET_HL7_EXT_VAL_SET_PK | VALUE_SET_CONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_HL7_EXT_VALSETS_U1 | UNIQUE | VALUE_SET_CONCEPT_ID |
Column | Comment |
---|---|
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. |
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. |
PK Name | Column |
---|---|
OHF_ETS_ET_LANG_TER_MAPPING_PK | ISO_LANGUAGE |
ISO_TERRITORY | |
STATUS | |
VERSION_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_LANG_TER_MAPPINGS_FK1 |
VERSION_ID |
OHF_ETS_ET_VERSIONS |
VERSION_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_LANG_TER_MAPNGS_U1 | UNIQUE | ISO_LANGUAGE |
ISO_TERRITORY | ||
STATUS | ||
VERSION_ID |
Column | Comment |
---|---|
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. |
Comment: |
User defined descriptions of concepts. |
PK Name | Column |
---|---|
OHF_ETS_ET_LOCAL_DESCS_PK | LOCAL_DESCRIPTION_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Peer table to OHF_ETS_ET_CONCEPTS to support additional Loinc concept attributes. |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Mapping between concepts in different Coding Schemes. |
PK Name | Column |
---|---|
OHF_ETS_ET_MAP_CROSS_MAPS_PK | MAP_OPTION_NUM |
MAP_SET_ID | |
SOURCE_CONCEPT_ID | |
TARGET_CODE |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
A Map Set is a set of Cross Maps. Each Map Set enables mapping between two Coding Schemes. |
PK Name | Column |
---|---|
OHF_ETS_ET_MAP_MAP_SETS_PK | MAP_SET_ID |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_MAP_MAP_SETS_U1 | UNIQUE | MAP_SET_ID |
Column | Comment |
---|---|
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. |
Comment: |
Targets for a map set. |
PK Name | Column |
---|---|
OHF_ETS_ET_MAP_MAP_TARGETS_PK | MAP_SET_ID |
TARGET_CODE |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_MAP_MAP_TARGETS_FK1 |
MAP_SET_ID |
OHF_ETS_ET_MAP_MAP_SETS |
MAP_SET_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_MAP_MAP_TARGETS_U1 | UNIQUE | MAP_SET_ID |
TARGET_CODE |
Column | Comment |
---|---|
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. |
Comment: |
Mapping of targets and the concepts that they consist of. |
PK Name | Column |
---|---|
OHF_ETS_ET_MAP_TARG_CON_MAP_PK | CONCEPT_ID |
MAP_SET_ID | |
TARGET_CODE |
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 |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_MAP_TARG_CON_MAP_U1 | UNIQUE | CONCEPT_ID |
MAP_SET_ID | ||
TARGET_CODE |
Column | Comment |
---|---|
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. |
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. |
PK Name | Column |
---|---|
OHF_ETS_ET_MODELS_PK | MODEL_NAME |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_MODELS_U1 | UNIQUE | MODEL_NAME |
Column | Comment |
---|---|
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). |
Comment: |
This view HCT_ET_PRI_EQVLN_CNCPT_V collects collective information about concepts and their equivalent primary concepts. |
Column | Comment |
---|---|
CONCEPT_ID | ETS identifier for the concept. |
PRIMARY_EQUIVALENT_CONCEPT_ID | ETS identifier for the primary equivalent concept. |
Comment: |
Association between concepts. |
PK Name | Column |
---|---|
OHF_ETS_ET_RELATIONSHIPS_PK | RELATIONSHIP_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
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). |
Column | Comment |
---|---|
CODINGSCHEME_DESC | Coding scheme description. |
CODINGSCHEME_NAME | Name of the coding scheme as specified by a standard list such as HL7, LN for LOINC. |
Comment: |
Peer table to HCT_ET_CONCEPTS to support additional Snomed concept attributes. |
PK Name | Column |
---|---|
OHF_ETS_ET_SNOMED_CONCEPTS_PK | ETSCONCEPT_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Peer table to HCT_ET_DESCRIPTIONS to support additional Snomed concept description attributes. |
PK Name | Column |
---|---|
OHF_ETS_ET_SNOMED_DESCS_PK | ETS_DESCRIPTION_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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 |
Comment: |
Peer table to HCT_ET_RELATIONSHIPS to support additional Snomed concept relation attributes. |
PK Name | Column |
---|---|
OHF_ETS_ET_SNOMED_RELS_PK | ETS_RELATIONSHIP_ID |
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 |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Members of a SNOMED subset. |
PK Name | Column |
---|---|
OHF_ETS_ET_SNOMED_SBST_MEMS_PK | ETS_SUBSET_ID |
MEMBER_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_SNOMED_SBST_MEM_FK1 |
ETS_SUBSET_ID |
OHF_ETS_ET_SNOMED_SUBSETS |
ETS_SUBSET_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_SNOMED_SBST_MEMS_U1 | UNIQUE | ETS_SUBSET_ID |
MEMBER_ID |
Column | Comment |
---|---|
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 |
Comment: |
Defines the nature of a subset. |
PK Name | Column |
---|---|
OHF_ETS_ET_SNOMED_SUBSETS_PK | ETS_SUBSET_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_SNOMED_SUBSETS_FK1 |
VERSION_ID |
OHF_ETS_ET_VERSIONS |
VERSION_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_SNOMED_SUBSETS_U1 | UNIQUE | ETS_SUBSET_ID |
OHF_ETS_ET_SNOMED_SUBSETS_N1 | NONUNIQUE | SUBSET_NUM |
VERSION_ID |
Column | Comment |
---|---|
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. |
Comment: |
Used in combination with Local Descriptions. |
PK Name | Column |
---|---|
OHF_ETS_ET_USAGE_CONTEXTS_PK | USAGE_CONTEXT_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_USAGE_CONTEXTS_U1 | UNIQUE | USAGE_CONTEXT_ID |
OHF_ETS_ET_USAGE_CONTEXTS_N1 | NONUNIQUE | USAGE_CONTEXT_NAME |
Column | Comment |
---|---|
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. |
Comment: |
Intersection table between usage contexts and external identifiers. |
PK Name | Column |
---|---|
OHF_ETS_ET_USGCONTXT_ASSCTS_PK | OWNER_ID |
OWNER_TYPE_CODE |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_USGCONTXT_ASS_FK1 |
USAGE_CONTEXT_ID |
OHF_ETS_ET_USAGE_CONTEXTS |
USAGE_CONTEXT_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_USGCNTXT_ASSCTNS_U1 | UNIQUE | OWNER_ID |
OWNER_TYPE_CODE |
Column | Comment |
---|---|
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. |
Comment: |
Stores version information of coding schemes. |
PK Name | Column |
---|---|
OHF_ETS_ET_VERSIONS_PK | VERSION_ID |
FK Name |
Column |
RefTableName |
RefColumnName |
OHF_ETS_ET_VERSIONS_FK1 |
CODINGSCHEME_ID |
OHF_ETS_ET_CODING_SCHEMES |
CODINGSCHEME_ID |
Index | Type | Column |
---|---|---|
OHF_ETS_ET_VERSIONS_U1 | UNIQUE | VERSION_ID |
OHF_ETS_ET_VERSIONS_N2 | NONUNIQUE | CODINGSCHEME_ID |
OHF_ETS_ET_VERSIONS_N1 | NONUNIQUE | VERSION_NAME |
Column | Comment |
---|---|
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 |
Comment: |
Staging table for ETS attributes that may be attached to versions, concepts, descriptions, or relationships. |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_ATTRIBUTES_N1 | NONUNIQUE | ATT_SEQ |
LOAD_SEQ |
Column | Comment |
---|---|
ATT_SEQ | Attribute sequence number. |
LOAD_SEQ | Load sequence identifier. |
NAME | Name of the attribute. |
VALUE | Value of the attribute. |
Comment: |
Staging table to represent the contents of a classification. Concepts can be acted upon in different manners in a classification. |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_CLSSFCTN_DCLRNS_N1 | NONUNIQUE | ATT_SEQ |
LOAD_SEQ |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to represent the versions of a classification. |
Column | Comment |
---|---|
LOAD_SEQ | Load sequence identifier. |
LOAD_STATUS_CODE | A code specifying the status of the load. |
Comment: |
Staging table to store the information about all the coding schemes. |
Column | Comment |
---|---|
LOAD_DATE | Load date of the coding scheme. |
LOAD_SEQ | Load sequence identifier. |
NAME | Name of the coding scheme. |
Comment: |
Staging table to store the information about ETS Concepts (units of thought represented by codes and strings). |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Staging table for human-readable strings representation of a concept. |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_DESCS_N2 | NONUNIQUE | CONCEPT_CODE |
LOAD_SEQ | ||
OHF_ETS_ST_DESCS_N1 | NONUNIQUE | ATT_SEQ |
LOAD_SEQ |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store the log of the concept linking provided by the vendor. |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_EQVLNC_CLIQTRANS_N1 | NONUNIQUE | LINK_TYPE_CODE |
LOAD_SEQ | ||
SOURCE_CONCEPT_CODE | ||
TARGET_CONCEPT_CODE |
Column | Comment |
---|---|
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. |
Comment: |
Staging peer table to HCT_ST_CONCEPTS to store additional FDB classification attributes. |
PK Name | Column |
---|---|
OHF_ETS_ST_FDB_CLSSFCTNS_PK | CONCEPT_CODE |
LOAD_SEQ |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_FDB_CLSSFCTNS_U1 | UNIQUE | CONCEPT_CODE |
LOAD_SEQ |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store cross mapping of IDs for loading purposes. |
PK Name | Column |
---|---|
OHF_ETS_ST_FDB_ID_MAPPING_PK | LOAD_SEQ |
MAPPING_SOURCE_ID | |
MAPPING_TARGET_ID | |
RECORD_TYPE_CODE |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_FDB_ID_MAPPING_U1 | UNIQUE | LOAD_SEQ |
MAPPING_SOURCE_ID | ||
MAPPING_TARGET_ID | ||
RECORD_TYPE_CODE |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store additional medication name attributes. |
PK Name | Column |
---|---|
OHF_ETS_ST_FDB_MEDNAME_ATTR_PK | CONCEPT_CODE |
LOAD_SEQ |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_FDB_MEDNAME_ATTR_U1 | UNIQUE | CONCEPT_CODE |
LOAD_SEQ |
Column | Comment |
---|---|
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. |
Comment: |
Staging peer table to OHF_ETS_ST_CONCEPTS to store additional medication concept attributes. |
PK Name | Column |
---|---|
OHF_ETS_ST_FDB_MED_CONCEPTS_PK | CONCEPT_CODE |
LOAD_SEQ |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_FDB_MED_CONCEPTS_U1 | UNIQUE | CONCEPT_CODE |
LOAD_SEQ |
Column | Comment |
---|---|
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. |
Comment: |
Staging peer table to OHF_ETS_ST_CONCEPTS to store additional NDC concept attributes. |
PK Name | Column |
---|---|
OHF_ETS_ST_FDB_NDC_CONCEPTS_PK | CONCEPT_CODE |
LOAD_SEQ |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to map HL7 value sets to concepts in external (non-HL7) terminologies. |
Column | Comment |
---|---|
EXTERNAL_ID | Unique identifier for the HL7 external map. |
LOAD_SEQ | Load sequence identifier. |
TARGET_CONCEPT_CODE | Unique identifier for the HL7 target concept. |
Comment: |
Staging table to associate HL7 external value sets with non-HL7 CodingSchemeVersions. |
Column | Comment |
---|---|
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. |
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. |
Column | Comment |
---|---|
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. |
Comment: |
Staging peer table to OHF_ETS_ST_CONCEPTS to support additional Loinc concept attributes. |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_LOINC_CONCEPTS_N2 | NONUNIQUE | LOAD_SEQ |
OHF_ETS_ST_LOINC_CONCEPTS_N1 | NONUNIQUE | CONCEPT_CODE |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store the parts information of LOINC name |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_LOINC_PARTS_N2 | NONUNIQUE | PART_ID |
OHF_ETS_ST_LOINC_PARTS_N1 | NONUNIQUE | LOAD_SEQ |
Column | Comment |
---|---|
LOAD_SEQ | Load sequence identifier. |
PART_ID | LOINC part identifier. |
PART_TYPE | LOINC part type. |
Comment: |
Staging table to store the synonyms of LOINC parts. |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
LOAD_SEQ | Load sequence identifier. |
PART_SYNONYM | Synonym of loinc parts. |
SOURCE_CONCEPT | Concept identifier. |
SYNONYM_ID | Synonym identifier. |
Comment: |
Staging table to store LOINC synonym map information. |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_LOINC_SYNYM_MAP_N3 | NONUNIQUE | SYNONYM_ID |
OHF_ETS_ST_LOINC_SYNYM_MAP_N2 | NONUNIQUE | PART_ID |
Column | Comment |
---|---|
LOAD_SEQ | Load sequence identifier. |
PART_ID | LOINC part identifier. |
SYNONYM_ID | LOINC synonym identifier. |
Comment: |
Staging table for mapping between concepts in different Coding Schemes. |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store defining information about Map Sets (sets of Cross Maps). |
Column | Comment |
---|---|
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. |
Comment: |
Staging table defining targets for a map set. |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to map Targets and the Concepts they consist of. |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store association between concepts. |
Index | Type | Column |
---|---|---|
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 |
Column | Comment |
---|---|
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. |
Comment: |
Staging peer table to OHF_ETS_ST_CONCEPTS to support additional Snomed concept attributes. |
Column | Comment |
---|---|
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. |
Comment: |
Staging peer table to OHF_ETS_ST_DESCRIPTIONS to support additional Snomed concept description attributes. |
Column | Comment |
---|---|
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 |
Comment: |
Staging peer table to OHF_ETS_ST_RELATIONSHIPS to support additional Snomed concept relation attributes. |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store members of a SNOMED subset. |
Column | Comment |
---|---|
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 |
Comment: |
Staging table to define the nature of a subset. |
Column | Comment |
---|---|
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. |
Comment: |
Staging table to store version information of coding schemes. |
Index | Type | Column |
---|---|---|
OHF_ETS_ST_VERSIONS_N1 | NONUNIQUE | ATT_SEQ |
LOAD_SEQ |
Column | Comment |
---|---|
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. |