aurora_standard.oebatchaud

Field	Type	Null	Key	Extra
chs_rowID	int(11)	NO	PRI	auto_increment
batch_id	char(10)	YES
seq_no	smallint(6)	YES
visit_no	int(11)	YES
price_code	char(10)	YES
chg_date	date	YES
chg_time	time	YES
units	decimal(10,4)	YES
amount	decimal(16,2)	YES
fin_class	char(5)	YES
pat_status	char(3)	YES
bill_status	char(3)	YES
gl_flag	char(10)	YES
source	char(20)	YES
comment	char(20)	YES
location	char(3)	YES
input_by	int(11)	YES
phy_no	smallint(6)	YES
charge_1	decimal(10,2)	YES
cpt_code	char(5)	YES
fac_no	char(3)	YES
mod_1	char(2)	YES
mod_2	char(2)	YES
mod_3	char(2)	YES
mod_4	char(2)	YES
mod_5	char(2)	YES
ub_rev_code	char(4)	YES
pos	char(2)	YES
tos	char(2)	YES
diag_seq_1	smallint(6)	YES
diag_seq_2	smallint(6)	YES
diag_seq_3	smallint(6)	YES
diag_seq_4	smallint(6)	YES
pos_1532	char(2)	YES
to_date	date	YES

References

Local Column

References

batch_id

