aurora_standard.agldfc

Field	Type	Null
dept	smallint(6)	YES
fc	char(2)	YES
price_code	char(10)	YES
rev_bucket	char(1)	YES
units	decimal(10,4)	YES
amount	decimal(16,2)	YES

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

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

dept

Table	Column
aurora_standard.TABLE 1424	new_dept
aurora_standard.TABLE 1425	new_dept
aurora_standard.axlscdm	gl_ip_dept
aurora_standard.axlscdm	gl_op_dept
aurora_standard.chmpchsd	rev_loc_dept
aurora_standard.chmrefnd	contr_dept
aurora_standard.chpcashr	cash_dept
aurora_standard.chpcempr	home_dept
aurora_standard.chpcntrc	educ_dept
aurora_standard.chpcntrc	cobra_cash_dept
aurora_standard.chpcntrc	cobra_bal_dept
aurora_standard.chpcntrc	cobra_fee_dept
aurora_standard.chpcobpd	cash_dept
aurora_standard.chpcobpd	bal_dept
aurora_standard.chpempcd	empl_dept
aurora_standard.chtemplr	dflt_dept
aurora_standard.chteshtv	dflt_dept
aurora_standard.chtsfdpd	shift_dept
aurora_standard.chtsupvc	supv_dept
aurora_standard.empldept	home_dept
aurora_standard.glxref	new_dept
aurora_standard.glxref	old_dept
aurora_standard.ohofadtl	depr_dept
aurora_standard.stfactvd	depr_dept
aurora_standard.stfactvv	depr_dept
aurora_standard.stfasstr	depr_dept
aurora_standard.stfasstr	accm_dept
aurora_standard.stgrowpd	rod_beg_dept
aurora_standard.stgrowpd	rod_end_dept
aurora_standard.stoinvce	td_ds_dept
aurora_standard.stoinvce	st_tx_dept
aurora_standard.stoinvce	co_tx_dept
aurora_standard.stoinvce	ci_tx_dept
aurora_standard.stoinvce	freight_dept
aurora_standard.stoinvce	asset_dept
aurora_standard.stoordrd	inv_dept
aurora_standard.stoordrd	sls_dept
aurora_standard.stoordrd	cog_dept
aurora_standard.stxcalix	medgenix_dept
aurora_standard.stxcalix	california_dept
aurora_standard.stxfinsd	fin_dept
aurora_standard.styaccrr	liab_dept
aurora_standard.styaccrr	expense_dept
aurora_standard.stydedcr	dflt_dept
aurora_standard.styemplr	home_dept
aurora_standard.styemplr	dir_dept
aurora_standard.styempod	bal_dept
aurora_standard.styinccr	dflt_dept
aurora_standard.styinccr	acru_lia_dept
aurora_standard.styoblcr	dflt_dept
aurora_standard.stypayod	bal_dept
aurora_standard.stytypod	bal_dept
common.test_codes	tco_x_lab_area_dept

