aurora_standard.audroomd

Field	Type	Null	Key	Extra
visit_no	int(11)	YES	MUL
nurs_stat	varchar(10)	YES	MUL
room	varchar(10)	YES	MUL
bed	varchar(10)	YES
room_date	date	YES	MUL
acc_code	varchar(3)	YES
level_care	varchar(3)	YES
clin_class	varchar(10)	YES
fin_class	varchar(5)	YES
pat_status	varchar(3)	YES
bill_stat	varchar(3)	YES	MUL
gl_flag	varchar(1)	YES
input_by	int(11)	YES
location	varchar(3)	YES
amount	decimal(16,2)	YES
doc_no	int(11)	YES
ub_rev_code	varchar(4)	YES
which_log	varchar(2)	YES
direct_cost	decimal(10,3)	YES
indirect_cost	decimal(10,3)	YES
proc_date	date	YES
stmnt_no	smallint(6)	YES
gl_no	int(11)	YES
gl_no_d	varchar(3)	YES
del_date	date	YES
del_time	time	YES
user_login	varchar(20)	YES
orig_rowid	bigint(20)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

amount

Table	Column
HSPI_CURES2015_B1.invoice_generation_rule_sets	minimum_amount
HSPI_Central_Hospital.invoice_generation_rule_sets	minimum_amount
HSPI_Dewitt.invoice_generation_rule_sets	minimum_amount
HSPI_Fulton.invoice_generation_rule_sets	minimum_amount
HSPI_Inferno.invoice_generation_rule_sets	minimum_amount
HSPI_MU2015_E1.invoice_generation_rule_sets	minimum_amount
HSPI_MU2015_G2.invoice_generation_rule_sets	minimum_amount
HSPI_MU2015_G9.invoice_generation_rule_sets	minimum_amount
HSPI_Sandbox.invoice_generation_rule_sets	minimum_amount
HSPI_Summit_General.invoice_generation_rule_sets	minimum_amount
HSPI_United_Physicians.invoice_generation_rule_sets	minimum_amount
MPI.invoice_generation_rule_sets	minimum_amount
_1.billing_codes	bil_negative_amount
_1.billing_codes	bil_positive_amount
_1.encounters_payments	epay_amount
_1.encounters_ub04	enc_ub04_39_a_amount
_1.encounters_ub04	enc_ub04_39_b_amount
_1.encounters_ub04	enc_ub04_39_c_amount
_1.encounters_ub04	enc_ub04_39_d_amount
_1.encounters_ub04	enc_ub04_40_a_amount
_1.encounters_ub04	enc_ub04_40_b_amount
_1.encounters_ub04	enc_ub04_40_c_amount
_1.encounters_ub04	enc_ub04_40_d_amount
_1.encounters_ub04	enc_ub04_41_a_amount
_1.encounters_ub04	enc_ub04_41_b_amount
_1.encounters_ub04	enc_ub04_41_c_amount
_1.encounters_ub04	enc_ub04_41_d_amount
_1.insurances_allowables_cpt_map	iacm_amount
_1.insurances_contracted_pricing	icp_amount
_1.ledger	led_amount
_1.ledger	led_orig_amount
_1.ledger	led_unit_amount
_1.patient_finance_records	pfr_min_due_amount
_1.patients	pat_min_due_amount
_1.patients_immunizations	pim_administered_amount
_1.patients_immunizations_templates	pimt_administered_amount
_1.patients_inventory	pinv_administered_amount
_1.patients_payments_schedules	pps_amount
_1.patients_responsibility_estimates	prest_allowed_amount
_1.patients_responsibility_estimates_services	prests_allowed_amount
_1.pre_services_line_adjustments	prestsla_amount
_1.voided_payments	vp_amount
_1.voided_payments	vp_orig_amount
_1188.billing_codes	bil_negative_amount
_1188.billing_codes	bil_positive_amount
_1188.encounters_payments	epay_amount
_1188.encounters_ub04	enc_ub04_39_a_amount
_1188.encounters_ub04	enc_ub04_39_b_amount
_1188.encounters_ub04	enc_ub04_39_c_amount
_1188.encounters_ub04	enc_ub04_39_d_amount
_1188.encounters_ub04	enc_ub04_40_a_amount
_1188.encounters_ub04	enc_ub04_40_b_amount
_1188.encounters_ub04	enc_ub04_40_c_amount
_1188.encounters_ub04	enc_ub04_40_d_amount
_1188.encounters_ub04	enc_ub04_41_a_amount
_1188.encounters_ub04	enc_ub04_41_b_amount
_1188.encounters_ub04	enc_ub04_41_c_amount
_1188.encounters_ub04	enc_ub04_41_d_amount
_1188.insurances_allowables_cpt_map	iacm_amount
_1188.insurances_contracted_pricing	icp_amount
_1188.ledger	led_amount
_1188.ledger	led_orig_amount
_1188.ledger	led_unit_amount
_1188.patient_finance_records	pfr_min_due_amount
_1188.patients	pat_min_due_amount
_1188.patients_immunizations	pim_administered_amount
_1188.patients_immunizations_templates	pimt_administered_amount
_1188.patients_inventory	pinv_administered_amount
_1188.patients_payments_schedules	pps_amount
_1188.patients_responsibility_estimates	prest_allowed_amount
_1188.patients_responsibility_estimates_services	prests_allowed_amount
_1188.pre_services_line_adjustments	prestsla_amount
_1188.voided_payments	vp_amount
_1188.voided_payments	vp_orig_amount
_1218.billing_codes	bil_negative_amount
_1218.billing_codes	bil_positive_amount
_1218.encounters_payments	epay_amount
_1218.encounters_ub04	enc_ub04_39_a_amount
_1218.encounters_ub04	enc_ub04_39_b_amount
_1218.encounters_ub04	enc_ub04_39_c_amount
_1218.encounters_ub04	enc_ub04_39_d_amount
_1218.encounters_ub04	enc_ub04_40_a_amount
_1218.encounters_ub04	enc_ub04_40_b_amount
_1218.encounters_ub04	enc_ub04_40_c_amount
_1218.encounters_ub04	enc_ub04_40_d_amount
_1218.encounters_ub04	enc_ub04_41_a_amount
_1218.encounters_ub04	enc_ub04_41_b_amount
_1218.encounters_ub04	enc_ub04_41_c_amount
_1218.encounters_ub04	enc_ub04_41_d_amount
_1218.insurances_allowables_cpt_map	iacm_amount
_1218.insurances_contracted_pricing	icp_amount
_1218.led_temporary_ledger_table_ANM	led_amount
_1218.led_temporary_ledger_table_ANM	led_orig_amount
_1218.ledger	led_amount
_1218.ledger	led_orig_amount
_1218.ledger	led_unit_amount
_1218.patient_finance_records	pfr_min_due_amount
_1218.patients	pat_min_due_amount
_1218.patients_immunizations	pim_administered_amount
_1218.patients_immunizations_templates	pimt_administered_amount
_1218.patients_inventory	pinv_administered_amount
_1218.patients_payments_schedules	pps_amount
_1218.patients_responsibility_estimates	prest_allowed_amount
_1218.patients_responsibility_estimates_services	prests_allowed_amount
_1218.pre_services_line_adjustments	prestsla_amount
_1218.voided_payments	vp_amount
_1218.voided_payments	vp_orig_amount
_1548.billing_codes	bil_negative_amount
_1548.billing_codes	bil_positive_amount
_1548.encounters_payments	epay_amount
_1548.encounters_ub04	enc_ub04_39_a_amount
_1548.encounters_ub04	enc_ub04_39_b_amount
_1548.encounters_ub04	enc_ub04_39_c_amount
_1548.encounters_ub04	enc_ub04_39_d_amount
_1548.encounters_ub04	enc_ub04_40_a_amount
_1548.encounters_ub04	enc_ub04_40_b_amount
_1548.encounters_ub04	enc_ub04_40_c_amount
_1548.encounters_ub04	enc_ub04_40_d_amount
_1548.encounters_ub04	enc_ub04_41_a_amount
_1548.encounters_ub04	enc_ub04_41_b_amount
_1548.encounters_ub04	enc_ub04_41_c_amount
_1548.encounters_ub04	enc_ub04_41_d_amount
_1548.insurances_allowables_cpt_map	iacm_amount
_1548.insurances_contracted_pricing	icp_amount
_1548.ledger	led_amount
_1548.ledger	led_orig_amount
_1548.ledger	led_unit_amount
_1548.patient_finance_records	pfr_min_due_amount
_1548.patients	pat_min_due_amount
_1548.patients_immunizations	pim_administered_amount
_1548.patients_immunizations_templates	pimt_administered_amount
_1548.patients_inventory	pinv_administered_amount
_1548.patients_payments_schedules	pps_amount
_1548.patients_responsibility_estimates	prest_allowed_amount
_1548.patients_responsibility_estimates_services	prests_allowed_amount
_1548.pre_services_line_adjustments	prestsla_amount
_1548.voided_payments	vp_amount
_1548.voided_payments	vp_orig_amount
_435.billing_codes	bil_negative_amount
_435.billing_codes	bil_positive_amount
_435.encounters_payments	epay_amount
_435.encounters_ub04	enc_ub04_39_a_amount
_435.encounters_ub04	enc_ub04_39_b_amount
_435.encounters_ub04	enc_ub04_39_c_amount
_435.encounters_ub04	enc_ub04_39_d_amount
_435.encounters_ub04	enc_ub04_40_a_amount
_435.encounters_ub04	enc_ub04_40_b_amount
_435.encounters_ub04	enc_ub04_40_c_amount
_435.encounters_ub04	enc_ub04_40_d_amount
_435.encounters_ub04	enc_ub04_41_a_amount
_435.encounters_ub04	enc_ub04_41_b_amount
_435.encounters_ub04	enc_ub04_41_c_amount
_435.encounters_ub04	enc_ub04_41_d_amount
_435.insurances_allowables_cpt_map	iacm_amount
_435.insurances_contracted_pricing	icp_amount
_435.ledger	led_amount
_435.ledger	led_orig_amount
_435.ledger	led_unit_amount
_435.patient_finance_records	pfr_min_due_amount
_435.patients	pat_min_due_amount
_435.patients_immunizations	pim_administered_amount
_435.patients_immunizations_templates	pimt_administered_amount
_435.patients_inventory	pinv_administered_amount
_435.patients_payments_schedules	pps_amount
_435.patients_responsibility_estimates	prest_allowed_amount
_435.patients_responsibility_estimates_services	prests_allowed_amount
_435.pre_services_line_adjustments	prestsla_amount
_435.voided_payments	vp_amount
_435.voided_payments	vp_orig_amount
_436.billing_codes	bil_negative_amount
_436.billing_codes	bil_positive_amount
_436.encounters_payments	epay_amount
_436.encounters_ub04	enc_ub04_39_a_amount
_436.encounters_ub04	enc_ub04_39_b_amount
_436.encounters_ub04	enc_ub04_39_c_amount
_436.encounters_ub04	enc_ub04_39_d_amount
_436.encounters_ub04	enc_ub04_40_a_amount
_436.encounters_ub04	enc_ub04_40_b_amount
_436.encounters_ub04	enc_ub04_40_c_amount
_436.encounters_ub04	enc_ub04_40_d_amount
_436.encounters_ub04	enc_ub04_41_a_amount
_436.encounters_ub04	enc_ub04_41_b_amount
_436.encounters_ub04	enc_ub04_41_c_amount
_436.encounters_ub04	enc_ub04_41_d_amount
_436.insurances_allowables_cpt_map	iacm_amount
_436.insurances_contracted_pricing	icp_amount
_436.ledger	led_amount
_436.ledger	led_orig_amount
_436.ledger	led_unit_amount
_436.patient_finance_records	pfr_min_due_amount
_436.patients	pat_min_due_amount
_436.patients_immunizations	pim_administered_amount
_436.patients_immunizations_templates	pimt_administered_amount
_436.patients_inventory	pinv_administered_amount
_436.patients_payments_schedules	pps_amount
_436.patients_responsibility_estimates	prest_allowed_amount
_436.patients_responsibility_estimates_services	prests_allowed_amount
_436.pre_services_line_adjustments	prestsla_amount
_436.voided_payments	vp_amount
_436.voided_payments	vp_orig_amount
_436_archive_testing.billing_codes	bil_negative_amount
_436_archive_testing.billing_codes	bil_positive_amount
_436_archive_testing.encounters_payments	epay_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_a_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_b_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_c_amount
_436_archive_testing.encounters_ub04	enc_ub04_39_d_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_a_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_b_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_c_amount
_436_archive_testing.encounters_ub04	enc_ub04_40_d_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_a_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_b_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_c_amount
_436_archive_testing.encounters_ub04	enc_ub04_41_d_amount
_436_archive_testing.insurances_allowables_cpt_map	iacm_amount
_436_archive_testing.insurances_contracted_pricing	icp_amount
_436_archive_testing.ledger	led_amount
_436_archive_testing.ledger	led_orig_amount
_436_archive_testing.ledger	led_unit_amount
_436_archive_testing.patient_finance_records	pfr_min_due_amount
_436_archive_testing.patients	pat_min_due_amount
_436_archive_testing.patients_immunizations	pim_administered_amount
_436_archive_testing.patients_immunizations_templates	pimt_administered_amount
_436_archive_testing.patients_inventory	pinv_administered_amount
_436_archive_testing.patients_payments_schedules	pps_amount
_436_archive_testing.patients_responsibility_estimates	prest_allowed_amount
_436_archive_testing.patients_responsibility_estimates_services	prests_allowed_amount
_436_archive_testing.pre_services_line_adjustments	prestsla_amount
_436_archive_testing.voided_payments	vp_amount
_436_archive_testing.voided_payments	vp_orig_amount
_437.billing_codes	bil_negative_amount
_437.billing_codes	bil_positive_amount
_437.encounters_payments	epay_amount
_437.encounters_ub04	enc_ub04_39_a_amount
_437.encounters_ub04	enc_ub04_39_b_amount
_437.encounters_ub04	enc_ub04_39_c_amount
_437.encounters_ub04	enc_ub04_39_d_amount
_437.encounters_ub04	enc_ub04_40_a_amount
_437.encounters_ub04	enc_ub04_40_b_amount
_437.encounters_ub04	enc_ub04_40_c_amount
_437.encounters_ub04	enc_ub04_40_d_amount
_437.encounters_ub04	enc_ub04_41_a_amount
_437.encounters_ub04	enc_ub04_41_b_amount
_437.encounters_ub04	enc_ub04_41_c_amount
_437.encounters_ub04	enc_ub04_41_d_amount
_437.insurances_allowables_cpt_map	iacm_amount
_437.insurances_contracted_pricing	icp_amount
_437.ledger	led_amount
_437.ledger	led_orig_amount
_437.ledger	led_unit_amount
_437.patient_finance_records	pfr_min_due_amount
_437.patients	pat_min_due_amount
_437.patients_immunizations	pim_administered_amount
_437.patients_immunizations_templates	pimt_administered_amount
_437.patients_inventory	pinv_administered_amount
_437.patients_payments_schedules	pps_amount
_437.patients_responsibility_estimates	prest_allowed_amount
_437.patients_responsibility_estimates_services	prests_allowed_amount
_437.pre_services_line_adjustments	prestsla_amount
_437.voided_payments	vp_amount
_437.voided_payments	vp_orig_amount
_8.billing_codes	bil_negative_amount
_8.billing_codes	bil_positive_amount
_8.daily_close_calculations	dcc_last_payment_amount
_8.daily_close_calculations	dcc_bil_negative_amount
_8.daily_close_calculations	dcc_bil_positive_amount
_8.daily_close_calculations	dcc_led_amount
_8.daily_close_calculations	dcc_led_orig_amount
_8.encounters_payments	epay_amount
_8.encounters_ub04	enc_ub04_39_a_amount
_8.encounters_ub04	enc_ub04_39_b_amount
_8.encounters_ub04	enc_ub04_39_c_amount
_8.encounters_ub04	enc_ub04_39_d_amount
_8.encounters_ub04	enc_ub04_40_a_amount
_8.encounters_ub04	enc_ub04_40_b_amount
_8.encounters_ub04	enc_ub04_40_c_amount
_8.encounters_ub04	enc_ub04_40_d_amount
_8.encounters_ub04	enc_ub04_41_a_amount
_8.encounters_ub04	enc_ub04_41_b_amount
_8.encounters_ub04	enc_ub04_41_c_amount
_8.encounters_ub04	enc_ub04_41_d_amount
_8.insurances_allowables_cpt_map	iacm_amount
_8.insurances_contracted_pricing	icp_amount
_8.ledger	led_amount
_8.ledger	led_orig_amount
_8.ledger	led_unit_amount
_8.patient_finance_records	pfr_min_due_amount
_8.patients	pat_min_due_amount
_8.patients_immunizations	pim_administered_amount
_8.patients_immunizations_templates	pimt_administered_amount
_8.patients_inventory	pinv_administered_amount
_8.patients_payments_schedules	pps_amount
_8.patients_responsibility_estimates	prest_allowed_amount
_8.patients_responsibility_estimates_services	prests_allowed_amount
_8.pre_services_line_adjustments	prestsla_amount
_8.voided_payments	vp_amount
_8.voided_payments	vp_orig_amount
_81.billing_codes	bil_negative_amount
_81.billing_codes	bil_positive_amount
_81.encounters_payments	epay_amount
_81.encounters_ub04	enc_ub04_39_a_amount
_81.encounters_ub04	enc_ub04_39_b_amount
_81.encounters_ub04	enc_ub04_39_c_amount
_81.encounters_ub04	enc_ub04_39_d_amount
_81.encounters_ub04	enc_ub04_40_a_amount
_81.encounters_ub04	enc_ub04_40_b_amount
_81.encounters_ub04	enc_ub04_40_c_amount
_81.encounters_ub04	enc_ub04_40_d_amount
_81.encounters_ub04	enc_ub04_41_a_amount
_81.encounters_ub04	enc_ub04_41_b_amount
_81.encounters_ub04	enc_ub04_41_c_amount
_81.encounters_ub04	enc_ub04_41_d_amount
_81.insurances_allowables_cpt_map	iacm_amount
_81.insurances_contracted_pricing	icp_amount
_81.ledger	led_amount
_81.ledger	led_orig_amount
_81.ledger	led_unit_amount
_81.patient_finance_records	pfr_min_due_amount
_81.patients	pat_min_due_amount
_81.patients_immunizations	pim_administered_amount
_81.patients_immunizations_templates	pimt_administered_amount
_81.patients_inventory	pinv_administered_amount
_81.patients_payments_schedules	pps_amount
_81.patients_responsibility_estimates	prest_allowed_amount
_81.patients_responsibility_estimates_services	prests_allowed_amount
_81.pre_services_line_adjustments	prestsla_amount
_81.voided_payments	vp_amount
_81.voided_payments	vp_orig_amount
_999.billing_codes	bil_negative_amount
_999.billing_codes	bil_positive_amount
_999.encounters_payments	epay_amount
_999.encounters_ub04	enc_ub04_39_a_amount
_999.encounters_ub04	enc_ub04_39_b_amount
_999.encounters_ub04	enc_ub04_39_c_amount
_999.encounters_ub04	enc_ub04_39_d_amount
_999.encounters_ub04	enc_ub04_40_a_amount
_999.encounters_ub04	enc_ub04_40_b_amount
_999.encounters_ub04	enc_ub04_40_c_amount
_999.encounters_ub04	enc_ub04_40_d_amount
_999.encounters_ub04	enc_ub04_41_a_amount
_999.encounters_ub04	enc_ub04_41_b_amount
_999.encounters_ub04	enc_ub04_41_c_amount
_999.encounters_ub04	enc_ub04_41_d_amount
_999.insurances_allowables_cpt_map	iacm_amount
_999.insurances_contracted_pricing	icp_amount
_999.ledger	led_amount
_999.ledger	led_orig_amount
_999.ledger	led_unit_amount
_999.patient_finance_records	pfr_min_due_amount
_999.patients	pat_min_due_amount
_999.patients_immunizations	pim_administered_amount
_999.patients_immunizations_templates	pimt_administered_amount
_999.patients_inventory	pinv_administered_amount
_999.patients_payments_schedules	pps_amount
_999.patients_responsibility_estimates	prest_allowed_amount
_999.patients_responsibility_estimates_services	prests_allowed_amount
_999.pre_services_line_adjustments	prestsla_amount
_999.voided_payments	vp_amount
_999.voided_payments	vp_orig_amount
aurora_standard.amcbd	wo_amount
aurora_standard.chmnbcgr	tot_amount
aurora_standard.chmnbpyr	tot_amount
aurora_standard.chmtbtrr	tot_amount
aurora_standard.chpempir	life_amount
aurora_standard.chrdrugc	purch_amount
aurora_standard.chtwkhrd	carry_amount
aurora_standard.mktcus	proposal_amount
aurora_standard.oddpayre	cash_amount
aurora_standard.odhpayre	cash_amount
aurora_standard.stfactvd	depr_amount
aurora_standard.stfactvv	depr_amount
aurora_standard.stoinvce	item_amount
aurora_standard.stoinvce	trd_ds_amount
aurora_standard.stoinvce	st_tx_amount
aurora_standard.stoinvce	co_tx_amount
aurora_standard.stoinvce	ci_tx_amount
aurora_standard.stoinvce	frght_amount
aurora_standard.stoinvce	total_amount
aurora_standard.stoinvce	tax_amount
aurora_standard.stoordrd	tax_amount
aurora_standard.stoordrd	net_amount
aurora_standard.stoordre	item_amount
aurora_standard.stoordre	trd_ds_amount
aurora_standard.stoordre	tax_amount
aurora_standard.stoordre	frght_amount
aurora_standard.stoordre	total_amount
aurora_standard.stoshipd	tax_amount
aurora_standard.stoshipd	net_amount
aurora_standard.stpactvd	home_curr_amount
aurora_standard.stpinvce	disc_amount
aurora_standard.stpinvce	ap_amount
aurora_standard.stpinvce	home_curr_amount
aurora_standard.stpopend	orig_amount
aurora_standard.stpopend	home_curr_amount
aurora_standard.stractvd	home_curr_amount
aurora_standard.strcustr	stmt_amount
aurora_standard.strinvce	disc_amount
aurora_standard.strinvce	tax_amount
aurora_standard.strinvce	frght_amount
aurora_standard.strinvce	misc_amount
aurora_standard.strinvce	ar_amount
aurora_standard.strinvce	home_curr_amount
aurora_standard.strnoted	orig_amount
aurora_standard.stropend	orig_amount
aurora_standard.stropend	home_curr_amount
aurora_standard.stuinvce	misc_amount
aurora_standard.stuinvce	frght_amount
aurora_standard.stuordre	item_amount
aurora_standard.stuordre	trd_ds_amount
aurora_standard.stuordre	tax_amount
aurora_standard.stuordre	frght_amount
aurora_standard.stuordre	misc_amount
aurora_standard.stuordre	goods_amount
aurora_standard.stuordre	total_amount
aurora_standard.stuordre	prepay_amount
aurora_standard.styinccr	ot_shift_amount
aurora_standard.stypayre	cash_amount
aurora_standard.styrevsd	cash_amount
aurora_standard.tmp04d	chg_amount
aurora_standard.tmp15chd	chg_amount
common.billing_codes	bil_negative_amount
common.billing_codes	bil_positive_amount
common.rcm_stats_aging	rcmsa_0_30_amount
common.rcm_stats_aging	rcmsa_31_60_amount
common.rcm_stats_aging	rcmsa_61_90_amount
common.rcm_stats_aging	rcmsa_91_120_amount
common.rcm_stats_aging	rcmsa_121_amount
common.rcm_stats_aging	rcmsa_total_amount
template_library.patients_immunizations_templates	pimt_administered_amount

