Loinc.loinc_codes

Field Type Null Default Key Extra Comment
lc_id int(11) NO PRI auto_increment
lc_loinc_num varchar(10) NO UNI
lc_cpt_code varchar(5) NO MUL
lc_cpt_id int(11) NO MUL
lc_component varchar(80) NO
lc_lccmp_id int(11) NO MUL
lc_property varchar(80) NO MUL
lc_lcp_id int(11) NO MUL
lc_time_aspct varchar(80) NO
lc_lcta_id int(11) NO
lc_system varchar(80) NO MUL
lc_lcs_id int(11) NO MUL
lc_scale_typ varchar(80) NO
lc_method_typ varchar(80) NO
lc_lcmt_id int(11) NO
lc_relat_nms varchar(80) NO
lc_class varchar(80) NO MUL
lc_lcc_id int(11) NO MUL
lc_source varchar(80) NO
lc_lcsrc_id int(11) NO MUL
lc_dt_last_ch varchar(8) NO
lc_chng_type varchar(80) NO
lc_comments varchar(80) NO
lc_answerlist varchar(80) NO
lc_status varchar(80) NO MUL
lc_map_to varchar(80) NO
lc_scope varchar(80) NO
lc_consumer_name varchar(512) NO User friendly name
lc_ipcc_units varchar(80) NO
lc_reference varchar(80) NO
lc_exact_cmp_sy varchar(80) NO
lc_molar_mass varchar(80) NO
lc_classtype int(11) NO 0
lc_formula varchar(80) NO
lc_species varchar(80) NO
lc_exmpl_answers text NO
lc_acssym text NO
lc_base_name varchar(80) NO
lc_final char(1) NO
lc_naaccr_id varchar(80) NO
lc_code_table varchar(80) NO
lc_setroot varchar(80) NO
lc_panelelements varchar(80) NO
lc_survey_quest_text varchar(512) NO Survey question text
lc_survey_quest_src varchar(80) NO
lc_unitsrequired varchar(80) NO
lc_submitted_units varchar(80) NO
lc_relatednames2 varchar(1000) NO MUL
lc_shortname varchar(80) NO MUL
lc_order_obs varchar(80) NO
lc_cdisc_common_tests varchar(80) NO
lc_hl7_field_subfield_id varchar(80) NO
lc_external_copyright_notice varchar(80) NO
lc_example_units varchar(80) NO
lc_inpc_percentage varchar(80) NO
lc_long_common_name varchar(512) NO MUL Fully qualified common name
lc_hl7_v2_datatype varchar(80) NO
lc_hl7v2_id int(11) NO
lc_hl7_v3_datatype varchar(80) NO
lc_hl7v3_id int(11) NO
lc_curated_range_and_units varchar(80) NO
lc_document_section varchar(80) NO
lc_definition_description_help varchar(80) NO
lc_example_ucum_units varchar(80) NO
lc_example_si_ucum_units varchar(80) NO
lc_status_reason varchar(80) NO
lc_status_text varchar(80) NO
lc_change_reason_public varchar(80) NO
lc_common_test_rank int(11) NO 0
lc_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
lc_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
lc_id
TableColumn
Loinc.answers_listsansl_context_lc_id
Loinc.loinc_codes_answers_lists_maplcanslm_lc_id
Loinc.loinc_codes_answers_lists_maplcanslm_context_lc_id
Loinc.loinc_codes_example_units_maplceum_lc_id
Loinc.loinc_codes_frequencylcf_lc_id
Loinc.loinc_codes_indexlci_lc_id
Loinc.loinc_keywords_maplkm_lc_id
Loinc.loinc_panels_and_formslpf_parent_lc_id
Loinc.loinc_panels_and_formslpf_child_lc_id
_1.orders_test_codesotc_lc_id
_1.orders_test_codes_mapotcm_lc_id
_1.orders_test_codes_statsotcs_lc_id
_1.orders_test_codes_templatesotct_lc_id
_1188.orders_test_codesotc_lc_id
_1188.orders_test_codes_mapotcm_lc_id
_1188.orders_test_codes_statsotcs_lc_id
_1188.orders_test_codes_templatesotct_lc_id
_1218.orders_test_codesotc_lc_id
_1218.orders_test_codes_mapotcm_lc_id
_1218.orders_test_codes_statsotcs_lc_id
_1218.orders_test_codes_templatesotct_lc_id
_1548.orders_test_codesotc_lc_id
_1548.orders_test_codes_mapotcm_lc_id
_1548.orders_test_codes_statsotcs_lc_id
_1548.orders_test_codes_templatesotct_lc_id
_435.orders_test_codesotc_lc_id
_435.orders_test_codes_mapotcm_lc_id
_435.orders_test_codes_statsotcs_lc_id
_435.orders_test_codes_templatesotct_lc_id
_436.orders_test_codesotc_lc_id
_436.orders_test_codes_mapotcm_lc_id
_436.orders_test_codes_statsotcs_lc_id
_436.orders_test_codes_templatesotct_lc_id
_436_archive_testing.orders_test_codesotc_lc_id
_436_archive_testing.orders_test_codes_mapotcm_lc_id
_436_archive_testing.orders_test_codes_statsotcs_lc_id
_436_archive_testing.orders_test_codes_templatesotct_lc_id
_437.orders_test_codesotc_lc_id
_437.orders_test_codes_mapotcm_lc_id
_437.orders_test_codes_statsotcs_lc_id
_437.orders_test_codes_templatesotct_lc_id
_8.orders_test_codesotc_lc_id
_8.orders_test_codes_mapotcm_lc_id
_8.orders_test_codes_statsotcs_lc_id
_8.orders_test_codes_templatesotct_lc_id
_81.orders_test_codesotc_lc_id
_81.orders_test_codes_mapotcm_lc_id
_81.orders_test_codes_statsotcs_lc_id
_81.orders_test_codes_templatesotct_lc_id
_999.orders_test_codesotc_lc_id
_999.orders_test_codes_mapotcm_lc_id
_999.orders_test_codes_statsotcs_lc_id
_999.orders_test_codes_templatesotct_lc_id
common.loinc_codes_indexlci_lc_id
template_library.orders_test_codes_templatesotct_lc_id