aurora_standard.chlrestd

Field	Type	Null	Key	Extra
reskey	int(11)	YES	MUL
ordkey	int(11)	YES	MUL
accno	int(11)	YES
subgroup	varchar(8)	YES
profile	varchar(8)	YES
test	varchar(8)	YES
result	decimal(8,3)	YES
remark	varchar(40)	YES
type_res	varchar(3)	YES
units	varchar(10)	YES
prec	smallint(6)	YES
low_ref	decimal(7,3)	YES
high_ref	decimal(7,3)	YES
text_ref	varchar(20)	YES
porder	int(11)	YES
torder	int(11)	YES
pdescrip	varchar(30)	YES
tdescrip	varchar(30)	YES
anal_date	date	YES
anal_time	varchar(6)	YES
tech	varchar(5)	YES
comments	varchar(60)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

comments

Table	Column
Loinc.loinc_codes	lc_comments
_1.patient_amendments	pa_comments
_1.patients_allergies	palg_comments
_1.patients_medications	pms_erx_comments
_1.patients_reminders	pr_comments
_1188.patient_amendments	pa_comments
_1188.patients_allergies	palg_comments
_1188.patients_medications	pms_erx_comments
_1188.patients_reminders	pr_comments
_1218.patient_amendments	pa_comments
_1218.patients_allergies	palg_comments
_1218.patients_medications	pms_erx_comments
_1218.patients_reminders	pr_comments
_1548.patient_amendments	pa_comments
_1548.patients_allergies	palg_comments
_1548.patients_medications	pms_erx_comments
_1548.patients_reminders	pr_comments
_435.patient_amendments	pa_comments
_435.patients_allergies	palg_comments
_435.patients_medications	pms_erx_comments
_435.patients_reminders	pr_comments
_436.patient_amendments	pa_comments
_436.patients_allergies	palg_comments
_436.patients_medications	pms_erx_comments
_436.patients_reminders	pr_comments
_436_archive_testing.patient_amendments	pa_comments
_436_archive_testing.patients_allergies	palg_comments
_436_archive_testing.patients_medications	pms_erx_comments
_436_archive_testing.patients_reminders	pr_comments
_437.patient_amendments	pa_comments
_437.patients_allergies	palg_comments
_437.patients_medications	pms_erx_comments
_437.patients_reminders	pr_comments
_8.patient_amendments	pa_comments
_8.patients_allergies	palg_comments
_8.patients_medications	pms_erx_comments
_8.patients_reminders	pr_comments
_81.patient_amendments	pa_comments
_81.patients_allergies	palg_comments
_81.patients_medications	pms_erx_comments
_81.patients_reminders	pr_comments
_999.patient_amendments	pa_comments
_999.patients_allergies	palg_comments
_999.patients_medications	pms_erx_comments
_999.patients_reminders	pr_comments
aurora_standard.cgsifldd	f_comments
aurora_standard.chlrescd	res_comments
aurora_standard.chpinsrd	class_comments
common.applicants	app_comments
common.data_import_clients_meta_data	dicmd_comments
common.data_import_field_types	dift_comments
common.data_import_fields	dif_comments
common.leads	lea_comments
common.loinc_codes	lc_comments

units

