Columns and Data Elements - 2023AB
All data elements in the Metathesaurus are described in this section. The data elements have been divided into Column Descriptions and Attribute Descriptions. The descriptions are arranged alphabetically by data element abbreviation.
Columns are described for Rich Release Format (RRF) in Table 1, and for Original Release Format (ORF) in Table 2.
Table 1. Columns and Data Elements in Rich Release Format (RRF)
| Abbreviation | Description | File | Length of Value in characters | Average Length of Value in characters | SQL92 Datatype |
|---|---|---|---|---|---|
| ATN | Attribute name | MRSAT.RRF | 2 - 62 | 11.25 | varchar(100) |
| ATNL | Attribute name list for a source. | MRSAB.RRF | 0 - 1178 | 69.62 | varchar(4000) |
| ATUI | Unique identifier for attribute. | MRSTY.RRF MRDEF.RRF MRSAT.RRF | 10 -
11 10 - 11 10 - 11 | 10.64 10.86 10.88 | varchar(11) varchar(11) varchar(11) |
| ATV | Attribute value | MRSAT.RRF | 1 - 35985 | 14.76 | varchar(65000) |
| AUI | Unique identifier for atom | MRHIER.RRF MRDEF.RRF MRCONSO.RRF | 8 -
9 8 - 9 8 - 9 | 8.60 8.75 8.78 | varchar(9) varchar(9) varchar(9) |
| AUI1 | Unique identifier for first atom | MRREL.RRF MRAUI.RRF | 0 -
9 8 - 9 | 8.52 8.55 | varchar(9) varchar(9) |
| AUI2 | Unique identifier for second atom | MRREL.RRF MRAUI.RRF | 0 -
9 8 - 9 | 8.52 8.55 | varchar(9) varchar(9) |
| AV | Average Length, Characters | MRCOLS.RRF | 4 - 6 | 4.14 | numeric(5,2) |
| BTS | Size in Bytes | MRFILES.RRF | 1 - 10 | 7.46 | integer |
| CENC | Character encoding of a source as specified by IANA | MRSAB.RRF | 5 | 5.00 | varchar(20) |
| CFR | CUI frequency for a source | MRSAB.RRF | 1 - 6 | 4.16 | integer |
| CHANGEKEY | CONCEPTSTATUS (if history relates to a SNOMED CT concept) or DESCRIPTIONSTATUS (if history relates to a SNOMED CT atom or "description") | MRHIST.RRF | 0 | 0.00 | varchar(1000) |
| CHANGETYPE | Source asserted code for type of change | MRHIST.RRF | 0 | 0.00 | varchar(1000) |
| CHANGEVAL | SNOMED CT CONCEPTSTATUS or DESCRIPTIONSTATUS value after the change took place | MRHIST.RRF | 0 | 0.00 | varchar(1000) |
| CLS | Number of columns | MRFILES.RRF | 1 - 2 | 1.12 | integer |
| CODE | Unique Identifier or code for string in source | MRSAT.RRF MRCONSO.RRF | 0 -
56 1 - 95 | 4.40 7.53 | varchar(100) varchar(100) |
| COL | Column or data element name | MRCOLS.RRF | 2 - 11 | 3.71 | varchar(20) |
| CUI | Unique identifier for concept | MRHIST.RRF AMBIGLUI.RRF AMBIGSUI.RRF CHANGE/MERGEDCUI.RRF MRCONSO.RRF MRDEF.RRF MRHIER.RRF MRSAT.RRF MRSTY.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_ARA.RRF MRXW_BAQ.RRF MRXW_CHI.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_EST.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_GRE.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_KOR.RRF MRXW_LAV.RRF MRXW_NOR.RRF MRXW_POL.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SCR.RRF MRXW_SPA.RRF MRXW_SWE.RRF MRXW_TUR.RRF MRXW_UKR.RRF | 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 | 0.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 | char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) |
| CUI1 | Unique identifier for first concept | MRAUI.RRF MRCUI.RRF MRREL.RRF | 8 8 8 | 8.00 8.00 8.00 | char(8) char(8) char(8) |
| CUI2 | Unique identifier for second concept | MRCUI.RRF MRAUI.RRF MRREL.RRF | 0 -
8 8 8 | 3.71 8.00 8.00 | char(8) char(8) char(8) |
| CURVER | Current Version flag | MRSAB.RRF | 1 | 1.00 | char(1) |
| CVF | Content view flag | MRDEF.RRF MRHIER.RRF MRHIST.RRF MRMAP.RRF MRREL.RRF MRSAT.RRF MRSMAP.RRF MRCONSO.RRF MRSTY.RRF | 0 0 0 0 0 0 0 0 - 5 0 - 5 | 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.98 1.80 | varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) |
| CXN | The context number if the atom has multiple contexts | MRHIER.RRF | 1 - 5 | 2.20 | integer |
| CXTY | Context type for a source | MRSAB.RRF | 0 - 13 | 5.13 | varchar(50) |
| DEF | Definition | MRDEF.RRF | 1 - 10939 | 232.01 | varchar(16000) |
| DES | Descriptive Name | MRCOLS.RRF MRFILES.RRF | 5 -
136 8 - 42 | 28.81 18.25 | varchar(200) varchar(200) |
| DIR | Source asserted directionality flag | MRREL.RRF | 0 - 1 | 0.25 | varchar(1) |
| DOCKEY | Key to be documented | MRDOC.RRF | 2 - 8 | 3.64 | varchar(50) |
| DTY | SQL-92 data type for this column | MRCOLS.RRF | 7 - 14 | 10.02 | varchar(20) |
| EXPL | Detailed explanation | MRDOC.RRF | 0 - 941 | 26.26 | varchar(1000) |
| FIL | Physical FILENAME | MRCOLS.RRF MRFILES.RRF | 9 -
21 9 - 21 | 10.99 12.12 | varchar(50) varchar(50) |
| FMT | Comma separated list of COL | MRFILES.RRF | 7 - 190 | 29.69 | varchar(300) |
| FROMEXPR | The expression that a mapping is mapped from | MRSMAP.RRF MRMAP.RRF | 1 -
9 1 - 18 | 6.93 8.34 | varchar(4000) varchar(4000) |
| FROMID | Metathesaurus identifier for the entity being mapped from | MRMAP.RRF | 1 - 18 | 7.39 | varchar(50) |
| FROMRES | Restriction applicable to the entity being mapped from | MRMAP.RRF | 0 | 0.00 | varchar(4000) |
| FROMRULE | Machine processible rule applicable to the entity being mapped from | MRMAP.RRF | 0 | 0.00 | varchar(4000) |
| FROMSID | Source asserted identifier for the entity being mapped from | MRMAP.RRF | 0 | 0.00 | varchar(50) |
| FROMTYPE | The type of expression that a mapping is mapped from | MRSMAP.RRF MRMAP.RRF | 3 -
4 3 - 4 | 3.98 3.99 | varchar(50) varchar(50) |
| HCD | Source asserted hierarchical number or code of context member (if it exists) | MRHIER.RRF | 0 - 51 | 0.46 | varchar(100) |
| IMETA | Version of the Metathesaurus that a source was added | MRSAB.RRF | 6 | 6.00 | varchar(10) |
| ISPREF | Indicates whether AUI is preferred | MRCONSO.RRF | 1 | 1.00 | char(1) |
| LAT | Language of Term(s) | MRSAB.RRF CHANGE/DELETEDSUI.RRF MRCONSO.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_ARA.RRF MRXW_BAQ.RRF MRXW_CHI.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_EST.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_GRE.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_KOR.RRF MRXW_LAV.RRF MRXW_NOR.RRF MRXW_POL.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SCR.RRF MRXW_SPA.RRF MRXW_SWE.RRF MRXW_TUR.RRF MRXW_UKR.RRF | 0 -
3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 | 2.97 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 | char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) |
| LUI | Unique identifier for term | CHANGE/MERGEDLUI.RRF MRSAT.RRF MRXW_BAQ.RRF MRXW_DAN.RRF MRXW_FIN.RRF MRXW_HEB.RRF MRXW_SCR.RRF MRXW_JPN.RRF AMBIGLUI.RRF MRCONSO.RRF MRXW_CZE.RRF MRXNS_ENG.RRF MRXW_ENG.RRF MRXNW_ENG.RRF MRXW_DUT.RRF MRXW_GER.RRF MRXW_SPA.RRF MRXW_ITA.RRF MRXW_POR.RRF MRXW_FRE.RRF MRXW_RUS.RRF MRXW_POL.RRF MRXW_SWE.RRF MRXW_KOR.RRF MRXW_NOR.RRF MRXW_HUN.RRF MRXW_LAV.RRF MRXW_ARA.RRF MRXW_CHI.RRF MRXW_EST.RRF MRXW_GRE.RRF MRXW_TUR.RRF MRXW_UKR.RRF | 0 0 - 9 8 8 8 8 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9 9 9 9 9 | 0.00 4.39 8.00 8.00 8.00 8.00 8.17 8.20 8.24 8.42 8.43 8.44 8.44 8.45 8.49 8.54 8.55 8.74 8.75 8.78 8.78 8.84 8.86 8.91 8.98 8.99 8.99 9.00 9.00 9.00 9.00 9.00 9.00 | varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) |
| MAPATN | Mapping attribute name (for future use) | MRMAP.RRF | 0 - 6 | 2.89 | varchar(20) |
| MAPATV | Mapping attribute value (for future use) | MRMAP.RRF | 0 - 1 | 0.00 | varchar(4000) |
| MAPID | Metathesaurus asserted identifier for mapping | MRSMAP.RRF MRMAP.RRF | 10 -
11 10 - 11 | 10.98 10.99 | varchar(50) varchar(50) |
| MAPIN | Mapping in current subset | MRCUI.RRF MRAUI.RRF | 0 -
1 1 | 0.46 1.00 | char(1) char(1) |
| MAPRANK | Order in which mappings in a subset should be applied | MRMAP.RRF | 0 - 2 | 0.50 | integer |
| MAPREASON | Reason for mapping | MRCUI.RRF MRAUI.RRF | 0 -
4 4 | 0.00 4.00 | varchar(4000) varchar(4000) |
| MAPRES | Restriction applicable to this mapping | MRMAP.RRF | 0 - 429 | 37.11 | varchar(4000) |
| MAPRULE | Machine processible rule applicable to this mapping | MRMAP.RRF | 0 - 336 | 10.76 | varchar(4000) |
| MAPSETCUI | CUI of the map set | MRMAP.RRF MRSMAP.RRF | 8 8 | 8.00 8.00 | char(8) char(8) |
| MAPSETSAB | SAB of the map set | MRSMAP.RRF MRMAP.RRF | 3 -
13 3 - 13 | 10.58 10.71 | varchar(40) varchar(40) |
| MAPSID | Source asserted identifier for mapping | MRSMAP.RRF MRMAP.RRF | 0 0 - 36 | 0.00 0.01 | varchar(50) varchar(50) |
| MAPSUBSETID | Map subset identifier used to identify a subset of related mappings within a map set | MRMAP.RRF | 0 - 1 | 0.50 | varchar(10) |
| MAPTYPE | Type of mapping | MRMAP.RRF | 0 - 9 | 4.36 | varchar(50) |
| MAX | Maximum Length | MRCOLS.RRF | 1 - 5 | 1.40 | integer |
| METAUI | Metathesaurus asserted unique identifier | MRSAT.RRF | 0 - 10 | 8.15 | varchar(50) |
| MIN | Minimum Length | MRCOLS.RRF | 1 - 2 | 1.02 | integer |
| NSTR | Normalized string | MRXNS_ENG.RRF | 1 - 2528 | 39.50 | varchar(3000) |
| NWD | Normalized word | MRXNW_ENG.RRF | 1 - 80 | 6.44 | varchar(100) |
| PAUI | Unique identifier for parent atom | MRHIER.RRF | 0 - 9 | 8.48 | varchar(9) |
| PCUI | Concept unique identifier in the previous Metathesaurus | CHANGE/DELETEDCUI.RRF CHANGE/MERGEDCUI.RRF | 8 8 | 8.00 8.00 | char(8) char(8) |
| PLUI | Lexical unique identifier in the previous Metathesaurus | CHANGE/MERGEDLUI.RRF CHANGE/DELETEDLUI.RRF | 0 8 - 9 | 0.00 8.87 | varchar(10) varchar(10) |
| PSTR | Preferred name in the previous Metathesaurus | CHANGE/DELETEDSUI.RRF CHANGE/DELETEDLUI.RRF CHANGE/DELETEDCUI.RRF | 3 -
2930 3 - 2930 5 - 2930 | 100.65 103.19 217.43 | varchar(3000) varchar(3000) varchar(3000) |
| PSUI | String unique identifier in the previous Metathesaurus | CHANGE/DELETEDSUI.RRF | 8 - 9 | 8.89 | varchar(10) |
| PTR | Path to root | MRHIER.RRF | 0 - 345 | 104.18 | varchar(1000) |
| RANK | Termgroup ranking | MRRANK.RRF | 4 | 4.00 | integer |
| RCUI | Unique identifier for root SRC concept | MRSAB.RRF | 8 | 8.00 | char(8) |
| REASON | Explanation of change, if present | MRHIST.RRF | 0 | 0.00 | varchar(1000) |
| REF | Documentation Section Number | MRCOLS.RRF | 0 | 0.00 | varchar(20) |
| REL | Relationship label | MRAUI.RRF MRMAP.RRF MRSMAP.RRF MRREL.RRF MRCUI.RRF | 0 2 2 2 - 3 2 - 3 | 0.00 2.00 2.00 2.22 2.54 | varchar(4) varchar(4) varchar(4) varchar(4) varchar(4) |
| RELA | Additional relationship label | MRAUI.RRF MRCUI.RRF MRREL.RRF MRMAP.RRF MRSMAP.RRF MRHIER.RRF | 0 0 0 - 54 0 - 37 0 - 37 0 - 12 | 0.00 0.00 11.42 13.89 19.85 2.71 | varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) |
| RG | Relationship group | MRREL.RRF | 0 - 3 | 0.12 | varchar(10) |
| RMETA | Version of the Metathesaurus where a version is removed | MRSAB.RRF | 0 - 6 | 0.15 | varchar(10) |
| RSAB | Root source abbreviation | MRSAB.RRF | 2 - 15 | 5.95 | varchar(40) |
| RUI | Unique identifier for relationship | MRREL.RRF | 9 - 10 | 9.78 | varchar(10) |
| RWS | Number of rows | MRFILES.RRF | 1 - 8 | 5.67 | integer |
| SAB | Source abbreviation | MRHIST.RRF MRDEF.RRF MRRANK.RRF MRCONSO.RRF MRREL.RRF MRSAT.RRF MRHIER.RRF | 0 2 - 11 2 - 15 2 - 15 2 - 15 2 - 13 2 - 13 | 0.00 4.11 5.49 5.89 5.96 6.34 7.86 | varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) |
| SABIN | Source in current subset | MRSAB.RRF | 1 | 1.00 | char(1) |
| SATUI | Source asserted attribute identifier | MRDEF.RRF MRSAT.RRF | 0 -
16 0 - 36 | 0.52 4.59 | varchar(50) varchar(50) |
| SAUI | Source asserted atom identifier | MRCONSO.RRF | 0 - 18 | 2.26 | varchar(100) |
| SCC | Content contact info for a source | MRSAB.RRF | 0 - 332 | 152.78 | varchar(1000) |
| SCIT | Source citation | MRSAB.RRF | 52 - 674 | 163.65 | varchar(4000) |
| SCUI | Source asserted concept identifier | MRCONSO.RRF | 0 - 95 | 5.33 | varchar(100) |
| SDUI | Source asserted descriptor identifier | MRCONSO.RRF | 0 - 13 | 2.51 | varchar(100) |
| SF | Source Family | MRSAB.RRF | 2 - 13 | 4.24 | varchar(40) |
| SL | Source of relationship labels | MRREL.RRF | 2 - 15 | 5.96 | varchar(40) |
| SLC | License contact info for a source | MRSAB.RRF | 12 - 346 | 167.91 | varchar(1000) |
| SON | Source Official Name | MRSAB.RRF | 10 - 145 | 48.47 | varchar(3000) |
| SOURCEUI | Source asserted unique identifier | MRHIST.RRF | 0 | 0.00 | varchar(50) |
| SRL | Source Restriction Level | MRCONSO.RRF MRSAB.RRF | 1 1 | 1.00 1.00 | integer integer |
| SRUI | Source attributed relationship identifier | MRREL.RRF | 0 - 36 | 2.59 | varchar(50) |
| SSN | Source short name | MRSAB.RRF | 3 - 89 | 25.49 | varchar(3000) |
| STN | Semantic type tree number | MRSTY.RRF | 1 - 14 | 7.78 | varchar(100) |
| STR | String | MRCONSO.RRF | 1 - 2875 | 39.27 | varchar(3000) |
| STT | String type | MRCONSO.RRF | 2 - 3 | 2.01 | varchar(3) |
| STY | Semantic type | MRSTY.RRF | 4 - 39 | 17.46 | varchar(50) |
| STYPE | The name of the column in MRCONSO.RRF or MRREL.RRF that contains the identifier to which the attribute is attached | MRSAT.RRF | 3 - 4 | 3.22 | varchar(50) |
| STYPE1 | The name of the column in MRCONSO.RRF that contains the first identifier to which the relationship is attached | MRREL.RRF | 3 - 4 | 3.65 | varchar(50) |
| STYPE2 | The name of the column in MRCONSO.RRF that contains the second identifier to which the relationship is attached | MRREL.RRF | 3 - 4 | 3.65 | varchar(50) |
| SUI | Unique identifier for string | MRSAT.RRF MRXW_BAQ.RRF MRXW_DAN.RRF MRXW_FIN.RRF MRXW_HEB.RRF AMBIGSUI.RRF MRXW_JPN.RRF MRXW_DUT.RRF MRCONSO.RRF MRXW_GER.RRF MRXW_SPA.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_ENG.RRF MRXW_ITA.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_FRE.RRF MRXW_CZE.RRF MRXW_SWE.RRF MRXW_NOR.RRF MRXW_HUN.RRF MRXW_ARA.RRF MRXW_CHI.RRF MRXW_EST.RRF MRXW_GRE.RRF MRXW_KOR.RRF MRXW_LAV.RRF MRXW_POL.RRF MRXW_SCR.RRF MRXW_TUR.RRF MRXW_UKR.RRF | 0 -
9 8 8 8 8 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9 9 9 9 9 9 9 9 9 | 4.46 8.00 8.00 8.00 8.00 8.34 8.35 8.50 8.56 8.57 8.59 8.63 8.66 8.66 8.78 8.78 8.80 8.83 8.87 8.87 8.98 8.99 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 | varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) |
| SUPPRESS | Suppressible flag | MRCONSO.RRF MRDEF.RRF MRRANK.RRF MRREL.RRF MRSAT.RRF | 1 1 1 1 1 | 1.00 1.00 1.00 1.00 1.00 | char(1) char(1) char(1) char(1) char(1) |
| SVER | Release date or version number of a source | MRHIST.RRF MRSAB.RRF | 0 0 - 15 | 0.00 5.03 | varchar(20) varchar(20) |
| TFR | Term frequency for a source | MRSAB.RRF | 1 - 7 | 4.45 | integer |
| TOEXPR | The expression that a mapping is mapped to | MRMAP.RRF MRSMAP.RRF | 0 -
242 1 - 242 | 6.02 6.94 | varchar(4000) varchar(4000) |
| TOID | Metathesaurus identifier for the entity being mapped to | MRMAP.RRF | 0 - 18 | 5.20 | varchar(50) |
| TORES | Restriction applicable to the entity being mapped to | MRMAP.RRF | 0 | 0.00 | varchar(4000) |
| TORULE | Machine processible rule applicable to the entity being mapped to | MRMAP.RRF | 0 | 0.00 | varchar(4000) |
| TOSID | Source asserted identifier for the entity being mapped to | MRMAP.RRF | 0 | 0.00 | varchar(50) |
| TOTYPE | The type of expression that a mapping is mapped to | MRMAP.RRF MRSMAP.RRF | 0 -
23 4 - 22 | 3.96 4.36 | varchar(50) varchar(50) |
| TS | Term status | MRCONSO.RRF | 1 | 1.00 | char(1) |
| TTY | Term type in source | MRCONSO.RRF MRRANK.RRF | 2 -
11 2 - 11 | 2.37 2.61 | varchar(20) varchar(20) |
| TTYL | Term type list for a source | MRSAB.RRF | 0 - 129 | 15.26 | varchar(400) |
| TUI | Unique identifier of Semantic type | MRSTY.RRF | 4 | 4.00 | char(4) |
| TYPE | Type of information | MRDOC.RRF | 3 - 21 | 13.04 | varchar(50) |
| VALUE | Value | MRDOC.RRF | 0 - 62 | 15.81 | varchar(200) |
| VCUI | Unique identifier for versioned SRC concept | MRSAB.RRF | 0 - 8 | 7.63 | char(8) |
| VEND | Valid end date for a source | MRSAB.RRF | 0 | 0.00 | char(8) |
| VER | Last release version in which CUI1 was valid | MRAUI.RRF MRCUI.RRF | 6 6 | 6.00 6.00 | varchar(10) varchar(10) |
| VSAB | Versioned source abbreviation | MRSAB.RRF | 3 - 24 | 11.40 | varchar(40) |
| VSTART | Valid start date for a source | MRSAB.RRF | 0 | 0.00 | char(8) |
| WD | Word in lower-case | MRXW_FIN.RRF MRXW_KOR.RRF MRXW_CHI.RRF MRXW_EST.RRF MRXW_TUR.RRF MRXW_ARA.RRF MRXW_POR.RRF MRXW_ITA.RRF MRXW_HEB.RRF MRXW_ENG.RRF MRXW_UKR.RRF MRXW_DAN.RRF MRXW_SPA.RRF MRXW_FRE.RRF MRXW_RUS.RRF MRXW_BAQ.RRF MRXW_GRE.RRF MRXW_POL.RRF MRXW_CZE.RRF MRXW_LAV.RRF MRXW_DUT.RRF MRXW_HUN.RRF MRXW_SCR.RRF MRXW_GER.RRF MRXW_SWE.RRF MRXW_JPN.RRF MRXW_NOR.RRF | 1 -
54 1 - 38 1 - 68 1 - 35 1 - 37 1 - 22 1 - 38 1 - 38 1 - 19 1 - 80 1 - 27 1 - 25 1 - 46 1 - 39 1 - 40 1 - 18 1 - 34 1 - 48 1 - 52 1 - 29 1 - 51 1 - 27 1 - 37 1 - 43 1 - 39 1 - 93 1 - 44 | 10.53 2.84 3.66 4.57 5.27 5.35 5.70 5.94 6.12 6.14 6.37 6.38 6.61 6.80 7.16 7.17 7.27 7.27 7.44 7.75 7.84 7.85 8.02 8.29 8.32 9.08 9.11 | varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) |
Table 2. Columns and Data Elements in Original Release Format (ORF)
| Abbreviation | Description | File | Length of Value in characters | Average Length of Value in characters | SQL92 Datatype |
|---|---|---|---|---|---|
| ATN | Attribute name | MRSAT | 2 - 62 | 7.79 | varchar(100) |
| ATNL | Attribute name list for a source | MRSAB | 0 - 1169 | 55.37 | varchar(4000) |
| ATV | Attribute value | MRSAT | 1 - 35985 | 12.72 | varchar(65000) |
| ATX | Associated expression | MRATX | 5 - 242 | 35.66 | varchar(300) |
| AV | Average Length, Characters | MRCOLS | 4 - 6 | 4.12 | numeric(5,2) |
| BTS | Size in Bytes | MRFILES | 1 - 10 | 7.49 | integer |
| CENC | Character encoding of a source as specified by IANA | MRSAB | 5 | 5.00 | varchar(20) |
| CFR | CUI frequency for a source | MRSAB | 1 - 6 | 4.16 | integer |
| CLS | Number of columns | MRFILES | 1 - 2 | 1.02 | integer |
| CODE | Unique Identifier or code for string in source | MRSAT MRSO | 0 -
56 1 - 95 | 6.35 7.53 | varchar(50) varchar(50) |
| COL | Column or data element name | MRCOLS | 2 - 6 | 3.08 | varchar(10) |
| CREL | Relationship to retired CUI (CUI1) to current CUI (CUI2) | MRCUI | 2 - 3 | 2.54 | varchar(4) |
| CUI | Unique identifier for concept | AMBIG.LUI AMBIG.SUI CHANGE/MERGED.CUI MRATX MRCON MRDEF MRSAT MRSO MRSTY MRXNS.ENG MRXNW.ENG MRXW.ARA MRXW.BAQ MRXW.CHI MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.EST MRXW.FIN MRXW.FRE MRXW.GER MRXW.GRE MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.KOR MRXW.LAV MRXW.NOR MRXW.POL MRXW.POR MRXW.RUS MRXW.SCR MRXW.SPA MRXW.SWE MRXW.TUR MRXW.UKR | 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 | 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 | char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) |
| CUI1 | Unique identifier of first concept | MRCUI MRREL | 8 8 | 8.00 8.00 | char(8) char(8) |
| CUI2 | Unique identifier of second concept | MRCUI MRREL | 0 -
8 8 | 3.71 8.00 | char(8) char(8) |
| CURVER | Current Version flag | MRSAB | 1 | 1.00 | char(1) |
| CXTY | Context type for a source (as per section 2.3.2) | MRSAB | 0 - 13 | 5.13 | varchar(50) |
| DEF | Definition | MRDEF | 1 - 10939 | 232.78 | varchar(16000) |
| DES | Descriptive Name | MRCOLS MRFILES | 5 -
56 7 - 42 | 25.61 18.10 | varchar(100) varchar(100) |
| DOCKEY | Key to be documented | MRDOC | 2 - 8 | 3.64 | varchar(50) |
| DTY | SQL-92 data type for this column | MRCOLS | 7 - 14 | 9.67 | varchar(20) |
| EXPL | Detailed explanation | MRDOC | 0 - 941 | 25.94 | varchar(1000) |
| FIL | Physical FILENAME | MRCOLS MRFILES | 4 -
18 4 - 18 | 7.48 8.33 | varchar(50) varchar(50) |
| FMT | Comma separated list of COL | MRFILES | 7 - 112 | 19.73 | varchar(150) |
| IMETA | Version of the Metathesaurus that a source was added | MRSAB | 6 | 6.00 | varchar(10) |
| LAT | Language of Term(s) | MRSAB CHANGE/DELETED.SUI MRCON MRXNS.ENG MRXNW.ENG MRXW.ARA MRXW.BAQ MRXW.CHI MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.EST MRXW.FIN MRXW.FRE MRXW.GER MRXW.GRE MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.KOR MRXW.LAV MRXW.NOR MRXW.POL MRXW.POR MRXW.RUS MRXW.SCR MRXW.SPA MRXW.SWE MRXW.TUR MRXW.UKR | 0 -
3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 | 2.97 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 | char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) |
| LRL | Least Restriction Level | MRCON | 1 | 1.00 | integer |
| LUI | Unique identifier for term | CHANGE/MERGED.LUI MRSAT MRXW.BAQ MRXW.DAN MRXW.FIN MRXW.HEB MRXW.SCR MRXW.JPN AMBIG.LUI MRSO MRXW.CZE MRCON MRXNS.ENG MRXW.ENG MRXNW.ENG MRXW.DUT MRXW.GER MRXW.SPA MRXW.ITA MRXW.POR MRXW.FRE MRXW.RUS MRXW.POL MRXW.SWE MRXW.KOR MRXW.NOR MRXW.HUN MRXW.LAV MRXW.ARA MRXW.CHI MRXW.EST MRXW.GRE MRXW.TUR MRXW.UKR | 0 0 - 9 8 8 8 8 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9 9 9 9 9 | 0.00 6.56 8.00 8.00 8.00 8.00 8.17 8.20 8.24 8.42 8.43 8.44 8.44 8.44 8.45 8.49 8.54 8.55 8.74 8.75 8.78 8.78 8.84 8.86 8.91 8.98 8.99 8.99 9.00 9.00 9.00 9.00 9.00 9.00 | varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) |
| MAPIN | Mapping in current subset | MRCUI | 0 - 1 | 0.46 | char(1) |
| MAX | Maximum Length | MRCOLS | 1 - 5 | 1.38 | integer |
| MEND | Metathesaurus end date for a source | MRSAB | 0 | 0.00 | char(8) |
| MG | Machine generated and unverified indicator | MRREL | 0 | 0.00 | varchar(1) |
| MIN | Minimum Length | MRCOLS | 1 - 2 | 1.01 | integer |
| MSTART | Metathesaurus start date for a source | MRSAB | 0 | 0.00 | char(8) |
| NSTR | Normalized string | MRXNS.ENG | 1 - 2528 | 39.50 | varchar(3000) |
| NWD | Normalized word | MRXNW.ENG | 1 - 80 | 6.44 | varchar(100) |
| PCUI | Concept unique identifier in the previous Metathesaurus | CHANGE/DELETED.CUI CHANGE/MERGED.CUI | 8 8 | 8.00 8.00 | char(8) char(8) |
| PLUI | Lexical unique identifier in the previous Metathesaurus | CHANGE/MERGED.LUI CHANGE/DELETED.LUI | 0 8 - 9 | 0.00 8.87 | varchar(10) varchar(10) |
| PSTR | Preferred name in the previous Metathesaurus | CHANGE/DELETED.SUI CHANGE/DELETED.LUI CHANGE/DELETED.CUI | 3 -
2930 3 - 2930 5 - 2930 | 100.65 103.19 217.43 | varchar(3000) varchar(3000) varchar(3000) |
| PSUI | String unique identifier in the previous Metathesaurus | CHANGE/DELETED.SUI | 8 - 9 | 8.89 | varchar(10) |
| RANK | Termgroup ranking | MRRANK | 4 | 4.00 | integer |
| RCUI | Unique identifier for root SRC concept | MRSAB | 8 | 8.00 | char(8) |
| REF | Documentation Section Number | MRCOLS | 0 | 0.00 | varchar(20) |
| REL | Relationship label | MRATX MRREL | 2 2 - 3 | 2.00 2.28 | varchar(3) varchar(3) |
| RELA | Additional relationship label | MRREL | 0 - 54 | 10.57 | varchar(100) |
| RMETA | Version of the Metathesaurus where a version is removed | MRSAB | 0 - 6 | 0.15 | varchar(10) |
| RSAB | Root source abbreviation | MRSAB | 2 - 15 | 5.95 | varchar(40) |
| RWS | Number of rows | MRFILES | 1 - 8 | 5.71 | integer |
| SAB | Source abbreviation | MRDEF MRSAT MRRANK MRREL MRSO MRATX | 2 -
11 2 - 13 2 - 15 2 - 15 2 - 15 3 | 4.11 5.18 5.49 5.76 5.89 3.00 | varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) |
| SABIN | Source in current subset | MRSAB | 1 | 1.00 | char(1) |
| SCC | Content contact info for a source | MRSAB | 0 - 332 | 152.78 | varchar(1000) |
| SF | Source Family | MRSAB | 2 - 13 | 4.24 | varchar(40) |
| SL | Source of relationship labels | MRREL | 2 - 15 | 5.76 | varchar(40) |
| SLC | License contact info for a source | MRSAB | 12 - 346 | 167.91 | varchar(1000) |
| SON | Source Official Name | MRSAB | 10 - 145 | 48.47 | varchar(3000) |
| SRL | Source Restriction Level | MRSAB MRSO | 1 1 | 1.00 1.00 | integer integer |
| STR | String | MRCON | 1 - 2875 | 41.24 | varchar(3000) |
| STT | String type | MRCON | 2 - 3 | 2.01 | varchar(3) |
| STY | Semantic type | MRSTY | 4 - 39 | 17.46 | varchar(50) |
| SUI | Unique identifier for string | MRSAT MRXW.BAQ MRXW.DAN MRXW.FIN MRXW.HEB AMBIG.SUI MRXW.JPN MRXW.DUT MRSO MRXW.GER MRCON MRXW.SPA MRXNS.ENG MRXNW.ENG MRXW.ENG MRXW.ITA MRXW.POR MRXW.RUS MRXW.FRE MRXW.CZE MRXW.SWE MRXW.NOR MRXW.HUN MRXW.ARA MRXW.CHI MRXW.EST MRXW.GRE MRXW.KOR MRXW.LAV MRXW.POL MRXW.SCR MRXW.TUR MRXW.UKR | 0 -
9 8 8 8 8 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9 9 9 9 9 9 9 9 9 | 6.68 8.00 8.00 8.00 8.00 8.34 8.35 8.50 8.56 8.57 8.59 8.59 8.63 8.66 8.66 8.78 8.78 8.80 8.83 8.87 8.87 8.98 8.99 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 | varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) |
| SUPRES | Suppressible flag | MRRANK | 1 | 1.00 | char(1) |
| SVER | Release date or version number of a source | MRSAB | 0 - 15 | 5.03 | varchar(20) |
| TFR | Term frequency for a source | MRSAB | 1 - 7 | 4.45 | integer |
| TS | Term status | MRCON | 1 | 1.00 | char(1) |
| TTY | Term type in source | MRSO MRRANK | 2 -
11 2 - 11 | 2.37 2.61 | varchar(20) varchar(20) |
| TTYL | Term type list for a source | MRSAB | 0 - 129 | 15.26 | varchar(400) |
| TUI | Unique identifier of Semantic type | MRSTY | 4 | 4.00 | char(4) |
| TYPE | Type of information | MRDOC | 3 - 21 | 13.04 | varchar(50) |
| VALUE | Value | MRDOC | 0 - 62 | 15.95 | varchar(200) |
| VCUI | Unique identifier for versioned SRC concept | MRSAB | 0 - 8 | 7.63 | char(8) |
| VER | Last release version in which CUI1 was valid | MRCUI | 6 | 6.00 | varchar(10) |
| VSAB | Versioned source abbreviation | MRSAB | 3 - 24 | 11.40 | varchar(40) |
| WD | Word in lower-case | MRXW.FIN MRXW.KOR MRXW.CHI MRXW.EST MRXW.TUR MRXW.ARA MRXW.POR MRXW.ITA MRXW.HEB MRXW.ENG MRXW.UKR MRXW.DAN MRXW.SPA MRXW.FRE MRXW.RUS MRXW.BAQ MRXW.GRE MRXW.POL MRXW.CZE MRXW.LAV MRXW.DUT MRXW.HUN MRXW.SCR MRXW.GER MRXW.SWE MRXW.JPN MRXW.NOR | 1 -
54 1 - 38 1 - 68 1 - 35 1 - 37 1 - 22 1 - 38 1 - 38 1 - 19 1 - 80 1 - 27 1 - 25 1 - 46 1 - 39 1 - 40 1 - 18 1 - 34 1 - 48 1 - 52 1 - 29 1 - 51 1 - 27 1 - 37 1 - 43 1 - 39 1 - 93 1 - 44 | 10.53 2.84 3.66 4.57 5.27 5.35 5.70 5.94 6.12 6.14 6.37 6.38 6.61 6.80 7.16 7.17 7.27 7.27 7.44 7.75 7.84 7.85 8.02 8.29 8.32 9.08 9.11 | varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) |
Last Reviewed: November 6, 2023