aurora_standard.chrpyxid

Field	Type	Null	Key	Extra
visit_no	int(11)	YES	MUL
ord_no	int(11)	YES
item_no	decimal(6,0)	YES
seq_no	smallint(6)	YES
service_code	varchar(10)	YES	MUL
units	decimal(8,4)	YES
nurse_station	varchar(20)	YES
staff_name	varchar(30)	YES
source	varchar(20)	YES
posted	varchar(1)	YES
input_by	int(11)	YES
dose_charge	decimal(9,2)	YES
transaction_date	time	YES
dose_date	date	YES
track_flag	varchar(1)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

source

Table	Column
Loinc.loinc_codes	lc_source
Loinc.loinc_codes_source	lcsrc_source
_1.encounters_ub04	enc_ub04_15_source
_1.hl7_orders	ord_specimen_source
_1.immunizations	imz_funding_source
_1.orders	ord_source
_1.orders_templates	ordt_source
_1.patient_portal_requests	ppr_source
_1.patients_education_results	peres_source
_1.patients_immunizations	pim_funding_source
_1.pre_services_line_adjustments	prestsla_source
_1.radiology_orders	rad_source
_1.referral_sources	ref_source
_1188.encounters_ub04	enc_ub04_15_source
_1188.hl7_orders	ord_specimen_source
_1188.immunizations	imz_funding_source
_1188.orders	ord_source
_1188.orders_templates	ordt_source
_1188.patient_portal_requests	ppr_source
_1188.patients_education_results	peres_source
_1188.patients_immunizations	pim_funding_source
_1188.pre_services_line_adjustments	prestsla_source
_1188.radiology_orders	rad_source
_1188.referral_sources	ref_source
_1218.encounters_ub04	enc_ub04_15_source
_1218.hl7_orders	ord_specimen_source
_1218.immunizations	imz_funding_source
_1218.orders	ord_source
_1218.orders_templates	ordt_source
_1218.patient_portal_requests	ppr_source
_1218.patients_education_results	peres_source
_1218.patients_immunizations	pim_funding_source
_1218.pre_services_line_adjustments	prestsla_source
_1218.radiology_orders	rad_source
_1218.referral_sources	ref_source
_1548.encounters_ub04	enc_ub04_15_source
_1548.hl7_orders	ord_specimen_source
_1548.immunizations	imz_funding_source
_1548.orders	ord_source
_1548.orders_templates	ordt_source
_1548.patient_portal_requests	ppr_source
_1548.patients_education_results	peres_source
_1548.patients_immunizations	pim_funding_source
_1548.pre_services_line_adjustments	prestsla_source
_1548.radiology_orders	rad_source
_1548.referral_sources	ref_source
_435.encounters_ub04	enc_ub04_15_source
_435.hl7_orders	ord_specimen_source
_435.immunizations	imz_funding_source
_435.orders	ord_source
_435.orders_templates	ordt_source
_435.patient_portal_requests	ppr_source
_435.patients_education_results	peres_source
_435.patients_immunizations	pim_funding_source
_435.pre_services_line_adjustments	prestsla_source
_435.radiology_orders	rad_source
_435.referral_sources	ref_source
_436.encounters_ub04	enc_ub04_15_source
_436.hl7_orders	ord_specimen_source
_436.immunizations	imz_funding_source
_436.orders	ord_source
_436.orders_templates	ordt_source
_436.patient_portal_requests	ppr_source
_436.patients_education_results	peres_source
_436.patients_immunizations	pim_funding_source
_436.pre_services_line_adjustments	prestsla_source
_436.radiology_orders	rad_source
_436.referral_sources	ref_source
_436_archive_testing.encounters_ub04	enc_ub04_15_source
_436_archive_testing.hl7_orders	ord_specimen_source
_436_archive_testing.immunizations	imz_funding_source
_436_archive_testing.orders	ord_source
_436_archive_testing.orders_templates	ordt_source
_436_archive_testing.patient_portal_requests	ppr_source
_436_archive_testing.patients_education_results	peres_source
_436_archive_testing.patients_immunizations	pim_funding_source
_436_archive_testing.pre_services_line_adjustments	prestsla_source
_436_archive_testing.radiology_orders	rad_source
_436_archive_testing.referral_sources	ref_source
_437.encounters_ub04	enc_ub04_15_source
_437.hl7_orders	ord_specimen_source
_437.immunizations	imz_funding_source
_437.orders	ord_source
_437.orders_templates	ordt_source
_437.patient_portal_requests	ppr_source
_437.patients_education_results	peres_source
_437.patients_immunizations	pim_funding_source
_437.pre_services_line_adjustments	prestsla_source
_437.radiology_orders	rad_source
_437.referral_sources	ref_source
_8.encounters_ub04	enc_ub04_15_source
_8.hl7_orders	ord_specimen_source
_8.immunizations	imz_funding_source
_8.orders	ord_source
_8.orders_templates	ordt_source
_8.patient_portal_requests	ppr_source
_8.patients_education_results	peres_source
_8.patients_immunizations	pim_funding_source
_8.pre_services_line_adjustments	prestsla_source
_8.radiology_orders	rad_source
_8.referral_sources	ref_source
_81.encounters_ub04	enc_ub04_15_source
_81.hl7_orders	ord_specimen_source
_81.immunizations	imz_funding_source
_81.orders	ord_source
_81.orders_templates	ordt_source
_81.patient_portal_requests	ppr_source
_81.patients_education_results	peres_source
_81.patients_immunizations	pim_funding_source
_81.pre_services_line_adjustments	prestsla_source
_81.radiology_orders	rad_source
_81.referral_sources	ref_source
_999.encounters_ub04	enc_ub04_15_source
_999.hl7_orders	ord_specimen_source
_999.immunizations	imz_funding_source
_999.orders	ord_source
_999.orders_templates	ordt_source
_999.patient_portal_requests	ppr_source
_999.patients_education_results	peres_source
_999.patients_immunizations	pim_funding_source
_999.pre_services_line_adjustments	prestsla_source
_999.radiology_orders	rad_source
_999.referral_sources	ref_source
ahiWiki.recentchanges	rc_source
ahiWiki.sites	site_source
aurora_standard.chm1500r	payor_source
aurora_standard.chmabstr	grp_source
aurora_standard.chmdrgcc	grp_source
aurora_standard.chmedilr	payor_source
aurora_standard.chmfcglc	grp_source
aurora_standard.chmgrprc	grp_source
aurora_standard.chmmdccc	grp_source
aurora_standard.chmmrhdr	get_grp_source
aurora_standard.chmpysrc	pay_source
aurora_standard.chmpysrc	grp_source
aurora_standard.chmvrsnc	grp_source
aurora_standard.chpvacid	vac_phy_source
aurora_standard.chpvacsc	vac_source
aurora_standard.chqletrd	letter_source
aurora_standard.chtclokd	trans_source
aurora_standard.hhtclokd	trans_source
aurora_standard.hl7in2	policy_source
aurora_standard.timetabl	trans_source
aurora_standard.tmpmrrpt	claim_source
aurora_standard.workdrg	grp_source
common.loinc_codes	lc_source
template_library.orders_templates	ordt_source

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