location

Table	Column
_1.cpoe_responses	cpoe_res_location
_1.encounters_soap_vitals	espv_location
_1.hl7_accessions	acc_location
_1.patients_immunizations	pim_location
_1.precerts	pre_scheduled_location
_1.precerts_map	prem_location
_1.radiology_results	rad_res_location
_1188.cpoe_responses	cpoe_res_location
_1188.encounters_soap_vitals	espv_location
_1188.hl7_accessions	acc_location
_1188.patients_immunizations	pim_location
_1188.precerts	pre_scheduled_location
_1188.precerts_map	prem_location
_1188.radiology_results	rad_res_location
_1218.cpoe_responses	cpoe_res_location
_1218.encounters_soap_vitals	espv_location
_1218.hl7_accessions	acc_location
_1218.patients_immunizations	pim_location
_1218.precerts	pre_scheduled_location
_1218.precerts_map	prem_location
_1218.radiology_results	rad_res_location
_1548.cpoe_responses	cpoe_res_location
_1548.encounters_soap_vitals	espv_location
_1548.hl7_accessions	acc_location
_1548.patients_immunizations	pim_location
_1548.precerts	pre_scheduled_location
_1548.precerts_map	prem_location
_1548.radiology_results	rad_res_location
_435.cpoe_responses	cpoe_res_location
_435.encounters_soap_vitals	espv_location
_435.hl7_accessions	acc_location
_435.patients_immunizations	pim_location
_435.precerts	pre_scheduled_location
_435.precerts_map	prem_location
_435.radiology_results	rad_res_location
_436.cpoe_responses	cpoe_res_location
_436.encounters_soap_vitals	espv_location
_436.hl7_accessions	acc_location
_436.patients_immunizations	pim_location
_436.precerts	pre_scheduled_location
_436.precerts_map	prem_location
_436.radiology_results	rad_res_location
_436_archive_testing.cpoe_responses	cpoe_res_location
_436_archive_testing.encounters_soap_vitals	espv_location
_436_archive_testing.hl7_accessions	acc_location
_436_archive_testing.patients_immunizations	pim_location
_436_archive_testing.precerts	pre_scheduled_location
_436_archive_testing.precerts_map	prem_location
_436_archive_testing.radiology_results	rad_res_location
_437.cpoe_responses	cpoe_res_location
_437.encounters_soap_vitals	espv_location
_437.hl7_accessions	acc_location
_437.patients_immunizations	pim_location
_437.precerts	pre_scheduled_location
_437.precerts_map	prem_location
_437.radiology_results	rad_res_location
_8.cpoe_responses	cpoe_res_location
_8.encounters_soap_vitals	espv_location
_8.hl7_accessions	acc_location
_8.patients_immunizations	pim_location
_8.precerts	pre_scheduled_location
_8.precerts_map	prem_location
_8.radiology_results	rad_res_location
_81.cpoe_responses	cpoe_res_location
_81.encounters_soap_vitals	espv_location
_81.hl7_accessions	acc_location
_81.patients_immunizations	pim_location
_81.precerts	pre_scheduled_location
_81.precerts_map	prem_location
_81.radiology_results	rad_res_location
_999.cpoe_responses	cpoe_res_location
_999.encounters_soap_vitals	espv_location
_999.hl7_accessions	acc_location
_999.patients_immunizations	pim_location
_999.precerts	pre_scheduled_location
_999.precerts_map	prem_location
_999.radiology_results	rad_res_location
aurora_standard.bhguar	emp_location
aurora_standard.bhtguar	emp_location
aurora_standard.chpinsrd	class_location
aurora_standard.chplocac	class_location
aurora_standard.chqcmeud	cme_location
aurora_standard.chqletrd	letter_location
aurora_standard.chrcntrc	rx_location
aurora_standard.mergdocs	file_location
aurora_standard.mergsigs	file_location
aurora_standard.sthcadjd	stock_location
aurora_standard.sticadjd	stock_location
aurora_standard.stilocar	stock_location
aurora_standard.stipyxlc	rev_location
aurora_standard.stipyxlc	exp_location
aurora_standard.stistkld	stock_location
aurora_standard.stock2	stock_location
aurora_standard.stoshipd	stock_location
aurora_standard.tmplocar	stock_location

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

