Page History

MRSAB.RRF

SVER

Release date or version number of a source

codingScheme.representsVersion

MRSAB.RRF

SSN

Source short name

codingScheme.codingScheme

MRSAB.RRF

SON

Source Official Name

codingScheme.formalName

MRSAB.RRF

LAT

Language of Term(s)

codingScheme.defaultLanguage

MRSAB.RRF

TRF

Term frequency for a source

codingScheme.approxNumConcepts

MRSAB.RRF

SCIT

Source citation

codingScheme.entityDescription

inherits entityDescription from versionableAndDescribable

MRSAB.RRF

SCC

Content contact info for a source

codingScheme.copyright

codingScheme.registeredName

Pulled from iso mapping configuration file using method getISOString(RSAB from MRSAB.RRF)

MRDOC.RRF

EXPL

Detailed explanation

x

codingScheme.representsVersion

Where Dockey = "RELEASE" and value = "umls.release.name"

x

codingScheme.codingScheme

Hard coded in java file as "NCI MetaThesaurus"

x

codingScheme.formalName

Hard coded in java file as "NCI MetaThesaurus"

x

codingScheme.defaultLanguage

Hard coded in java file as "ENG"

MRCONSO.RRF

x

codingScheme.approxNumConcepts

Count of CODE value in MRCONSO.RRF

x

codingScheme.entityDescription

Hard coded in java file as "NCI MetaThesaurus loaded from RRF files."

x

codingScheme.copyright

Hard coded in java file as "Some material in the NCI Metathesaurus is from copyrighted sources of the respective copyright claimants. All sources appearing in the NCI Metathesaurus are licensed or authorized for NCI use. Users of the NCI Metathesaurus are responsible for compliance with the terms of these licenses and with any copyright restrictions and are referred to NCI Center of Bioinformatics for license terms and to the copyright notices appearing in the original sources, all of which are obtainable online by reference at

http://ncimeta.nci.nih.gov/

."

codingScheme.localNameList

Hard coded as constant in java file as "localName"

MRSAB.RRF

SON

Source Official Name

codingScheme.localNameList.

codingScheme.localNameList

Hard coded as constant in java file as "localName"

codingScheme.localNameList.

Pulled from iso mapping configuration file using method getISOString(RSAB from MRSAB.RRF)

codingScheme.source

Hard coded as constant in java file as "source"

MRDOC.RRF

EXPL

Detailed explanation

codingScheme.source.content

String concatenation of "UMLS-" and value of EXPL

x

codingScheme.localNameList

Hard coded as constant in java file as "localName"

x

codingScheme.localNameList.

Hard coded in java file as "NCI Thesaurus"

x

codingScheme.localNameList

Hard coded as constant in java file as "localName"

x

codingScheme.localNameList.

Hard coded in java file as "NCI_Thesaurus"

x

codingScheme.localNameList

Hard coded as constant in java file as "localName"

x

codingScheme.localNameList.

Hard coded in java file as "10001"

x

codingScheme.localNameList

Hard coded as constant in java file as "source"

x

codingScheme.localNameList.

Hard coded in java file as "RRF Files"

mappings.supportedFormat

Hard coded as constant in java file as "Format"

mappings.supportedFormat.localId

Hard coded as one of several constants in a java file

mappings.supportedAssociation

Hard coded as constant in java file as "Association"

MRREL.RRF

REL, RELA

Relationship, Relationship attribute

mappings.supportedAssociation.localId

mappings.supportedContext

Hard coded as constant in java file as "Context" May not be used in individual RRF load

mappings.supportedSource

Hard coded as constant in java file as "Source" May not be used in individual RRF load

mappings.supportedHierarchy

Hard coded as constant in java file as "Hierarchy"

mappings.supportedAssociationQualifier

Hard coded as constant in java file as "AssociationQualifier"

mappings mappings.supportedProperty

Hard coded as constant in java file as "Property"

mappings.supportedLanguage

Hard coded as constant in java file as "Language"

mappings.supportedCodingScheme

Hard coded as constant in java file as "CodingScheme"

mappings.supportedRepresentationalForm

Hard coded as constant in java file as "RepresentationalForm"

mappings.supportedConceptStatus

Hard coded as constant in java file as "ConceptStatus"

mappings.supportedPropertyLink

Hard coded as constant in java file as "PropertyLink"

mappings.supportedPropertyQualifier

Hard coded as constant in java file as "PropertyQualifier"

