Tables & Views

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_ATTRIBUTES_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Name of this attribute.

Value of this attribute.

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

ETS identifier of the owner.

ETS identifier for the version of the owner.

ETS identifier for the concept.

Standard who column - user who created this row.

Standard who column - date when this row was created.

ETS identifier of the description.

Language code of the terminology concept description.

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.

Standard who column - user who last updated this row.

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

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

Specifies whether this is the preferred description.

Date when retired.

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

The actual word/phrase used for the description.

ETS identifier for the version.

ETS identifier for the concept.

Standard who column - user who created this row.

Standard who column - date when this row was created.

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

Language code of the terminology concept description.

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

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

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

ETS Identifier for the local description.

Retired date of this local description.

Status of the local description.

The actual word or phrase used for the local description.

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

ETS identifier for the version.

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

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

ETS identifier for the classification.

ETS identifier for the concept associated with the classification.

Standard who column - user who created this row..

Standard who column - date when this row was created.

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.

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

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

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

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CLSSFCTN_MAP_FK1

CLASSIFICATION_ID

OHF_ETS_ET_CONCEPTS

CONCEPT_ID

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

ETS identifier for the classification.

The CLIQUE_ID of the concept associated with the classification.

Standard who column - user who created this row..

Standard who column - date when this row was created.

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

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

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

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

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

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

The date when the concept becomes active.

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

The date when the concept retires from its concept list.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

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

Standard who column - user who last updated this row.

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

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

The locally preferred description for the concept.

This column is for future use.

A complete or descriptive name of the lookup value.

This column is for future use.

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

A name for printing purposes such as for documentation.

This column is for future use.

A shortened or abbreviated version of the lookup value name.

This column is for future use.

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

The terminology preferred description for the concept.

This column is for future use.

Name of the coding scheme associated with the concept.

ETS Identifier for the concept list

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

Source specified code for this concept.

ETS identifier for the concept.

Name of the coding scheme associated with the equivalent concept.

Source specified code for the equivalent concept.

ETS identifier for the equivalent concept.

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

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

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

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

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

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

Name of the coding scheme version associated with the concept.

Description of the concept list.

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

The date when the concept becomes active.

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

The date when the concept retires from its concept list.

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

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

Preferred description of the concept in the concept list.

Terminology description of the concept in the concept list.

Coding scheme description.

ETS identifier for the coding scheme

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

HL7 specified ISO OID for this coding scheme

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.

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

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

Version name for this source

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_CODING_SCHEMES_FK1

MODEL_NAME

OHF_ETS_ET_MODELS

MODEL_NAME

Coding scheme description.

ETS identifier for the coding scheme

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

HL7 specified ISO OID for this coding scheme

Standard who column - user who created this row.

Standard who column - date when this row was created.

Denotes whether the coding scheme is editable or not.

Standard who column - user who last updated this row.

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

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

Model name of the coding scheme.

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

Concept list description.

ETS Identifier for this concept list

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

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

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

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

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

Standard who column - user who last updated this row.

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

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

This identifies the id of the parent concept list.

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.

This flag identifies the status of the concept list.

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.

Description of the concept list.

ETS Identifier for the concept list

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

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

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

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

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

This identifies the id of the parent concept list.

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.

This flag identifies the status of the concept list.

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.

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

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

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

The CLIQUE_ID of the concept.

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.

ETS Identifier of the concept

Standard who column - user who created this row.

Standard who column - date when this row was created.

The domain with which the classification is associated.

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.

Standard who column - user who last updated this row.

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

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

The ETS identifier to which it has been reassigned.

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 of the concept.

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

ETS identifier for the version.

Name of the coding scheme associated with the concept.

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

Source specified code for this concept.

ETS identifier for the concept.

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

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

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

Name of the coding scheme version associated with the concept.

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

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

ETS identifier for the concept.

Standard who column - user who created this row.

Standard who column - date when this row was created.

ETS identifier of the description.

Language code of the terminology concept description.

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.

Standard who column - user who last updated this row.

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

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

Specifies whether this is the preferred description

Date when retired

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

The actual word/phrase used for the description.

ETS identifier for the version.

ETS identifier for the concept.

ETS identifier of the Description

Specifies whether this is the local preferred description.

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

Specifies whether this is the preferred description.

The actual word/phrase used for the description.

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_EQVLNC_CLIQ_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Unique identifier for the concept link.

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

Code to indicate a linking type for concepts.

The clique id of the source concept.