doc_no

Table	Column
aurora_standard.audpadjd	py_doc_no
aurora_standard.chmgltrc	ar_doc_no
aurora_standard.chmgltrc	rm_doc_no
aurora_standard.chmgltrc	ip_doc_no
aurora_standard.chmgltrc	op_doc_no
aurora_standard.chmgltrc	r3_doc_no
aurora_standard.chmgltrc	r4_doc_no
aurora_standard.chmgltrc	cr_doc_no
aurora_standard.chmgltrc	aj_doc_no
aurora_standard.chmgltrc	nr_doc_no
aurora_standard.chmgltrc	nc_doc_no
aurora_standard.chmgltrc	fc_doc_no
aurora_standard.chmpadjd	py_doc_no
aurora_standard.chmrefnd	check_doc_no
aurora_standard.discounts	inv_doc_no
aurora_standard.odhpaydd	py_doc_no
aurora_standard.odhpayid	py_doc_no
aurora_standard.odhpayod	py_doc_no
aurora_standard.odhpayre	py_doc_no
aurora_standard.stfcntrc	fa_doc_no
aurora_standard.stgcntrc	genjrn_doc_no
aurora_standard.stgcntrc	stdent_doc_no
aurora_standard.sticstvr	rec_doc_no
aurora_standard.stoinvce	inv_doc_no
aurora_standard.stoordre	orig_doc_no
aurora_standard.stoordre	inv_doc_no
aurora_standard.stoshipd	inv_doc_no
aurora_standard.stoshipd	po_doc_no
aurora_standard.stpactvd	inv_doc_no
aurora_standard.stpactvv	inv_doc_no
aurora_standard.stpcashd	inv_doc_no
aurora_standard.stpcntrc	ap_doc_no
aurora_standard.stpcntrc	cd_doc_no
aurora_standard.stpvoidr	chk_doc_no
aurora_standard.stractvd	inv_doc_no
aurora_standard.stractvv	inv_doc_no
aurora_standard.strcashd	inv_doc_no
aurora_standard.strcntrc	ar_doc_no
aurora_standard.strcntrc	cr_doc_no
aurora_standard.stucntrc	req_doc_no
aurora_standard.stucntrc	po_doc_no
aurora_standard.stucntrc	rec_doc_no
aurora_standard.stucntrc	inv_doc_no
aurora_standard.stucntrc	ret_doc_no
aurora_standard.stuinvcd	inv_doc_no
aurora_standard.stuinvcd	po_doc_no
aurora_standard.stuinvce	inv_doc_no
aurora_standard.stuinvce	po_doc_no
aurora_standard.stuordrd	order_doc_no
aurora_standard.stuordre	orig_doc_no
aurora_standard.stuordre	order_doc_no
aurora_standard.stuprche	inv_doc_no
aurora_standard.sturectd	rec_doc_no
aurora_standard.sturectd	po_doc_no
aurora_standard.sturecte	rec_doc_no
aurora_standard.sturecte	po_doc_no
aurora_standard.sturqstd	po_doc_no
aurora_standard.sturqstd	ref_doc_no
aurora_standard.sturtrnd	ret_doc_no
aurora_standard.sturtrnd	po_doc_no
aurora_standard.sturtrnd	rec_doc_no
aurora_standard.sturtrnd	inv_doc_no
aurora_standard.sturtrne	ret_doc_no
aurora_standard.stxmtaxd	inv_doc_no
aurora_standard.stxtaxld	inv_doc_no
aurora_standard.stycdedd	py_doc_no
aurora_standard.stycincd	py_doc_no
aurora_standard.stycntrc	py_doc_no
aurora_standard.stypayar	py_doc_no
aurora_standard.stypddrd	py_doc_no
aurora_standard.styvoide	pay_doc_no