mappings.supportedDataType

Hard coded as constant in java file as "DataType" <big>Concepts</big>

MRCONSO.RRF

CODE

Unique Identifier or code for string in source

concept.conceptCode

MRCONSO.RRF

CUI

Unique identifier for concept

x

concept.conceptCode

concept.isActive

Hardcoded in parameter as true.

concept.conceptStatus

Hard coded as constant in java file as "Active"

concept.isAnonymous

Hardcoded in parameter as false.

MRCONSO.RRF

STR

String

concept.entityDescription

concept.conceptProperty.Format

Hard coded as constant in java file as "text/plain" or null

concept.conceptProperty.propertyName

May be hard coded as constant in java file as one of several properties.

concept.conceptProperty.usageContext

concept.conceptProperty.propertyId

Generated value for property using "P" concatenated with a steadily incremented numerical value.

concept.presentation.propertyId

Generated value for property textual presentation using "T" concatenated with a steadily incremented numerical value.

concept.comment.propertyId

Generated value for property comment using "C" concatenated with a steadily incremented numerical value.

concept.definition.propertyId

Generated value for property definition using "D" concatenated with a steadily incremented numerical value.

concept concept.instruction.propertyId

Generated value for property instruction using "I" concatenated with a steadily incremented numerical value.

MRCONSO.RRF

CUI

Unique identifier for concept

concept.conceptProperty.text.content.

concept.conceptProperty.propertyId

Generated value for property using "CUI" concatenated with a steadily incremented numerical value.

concept.conceptProperty.propertyName

hard coded as constant in java file as "UMLS_CUI"

concept.conceptProperty.propertyType

hard coded as constant in java file as "property"

concept.conceptProperty.format

left as null

MRSTY.RRF

STY

Semantic type

concept.conceptProperty.text.content

concept.conceptProperty.propertyId

Generated value for property using "SemType" concatenated with a steadily incremented numerical value.

concept.conceptProperty.propertyName

hard coded as constant in java file as "Semantic_Type"

concept.conceptProperty.propertyType

hard coded as constant in java file as "property"

concept.conceptProperty.format

Hard coded as constant in java file as "text/plain"

MRCONSO.RRF

LAT

Language of Term(s)

concept.conceptProperty.language

Logic of code simply selects the first definition in the source as the preferred source

MRCONSO.RRF

TS

Term status

concept.presentation.isPreferred

One or a combination of these RRF values determines whether a presentation is preferred: LAT, TS, STT, ISPREF, RANK.

MRCONSO.RRF

STT

String type

concept.presentation.isPreferred

One or a combination of these RRF values determines whether a presentation is preferred: LAT, TS, STT, ISPREF, RANK.

MRCONSO.RRF

ISPREF

Indicates whether AUI is preferred

concept.presentation.isPreferred

One or a combination of these RRF values determines whether a presentation is preferred: LAT, TS, STT, ISPREF, RANK.

MRRANK.RRF

RANK

Termgroup ranking

concept.presentation.isPreferred

One or a combination of these RRF values determines whether a presentation is preferred: LAT, TS, STT, ISPREF, RANK.

concept.presentation.isPreferred

MRDEF.RRF

DEF

Definition

concept.definition.text.content

concept.definition.isPreferred

Logic of code simply selects the first definition in the source as the preferred source  

MRSAT.RRF

ATN

Attribute name

concept.conceptProperty.propertyType

Translated to a LexGrid property type. For values AN, CX, HN this property is typed as a "COMMENT" in LexGrid. For value EV this property is typed "PRESENTATION" This only occurs when the STYPE points to the CODE, SCUI or SDUI columns in MRREL.RRF or MRCONSO.RRF. If the STYPE points to SAUI then the values are loaded as property qualifiers.

MRSAT.RRF

ATV

Attribute value

concept.conceptProperty.propertyValue

MRSAT.RRF

ATN

Attribute name

concept.conceptProperty.propertyQualifier.propertyQualifierId

If the STYPE points to SAUI then the value is loaded as a property qualifier attribute

MRSAT.RRF

ATV

Attribute value

concept.conceptProperty.propertyQualifier.content

If the STYPE points to SAUI then the value is loaded as a property qualifier attribute

MRCONSO.RRF

SAB

x

concept.conceptProperty.source.content

x

concept.conceptProperty.propertyQualifier.propertyQualifierId

hard coded as constant in java file as "source-code"

