_435.hl7_results_obx_map

Field Type Null Default Key Extra Comment
obxm_id int(11) NO PRI auto_increment
obxm_cus_id int(11) YES MUL
obxm_cli_id int(11) YES MUL
obxm_loinc_num varchar(20) YES MUL
obxm_code varchar(20) YES CPT, LOINC, or SNOMED code
obxm_cs_id int(11) NO Code System ID to associate type of code
obxm_unit varchar(45) YES
obxm_range text YES
obxm_range_low varchar(10) YES
obxm_range_high varchar(10) YES
obxm_data_value_type varchar(2) YES
obxm_modified datetime YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
obxm_created datetime YES CURRENT_TIMESTAMP

References

Local Column References