Table	Column
HSPI_Bastrop.charges	charge_batch_id
HSPI_Bastrop.claim_items	claim_batch_id
HSPI_Bastrop.claims	claim_batch_id
HSPI_Bastrop.invoice_batches_facilities_map	invoice_batch_id
HSPI_Bastrop.invoices	invoice_batch_id
HSPI_Bastrop.transactions	transaction_batch_id
HSPI_CURES2015_B1.charges	charge_batch_id
HSPI_CURES2015_B1.claim_items	claim_batch_id
HSPI_CURES2015_B1.claims	claim_batch_id
HSPI_CURES2015_B1.claims_claim_batches_map	claim_batch_id
HSPI_CURES2015_B1.fa_transaction_wrappers	transaction_batch_id
HSPI_CURES2015_B1.invoice_batches_facilities_map	invoice_batch_id
HSPI_CURES2015_B1.invoices	invoice_batch_id
HSPI_CURES2015_B1.transaction_batch_financial_accounts	transaction_batch_id
HSPI_CURES2015_B1.transactions	transaction_batch_id
HSPI_Central_Hospital.charges	charge_batch_id
HSPI_Central_Hospital.claim_files	claim_batch_id
HSPI_Central_Hospital.claim_items	claim_batch_id
HSPI_Central_Hospital.claims	claim_batch_id
HSPI_Central_Hospital.claims_claim_batches_map	claim_batch_id
HSPI_Central_Hospital.fa_transaction_wrappers	transaction_batch_id
HSPI_Central_Hospital.invoice_batches_facilities_map	invoice_batch_id
HSPI_Central_Hospital.invoices	invoice_batch_id
HSPI_Central_Hospital.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Central_Hospital.transactions	transaction_batch_id
HSPI_Dewitt.charges	charge_batch_id
HSPI_Dewitt.claim_files	claim_batch_id
HSPI_Dewitt.claim_items	claim_batch_id
HSPI_Dewitt.claims	claim_batch_id
HSPI_Dewitt.claims_claim_batches_map	claim_batch_id
HSPI_Dewitt.fa_transaction_wrappers	transaction_batch_id
HSPI_Dewitt.invoice_batches_facilities_map	invoice_batch_id
HSPI_Dewitt.invoices	invoice_batch_id
HSPI_Dewitt.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Dewitt.transactions	transaction_batch_id
HSPI_Fulton.charges	charge_batch_id
HSPI_Fulton.claim_files	claim_batch_id
HSPI_Fulton.claim_items	claim_batch_id
HSPI_Fulton.claims	claim_batch_id
HSPI_Fulton.claims_claim_batches_map	claim_batch_id
HSPI_Fulton.fa_transaction_wrappers	transaction_batch_id
HSPI_Fulton.invoice_batches_facilities_map	invoice_batch_id
HSPI_Fulton.invoices	invoice_batch_id
HSPI_Fulton.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Fulton.transactions	transaction_batch_id
HSPI_Inferno.charges	charge_batch_id
HSPI_Inferno.claim_files	claim_batch_id
HSPI_Inferno.claim_items	claim_batch_id
HSPI_Inferno.claims	claim_batch_id
HSPI_Inferno.claims_claim_batches_map	claim_batch_id
HSPI_Inferno.fa_transaction_wrappers	transaction_batch_id
HSPI_Inferno.invoice_batches_facilities_map	invoice_batch_id
HSPI_Inferno.invoices	invoice_batch_id
HSPI_Inferno.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Inferno.transactions	transaction_batch_id
HSPI_MU2015_E1.charges	charge_batch_id
HSPI_MU2015_E1.claim_files	claim_batch_id
HSPI_MU2015_E1.claim_items	claim_batch_id
HSPI_MU2015_E1.claims	claim_batch_id
HSPI_MU2015_E1.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_E1.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_E1.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_E1.invoices	invoice_batch_id
HSPI_MU2015_E1.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_E1.transactions	transaction_batch_id
HSPI_MU2015_G2.charges	charge_batch_id
HSPI_MU2015_G2.claim_files	claim_batch_id
HSPI_MU2015_G2.claim_items	claim_batch_id
HSPI_MU2015_G2.claims	claim_batch_id
HSPI_MU2015_G2.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_G2.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_G2.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_G2.invoices	invoice_batch_id
HSPI_MU2015_G2.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_G2.transactions	transaction_batch_id
HSPI_MU2015_G9.charges	charge_batch_id
HSPI_MU2015_G9.claim_files	claim_batch_id
HSPI_MU2015_G9.claim_items	claim_batch_id
HSPI_MU2015_G9.claims	claim_batch_id
HSPI_MU2015_G9.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_G9.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_G9.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_G9.invoices	invoice_batch_id
HSPI_MU2015_G9.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_G9.transactions	transaction_batch_id
HSPI_Sandbox.charges	charge_batch_id
HSPI_Sandbox.claim_files	claim_batch_id
HSPI_Sandbox.claim_items	claim_batch_id
HSPI_Sandbox.claims	claim_batch_id
HSPI_Sandbox.claims_claim_batches_map	claim_batch_id
HSPI_Sandbox.fa_transaction_wrappers	transaction_batch_id
HSPI_Sandbox.invoice_batches_facilities_map	invoice_batch_id
HSPI_Sandbox.invoices	invoice_batch_id
HSPI_Sandbox.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Sandbox.transactions	transaction_batch_id
HSPI_Summit_General.charges	charge_batch_id
HSPI_Summit_General.claim_files	claim_batch_id
HSPI_Summit_General.claim_items	claim_batch_id
HSPI_Summit_General.claims	claim_batch_id
HSPI_Summit_General.claims_claim_batches_map	claim_batch_id
HSPI_Summit_General.fa_transaction_wrappers	transaction_batch_id
HSPI_Summit_General.invoice_batches_facilities_map	invoice_batch_id
HSPI_Summit_General.invoices	invoice_batch_id
HSPI_Summit_General.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Summit_General.transactions	transaction_batch_id
HSPI_United_Physicians.charges	charge_batch_id
HSPI_United_Physicians.claim_files	claim_batch_id
HSPI_United_Physicians.claim_items	claim_batch_id
HSPI_United_Physicians.claims	claim_batch_id
HSPI_United_Physicians.claims_claim_batches_map	claim_batch_id
HSPI_United_Physicians.fa_transaction_wrappers	transaction_batch_id
HSPI_United_Physicians.invoice_batches_facilities_map	invoice_batch_id
HSPI_United_Physicians.invoices	invoice_batch_id
HSPI_United_Physicians.transaction_batch_financial_accounts	transaction_batch_id
HSPI_United_Physicians.transactions	transaction_batch_id
MPI.charges	charge_batch_id
MPI.claim_files	claim_batch_id
MPI.claim_items	claim_batch_id
MPI.claims	claim_batch_id
MPI.claims_claim_batches_map	claim_batch_id
MPI.fa_transaction_wrappers	transaction_batch_id
MPI.invoice_batches_facilities_map	invoice_batch_id
MPI.invoices	invoice_batch_id
MPI.transaction_batch_financial_accounts	transaction_batch_id
MPI.transactions	transaction_batch_id
aurora_standard.hl7ft1	trans_batch_id
xlnt.selenium_test_queue	selenium_test_batch_id

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.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.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.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.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.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.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.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.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.daily_close_calculations	dcc_last_payment_amount
_8.daily_close_calculations	dcc_bil_negative_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.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.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.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