The clique id of the target concept.

ETS version identifier.

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

Standard who column - user who created this row.

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

Standard who column - date when this row was created.

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

The type of equivalence.

Standard who column - user who last updated this row.

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

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

The clique id of the source clique.

The clique id of the target clique.

ETS Identifier of the clique.

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

The equivalence context of the equivalence link.

Standard who column - user who last updated this row.

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

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

The map set id of the cross map equivalence.

The clique id of the source clique.

The clique id of the target clique.

Name of the coding scheme associated with the concept.

Source specified code for this concept.

ETS identifier for the concept.

Name of the coding scheme associated with the equivalent concept.

Source specified code for the equivalent concept.

ETS identifier for the equivalent concept.

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

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

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

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

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

Name of the coding scheme version associated with the concept.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

Indicates that at least one GCNSEQNO is associated.

Indicates whether it is a suggested level for building formularies.

Level of the Classification in the hierarchy.

Sort order for presentation of siblings.

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

Indicator to denote if this is the ultimate child.

ETS identifier for the FDB classification.

Standard who column - user who last updated this row.

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

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

ETS identifier for the version associated with the FDB classification.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

ETS identifier for the medication name.

Standard who column - user who last updated this row.

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

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

Code for the type of medication name.

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

ETS identifier for the version associated with the medication name.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

ETS identifier for the medication concept.

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

Generic medication Identifier.

Standard who column - user who last updated this row.

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

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

Medication GCN_SEQNO assignment code.

Medication Reference Federal DEA Class code.

Medication Reference Federal Legend indicator.

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

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

Text to represent the strength of the medication.

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

ETS identifier for the version associated with the medication concept.

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

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

Text to indicate the brand name.

Text to indicate the drug class code.

Standard who column - user who created this row.

Standard who column - date when this row was created.

Text to indicate the DEA code.

ETS identifier for the NDC concept.

Generic Code Number Sequence Number.

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

Generic Named Drug Indicator.

Text to indicate the HCFA Common Procedure Code.

Hierarchical Ingredient Code List Sequence Number.

Hospital Selection Indicator

Standard who column - user who last updated this row.

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

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

NDC Format Indicator.

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

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

Text to indicate the smart key number.

ETS identifier for the version associated with the NDC concept

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

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

Unique identifier for the HL7 value set.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

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.

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

ETS identifier for the version.

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_LANG_TER_MAPPINGS_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

Standard who column - user who created this row.

Standard who column - date when this row was created.

Language code of the terminology concept description.

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 Code which is mapped to the language of the terminology concept description. XX denotes all ISO_ TERRITORY other than specified explicitly

Standard who column - user who last updated this row.

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

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

Status of the mapping. Y/N

ETS identifier for the coding scheme version.

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

ETS identifier for the concept.

Standard who column - user who created this row.

Standard who column - date when this row was created.

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

Language code of the terminology concept description.

Standard who column - user who last updated this row.

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

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

ETS Identifier for the local description.

Retired date of this local description.

Status of the local description.

The actual word or phrase used for the local description.

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

ETS identifier for the version.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

ETS identifier for the LOINC concept.

Standard who column - user who last updated this row.

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

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

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

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

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

Chemical base name from CAS.

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

Reason term was changed.

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

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

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

Examples on CR0050 Cancer Registry.

Free-text comments relating to the test result.

The LOINC component name.

French name for LOINC term.

German name for LOINC term.

Italian name for LOINC term.

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

Date last changed, in the format YYYYMMDD.

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

Exact core component synonym.

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.

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

Internal LOINC use field.

Regression equation details for many OB.US calculated terms.

OMIM (Online Mendelian Inheritance in Man) names.

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

HCFA code.

Example units used by IUPAC/IFCC.

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

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.

The LOINC method code.

Metpath code.

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

Molecular structure ID, usually CAS number.

Maps to Multum Inc. database of codes for drugs.

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

Normal Range - Example answers from real tests.

List of individual tests that comprise a panel.

The LOINC property name.

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

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

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

The LOINC scale code.

Not currently used.

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

SNOMED Code.

Source text is for LOINC internal use.

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

For future use.

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

Example units as submitted by original requester.

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

Verbatim question from the survey instrument.

The LOINC system code.

The LOINC time aspect.

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

VA 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.

ETS identifier for the version associated with the LOINC concept.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

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

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

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

Standard who column - user who last updated this row.

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

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

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.

Unique SNOMED CT identifier for the Map Set.

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.

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

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

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

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

