01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | LOINC_NUM PK | string | varchar(50) | no | |
| 2 | COMPONENT | string | varchar(255) | no | |
| 3 | PROPERTY | string | varchar(50) | yes | |
| 4 | TIME_ASPCT | string | varchar(50) | yes | |
| 5 | SYSTEM | string | varchar(100) | yes | |
| 6 | SCALE_TYP | string | varchar(50) | yes | |
| 7 | METHOD_TYP | string | varchar(50) | yes | |
| 8 | RELAT_NMS | string | varchar(254) | yes | |
| 9 | CLASS | string | varchar(50) | yes | |
| 10 | SOURCE | string | varchar(50) | yes | |
| 11 | DT_LAST_CH | string | varchar(50) | yes | |
| 12 | CHNG_TYPE | string | varchar(50) | yes | |
| 13 | COMMENTS | string | varchar(max) | yes | |
| 14 | ANSWERLIST | string | varchar(max) | yes | |
| 15 | STATUS | string | varchar(50) | no | |
| 16 | MAP_TO | string | varchar(50) | yes | |
| 17 | SCOPE | string | varchar(50) | yes | |
| 18 | CONSUMER_NAME | string | varchar(255) | yes | |
| 19 | IPCC_UNITS | string | varchar(50) | yes | |
| 20 | REFERENCE | string | varchar(max) | yes | |
| 21 | EXACT_CMP_SY | string | varchar(50) | yes | |
| 22 | MOLAR_MASS | string | varchar(50) | yes | |
| 23 | CLASSTYPE | integer | int | no | |
| 24 | FORMULA | string | varchar(255) | yes | |
| 25 | SPECIES | string | varchar(50) | yes | |
| 26 | EXMPL_ANSWERS | string | varchar(max) | yes | |
| 27 | ACSSYM | string | varchar(max) | yes | |
| 28 | BASE_NAME | string | varchar(50) | yes | |
| 29 | FINAL | string | varchar(50) | no | |
| 30 | NAACCR_ID | string | varchar(50) | yes | |
| 31 | CODE_TABLE | string | varchar(50) | yes | |
| 32 | SETROOT | boolean | bit | no | |
| 33 | PANELELEMENTS | string | varchar(max) | yes | |
| 34 | SURVEY_QUEST_TEXT | string | varchar(max) | yes | |
| 35 | SURVEY_QUEST_SRC | string | varchar(50) | yes | |
| 36 | UNITSREQUIRED | string | varchar(50) | yes | |
| 37 | SUBMITTED_UNITS | string | varchar(50) | yes | |
| 38 | RELATEDNAMES2 | string | varchar(max) | yes | |
| 39 | SHORTNAME | string | varchar(50) | yes | |
| 40 | ORDER_OBS | string | varchar(50) | yes | |
| 41 | CDISC_COMMON_TESTS | string | varchar(50) | yes | |
| 42 | HL7_FIELD_SUBFIELD_ID | string | varchar(50) | yes | |
| 43 | EXTERNAL_COPYRIGHT_NOTICE | string | varchar(max) | yes | |
| 44 | EXAMPLE_UNITS | string | varchar(255) | yes | |
| 45 | INPC_PERCENTAGE | float | real | no | |
| 46 | LONG_COMMON_NAME | string | varchar(255) | yes | |
| 47 | HL7_V2_DATATYPE | string | varchar(255) | yes | |
| 48 | HL7_V3_DATATYPE | string | varchar(255) | yes | |
| 49 | CURATED_RANGE_AND_UNITS | string | varchar(max) | yes | |
| 50 | DOCUMENT_SECTION | string | varchar(255) | yes | |
| 51 | DEFINITION_DESCRIPTION_HELP | string | varchar(max) | yes | |
| 52 | EXAMPLE_UCUM_UNITS | string | varchar(255) | yes | |
| 53 | EXAMPLE_SI_UCUM_UNITS | string | varchar(255) | yes | |
| 54 | STATUS_REASON | string | varchar(50) | yes | |
| 55 | STATUS_TEXT | string | varchar(max) | yes | |
| 56 | CHANGE_REASON_PUBLIC | string | varchar(max) | yes | |
| 57 | COMMON_TEST_RANK | integer | int | no |