common.test_codes

Field Type Null Default Key Extra Comment
tco_id int(11) NO PRI auto_increment
tco_lab_id int(11) NO MUL
tco_test_code varchar(128) NO MUL
tco_is_panel char(1) NO
tco_reporting_title text NO
tco_test_type varchar(128) YES
tco_keywords text NO
tco_cpt text NO
tco_master_charge varchar(20) NO
tco_afp_test char(1) NO 0
tco_pap_test char(1) NO 0
tco_x_type text NO
tco_x_specimen_description text NO
tco_x_referred_to text NO
tco_x_price text NO
tco_x_preferred_specimen_requirements text NO
tco_x_container_type text NO
tco_x_alt_acceptable_specimen_requirements text NO
tco_x_transport_temperature text NO
tco_x_minimum_specimen_volume text NO
tco_x_lab_area_dept text NO
tco_x_analytic_turn_around_time text NO
tco_x_days_performed text NO
tco_x_methodology text NO
tco_x_stability text NO
tco_x_reject_due_to_hemolysis text NO
tco_x_reject_due_to_thawing_or_other text NO
tco_x_inquiry_instructions text NO
tco_x_draw_list_instructions text NO
tco_disabled char(1) NO is test code disabled
tco_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
tco_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
tco_id
TableColumn
_1.clients_test_codes_mapctcm_tco_id
_1.orders_test_codesotc_tco_id
_1.orders_test_codes_mapotcm_tco_id
_1.orders_test_codes_statsotcs_tco_id
_1.orders_test_codes_templatesotct_tco_id
_1.test_codes_search_frequencytcof_tco_id
_1188.clients_test_codes_mapctcm_tco_id
_1188.orders_test_codesotc_tco_id
_1188.orders_test_codes_mapotcm_tco_id
_1188.orders_test_codes_statsotcs_tco_id
_1188.orders_test_codes_templatesotct_tco_id
_1188.test_codes_search_frequencytcof_tco_id
_1218.clients_test_codes_mapctcm_tco_id
_1218.orders_test_codesotc_tco_id
_1218.orders_test_codes_mapotcm_tco_id
_1218.orders_test_codes_statsotcs_tco_id
_1218.orders_test_codes_templatesotct_tco_id
_1218.test_codes_search_frequencytcof_tco_id
_1548.clients_test_codes_mapctcm_tco_id
_1548.orders_test_codesotc_tco_id
_1548.orders_test_codes_mapotcm_tco_id
_1548.orders_test_codes_statsotcs_tco_id
_1548.orders_test_codes_templatesotct_tco_id
_1548.test_codes_search_frequencytcof_tco_id
_435.clients_test_codes_mapctcm_tco_id
_435.orders_test_codesotc_tco_id
_435.orders_test_codes_mapotcm_tco_id
_435.orders_test_codes_statsotcs_tco_id
_435.orders_test_codes_templatesotct_tco_id
_435.test_codes_search_frequencytcof_tco_id
_436.clients_test_codes_mapctcm_tco_id
_436.orders_test_codesotc_tco_id
_436.orders_test_codes_mapotcm_tco_id
_436.orders_test_codes_statsotcs_tco_id
_436.orders_test_codes_templatesotct_tco_id
_436.test_codes_search_frequencytcof_tco_id
_436_archive_testing.clients_test_codes_mapctcm_tco_id
_436_archive_testing.orders_test_codesotc_tco_id
_436_archive_testing.orders_test_codes_mapotcm_tco_id
_436_archive_testing.orders_test_codes_statsotcs_tco_id
_436_archive_testing.orders_test_codes_templatesotct_tco_id
_436_archive_testing.test_codes_search_frequencytcof_tco_id
_437.clients_test_codes_mapctcm_tco_id
_437.orders_test_codesotc_tco_id
_437.orders_test_codes_mapotcm_tco_id
_437.orders_test_codes_statsotcs_tco_id
_437.orders_test_codes_templatesotct_tco_id
_437.test_codes_search_frequencytcof_tco_id
_8.clients_test_codes_mapctcm_tco_id
_8.orders_test_codesotc_tco_id
_8.orders_test_codes_mapotcm_tco_id
_8.orders_test_codes_statsotcs_tco_id
_8.orders_test_codes_templatesotct_tco_id
_8.test_codes_search_frequencytcof_tco_id
_81.clients_test_codes_mapctcm_tco_id
_81.orders_test_codesotc_tco_id
_81.orders_test_codes_mapotcm_tco_id
_81.orders_test_codes_statsotcs_tco_id
_81.orders_test_codes_templatesotct_tco_id
_81.test_codes_search_frequencytcof_tco_id
_999.clients_test_codes_mapctcm_tco_id
_999.orders_test_codesotc_tco_id
_999.orders_test_codes_mapotcm_tco_id
_999.orders_test_codes_statsotcs_tco_id
_999.orders_test_codes_templatesotct_tco_id
_999.test_codes_search_frequencytcof_tco_id
common.test_codes_aoe_maptcaoem_tco_id
common.test_codes_cpttcc_tco_id
common.test_codes_results_test_codes_maptcrtcm_tco_id
template_library.orders_test_codes_templatesotct_tco_id