Table	Column
Loinc.loinc_codes	lc_ipcc_units
Loinc.loinc_codes	lc_submitted_units
Loinc.loinc_codes	lc_example_units
Loinc.loinc_codes	lc_curated_range_and_units
Loinc.loinc_codes	lc_example_ucum_units
Loinc.loinc_codes	lc_example_si_ucum_units
Loinc.loinc_codes_example_units	lceu_example_units
_1.charts_cpt_codes	chcp_num_units
_1.charts_medications	cm_quantity_units
_1.charts_procedures	cp_num_units
_1.clients_fee_schedules_map	cfsm_num_units
_1.clinical_interventions_coded_attributes	cica_units
_1.clinical_interventions_lab_results_map	cilrm_units
_1.configured_encounters_templates_cpt_codes	cetcc_num_units
_1.encounters_cpt_codes	ecp_num_units
_1.encounters_cpt_codes_templates	ecpt_num_units
_1.hl7_results	res_observ_units
_1.labs_results	lr_observ_units
_1.patients_immunizations	pim_administered_units
_1.patients_immunizations_templates	pimt_administered_units
_1.patients_inventory	pinv_administered_units
_1.patients_medications	pms_quantity_units
_1.patients_prescriptions	prx_quantity_units
_1.patients_responsibility_estimates_services	prests_ndc_num_units
_1.patients_responsibility_estimates_services	prests_num_units
_1.patients_responsibility_estimates_services	prests_allowed_units
_1.precerts_cpt_codes	pcp_num_units
_1188.charts_cpt_codes	chcp_num_units
_1188.charts_medications	cm_quantity_units
_1188.charts_procedures	cp_num_units
_1188.clients_fee_schedules_map	cfsm_num_units
_1188.clinical_interventions_lab_results_map	cilrm_units
_1188.configured_encounters_templates_cpt_codes	cetcc_num_units
_1188.encounters_cpt_codes	ecp_num_units
_1188.encounters_cpt_codes_templates	ecpt_num_units
_1188.hl7_results	res_observ_units
_1188.labs_results	lr_observ_units
_1188.patients_immunizations	pim_administered_units
_1188.patients_immunizations_templates	pimt_administered_units
_1188.patients_inventory	pinv_administered_units
_1188.patients_medications	pms_quantity_units
_1188.patients_prescriptions	prx_quantity_units
_1188.patients_responsibility_estimates_services	prests_ndc_num_units
_1188.patients_responsibility_estimates_services	prests_num_units
_1188.patients_responsibility_estimates_services	prests_allowed_units
_1188.precerts_cpt_codes	pcp_num_units
_1218.charts_cpt_codes	chcp_num_units
_1218.charts_medications	cm_quantity_units
_1218.charts_procedures	cp_num_units
_1218.clients_fee_schedules_map	cfsm_num_units
_1218.clinical_interventions_lab_results_map	cilrm_units
_1218.configured_encounters_templates_cpt_codes	cetcc_num_units
_1218.encounters_cpt_codes	ecp_num_units
_1218.encounters_cpt_codes_templates	ecpt_num_units
_1218.hl7_results	res_observ_units
_1218.labs_results	lr_observ_units
_1218.patients_immunizations	pim_administered_units
_1218.patients_immunizations_templates	pimt_administered_units
_1218.patients_inventory	pinv_administered_units
_1218.patients_medications	pms_quantity_units
_1218.patients_prescriptions	prx_quantity_units
_1218.patients_responsibility_estimates_services	prests_ndc_num_units
_1218.patients_responsibility_estimates_services	prests_num_units
_1218.patients_responsibility_estimates_services	prests_allowed_units
_1218.precerts_cpt_codes	pcp_num_units
_1548.charts_cpt_codes	chcp_num_units
_1548.charts_medications	cm_quantity_units
_1548.charts_procedures	cp_num_units
_1548.clients_fee_schedules_map	cfsm_num_units
_1548.clinical_interventions_coded_attributes	cica_units
_1548.clinical_interventions_lab_results_map	cilrm_units
_1548.configured_encounters_templates_cpt_codes	cetcc_num_units
_1548.encounters_cpt_codes	ecp_num_units
_1548.encounters_cpt_codes_templates	ecpt_num_units
_1548.hl7_results	res_observ_units
_1548.labs_results	lr_observ_units
_1548.patients_immunizations	pim_administered_units
_1548.patients_immunizations_templates	pimt_administered_units
_1548.patients_inventory	pinv_administered_units
_1548.patients_medications	pms_quantity_units
_1548.patients_prescriptions	prx_quantity_units
_1548.patients_responsibility_estimates_services	prests_ndc_num_units
_1548.patients_responsibility_estimates_services	prests_num_units
_1548.patients_responsibility_estimates_services	prests_allowed_units
_1548.precerts_cpt_codes	pcp_num_units
_435.charts_cpt_codes	chcp_num_units
_435.charts_medications	cm_quantity_units
_435.charts_procedures	cp_num_units
_435.clients_fee_schedules_map	cfsm_num_units
_435.clinical_interventions_coded_attributes	cica_units
_435.clinical_interventions_lab_results_map	cilrm_units
_435.configured_encounters_templates_cpt_codes	cetcc_num_units
_435.encounters_cpt_codes	ecp_num_units
_435.encounters_cpt_codes_templates	ecpt_num_units
_435.hl7_results	res_observ_units
_435.labs_results	lr_observ_units
_435.patients_immunizations	pim_administered_units
_435.patients_immunizations_templates	pimt_administered_units
_435.patients_inventory	pinv_administered_units
_435.patients_medications	pms_quantity_units
_435.patients_prescriptions	prx_quantity_units
_435.patients_responsibility_estimates_services	prests_ndc_num_units
_435.patients_responsibility_estimates_services	prests_num_units
_435.precerts_cpt_codes	pcp_num_units
_436.charts_cpt_codes	chcp_num_units
_436.charts_medications	cm_quantity_units
_436.charts_procedures	cp_num_units
_436.clients_fee_schedules_map	cfsm_num_units
_436.clinical_interventions_coded_attributes	cica_units
_436.clinical_interventions_lab_results_map	cilrm_units
_436.configured_encounters_templates_cpt_codes	cetcc_num_units
_436.encounters_cpt_codes	ecp_num_units
_436.encounters_cpt_codes_templates	ecpt_num_units
_436.hl7_results	res_observ_units
_436.labs_results	lr_observ_units
_436.patients_immunizations	pim_administered_units
_436.patients_immunizations_templates	pimt_administered_units
_436.patients_inventory	pinv_administered_units
_436.patients_medications	pms_quantity_units
_436.patients_prescriptions	prx_quantity_units
_436.patients_responsibility_estimates_services	prests_ndc_num_units
_436.patients_responsibility_estimates_services	prests_num_units
_436.precerts_cpt_codes	pcp_num_units
_436_archive_testing.charts_cpt_codes	chcp_num_units
_436_archive_testing.charts_medications	cm_quantity_units
_436_archive_testing.charts_procedures	cp_num_units
_436_archive_testing.clients_fee_schedules_map	cfsm_num_units
_436_archive_testing.clinical_interventions_coded_attributes	cica_units
_436_archive_testing.clinical_interventions_lab_results_map	cilrm_units
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_num_units
_436_archive_testing.encounters_cpt_codes	ecp_num_units
_436_archive_testing.encounters_cpt_codes_templates	ecpt_num_units
_436_archive_testing.hl7_results	res_observ_units
_436_archive_testing.labs_results	lr_observ_units
_436_archive_testing.patients_immunizations	pim_administered_units
_436_archive_testing.patients_immunizations_templates	pimt_administered_units
_436_archive_testing.patients_inventory	pinv_administered_units
_436_archive_testing.patients_medications	pms_quantity_units
_436_archive_testing.patients_prescriptions	prx_quantity_units
_436_archive_testing.patients_responsibility_estimates_services	prests_ndc_num_units
_436_archive_testing.patients_responsibility_estimates_services	prests_num_units
_436_archive_testing.precerts_cpt_codes	pcp_num_units
_437.charts_cpt_codes	chcp_num_units
_437.charts_medications	cm_quantity_units
_437.charts_procedures	cp_num_units
_437.clients_fee_schedules_map	cfsm_num_units
_437.clinical_interventions_coded_attributes	cica_units
_437.clinical_interventions_lab_results_map	cilrm_units
_437.configured_encounters_templates_cpt_codes	cetcc_num_units
_437.encounters_cpt_codes	ecp_num_units
_437.encounters_cpt_codes_templates	ecpt_num_units
_437.hl7_results	res_observ_units
_437.labs_results	lr_observ_units
_437.patients_immunizations	pim_administered_units
_437.patients_immunizations_templates	pimt_administered_units
_437.patients_inventory	pinv_administered_units
_437.patients_medications	pms_quantity_units
_437.patients_prescriptions	prx_quantity_units
_437.patients_responsibility_estimates_services	prests_ndc_num_units
_437.patients_responsibility_estimates_services	prests_num_units
_437.precerts_cpt_codes	pcp_num_units
_8.charts_cpt_codes	chcp_num_units
_8.charts_medications	cm_quantity_units
_8.charts_procedures	cp_num_units
_8.clients_fee_schedules_map	cfsm_num_units
_8.clinical_interventions_coded_attributes	cica_units
_8.clinical_interventions_lab_results_map	cilrm_units
_8.configured_encounters_templates_cpt_codes	cetcc_num_units
_8.daily_close_calculations	dcc_ecp_num_units
_8.encounters_cpt_codes	ecp_num_units
_8.encounters_cpt_codes_templates	ecpt_num_units
_8.hl7_results	res_observ_units
_8.labs_results	lr_observ_units
_8.patients_immunizations	pim_administered_units
_8.patients_immunizations_templates	pimt_administered_units
_8.patients_inventory	pinv_administered_units
_8.patients_medications	pms_quantity_units
_8.patients_prescriptions	prx_quantity_units
_8.patients_responsibility_estimates_services	prests_ndc_num_units
_8.patients_responsibility_estimates_services	prests_num_units
_8.patients_responsibility_estimates_services	prests_allowed_units
_8.precerts_cpt_codes	pcp_num_units
_81.charts_cpt_codes	chcp_num_units
_81.charts_medications	cm_quantity_units
_81.charts_procedures	cp_num_units
_81.clients_fee_schedules_map	cfsm_num_units
_81.clinical_interventions_lab_results_map	cilrm_units
_81.configured_encounters_templates_cpt_codes	cetcc_num_units
_81.encounters_cpt_codes	ecp_num_units
_81.encounters_cpt_codes_templates	ecpt_num_units
_81.hl7_results	res_observ_units
_81.labs_results	lr_observ_units
_81.patients_immunizations	pim_administered_units
_81.patients_immunizations_templates	pimt_administered_units
_81.patients_inventory	pinv_administered_units
_81.patients_medications	pms_quantity_units
_81.patients_prescriptions	prx_quantity_units
_81.patients_responsibility_estimates_services	prests_ndc_num_units
_81.patients_responsibility_estimates_services	prests_num_units
_81.patients_responsibility_estimates_services	prests_allowed_units
_81.precerts_cpt_codes	pcp_num_units
_999.charts_cpt_codes	chcp_num_units
_999.charts_medications	cm_quantity_units
_999.charts_procedures	cp_num_units
_999.clients_fee_schedules_map	cfsm_num_units
_999.clinical_interventions_coded_attributes	cica_units
_999.clinical_interventions_lab_results_map	cilrm_units
_999.configured_encounters_templates_cpt_codes	cetcc_num_units
_999.encounters_cpt_codes	ecp_num_units
_999.encounters_cpt_codes_templates	ecpt_num_units
_999.hl7_results	res_observ_units
_999.labs_results	lr_observ_units
_999.patients_immunizations	pim_administered_units
_999.patients_immunizations_templates	pimt_administered_units
_999.patients_inventory	pinv_administered_units
_999.patients_medications	pms_quantity_units
_999.patients_prescriptions	prx_quantity_units
_999.patients_responsibility_estimates_services	prests_ndc_num_units
_999.patients_responsibility_estimates_services	prests_num_units
_999.patients_responsibility_estimates_services	prests_allowed_units
_999.precerts_cpt_codes	pcp_num_units
aurora_standard.c7cdmrx	bill_units
aurora_standard.cachrg	chg_units
aurora_standard.cachrg2	chg_units
aurora_standard.cachrgca	chg_units
aurora_standard.cachrgevo	chg_units
aurora_standard.canullchrg	chg_units
aurora_standard.caroom	chg_units
aurora_standard.chmabstr	blood_units
aurora_standard.chmapcbr	cpt_units
aurora_standard.chmapcir	cpt_units
aurora_standard.choordmd	order_units
aurora_standard.choordrc	default_units
aurora_standard.chrordrr	dispense_units
aurora_standard.oeorder	order_units
common.loinc_codes	lc_ipcc_units
common.loinc_codes	lc_submitted_units
common.loinc_codes	lc_example_units
common.loinc_codes	lc_curated_range_and_units
common.loinc_codes	lc_example_ucum_units
common.loinc_codes	lc_example_si_ucum_units
common.test_codes_cpt	tcc_units
template_library.encounters_cpt_codes_templates	ecpt_num_units
template_library.patients_immunizations_templates	pimt_administered_units

