Page History

UMLS Mapping

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