MRCONSO.RRF

CODE

x

concept.conceptProperty.propertyQualifier.content

x

concept.conceptProperty.propertyQualifier.propertyQualifierId

hard coded as constant in java file as "AUI"

MRCONSO.RRF

AUI

x

concept.conceptProperty.propertyQualifier.content

concept.presentation.representationalForm

When ATN value is EV this presentation will be given a representationalForm of "Abbrev."

MRCONSO.RRF

TTY

Term type in source

concept.presentation.representationForm

When TTY value is FN then representationalForm is represented as "Full Form" Otherwise the representationalForm is the same as the TTY source (i.e. if TTY is PT then representationalForm is PT.) PT is one of the preferred presentations.

concept concept.conceptProperty.propertyQualifier.propertyQualifierId

hard coded as "HCD"

MRHIER.RRF

HCD

Source asserted hierarchical number or code for this atom in this context

concept.conceptProperty.propertyQualifier.content

This propertyQualifier is present when the HCD is populated in the the MRHIER file. The corresponding code and property for concept or code is qualified as a code or concept with a context derived heirarchy. <big>Relations</big>

MRREL.RRF

CUI1

Unique identifier for first concept

MRREL.RRF

AUI1

Unique identifier for first atom

MRCONSO.RRF

CODE

Unique Identifier or code for string in source

ConceptReference.conceptCode

(Model element is a ResolvedConceptReference with the value sourceOf attached to the appropriate AssociationList containing this particular REL or RELA association name.) Mapping to the CODE depends upon the CUI or a combination of CUI and AUI values. If the CODE value is "NOCODE" then LexBIG concatenates "NOCODE" with a "-" and the CUI value. Target or source code value requires use of the DIR flag which indicates the directionality of the relationship in REL or RELA. CUI1 can be used as a pointer to the source CODE value if DIR equals Y, else CUI1 is the targetCode. Similarly, if an AUI exists AUI1 can be an indicator for CODE value to be either or source or target depending on the DIR flag.

MRREL.RRF

CUI2

Unique identifier for second concept

MRREL.RRF

AUI2

Unique identifier for second atom

MRCONSO.RRF

CODE

Unique Identifier or code for string in source

ConceptReference.conceptCode

(Model element is a ResolvedConceptReference with the value targetOf attached to the appropriate AssociationList containing this particular REL or RELA association name.) Mapping to the CODE depends upon the CUI or a combination of CUI and AUI values. If the CODE value is "NOCODE" then LexBIG concatenates "NOCODE" with a "-" and the CUI value. Target or source code value requires use of the DIR flag which indicates the directionality of the relationship in REL or RELA. CUI2 can be used as a pointer to the source CODE value if DIR equals Y, else CUI1 is the targetCode. Similarly, if an AUI exists AUI2 can be an indicator for CODE value to be either or source or target depending on the DIR flag.

MRREL.RRF

DIR

Source asserted directionality flag

The UMLS directional flag. Y indicates that this is the direction of the RELA relationship in its source; N indicates that it is not; otherwise indicates that it is not important or has not yet been determined. (If blank RELA, we interpret as 'N', based on empirical review of meta files).  

MRREL.RRF

RELA

Relationship attribute

association.id (id inherited from Entity)

Source defined associations. If RELA value is "inverse_isa" then it is changed to "hasSubtype." All others mapped as defined in source.  

MRREL.RRF

REL

Relationship

association.id (id inherited from Entity)

UMLS defined associations  

MRSAT.RRF

METAUI

Metathesaurus asserted unique identifier

Presence of RUI in MRSAT.RRF METAUI column indicates the association defined in MRREL has an association qualifier. Currently only MedDRA uses these.

MRSAT.RRF

ATN

AssociatedConcept.nameAndValueList.name

MRSAT.RRF

ATV

AssociationQualification.nameAndValueList.content

AssociatedConcept.nameAndValueList.name

qualifier name is hard coded to "HCD" This association qualifier is attached to an association when the HCD field in MRHIER.RRF is populated. Associations are identified by evaluating a structured series of AUI's that describe the path to root (PTR field in MRHIER) Once these associations are identified they have and association qualifier attached to them with the value of the HCD loaded as the qualifier.

MRHIER.RRF

HCD

AssociationQualification.nameAndValueList.content

MRSAB.RRF

SSN

Source short name

association.codingSchemeId (Inherited from Entity)

MRREL.RR

REL or RELA

