Page History
...
RRF File Name | RRF Column Name | RRF Definition | NCI Meta only | LexGrid Model Element | comments Comments |
---|---|---|---|---|---|
MRSAB.RRF | SVER | Release date or version number of a source | NA | codingScheme.representsVersion | No comments |
MRSAB.RRF | SSN | Source short name | NA | codingScheme.codingSchemeName | No comments |
MRSAB.RRF | SON | Source Official Name | NA | codingScheme.formalName | No comments |
MRSAB.RRF | LAT | Language of Term(s) | NA | codingScheme.defaultLanguage | No comments |
MRSAB.RRF | TRF | Term frequency for a source | NA | codingScheme.approxNumConcepts | No comments |
MRSAB.RRF | SCIT | Source citation | NA | codingScheme.entityDescription | inherits entityDescription from versionableAndDescribable |
MRSAB.RRF | SCC | Content contact info for a source | NA | codingScheme.copyright | No comments |
MRSAB.RRF | SCC | Content contact info for a source | NA | codingScheme.codingSchemeURI | 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" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.codingSchemeName | Hard coded in java file as "NCI MetaThesaurus" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.formalName | Hard coded in java file as "NCI MetaThesaurus" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.defaultLanguage | Hard coded in java file as "ENG" |
MRCONSO.RRF | EXPL | Detailed explanation | x | codingScheme.approxNumConcepts | Count of CODE value in MRCONSO.RRF |
MRCONSO.RRF | EXPL | Detailed explanation | x | codingScheme.entityDescription | Hard coded in java file as "NCI MetaThesaurus loaded from RRF files." |
MRCONSO.RRF | EXPL | Detailed explanation | 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/." |
MRCONSO.RRF | EXPL | Detailed explanation | NA | codingScheme.localNameList | Hard coded as constant in java file as "localName" |
MRSAB.RRF | SON | Source Official Name | NA | codingScheme.localNameList. | No comments |
MRSAB.RRF | SON | Source Official Name | NA | codingScheme.localNameList | Hard coded as constant in java file as "localName" |
MRSAB.RRF | SON | Source Official Name | NA | codingScheme.localNameList. | Pulled from iso mapping configuration file using method getISOString(RSAB from MRSAB.RRF) |
MRSAB.RRF | SON | Source Official Name | NA | codingScheme.source | Hard coded as constant in java file as "source" |
MRDOC.RRF | EXPL | Detailed explanation | NA | codingScheme.source.content | String concatenation of "UMLS-" and value of EXPL |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList | Hard coded as constant in java file as "localName" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList. | Hard coded in java file as "NCI Thesaurus" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList | Hard coded as constant in java file as "localName" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList. | Hard coded in java file as "NCI_Thesaurus" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList | Hard coded as constant in java file as "localName" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList. | Hard coded in java file as "10001" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList | Hard coded as constant in java file as "source" |
MRDOC.RRF | EXPL | Detailed explanation | x | codingScheme.localNameList. | Hard coded in java file as "RRF Files" |
MRDOC.RRF | EXPL | Detailed explanation | NA | mappings.supportedFormat | Hard coded as constant in java file as "Format" |
MRDOC.RRF | EXPL | Detailed explanation | NA | mappings.supportedFormat.localId | Hard coded as one of several constants in a java file |
MRDOC.RRF | EXPL | Detailed explanation | NA | mappings.supportedAssociation | Hard coded as constant in java file as "Association" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedAssociation.localId |
|
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedContext | Hard coded as constant in java file as "Context" May not be used in individual RRF load |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedSource | Hard coded as constant in java file as "Source" May not be used in individual RRF load |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedHierarchy | Hard coded as constant in java file as "Hierarchy" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedAssociationQualifier | Hard coded as constant in java file as "AssociationQualifier" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedProperty | Hard coded as constant in java file as "Property" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedLanguage | Hard coded as constant in java file as "Language" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedCodingScheme | Hard coded as constant in java file as "CodingScheme" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedRepresentationalForm | Hard coded as constant in java file as "RepresentationalForm" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedConceptStatus | Hard coded as constant in java file as "ConceptStatus" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedPropertyLink | Hard coded as constant in java file as "PropertyLink" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedPropertyQualifier | Hard coded as constant in java file as "PropertyQualifier" |
MRREL.RRF | REL, RELA | Relationship, Relationship attribute | NA | mappings.supportedDataType | Hard coded as constant in java file as "DataType" |
...
RRF File Name | RRF Column Name | RRF Definition | NCI Meta only | LexGrid Model Element | comments Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Relations | |||||||||||
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 |
| AssociationPredicate.associationName | 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 |
| AssociationPredicate.associationName | 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. Currentely 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 |
| AssociationEntity.forwardName | unqualified REL or RELA value (inverse_isa remains the same) | ||||||
MRDOC.RRF | EXPL | Detailed explanation |
| AssociationEntity.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.isNavigable | hard coded as Boolean with value true. | ||||||
MRREL.RRF | SAB, REL, RELA | Source abbreviation |
| AssociationEntity.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. | ||||||
|
|
|
| AssociatableElement.entityDescription.content (inheritance path for entityDescription is Entity->versionableAndDescribable) | Hard coded to: "UMLS-defined relationships" |
|
|
| |||
|
|
|
|
|
|
| relations.containerName | 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. |
...
RRF File Name | RRF Column Name | RRF Definition | LexGrid Model Element | comments Comments | ||
---|---|---|---|---|---|---|
RSAB.RRF | SVER | Release date or version number of a source | codingScheme.representsVersion | No comments | ||
RSAB.RRF | SSN | Source short name | codingScheme.codingScheme? | No comments | ||
RSAB.RRF | SON | Source Official Name | codingScheme.formalName |
| No comments | |
RSAB.RRF | SON |
|
| Hard coded to "en" | codingScheme.defaultLanguage | No comments |
MRSAT.RRF | ATV | None | concept.presentation.language | Unique to snomed. |
...