bed

Table	Column
aurora_standard.bdallvis	cur_bed
aurora_standard.bdvis	cur_bed
aurora_standard.c7vis	cur_bed
aurora_standard.cavis	cur_bed
aurora_standard.cavish	cur_bed
aurora_standard.chhl7adt	curr_bed
aurora_standard.chmadmtr	curr_bed
aurora_standard.chmmashr	room_bed
aurora_standard.chmrtrnd	f_bed
aurora_standard.chmrtrnd	t_bed
aurora_standard.hhmadmtr	curr_bed
aurora_standard.kcvis	cur_bed
aurora_standard.kcvisit	cur_bed

room

Table	Column
aurora_standard.chhl7adt	curr_room
aurora_standard.chmadmtr	curr_room
aurora_standard.chmblogd	pat_resp_room
aurora_standard.chmplogd	pat_resp_room
aurora_standard.chmrtrnd	f_room
aurora_standard.chmrtrnd	t_room
aurora_standard.chmstatc	req_room
aurora_standard.hhmadmtr	curr_room
aurora_standard.logchrgd	deliv_room
aurora_standard.logchrgd	rec_room
aurora_standard.logchrgd	ob_room
aurora_standard.logdetld	pat_resp_room
aurora_standard.schmultior	surgery_room

fin_class