Relationship or Relationship attribute

association.forwardName

unqualified REL or RELA value (inverse_isa remains the same)

MRDOC.RRF

EXPL

Detailed explanation

association.reverseName

Where DOCKEY in MRDOC equals REL or RELA and value is the association name and TYPE is REL or RELA name prepended to "_inverse".

association.inverse

Hard coded as a blank string.

association.isAntiReflexive

hard coded to null.

association.isAntiSymmetric

hard coded to null.

association.isAntiTransitive

hard coded to null.

association association.isAntiTransitive

hard coded to null.

association.isNavigable

hard coded as Boolean with value true.

association.isReflexive

hard coded to null.

association.isReverseFunctional

hard coded to null.

association.isSymmetric

hard coded to null.

MRREL.RRF

SAB, REL, RELA

Source abbreviation

association.isTransitive

True when the name of the association can be mapped to a source defined in the SAB attribute of MRREL.RRF. Not the SAB value itself, but extrapolated from it using SAB to REL, RELA relationship.

association.isTranslationAssociation

hard coded to null.

association.targetCodingScheme

hard coded to null.

association.entityDescription.content (inheritance path for entityDescription is Entity->versionableAndDescribable)

Hard coded to: "UMLS-defined relationships"

relations.dc

If REL, this is hard coded as "UMLS-Relations" if RELA then it is hard coded to "Relations"

MRREL.RRF

REL, RELA

x

propertyLink.link

This is a link established when the MRREL.RRF file contains a relationship where the CUI is related to itself. Under these conditions the relationship is mapped as a property link with the MRREL defined relationship mapped as the link value.

x

propertyLink.sourceProperty

Generated as a propertyId for concept, ex: "T-10" This is retrieved based on the AUI value in MRCONSO.RRF from the entityPropertyMultiAttrib table where the AUI equals the attributeValue column.

x

propertyLink.targetProperty

Generated as a propertyId for concept, ex: "T-10" This is retrieved based on the AUI value in MRCONSO.RRF from the entityPropertyMultiAttrib table where the AUI equals the attributeValue column.

RSAB.RRF

SVER

Release date or version number of a source

codingScheme.representsVersion

RSAB.RRF

SSN

Source short name

codingScheme.codingScheme?

RSAB.RRF

SON

Source Official Name

codingScheme.formalName

codingScheme.defaultLanguage

Hard coded to "en" codingScheme.defaultLanguage

MRSAT.RRF

ATV

concept.presentation.language

Unique to snomed.

Document Header

format-version

Not mapped.

Document Header

data-version

CodingScheme.representsVersion

Creates a codingSchemeVersion and SystemRelease record. If not specified, then hard coded "UNASSIGNED"

Document Header

version

CodingScheme.representsVersion

Deprecated - use data-version if present.

Document Header

date

Not mapped.

Document Header

saved-by

Ignored but included if contained in the remark entity.

Document Header

auto-generated-by

Ignored but included if contained in the remark entity.

Document Header

subsetdef

Not mapped.

Document Header

import

Deprecated - Imports are used to assemble a larger document from smaller.

Document Header

typeref

Deprecated.

Document Header

synonymtypedef

Not mapped.

Document Header

idspace

Not mapped.The idspace is a triple - localName, URN and description.

Document Header

default-relationship-id-prefix

Not mapped.

Document Header

id-mapping

CodingScheme.supportedAssociation

This is more generalized than the LexGrid model, as it supports mapping between any id's. Note that its primary purpose, however, is to handle supportedAssociation.

Document Header

remark

CodingScheme.entityDescription

Will combine multiple remark entities into the entityDescription.

Document Header

default-namespace

codingScheme.codingScheme

Will use default-namespace if provided; otherwise will use filename without the extension.

Document Header

default-namespace

codingScheme.formalName

Will use default-namespace if provided; otherwise will use filename without the extension.

Document Header

default-namespace

codingScheme.registeredName

Combination of "urn:lsid:bioontology.org:" and if provided, the value in "default-namespace"; but if not will use filename without the extension.

codingScheme.defaultLanguage

Hardcoded "en"

codingScheme.isNative

Hardcoded "true"

Stanza

id

CodedEntry.conceptCode

Stanza

name