Map set description.

Unique identifier for the Map Set.

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

A name that describes the map set.

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

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

Version identifier of the source scheme.

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

Version identifier of the target scheme.

The name of the vendor that provided this map set.

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_MAP_MAP_TARGETS_FK1

MAP_SET_ID

OHF_ETS_ET_MAP_MAP_SETS

MAP_SET_ID

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

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

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

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

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

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

A concept code of a mapped concept for this target.

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

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

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

Designates the cache to be used for the caching implementation.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

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

Standard who column - user who last updated this row.

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

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

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

Description of the model.

Name of the terminology model.

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

ETS identifier for the concept.

ETS identifier for the primary equivalent concept.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

ETS identifier for the relationship type concept.

ETS identifier for the relationship.

Retired date of the relationship.

ETS identifier for the source concept.

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

ETS identifier for the target concept.

ETS version identifier.

Coding scheme description.

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

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

The clinical terms version 3 identifier for the concept.

null

Unique SNOMED CT identifier.

Standard who column - user who last updated this row.

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

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

null

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

The SNOMED RT identifier for the concept.

Status whether the concept is in use.

ETS identifier for the version.

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

null

ETS identifier for the SNOMED description.

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

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

Standard who column - user who last updated this row.

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

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

null

Unique SNOMED CT identifier for the description.

Indicate whether the description is in use.

null

ETS identifier for the version

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

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

null

null

ETS identifier for the SNOMED CT relationship.

Standard who column - user who last updated this row.

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

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

null

null

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

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

Unique SNOMED CT identifier for the relationship.

ETS identifier for the version.

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_SNOMED_SBST_MEM_FK1

ETS_SUBSET_ID

OHF_ETS_ET_SNOMED_SUBSETS

ETS_SUBSET_ID

Standard who column - user who created this row.

Standard who column - date when this row was created.

null

ETS identifier for the SNOMED CT subset.

Standard who column - user who last updated this row.

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

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

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

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

null

null

null

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_SNOMED_SUBSETS_FK1

VERSION_ID

OHF_ETS_ET_VERSIONS

VERSION_ID

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

Standard who column - user who created this row.

Standard who column - date when this row was created.

ETS identifier for the SNOMED CT subset.

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

Standard who column - user who last updated this row.

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

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

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.

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

Unique SNOMED CT identifier for the subset.

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

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

An integer incremented for each release of a subset.

ETS identifier for the version.

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

Description of the usage context.

Unique identifier for the usage context.

Name of the usage context.

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_USGCONTXT_ASS_FK1

USAGE_CONTEXT_ID

OHF_ETS_ET_USAGE_CONTEXTS

USAGE_CONTEXT_ID

Standard who column - user who created this row.

Standard who column - date when this row was created.

Standard who column - user who last updated this row.

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

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

Unique external identifier

Application that owns the external identifier.

Usage context identifier.

FK Name

Column

RefTableName

RefColumnName

OHF_ETS_ET_VERSIONS_FK1

CODINGSCHEME_ID

OHF_ETS_ET_CODING_SCHEMES

CODINGSCHEME_ID

ETS identifier for the parent coding scheme this source belongs to

Standard who column - user who created this row.

Standard who column - date when this row was created.

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.

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

Standard who column - user who last updated this row.

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

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

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

Date when retired

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

Description of the version.

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

Version name for this source

Attribute sequence number.

Load sequence identifier.

Name of the attribute.

Value of the attribute.

Attribute sequence number.

Code specified for the classification.

ETS identifier for the classification.

Name of the coding scheme associated with the classification.

Version of the coding scheme associated with the classification.

Source defined code for the concept associated with the classification.

ETS identifier for the concept associated with the classification.

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 sequence identifier.

Load sequence identifier.

A code specifying the status of the load.

Load date of the coding scheme.

Load sequence identifier.

Name of the coding scheme.

Attribute sequence number.

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 identifier.

Retired date of the concept.

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 sequence identifier.

The identifier to which it has been reassigned

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

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

Attribute sequence number.

Concept code associated with the description.

Date when retired.

Description identifier.

Language code of the terminology concept description.

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 sequence identifier.

Specifies whether this is the preferred description.

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

The actual word/phrase used for the description.

Code to indicate a linking type for concepts.

Load Sequence identifier.

Vendor specified code for the source concept.

Vendor specified code for the target concept.

Vendor specified code for a concept.

Indicates that atleast one GCNSEQNO is associated.