Table	Column
aurora_standard.chmarsi	cur_fin_class
aurora_standard.chmcampi	cur_fin_class
aurora_standard.chmerafc	new_fin_class
aurora_standard.chmexmpi	cur_fin_class
aurora_standard.hl7gt1	guar_fin_class

gl_no

Table	Column
aurora_standard.chmchfcd	old_gl_no
aurora_standard.chmchfcd	old_gl_no_d
aurora_standard.chmchfcd	new_gl_no
aurora_standard.chmchfcd	new_gl_no_d
aurora_standard.financial_class_changes	old_gl_no
aurora_standard.financial_class_changes	old_gl_no_d
aurora_standard.financial_class_changes	new_gl_no
aurora_standard.financial_class_changes	new_gl_no_d

pat_status

Table	Column
aurora_standard.chmgltcd	a_pat_status
aurora_standard.chmgltcd	b_pat_status
aurora_standard.chmprica	prev_pat_status
aurora_standard.chmprica	cur_pat_status

nurs_stat

Table	Column
aurora_standard.chmrtrnd	f_nurs_stat
aurora_standard.chmrtrnd	t_nurs_stat

clin_class

Table	Column
aurora_standard.chmstatc	def_clin_class

level_care

Table	Column
aurora_standard.chmstatc	def_level_care

ub_rev_code

Table	Column
aurora_standard.chmstatc	def_ub_rev_code

proc_date

Table	Column
aurora_standard.chmutah7	cpt_proc_date
aurora_standard.chmutaha	cpt_proc_date