Page History
...
UMLS Mapping | |||||
RRF File Name | RRF Column Name | RRF Definition | NCI Meta only | LexGrid Model Element | comments |
---|---|---|---|---|---|
<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. |
...