Indicates whether it is a suggested level for building formularies.

Level of the Classification in the hierarchy.

Sort order for presentation of siblings.

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

Indicator to denote if this is the ultimate child.

Load Sequence identifier.

Load Sequence identifier.

Identifier for the source record.

Identifier for the target record.

Type of record.

Source specified code for a concept.

Load Sequence identifier.

Code for the type of medication name.

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

Source specified code for a concept.

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

Generic medication Identifier.

Load Sequence identifier.

Medication GCN_SEQNO assignment code.

Medication Reference Federal DEA Class code.

Medication Reference Federal Legend indicator.

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

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

Text to represent the strength of the medication.

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

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

Text to indicate the brand name.

Text to indicate the drug class code.

Source specified code for a concept.

Text to indicate the DEA code.

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

Generic Code Number Sequence Number.

Generic Named Drug Indicator.

Text to indicate the HCFA Common Procedure Code.

Hierarchical Ingredient Code List Sequence Number.

Hospital Selection Indicator.

Load Sequence identifier.

NDC Format Indicator.

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

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

Text to indicate the smart key number.

Unique identifier for the HL7 external map.

Load sequence identifier.

Unique identifier for the HL7 target concept.

Unique identifier for the HL7 external value set.

Load sequence identifier.

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.

Name of the scheme.

Version identifier.

Language code of the terminology concept description.

ISO Language code.

ISO Territory code.

Load sequence identifier.

Status of the mapping. Y/N.

LOINC concept code.

Load sequence identifier.

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

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

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

Chemical base name from CAS.

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

Reason term was changed.

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

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

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

Examples on CR0050 Cancer Registry.

Free-text comments relating to the test result.

The LOINC component name.

French name for LOINC term.

German name for LOINC term

Italian name for LOINC term.

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

Date last changed, in the format YYYYMMDD.

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

Exact core component synonym.

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.

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

Internal LOINC use field.

Regression equation details for many OB.US calculated terms.

OMIM (Online Mendelian Inheritance in Man) names.

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

HCFA code.

Example units used by IUPAC/IFCC.

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

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.

The LOINC method code.

Metpath code.

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

Molecular structure ID, usually CAS number.

Maps to Multum Inc. database of codes for drugs.

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

Normal Range - Example answers from real tests.

List of individual tests that comprise a panel.

The LOINC property name.

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

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

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

The LOINC scale code.

Not currently used.

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

SNOMED Code.

Source text is for LOINC internal use.

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

For future use.

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

Example units as submitted by original requester.

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

Verbatim question from the survey instrument.

The LOINC system code.

The LOINC time aspect.

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

VA 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.

Load sequence identifier.

LOINC part identifier.

LOINC part type.

Load sequence identifier.

Synonym of loinc parts.

Concept identifier.

Synonym identifier.

Load sequence identifier.

LOINC part identifier.

LOINC synonym identifier.

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

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

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

The equivalence context of the cross map.

Load sequence identifier.

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.

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 for this cross map.

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

Load sequence identifier.

Load status of the map sets.

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

Map set description.

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

A name that describes the map set.

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

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

Version identifier of the source scheme.

Version identifier of the target scheme.

The name of the vendor that provided this map set.

Load sequence identifier.

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

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

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

Vendor specified code for the concept.

Load sequence identifier.

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

Attribute sequence number.

Retired date of the relationship.

Load sequence identifier.

Identifier of the relationship concept.

Relationship identifier.

Identifier of the source concept.

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

Identifier of the target concept.

SNOMED CT concept identifier.

Status whether the concept is in use.

The clinical terms version 3 identifier for the concept.

null

Fully specified name of the concept.

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

Load sequence identifier.

null

The current SNOMED identifier for the concept.

null

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

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

Load sequence identifier.

null

SNOMED description identifier.

Status whether the description is in use.

null

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

null

null

Load sequence identifier.

null

null

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

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

SNOMED relationship identifier.

null

ETS identifier for the SNOMED CT subset.

load sequence identifier.

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

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

null

null

Identifier for the SNOMED subset.

null

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

ETS identifier for the SNOMED CT subset.

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

Load sequence identifier.

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.

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

Unique SNOMED CT identifier for the subset.

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

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

An integer incremented for each release of a subset.

Attribute sequence number.

Standard who column - date when this row was created.

Description of the version.

This column is for future use.

This column is for future use.

Load date of the version.

Load sequence identifier.

Load status of the coding scheme version.

Version name for this source.

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 identifier.