NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...