CodedEntry.entityDescription

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="bd41bd00-0820-4e01-908e-72f986474762"><ac:plain-text-body><![CDATA[

  CodedEntry.presentation'textualPresentation'.text

CodedEntry.presentation['textualPresentation'.isPreferred = true ].text

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1f22b2da-caff-42ff-9c5a-c4116292f7fa"><ac:plain-text-body><![CDATA[

Stanza

alt_id

CodedEntry.property'alt_id'.propertyId

CodedEntry.property'alt_id'.text

Stanza

is_anonymous

CodedEntry.isAnonymous = true

Stanza

is_obsolete

CodedEntry.isActive = false

Stanza

def

CodedEntry.definition

CodedEntry.definition.isPreferred = true

Stanza

def.dbxref

See dbxref

Stanza

comment

CodedEntry.comment.text

Stanza

subset

propertysubset tag

See subsetdef

Stanza

syonym

presentation'textualPresentation'.text

Stanza

synonym.scope

presentation'textualPresentation'.degreeOfFidelity

Stanza

synonym.type

presentation'textualPresentation'.representationalForm

Stanza

synonym.dbxref

(see dbxref)

Stanza

exact_synonym

See synonym

Stanza

narrow_synonym

See synonym

Stanza

broad_synonym

See synonym

Stanza

xref

associations.'mapsTo'

Stanza

xref_analog

See synonym

Stanza

xref_unk

Stanza

is_a

associations.'hasSubtype'

Reverse of the source and target.

presentation['textualPresentation'].isPreferred = true

]]></ac:plain-text-body></ac:structured-macro>

Stanza