cpt_code

Table	Column
Loinc.loinc_codes	lc_cpt_code
_1.clients_fee_schedules_map	cfsm_cpt_code
_1.clinical_interventions_test_codes_map	citcm_cpt_code
_1.immunizations_cpt_map	icm_cpt_code
_1.insurances_allowables_cpt_map	iacm_cpt_code
_1.insurances_contracted_pricing	icp_cpt_code
_1.insurances_contracted_pricing_log	icpl_cpt_code
_1.patients_responsibility_estimates_services	prests_cpt_code
_1188.clients_fee_schedules_map	cfsm_cpt_code
_1188.clinical_interventions_test_codes_map	citcm_cpt_code
_1188.immunizations_cpt_map	icm_cpt_code
_1188.insurances_allowables_cpt_map	iacm_cpt_code
_1188.insurances_contracted_pricing	icp_cpt_code
_1188.insurances_contracted_pricing_log	icpl_cpt_code
_1188.patients_responsibility_estimates_services	prests_cpt_code
_1218.clients_fee_schedules_map	cfsm_cpt_code
_1218.clinical_interventions_test_codes_map	citcm_cpt_code
_1218.immunizations_cpt_map	icm_cpt_code
_1218.insurances_allowables_cpt_map	iacm_cpt_code
_1218.insurances_contracted_pricing	icp_cpt_code
_1218.insurances_contracted_pricing_log	icpl_cpt_code
_1218.patients_responsibility_estimates_services	prests_cpt_code
_1548.clients_fee_schedules_map	cfsm_cpt_code
_1548.clinical_interventions_test_codes_map	citcm_cpt_code
_1548.immunizations_cpt_map	icm_cpt_code
_1548.insurances_allowables_cpt_map	iacm_cpt_code
_1548.insurances_contracted_pricing	icp_cpt_code
_1548.insurances_contracted_pricing_log	icpl_cpt_code
_1548.patients_responsibility_estimates_services	prests_cpt_code
_435.clients_fee_schedules_map	cfsm_cpt_code
_435.clinical_interventions_test_codes_map	citcm_cpt_code
_435.immunizations_cpt_map	icm_cpt_code
_435.insurances_allowables_cpt_map	iacm_cpt_code
_435.insurances_contracted_pricing	icp_cpt_code
_435.insurances_contracted_pricing_log	icpl_cpt_code
_435.patients_responsibility_estimates_services	prests_cpt_code
_436.clients_fee_schedules_map	cfsm_cpt_code
_436.clinical_interventions_test_codes_map	citcm_cpt_code
_436.immunizations_cpt_map	icm_cpt_code
_436.insurances_allowables_cpt_map	iacm_cpt_code
_436.insurances_contracted_pricing	icp_cpt_code
_436.insurances_contracted_pricing_log	icpl_cpt_code
_436.patients_responsibility_estimates_services	prests_cpt_code
_436_archive_testing.clients_fee_schedules_map	cfsm_cpt_code
_436_archive_testing.clinical_interventions_test_codes_map	citcm_cpt_code
_436_archive_testing.immunizations_cpt_map	icm_cpt_code
_436_archive_testing.insurances_allowables_cpt_map	iacm_cpt_code
_436_archive_testing.insurances_contracted_pricing	icp_cpt_code
_436_archive_testing.insurances_contracted_pricing_log	icpl_cpt_code
_436_archive_testing.patients_responsibility_estimates_services	prests_cpt_code
_437.clients_fee_schedules_map	cfsm_cpt_code
_437.clinical_interventions_test_codes_map	citcm_cpt_code
_437.immunizations_cpt_map	icm_cpt_code
_437.insurances_allowables_cpt_map	iacm_cpt_code
_437.insurances_contracted_pricing	icp_cpt_code
_437.insurances_contracted_pricing_log	icpl_cpt_code
_437.patients_responsibility_estimates_services	prests_cpt_code
_8.clients_fee_schedules_map	cfsm_cpt_code
_8.clinical_interventions_test_codes_map	citcm_cpt_code
_8.immunizations_cpt_map	icm_cpt_code
_8.insurances_allowables_cpt_map	iacm_cpt_code
_8.insurances_contracted_pricing	icp_cpt_code
_8.insurances_contracted_pricing_log	icpl_cpt_code
_8.patients_responsibility_estimates_services	prests_cpt_code
_81.clients_fee_schedules_map	cfsm_cpt_code
_81.clinical_interventions_test_codes_map	citcm_cpt_code
_81.immunizations_cpt_map	icm_cpt_code
_81.insurances_allowables_cpt_map	iacm_cpt_code
_81.insurances_contracted_pricing	icp_cpt_code
_81.insurances_contracted_pricing_log	icpl_cpt_code
_81.patients_responsibility_estimates_services	prests_cpt_code
_999.clients_fee_schedules_map	cfsm_cpt_code
_999.clinical_interventions_test_codes_map	citcm_cpt_code
_999.immunizations_cpt_map	icm_cpt_code
_999.insurances_allowables_cpt_map	iacm_cpt_code
_999.insurances_contracted_pricing	icp_cpt_code
_999.insurances_contracted_pricing_log	icpl_cpt_code
_999.patients_responsibility_estimates_services	prests_cpt_code
aurora_standard.axlscdm	md_cpt_code
aurora_standard.axlscdm	ci_cpt_code
aurora_standard.c5cdm	oth_cpt_code
aurora_standard.c5cdm	wc_cpt_code
aurora_standard.c5cdm	comm_cpt_code
aurora_standard.c5cdmdr	oth_cpt_code
aurora_standard.c5cdmdr	wc_cpt_code
aurora_standard.c5cdmdr	comm_cpt_code
aurora_standard.c7cdm	comm_cpt_code
aurora_standard.c8cdm	comm_cpt_code
aurora_standard.chmprica	prev_cpt_code
aurora_standard.chmprica	cur_cpt_code
aurora_standard.chmpricc	comm_cpt_code
aurora_standard.glsprice	comm_cpt_code
common.loinc_codes	lc_cpt_code
common.mednec	med_cpt_code
common.test_codes_cpt	tcc_cpt_code

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

