_1548.radiology_orders_test_codes_map

Field Type Null Default Key Extra Comment
rtcm_id int(11) NO PRI auto_increment
rtcm_cus_id int(11) NO MUL
rtcm_cli_id int(11) NO MUL
rtcm_cpt_id int(11) NO MUL
rtcm_lab_id int(11) NO MUL
rtcm_rad_id int(11) NO MUL
rtcm_rad_res_id int(11) NO MUL
rtcm_cs_id int(11) NO MUL coding system id
rtcm_code_id bigint(20) NO MUL code id
rtcm_test_code varchar(45) NO test code
rtcm_reporting_title text NO
rtcm_abn tinyint(1) NO
rtcm_req_num varchar(20) NO MUL Uniquely identifies a radiology order
rtcm_sent tinyint(1) NO 0
rtcm_modified datetime YES CURRENT_TIMESTAMP
rtcm_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
rtcm_id
TableColumn
_1.radiology_order_notesradnot_rtcm_id
_1.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_1.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_1188.radiology_order_notesradnot_rtcm_id
_1188.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_1188.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_1218.radiology_order_notesradnot_rtcm_id
_1218.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_1218.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_1548.radiology_order_notesradnot_rtcm_id
_1548.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_1548.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_435.radiology_order_notesradnot_rtcm_id
_435.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_435.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_436.radiology_order_notesradnot_rtcm_id
_436.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_436.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_436_archive_testing.radiology_order_notesradnot_rtcm_id
_436_archive_testing.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_436_archive_testing.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_437.radiology_order_notesradnot_rtcm_id
_437.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_437.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_8.radiology_order_notesradnot_rtcm_id
_8.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_8.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_81.radiology_order_notesradnot_rtcm_id
_81.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_81.radiology_orders_dx_test_codes_mapritcm_rtcm_id
_999.radiology_order_notesradnot_rtcm_id
_999.radiology_order_test_codes_aoe_valuesrtcaoev_rtcm_id
_999.radiology_orders_dx_test_codes_mapritcm_rtcm_id