alt_id

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="35ef4c5d-1c3d-4554-a37c-2230d85866f1"><ac:plain-text-body><![CDATA[

CodedEntry.property['alt_id'].propertyId

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="45eb2fe2-b05d-403c-9e58-9ef114595e34"><ac:plain-text-body><![CDATA[

CodedEntry.property['alt_id'].text

]]></ac:plain-text-body></ac:structured-macro>

Stanza

is_anonymous

CodedEntry.isAnonymous = true

Stanza

is_obsolete

CodedEntry.isActive = false

Stanza

def

CodedEntry.definition

CodedEntry.definition.isPreferred = true

Stanza

def.dbxref

See dbxref

Stanza

comment

CodedEntry.comment.text

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f0511cd1-9915-4f34-b5d9-e0325524192e"><ac:plain-text-body><![CDATA[

Stanza

subset

property[subset tag]

See subsetdef

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1b7bd8bf-6cde-40d4-ad20-974070869847"><ac:plain-text-body><![CDATA[

Stanza

synonym

presentation['textualPresentation'].text

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c3f99739-93e2-436a-8aa0-5026c472ca1f"><ac:plain-text-body><![CDATA[

Stanza

synonym.scope

presentation['textualPresentation'].degreeOfFidelity

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="a559206d-0419-4128-b8a6-2b07b2acdf65"><ac:plain-text-body><![CDATA[

Stanza

synonym.type

presentation['textualPresentation'].representationalForm

]]></ac:plain-text-body></ac:structured-macro>

Stanza

synonym.dbxref

(see dbxref)

Stanza

exact_synonym

See synonym

Stanza

narrow_synonym

See synonym

Stanza

broad_synonym

See synonym

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="0958cbbb-8dcf-4018-b10c-6b8cf4a976df"><ac:plain-text-body><![CDATA[

Stanza

xref

associations.['mapsTo']

]]></ac:plain-text-body></ac:structured-macro>

Stanza

xref_analog

See synonym

Stanza

xref_unk

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="68356166-b79b-41d0-b722-63657401c7a1"><ac:plain-text-body><![CDATA[

Stanza

is_a

associations.['hasSubtype']

Reverse of the source and target.

]]></ac:plain-text-body></ac:structured-macro>

Stanza

is_a.namespace

If present, the supplied namespace becomes the owning "codingScheme".

Stanza

is_a.derived

associations.hasSubtype.associationQualifier

If present, need to include derived in the supportedAssociationQualifiers section

Stanza

intersection_of

Processed the same way that OWL intersection operator is processed. This includes creation of anonymous sets.

Stanza

union_of

Same as OWL

Stanza

disjoint_from

Same as OWL

Stanza

relationship

associations.

Stanza

relationship.not_necessary

associations..associationQualifier

Stanza

relationship.inverse_necessary

associations..associationQualifier

Stanza

relationship.namespace

If present

Stanza

is_a.namespace

If present, the supplied namespace becomes the owning "codingScheme".

Stanza

relationship.derived

associations..associationQualifier

Stanza

relationship.cardinality

associations..associationQualifier

Stanza

relationship.maxCardinality

associations..associationQualifier

Stanza

relationship.minCardinality

associations..associationQualifier

Stanza

is_a.derived

associations.hasSubtype.associationQualifier

If present, need to include derived in the supportedAssociationQualifiers section

Stanza

intersection_of

Processed the same way that OWL intersection operator is processed. This includes creation of anonymous sets.

Stanza

union_of

Same as OWL

Stanza

disjoint_from

Same as OWL

Stanza

relationship

associations.

Stanza

relationship.not_necessary

associations..associationQualifier

Stanza

relationship.inverse_necessary

associations..associationQualifier

Stanza

relationship.namespace

If present, the supplied namespace becomes the owning "codingScheme".

Stanza

relationship.derived

associations..associationQualifier

Stanza

relationship.cardinality

associations..associationQualifier

Stanza

relationship.maxCardinality

associations..associationQualifier

Stanza

relationship.minCardinality

associations..associationQualifier

Stanza

is_obsolete

codedEntry.isActive = false

Stanza

replaced_by

Stanza

consider

Not Mapped

Stanza

use_term

(deprecated)

dbxref

dbxref name

CodedEntry..source

supportedSource

dbxref name format is inconsistent. In most cases, it can be the localName of supportedSource, but special processing may be necessary in the case of URL's, etc

dbxref

dbxref description

Not mapped.

dbxref

trailing modifiers

Not mapped.

typeDef Stanza

domain

associations.'has_domain'

typeDef Stanza

range

associations.'has_range'

typeDef Stanza

is_cyclic

property'is_cyclic'

typeDef Stanza

is_reflexive

property'is_reflexive'

association.isReflexive

typeDef Stanza

is_symmetric

property'is_symmetric'

_obsolete

codedEntry.isActive = false

Stanza

replaced_by

Stanza

consider

Not Mapped

Stanza

use_term

(deprecated)

dbxref

dbxref name

CodedEntry..source

supportedSource

dbxref name format is inconsistent. In most cases, it can be the localName of supportedSource, but special processing may be necessary in the case of URL's, etc

dbxref

dbxref description

Not mapped.

dbxref

trailing modifiers

Not mapped.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="598814ef-2e4f-4735-9217-4ad0f380d287"><ac:plain-text-body><![CDATA[

typeDef Stanza

domain

associations.['has_domain']

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="86da471a-5932-4384-86f1-2c67c263d9cb"><ac:plain-text-body><![CDATA[

typeDef Stanza

range

associations.['has_range']

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="52eb11c8-bc58-4fc0-9ec6-357d68f43fb3"><ac:plain-text-body><![CDATA[

typeDef Stanza

is_cyclic

property['is_cyclic']

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="768b6af3-4b4a-4d51-9336-d2b4460bf44b"><ac:plain-text-body><![CDATA[

typeDef Stanza

is_reflexive

property['is_reflexive']

]]></ac:plain-text-body></ac:structured-macro>

association.isReflexive

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="45253021-49d9-4d52-9ac8-6576b8a06137"><ac:plain-text-body><![CDATA[

typeDef Stanza

is_symmetric

property['is_symmetric']

]]></ac:plain-text-body></ac:structured-macro>

association.isSymmetric

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="35c8ecce-d0fc-4b4a-9c73-204c3ffe9186"><ac:plain-text-body><![CDATA[

association.isSymmetric

typeDef Stanza

is_transitive

property['is_transitive']

]]></ac:plain-text-body></ac:structured-macro>

association.isTransitive

  association.isTransitive

typeDef Stanza

inverse_of

association.inverse

instance stanza

id

same rules as general stanza

same rules as general stanza

instance stanza

name

same rules as general stanza

same rules as general stanza

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="566d289f-ccdd-4766-89f5-ac11050ea3fd"><ac:plain-text-body><![CDATA[

instance stanza

instance_of

association['has_instance']

]]></ac:plain-text-body></ac:structured-macro>

instance stanza

CodedEntry.property.property=""

data type properties go in Coded Entry property section

Model

<modelID>

<codingSchemeName>

<name>

<formalName>

<registeredName>

http://www.hl7.org/Library/data-model/RIM

*1

<defaultLanguage>

en*

<versionNumber>

<representsVersion>

<isNative>

0* *

<approximateNumberofConcepts>

Result of count on concept bearing table?

<firstRelease>

MISSING

<modifiedRelease>

MISSING

<deprecated>

MISSING

<description>

<entityDescription>

<copyright>

MISSING

VCS_code_system

codeSystemId

codingScheme.registeredName

Moved to metadata file.

codeSystemType

commonTypes::Properties

commonTypes::Properties

This is an HL7 specific code system property to distinguish internal vs external code systems. Moved to metadata file.

codeSystemName

concept.conceptCode

Moved to metadata file.

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="26d7ddd5-8109-4a65-a45f-07d17dd503a6"><ac:plain-text-body><![CDATA[ This is an HL7 specific code system property to distinguish internal vs external code systems. Moved to metadata file.

codeSystemName

concept.conceptCode presentation['textualPresentation'].text

  Moved to metadata file.

codeSystemName

]]></ac:plain-text-body></ac:structured-macro> concept.presentation'textualPresentation'.text

fullName

codingScheme.formalName

description

codingScheme.entityDescription

Moved to metadata file.

releaseId

codingScheme.representsVersion

Moved to metadata file.

copyrightNotice

codingScheme.copyright

Moved to metadata file.

literal('en')

codingScheme.defaultLanguage

Moved to metadata file.

VCS_concept_code_xref

internalId

Concept Code

concept.conceptCode

RIM db column conceptCode2

Case Difference

commonTypes::Properties

Basically a proprty to outline whether there are case differences in the Concept Code or not (mainly used, but not restricted tor units of measure)

RIM db column codeInstance

Status

concept.isActive=(conceptStatus=='A'?)

RIM db column conceptStatus

concept.conceptStatus

Not used by HL7. A = isActive, R = retired

VCS_concept_designation

internalId

foreign key

designation

concept.presentation'textualPresentation'.text

designationSeq

language

concept.presentation'textualPresentation'.language

Can be omitted if language = default language

preferredForLanguage

concept.presentation'textualPresentation'.isPreferred

VCS_concept_description

internalId

with(codeSystemderef(internalId).conceptderef(internalId)).definition

foreign key

description

concept.presentation'textualPresentation'.text

language

concept.presentation'textualPresentation'.language

literal('true')

concept.presentation'textualPresentation'.isPreferred

uniqueId()

concept.presentation'textualPresentation'.propertyId

literal('definition')

concept.presentation'textualPresentation'.property

VCS_concept_property

internalId

foreign key

propertyCode

concept.property.property

propertySeq

Currently not used by HL7

propartyValue

concept.property.text

language

concept.property.language

VCS_concept_relationship

relationCode

association.association

sourceInternalId

associationInstance.sourceConcept

targetInternalId

associationTarget.targetConcept

Model

modelID

systemRelease.releaseId

name

service.service

versionNumber

service.version

lastModifiedDate

systemRelease.releaseDate

developingOrganization

systemRelease.releaseAgency

committeeID

description

systemRelease.entityDescription

concat('urn:oid:2.16.840.1.113883:',systemRelease.releaseId)

systemRelease.releaseURN

literal('true')

systemRelease.isLatest

Also have to set the prior release isLatest to false

preceding-sibling/releaseOrder + 1

systemRelease.releaseOrder

Model

modelID

commonTypes::Properties

(Special mapping for NCI)

name

codingScheme.localName

versionNumber

codingScheme.representsVersion

lastModifiedDate

commonTypes::Properties

developingOrganization

commonTypes::Properties

committeeID

description

codingScheme.entityDescription

concat('urn:oid:2.16.840.1.113883:',systemRelease.releaseId)

codingScheme.registeredName

literal('true')

commonTypes::Properties

Also have to set the prior release isLatest to false

preceding-sibling/releaseOrder + 1

commonTypes::Properties

RIM_vocabulary_domain

vocDomain

codingscheme"VocabularyDomain".concept.conceptCode

Vocabulary Domains are carried in a code system of vocabulary domains.

codingscheme"VocabularyDomain".concept.presentation"textualPresentation".text

preferredPresentation

description

codingscheme"VocabularyDomain".concept.definition.text

preferredDefinition for code

restrictsDomain

codingscheme"VocabularyDomain".association"hasSubtype".sourceConcept

Should this be hasSubtype or something else?

codingscheme"VocabularyDomain".association"hasSubtype".targetconcept = vocDomain

VOC_code_reference

usedToBuildValueSet

referencesConceptCode

...valueDomainEntry/conceptCode