Skip to main content


persistent class %UMLS.meta.MRCONSO extends %Library.Persistent

SQL Table Name: %UMLS_meta.MRCONSO

Concept names and sources

Property Inventory


parameter UMLSVERSION = 2014AA;


property AUI as %Library.String (MAXLEN = 9) [ Required ];
Unique identifier for atom // MAXLEN = 9
Property methods: AUIDisplayToLogical(), AUIGet(), AUIGetStored(), AUIIsValid(), AUILogicalToDisplay(), AUILogicalToOdbc(), AUINormalize(), AUISet()
property BM25 as %Double;
Property methods: BM25DisplayToLogical(), BM25Get(), BM25GetStored(), BM25IsValid(), BM25LogicalToDisplay(), BM25Normalize(), BM25OdbcToLogical(), BM25Set()
property CODE as %Library.String (MAXLEN = 50) [ Required ];
Unique Identifier or code for string in source // MAXLEN = 30
Property methods: CODEDisplayToLogical(), CODEGet(), CODEGetStored(), CODEIsValid(), CODELogicalToDisplay(), CODELogicalToOdbc(), CODENormalize(), CODESet()
property CUI as %Library.String (MAXLEN = 8) [ Required ];
Unique identifier for concept // MAXLEN = 8
Property methods: CUIDisplayToLogical(), CUIGet(), CUIGetStored(), CUIIsValid(), CUILogicalToDisplay(), CUILogicalToOdbc(), CUINormalize(), CUISet()
property CVF as %Library.Integer;
Content view flag // MAXLEN = 4
Property methods: CVFDisplayToLogical(), CVFGet(), CVFGetStored(), CVFIsValid(), CVFLogicalToDisplay(), CVFNormalize(), CVFSet()
property ISPREF as %Library.String (MAXLEN = 1) [ Required ];
Indicates whether AUI is preferred // MAXLEN = 1
Property methods: ISPREFDisplayToLogical(), ISPREFGet(), ISPREFGetStored(), ISPREFIsValid(), ISPREFLogicalToDisplay(), ISPREFLogicalToOdbc(), ISPREFNormalize(), ISPREFSet()
property L1 as %Integer [ Calculated ];
Property methods: L1Compute(), L1DisplayToLogical(), L1Get(), L1IsValid(), L1LogicalToDisplay(), L1Normalize(), L1SQLCompute()
property L2 as %Integer [ Calculated ];
Property methods: L2Compute(), L2DisplayToLogical(), L2Get(), L2IsValid(), L2LogicalToDisplay(), L2Normalize(), L2SQLCompute()
property LAT as %Library.String (MAXLEN = 3) [ Required ];
Language of Term(s) // MAXLEN = 3
Property methods: LATDisplayToLogical(), LATGet(), LATGetStored(), LATIsValid(), LATLogicalToDisplay(), LATLogicalToOdbc(), LATNormalize(), LATSet()
property LUI as %Library.String (MAXLEN = 10) [ Required ];
Unique identifier for term // MAXLEN = 9
Property methods: LUIDisplayToLogical(), LUIGet(), LUIGetStored(), LUIIsValid(), LUILogicalToDisplay(), LUILogicalToOdbc(), LUINormalize(), LUISet()
property SAB as %Library.String (MAXLEN = 20) [ Required ];
Source abbreviation // MAXLEN = 15
Property methods: SABDisplayToLogical(), SABGet(), SABGetStored(), SABIsValid(), SABLogicalToDisplay(), SABLogicalToOdbc(), SABNormalize(), SABSet()
property SAUI as %Library.String (MAXLEN = 50);
Source asserted atom identifier // MAXLEN = 10
Property methods: SAUIDisplayToLogical(), SAUIGet(), SAUIGetStored(), SAUIIsValid(), SAUILogicalToDisplay(), SAUILogicalToOdbc(), SAUINormalize(), SAUISet()
property SCUI as %Library.String (MAXLEN = 50);
Source asserted concept identifier // MAXLEN = 20
Property methods: SCUIDisplayToLogical(), SCUIGet(), SCUIGetStored(), SCUIIsValid(), SCUILogicalToDisplay(), SCUILogicalToOdbc(), SCUINormalize(), SCUISet()
property SDUI as %Library.String (MAXLEN = 50);
Source asserted descriptor identifier // MAXLEN = 13
Property methods: SDUIDisplayToLogical(), SDUIGet(), SDUIGetStored(), SDUIIsValid(), SDUILogicalToDisplay(), SDUILogicalToOdbc(), SDUINormalize(), SDUISet()
property SRL as %Library.Integer [ Required ];
Source Restriction Level // MAXLEN = 1
Property methods: SRLDisplayToLogical(), SRLGet(), SRLGetStored(), SRLIsValid(), SRLLogicalToDisplay(), SRLNormalize(), SRLSet()
property STR as %String (COLLATION = "SQLUPPER(150)", MAXLEN = 4096) [ Required ];
String // MAXLEN = 2864
Property methods: STRDisplayToLogical(), STRGet(), STRGetStored(), STRIsValid(), STRLogicalToDisplay(), STRLogicalToOdbc(), STRNormalize(), STRSet()
property STT as %Library.String (MAXLEN = 3) [ Required ];
String type // MAXLEN = 3
Property methods: STTDisplayToLogical(), STTGet(), STTGetStored(), STTIsValid(), STTLogicalToDisplay(), STTLogicalToOdbc(), STTNormalize(), STTSet()
property SUI as %Library.String (MAXLEN = 10) [ Required ];
Unique identifier for string // MAXLEN = 9
Property methods: SUIDisplayToLogical(), SUIGet(), SUIGetStored(), SUIIsValid(), SUILogicalToDisplay(), SUILogicalToOdbc(), SUINormalize(), SUISet()
property SUPPRESS as %Library.String (MAXLEN = 1) [ Required ];
Suppressible flag // MAXLEN = 1
Property methods: SUPPRESSDisplayToLogical(), SUPPRESSGet(), SUPPRESSGetStored(), SUPPRESSIsValid(), SUPPRESSLogicalToDisplay(), SUPPRESSLogicalToOdbc(), SUPPRESSNormalize(), SUPPRESSSet()
property TS as %Library.String (MAXLEN = 1) [ Required ];
Term status // MAXLEN = 1
Property methods: TSDisplayToLogical(), TSGet(), TSGetStored(), TSIsValid(), TSLogicalToDisplay(), TSLogicalToOdbc(), TSNormalize(), TSSet()
property TTY as %Library.String (MAXLEN = 20) [ Required ];
Term type in source // MAXLEN = 11
Property methods: TTYDisplayToLogical(), TTYGet(), TTYGetStored(), TTYIsValid(), TTYLogicalToDisplay(), TTYLogicalToOdbc(), TTYNormalize(), TTYSet()
property cuiID as CUICOLL [ Calculated ];
cuicoll.%ID value corresponding to this CUI
Property methods: cuiIDCompute(), cuiIDGet(), cuiIDGetObject(), cuiIDGetObjectId(), cuiIDSQLCompute()
property suiID as SUICOLL [ Calculated ];
Property methods: suiIDCompute(), suiIDGet(), suiIDGetObject(), suiIDGetObjectId(), suiIDSQLCompute()


index ($MRCONSO on ) [Extent, Type = bitmap];
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (i1 on SUI);
Index methods: i1Exists()
index (i2 on CUI);
Index methods: i2Exists()
index (i3 on cuiID) [Data = (CUI,STR,SAB)];
Index methods: i3Exists()
index (i4 on suiID) [Data = (SUI,CUI,STR,SAB)];
Index methods: i4Exists()
index (iAUI on AUI);
Index methods: iAUIExists()
index (iCODE on CODE);
Index methods: iCODEExists()
index (iL1 on L1) [Type = bitmap];
index (iL2 on L2) [Type = bitmap];
index (iLANG on LAT) [Type = bitmap];
index (iSAB on SAB) [Type = bitmap];
index (iStr on STR:SqlUpper(150));
Index methods: iStrExists()

Inherited Members

Inherited Methods


Storage Model: CacheStorage (%UMLS.meta.MRCONSO)

FeedbackOpens in a new tab