Table	Column
aurora_standard.abmmpi	i1_fc
aurora_standard.abmmpi	i2_fc
aurora_standard.abmmpi	i3_fc
aurora_standard.abmvis	cur_fc
aurora_standard.abmvis	pri_fc
aurora_standard.abmvis	i2_fc
aurora_standard.abmvis	i3_fc
aurora_standard.adshmd	pri_fc
aurora_standard.adshrev	pri_fc
aurora_standard.afcsum2	pri_fc
aurora_standard.agingwk	pri_fc
aurora_standard.agingwk2	pri_fc
aurora_standard.ainsrvw	pri_fc
aurora_standard.amcbd	pri_fc
aurora_standard.anarc	cur_fc
aurora_standard.anarc	pri_fc
aurora_standard.apsaging	cur_fc
aurora_standard.apsar	cur_fc
aurora_standard.apsar	pri_fc
aurora_standard.apsar0	cur_fc
aurora_standard.apsar0	pri_fc
aurora_standard.apsarbd	cur_fc
aurora_standard.apsarbd	pri_fc
aurora_standard.apsarhist	cur_fc
aurora_standard.apsarhist	pri_fc
aurora_standard.apsunb	cur_fc
aurora_standard.apsvis	cur_fc
aurora_standard.apsvis	pri_fc
aurora_standard.avtots	pri_fc
aurora_standard.bdallvis	pri_fc
aurora_standard.bdallvis	cur_fc
aurora_standard.bdvis	pri_fc
aurora_standard.bdvis	cur_fc
aurora_standard.bevis	cur_fc
aurora_standard.bevisbd	cur_fc
aurora_standard.bevisbd2	cur_fc
aurora_standard.bevisbd2	prev_fc
aurora_standard.bhar	cur_fc
aurora_standard.bhar	co1_fc
aurora_standard.bhar	co2_fc
aurora_standard.bhar	co3_fc
aurora_standard.bhar	co4_fc
aurora_standard.bhar	co5_fc
aurora_standard.bhar	co6_fc
aurora_standard.bmvis	pri_fc
aurora_standard.bmvis	cur_fc
aurora_standard.bpar	cur_fc
aurora_standard.bpar	co1_fc
aurora_standard.bpar	co2_fc
aurora_standard.bpar	co3_fc
aurora_standard.bpar	co4_fc
aurora_standard.bpar	co5_fc
aurora_standard.bpar	co6_fc
aurora_standard.bpar2	cur_fc
aurora_standard.bpar2	co1_fc
aurora_standard.bpar2	co2_fc
aurora_standard.bpar2	co3_fc
aurora_standard.bpar2	co4_fc
aurora_standard.bpar2	co5_fc
aurora_standard.bpar2	co6_fc
aurora_standard.bsvis	pri_fc
aurora_standard.bsvis	cur_fc
aurora_standard.bsvisbd	pri_fc
aurora_standard.bsvisbd	cur_fc
aurora_standard.c7vis	pri_fc
aurora_standard.c7vis	cur_fc
aurora_standard.c9vis	cur_fc
aurora_standard.c9vis	bd_fc
aurora_standard.cafc	cur_fc
aurora_standard.catots	pri_fc
aurora_standard.cavis	pri_fc
aurora_standard.cavis	cur_fc
aurora_standard.cavish	pri_fc
aurora_standard.cavish	cur_fc
aurora_standard.chmadmtr	pri_fc
aurora_standard.chmarbex	pri_fc
aurora_standard.chmardyd	age_fc
aurora_standard.chmarsi	pri_fc
aurora_standard.chmbadjd	new_fc
aurora_standard.chmblogd	new_fc
aurora_standard.chmbpayd	new_fc
aurora_standard.chmbremd	new_fc
aurora_standard.chmcampi	pri_fc
aurora_standard.chmchfcd	old_fc
aurora_standard.chmchfcd	new_fc
aurora_standard.chmchpsd	cur_fc
aurora_standard.chmcntrc	roll_fc
aurora_standard.chmcntrc	no_insur_fc
aurora_standard.chmcolac	bd_fc
aurora_standard.chmexmpi	pri_fc
aurora_standard.chmexvis	pri_fc
aurora_standard.chmfcglc	bd_fc
aurora_standard.chmhcaph	pri_fc
aurora_standard.chmhcaps	pri_fc
aurora_standard.chminsrc	inpatient_fc
aurora_standard.chminsrc	outpatient_fc
aurora_standard.chmpdemo	pri_fc
aurora_standard.chmpsvcd	cur_fc
aurora_standard.chmradex	pri_fc
aurora_standard.chmstatc	def_sp_fc
aurora_standard.chmtkl1d	pri_fc
aurora_standard.chmtkl2d	pri_fc
aurora_standard.chmtkl3d	pri_fc
aurora_standard.chmtkl4d	pri_fc
aurora_standard.chmtkl5d	pri_fc
aurora_standard.chmtkl6d	pri_fc
aurora_standard.chmtkl7d	pri_fc
aurora_standard.chmtkl8d	pri_fc
aurora_standard.chmtkl9d	pri_fc
aurora_standard.chmvisiv	pri_fc
aurora_standard.chmvtotd	pri_fc
aurora_standard.financial_class_changes	old_fc
aurora_standard.financial_class_changes	new_fc
aurora_standard.kcvis	pri_fc
aurora_standard.kcvis	cur_fc
aurora_standard.kcvisit	pri_fc
aurora_standard.kcvisit	cur_fc
aurora_standard.strcntrc	mtax_fc
aurora_standard.strcustr	mtax_fc