pos

Table	Column
_1.billing_codes	bil_positive_amount
_1188.billing_codes	bil_positive_amount
_1218.billing_codes	bil_positive_amount
_1548.billing_codes	bil_positive_amount
_435.billing_codes	bil_positive_amount
_436.billing_codes	bil_positive_amount
_436_archive_testing.billing_codes	bil_positive_amount
_437.billing_codes	bil_positive_amount
_8.billing_codes	bil_positive_amount
_8.daily_close_calculations	dcc_bil_positive_amount
_81.billing_codes	bil_positive_amount
_999.billing_codes	bil_positive_amount
aurora_standard.cgmmposr	x_pos
aurora_standard.cgmmposr	y_pos
aurora_standard.chmabstr	hidi_pos
aurora_standard.chmstatc	hidi_pos
aurora_standard.chmstatc	def_pos
common.billing_codes	bil_positive_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

comment

Table	Column
_1.orders_comments	orc_comment
_1.orders_comments_templates	orct_comment
_1.precerts_comments	prc_comment
_1.radiology_order_notes	radnot_comment
_1188.orders_comments	orc_comment
_1188.orders_comments_templates	orct_comment
_1188.precerts_comments	prc_comment
_1188.radiology_order_notes	radnot_comment
_1218.orders_comments	orc_comment
_1218.orders_comments_templates	orct_comment
_1218.precerts_comments	prc_comment
_1218.radiology_order_notes	radnot_comment
_1548.orders_comments	orc_comment
_1548.orders_comments_templates	orct_comment
_1548.precerts_comments	prc_comment
_1548.radiology_order_notes	radnot_comment
_435.orders_comments	orc_comment
_435.orders_comments_templates	orct_comment
_435.precerts_comments	prc_comment
_435.radiology_order_notes	radnot_comment
_436.orders_comments	orc_comment
_436.orders_comments_templates	orct_comment
_436.precerts_comments	prc_comment
_436.radiology_order_notes	radnot_comment
_436_archive_testing.orders_comments	orc_comment
_436_archive_testing.orders_comments_templates	orct_comment
_436_archive_testing.precerts_comments	prc_comment
_436_archive_testing.radiology_order_notes	radnot_comment
_437.orders_comments	orc_comment
_437.orders_comments_templates	orct_comment
_437.precerts_comments	prc_comment
_437.radiology_order_notes	radnot_comment
_8.orders_comments	orc_comment
_8.orders_comments_templates	orct_comment
_8.precerts_comments	prc_comment
_8.radiology_order_notes	radnot_comment
_81.orders_comments	orc_comment
_81.orders_comments_templates	orct_comment
_81.precerts_comments	prc_comment
_81.radiology_order_notes	radnot_comment
_999.orders_comments	orc_comment
_999.orders_comments_templates	orct_comment
_999.precerts_comments	prc_comment
_999.radiology_order_notes	radnot_comment
ahiWiki.archive	ar_comment
ahiWiki.logging	log_comment
ahiWiki.recentchanges	rc_comment
ahiWiki.revision	rev_comment
aurora_standard.audppayd	denial_comment
aurora_standard.chmabstr	status_comment
aurora_standard.chmblogd	denial_comment
aurora_standard.chmbremd	denial_comment
aurora_standard.chmmcqud	emp_comment
aurora_standard.chmmcqud	sp_emp_comment
aurora_standard.chmozpcd	acct_comment
aurora_standard.chmppayd	denial_comment
aurora_standard.chpevald	reviewer_comment
aurora_standard.hl7nte	src_comment
aurora_standard.hl7ntead	src_comment
common.service_tickets_comments	stcp_comment
template_library.orders_comments_templates	orct_comment