visit_no

Table	Column
aurora_standard.anotesd	an_visit_no
aurora_standard.bdfiled	bd_visit_no
aurora_standard.chmarsi	pat_visit_no
aurora_standard.chmcampi	pat_visit_no
aurora_standard.chmcombr	to_visit_no
aurora_standard.chmexmpi	pat_visit_no
aurora_standard.chmokipd	pat_visit_no
aurora_standard.chmokopd	pat_visit_no
aurora_standard.chmraded	pat_visit_no
aurora_standard.chmradex	pat_visit_no
aurora_standard.chrcombr	to_visit_no
aurora_standard.ncexmpi	pat_visit_no

seq_no

Table	Column
aurora_standard.chmarsta	rec_seq_no
aurora_standard.chmarstac	rec_seq_no
aurora_standard.chmarstai	rec_seq_no
aurora_standard.chmarstd	rec_seq_no
aurora_standard.chmarstdi	rec_seq_no
aurora_standard.chmarste	rec_seq_no
aurora_standard.chmarsth	rec_seq_no
aurora_standard.chmarsthi	rec_seq_no
aurora_standard.chmarstph	rec_seq_no
aurora_standard.chmarstpi	rec_seq_no
aurora_standard.chmarstpo	rec_seq_no
aurora_standard.chmarstpq	rec_seq_no
aurora_standard.chmarstpr	rec_seq_no
aurora_standard.chmarstps	rec_seq_no
aurora_standard.chmarstpt	rec_seq_no
aurora_standard.chmarstpy	rec_seq_no
aurora_standard.chmcosta	rec_seq_no
aurora_standard.chmcostb	rec_seq_no
aurora_standard.chmcostd	rec_seq_no
aurora_standard.chmcostrc	rec_seq_no
aurora_standard.chmgltcd	a_seq_no
aurora_standard.chmgltcd	b_seq_no
aurora_standard.chmhid4a	rec_seq_no
aurora_standard.chmhid4b	rec_seq_no
aurora_standard.chmhid4c	rec_seq_no
aurora_standard.chmhid4d	rec_seq_no
aurora_standard.chmhid4g	rec_seq_no
aurora_standard.chrhhdcc	listing_seq_no
aurora_standard.chrhhmpr	listing_seq_no
aurora_standard.chrhhndc	listing_seq_no
aurora_standard.chrhhndc	firm_seq_no
aurora_standard.chrhhroc	listing_seq_no
aurora_standard.chrmndc	listing_seq_no
aurora_standard.chrmndc	firm_seq_no
aurora_standard.chxhistd	h_seq_no
aurora_standard.chyhistd	h_seq_no
aurora_standard.drugclas	listing_seq_no
aurora_standard.formulat	listing_seq_no
aurora_standard.listings	listing_seq_no
aurora_standard.listings	firm_seq_no
aurora_standard.package	listing_seq_no
aurora_standard.routes	listing_seq_no

item_no

Table	Column
aurora_standard.chmpintr	rx_item_no