common.labs

Field Type Null Default Key Extra Comment
lab_id int(11) NO PRI auto_increment
lab_lat_id int(11) NO 1 MUL Lab Type ID#, 1 for regular labs, 2 for radiology
lab_mnemonic varchar(20) NO
lab_name varchar(40) NO
lab_address1 varchar(40) NO
lab_address2 varchar(40) NO
lab_city varchar(30) NO
lab_state varchar(2) NO
lab_zip varchar(5) NO
lab_zip_plus4 varchar(4) NO
lab_phone1 varchar(20) NO
lab_phone2 varchar(20) NO
lab_fax varchar(20) NO
lab_logo text NO
lab_logo_x int(11) NO
lab_logo_y int(11) NO
lab_logo_s int(11) NO
lab_configs varchar(256) NO optional json configuration options lab wide
lab_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
lab_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
lab_id
TableColumn
_1.clients_test_codesctc_lab_id
_1.clients_test_codes_mapctcm_lab_id
_1.cpoe_responsescpoe_res_lab_id
_1.hl7_accessionsacc_lab_id
_1.insurancesins_lab_id
_1.insurances_newins_lab_id
_1.labs_orderslo_lab_id
_1.labs_orders_clients_pricinglocp_lab_id
_1.labs_resultslr_lab_id
_1.ordersord_lab_id
_1.orders_icd9_test_codes_mapoitcm_lab_id
_1.orders_templatesordt_lab_id
_1.orders_test_codes_mapotcm_lab_id
_1.radiology_ordersrad_lab_id
_1.radiology_orders_dx_test_codes_mapritcm_lab_id
_1.radiology_orders_test_codes_maprtcm_lab_id
_1188.clients_test_codesctc_lab_id
_1188.clients_test_codes_mapctcm_lab_id
_1188.cpoe_responsescpoe_res_lab_id
_1188.hl7_accessionsacc_lab_id
_1188.insurancesins_lab_id
_1188.insurances_newins_lab_id
_1188.labs_orderslo_lab_id
_1188.labs_orders_clients_pricinglocp_lab_id
_1188.labs_resultslr_lab_id
_1188.ordersord_lab_id
_1188.orders_icd9_test_codes_mapoitcm_lab_id
_1188.orders_templatesordt_lab_id
_1188.orders_test_codes_mapotcm_lab_id
_1188.radiology_ordersrad_lab_id
_1188.radiology_orders_dx_test_codes_mapritcm_lab_id
_1188.radiology_orders_test_codes_maprtcm_lab_id
_1218.clients_test_codesctc_lab_id
_1218.clients_test_codes_mapctcm_lab_id
_1218.cpoe_responsescpoe_res_lab_id
_1218.hl7_accessionsacc_lab_id
_1218.insurancesins_lab_id
_1218.insurances_newins_lab_id
_1218.labs_orderslo_lab_id
_1218.labs_orders_clients_pricinglocp_lab_id
_1218.labs_resultslr_lab_id
_1218.ordersord_lab_id
_1218.orders_icd9_test_codes_mapoitcm_lab_id
_1218.orders_templatesordt_lab_id
_1218.orders_test_codes_mapotcm_lab_id
_1218.radiology_ordersrad_lab_id
_1218.radiology_orders_dx_test_codes_mapritcm_lab_id
_1218.radiology_orders_test_codes_maprtcm_lab_id
_1548.clients_test_codesctc_lab_id
_1548.clients_test_codes_mapctcm_lab_id
_1548.cpoe_responsescpoe_res_lab_id
_1548.hl7_accessionsacc_lab_id
_1548.insurancesins_lab_id
_1548.insurances_newins_lab_id
_1548.labs_orderslo_lab_id
_1548.labs_orders_clients_pricinglocp_lab_id
_1548.labs_resultslr_lab_id
_1548.ordersord_lab_id
_1548.orders_icd9_test_codes_mapoitcm_lab_id
_1548.orders_templatesordt_lab_id
_1548.orders_test_codes_mapotcm_lab_id
_1548.radiology_ordersrad_lab_id
_1548.radiology_orders_dx_test_codes_mapritcm_lab_id
_1548.radiology_orders_test_codes_maprtcm_lab_id
_435.clients_test_codesctc_lab_id
_435.clients_test_codes_mapctcm_lab_id
_435.cpoe_responsescpoe_res_lab_id
_435.hl7_accessionsacc_lab_id
_435.insurancesins_lab_id
_435.insurances_newins_lab_id
_435.labs_orderslo_lab_id
_435.labs_orders_clients_pricinglocp_lab_id
_435.labs_resultslr_lab_id
_435.ordersord_lab_id
_435.orders_icd9_test_codes_mapoitcm_lab_id
_435.orders_templatesordt_lab_id
_435.orders_test_codes_mapotcm_lab_id
_435.radiology_ordersrad_lab_id
_435.radiology_orders_dx_test_codes_mapritcm_lab_id
_435.radiology_orders_test_codes_maprtcm_lab_id
_436.clients_test_codesctc_lab_id
_436.clients_test_codes_mapctcm_lab_id
_436.cpoe_responsescpoe_res_lab_id
_436.hl7_accessionsacc_lab_id
_436.insurancesins_lab_id
_436.insurances_newins_lab_id
_436.labs_orderslo_lab_id
_436.labs_orders_clients_pricinglocp_lab_id
_436.labs_resultslr_lab_id
_436.ordersord_lab_id
_436.orders_icd9_test_codes_mapoitcm_lab_id
_436.orders_templatesordt_lab_id
_436.orders_test_codes_mapotcm_lab_id
_436.radiology_ordersrad_lab_id
_436.radiology_orders_dx_test_codes_mapritcm_lab_id
_436.radiology_orders_test_codes_maprtcm_lab_id
_436_archive_testing.clients_test_codesctc_lab_id
_436_archive_testing.clients_test_codes_mapctcm_lab_id
_436_archive_testing.cpoe_responsescpoe_res_lab_id
_436_archive_testing.hl7_accessionsacc_lab_id
_436_archive_testing.insurancesins_lab_id
_436_archive_testing.insurances_newins_lab_id
_436_archive_testing.labs_orderslo_lab_id
_436_archive_testing.labs_orders_clients_pricinglocp_lab_id
_436_archive_testing.labs_resultslr_lab_id
_436_archive_testing.ordersord_lab_id
_436_archive_testing.orders_icd9_test_codes_mapoitcm_lab_id
_436_archive_testing.orders_templatesordt_lab_id
_436_archive_testing.orders_test_codes_mapotcm_lab_id
_436_archive_testing.radiology_ordersrad_lab_id
_436_archive_testing.radiology_orders_dx_test_codes_mapritcm_lab_id
_436_archive_testing.radiology_orders_test_codes_maprtcm_lab_id
_437.clients_test_codesctc_lab_id
_437.clients_test_codes_mapctcm_lab_id
_437.cpoe_responsescpoe_res_lab_id
_437.hl7_accessionsacc_lab_id
_437.insurancesins_lab_id
_437.insurances_newins_lab_id
_437.labs_orderslo_lab_id
_437.labs_orders_clients_pricinglocp_lab_id
_437.labs_resultslr_lab_id
_437.ordersord_lab_id
_437.orders_icd9_test_codes_mapoitcm_lab_id
_437.orders_templatesordt_lab_id
_437.orders_test_codes_mapotcm_lab_id
_437.radiology_ordersrad_lab_id
_437.radiology_orders_dx_test_codes_mapritcm_lab_id
_437.radiology_orders_test_codes_maprtcm_lab_id
_8.clients_test_codesctc_lab_id
_8.clients_test_codes_mapctcm_lab_id
_8.cpoe_responsescpoe_res_lab_id
_8.hl7_accessionsacc_lab_id
_8.insurancesins_lab_id
_8.insurances_newins_lab_id
_8.labs_orderslo_lab_id
_8.labs_orders_clients_pricinglocp_lab_id
_8.labs_resultslr_lab_id
_8.ordersord_lab_id
_8.orders_icd9_test_codes_mapoitcm_lab_id
_8.orders_templatesordt_lab_id
_8.orders_test_codes_mapotcm_lab_id
_8.radiology_ordersrad_lab_id
_8.radiology_orders_dx_test_codes_mapritcm_lab_id
_8.radiology_orders_test_codes_maprtcm_lab_id
_81.clients_test_codesctc_lab_id
_81.clients_test_codes_mapctcm_lab_id
_81.cpoe_responsescpoe_res_lab_id
_81.hl7_accessionsacc_lab_id
_81.insurancesins_lab_id
_81.insurances_newins_lab_id
_81.labs_orderslo_lab_id
_81.labs_orders_clients_pricinglocp_lab_id
_81.labs_resultslr_lab_id
_81.ordersord_lab_id
_81.orders_icd9_test_codes_mapoitcm_lab_id
_81.orders_templatesordt_lab_id
_81.orders_test_codes_mapotcm_lab_id
_81.radiology_ordersrad_lab_id
_81.radiology_orders_dx_test_codes_mapritcm_lab_id
_81.radiology_orders_test_codes_maprtcm_lab_id
_999.clients_test_codesctc_lab_id
_999.clients_test_codes_mapctcm_lab_id
_999.cpoe_responsescpoe_res_lab_id
_999.hl7_accessionsacc_lab_id
_999.insurancesins_lab_id
_999.insurances_newins_lab_id
_999.labs_orderslo_lab_id
_999.labs_orders_clients_pricinglocp_lab_id
_999.labs_resultslr_lab_id
_999.ordersord_lab_id
_999.orders_icd9_test_codes_mapoitcm_lab_id
_999.orders_templatesordt_lab_id
_999.orders_test_codes_mapotcm_lab_id
_999.radiology_ordersrad_lab_id
_999.radiology_orders_dx_test_codes_mapritcm_lab_id
_999.radiology_orders_test_codes_maprtcm_lab_id
common.customers_labscul_lab_id
common.interfaces_typesit_lab_id
common.lab_interfaces_performing_siteslips_lab_id
common.test_codestco_lab_id
common.test_codes_aoetcaoe_lab_id
common.test_codes_aoe_maptcaoem_lab_id
common.test_codes_cpttcc_lab_id
common.test_codes_panelstcp_lab_id
common.test_codes_profilestcp_lab_id
common.test_codes_resultstcr_lab_id