result

Table	Column
_1.hl7_results	res_observ_result
_1.orders_paps	opap_last_pap_result
_1.radiology_results_test_codes_results	rrtcres_observ_result
_1188.hl7_results	res_observ_result
_1188.orders_paps	opap_last_pap_result
_1188.radiology_results_test_codes_results	rrtcres_observ_result
_1218.hl7_results	res_observ_result
_1218.orders_paps	opap_last_pap_result
_1218.radiology_results_test_codes_results	rrtcres_observ_result
_1548.hl7_results	res_observ_result
_1548.orders_paps	opap_last_pap_result
_1548.radiology_results_test_codes_results	rrtcres_observ_result
_435.hl7_results	res_observ_result
_435.orders_paps	opap_last_pap_result
_435.radiology_results_test_codes_results	rrtcres_observ_result
_436.hl7_results	res_observ_result
_436.orders_paps	opap_last_pap_result
_436.radiology_results_test_codes_results	rrtcres_observ_result
_436_archive_testing.hl7_results	res_observ_result
_436_archive_testing.orders_paps	opap_last_pap_result
_436_archive_testing.radiology_results_test_codes_results	rrtcres_observ_result
_437.hl7_results	res_observ_result
_437.orders_paps	opap_last_pap_result
_437.radiology_results_test_codes_results	rrtcres_observ_result
_8.hl7_results	res_observ_result
_8.orders_paps	opap_last_pap_result
_8.radiology_results_test_codes_results	rrtcres_observ_result
_81.hl7_results	res_observ_result
_81.orders_paps	opap_last_pap_result
_81.radiology_results_test_codes_results	rrtcres_observ_result
_999.hl7_results	res_observ_result
_999.orders_paps	opap_last_pap_result
_999.radiology_results_test_codes_results	rrtcres_observ_result
aurora_standard.hl7obr	parent_result
common.interfaces_types	it_lab_result