to_date

Table	Column
_1.schedules	sch_to_date
_1.schedules_events	sevnt_to_date
_1.tasks	task_to_date
_1188.schedules	sch_to_date
_1188.schedules_events	sevnt_to_date
_1188.tasks	task_to_date
_1218.schedules	sch_to_date
_1218.schedules_events	sevnt_to_date
_1218.tasks	task_to_date
_1548.schedules	sch_to_date
_1548.schedules_events	sevnt_to_date
_1548.tasks	task_to_date
_435.schedules	sch_to_date
_435.schedules_events	sevnt_to_date
_435.tasks	task_to_date
_436.schedules	sch_to_date
_436.schedules_events	sevnt_to_date
_436.tasks	task_to_date
_436_archive_testing.schedules	sch_to_date
_436_archive_testing.schedules_events	sevnt_to_date
_436_archive_testing.tasks	task_to_date
_437.schedules	sch_to_date
_437.schedules_events	sevnt_to_date
_437.tasks	task_to_date
_8.schedules	sch_to_date
_8.schedules_events	sevnt_to_date
_8.tasks	task_to_date
_81.schedules	sch_to_date
_81.schedules_events	sevnt_to_date
_81.tasks	task_to_date
_999.schedules	sch_to_date
_999.schedules_events	sevnt_to_date
_999.tasks	task_to_date
common.rcm_stats_aging	rcmsa_to_date
common.rcm_stats_general	rcmsg_to_date
common.rcm_stats_practice_analysis	rcmspa_to_date

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

mod_1

Table	Column
aurora_standard.axlscdm	md_mod_1
aurora_standard.axlscdm	ci_mod_1
aurora_standard.chmprica	prev_mod_1
aurora_standard.chmprica	cur_mod_1

mod_2

Table	Column
aurora_standard.axlscdm	md_mod_2
aurora_standard.axlscdm	ci_mod_2
aurora_standard.chmprica	prev_mod_2
aurora_standard.chmprica	cur_mod_2

phy_no

Table	Column
aurora_standard.bsinsur	fam_phy_no
aurora_standard.c7mpi	pri_phy_no
aurora_standard.campi	fam_phy_no
aurora_standard.chmabstr	admit_phy_no
aurora_standard.chmabstr	attend_phy_no
aurora_standard.chmarsi	fam_phy_no
aurora_standard.chmcampi	fam_phy_no
aurora_standard.chmexmpi	fam_phy_no
aurora_standard.chmpatmr	fam_phy_no
aurora_standard.chmpdemo	fam_phy_no
aurora_standard.chmradex	fam_phy_no
aurora_standard.chpwkmnr	refer_phy_no

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

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

chg_date

Table	Column
aurora_standard.chmbchgr	def_chg_date
aurora_standard.chmbitmr	def_chg_date

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

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no

charge_1

Table	Column
aurora_standard.chmpricc	prev_charge_1

ub_rev_code

Table	Column
aurora_standard.chmstatc	def_ub_rev_code