test

Table	Column
_1.labs_results	lr_drug_test
_1.orders_afps	oafp_repeat_test
_1188.labs_results	lr_drug_test
_1188.orders_afps	oafp_repeat_test
_1218.labs_results	lr_drug_test
_1218.orders_afps	oafp_repeat_test
_1548.labs_results	lr_drug_test
_1548.orders_afps	oafp_repeat_test
_435.labs_results	lr_drug_test
_435.orders_afps	oafp_repeat_test
_436.labs_results	lr_drug_test
_436.orders_afps	oafp_repeat_test
_436_archive_testing.labs_results	lr_drug_test
_436_archive_testing.orders_afps	oafp_repeat_test
_437.labs_results	lr_drug_test
_437.orders_afps	oafp_repeat_test
_8.labs_results	lr_drug_test
_8.orders_afps	oafp_repeat_test
_81.labs_results	lr_drug_test
_81.orders_afps	oafp_repeat_test
_999.labs_results	lr_drug_test
_999.orders_afps	oafp_repeat_test
aurora_standard.chmpricc	lab_test
aurora_standard.glsprice	lab_test
aurora_standard.hl7obx	nat_abnorm_test
common.clients	cli_test
common.test_codes	tco_afp_test
common.test_codes	tco_pap_test

tech

Table	Column
aurora_standard.chxstatr	stat_tech
aurora_standard.chystatr	stat_tech