aurora_standard.stpapckv

Field	Type	Null
vendor_code	varchar(6)	YES
vendor_name	varchar(30)	YES
pay_to_code	varchar(6)	YES
pay_to_name	varchar(30)	YES
source_journal	varchar(2)	YES
document_number	int(11)	YES
accounting_date	date	YES
posting_number	int(11)	YES
posting_date	date	YES
ap_nonap	varchar(1)	YES
check_number	varchar(15)	YES
reconciled	varchar(1)	YES
check_voided	varchar(1)	YES
facility_code	varchar(3)	YES
facility_name	varchar(40)	YES
account_number	int(11)	YES
acct_description	varchar(30)	YES
department_code	varchar(3)	YES
department_name	varchar(30)	YES
amount	decimal(12,2)	YES
debit_credit	varchar(1)	YES
inv_document_no	int(11)	YES
invoice_no_paid	varchar(15)	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

vendor_name

Table	Column
_1.erx_config	erx_config_vendor_name
_1188.erx_config	erx_config_vendor_name
_1218.erx_config	erx_config_vendor_name
_1548.erx_config	erx_config_vendor_name
_435.erx_config	erx_config_vendor_name
_436.erx_config	erx_config_vendor_name
_436_archive_testing.erx_config	erx_config_vendor_name
_437.erx_config	erx_config_vendor_name
_8.erx_config	erx_config_vendor_name
_81.erx_config	erx_config_vendor_name
_999.erx_config	erx_config_vendor_name

reconciled

Table	Column
_1.patients_allergies	palg_reconciled
_1.patients_icd9_problems	pip_reconciled
_1.patients_medications	pms_reconciled
_1.patients_prescriptions	prx_reconciled
_1188.patients_allergies	palg_reconciled
_1188.patients_icd9_problems	pip_reconciled
_1188.patients_medications	pms_reconciled
_1188.patients_prescriptions	prx_reconciled
_1218.patients_allergies	palg_reconciled
_1218.patients_icd9_problems	pip_reconciled
_1218.patients_medications	pms_reconciled
_1218.patients_prescriptions	prx_reconciled
_1548.patients_allergies	palg_reconciled
_1548.patients_icd9_problems	pip_reconciled
_1548.patients_medications	pms_reconciled
_1548.patients_prescriptions	prx_reconciled
_435.patients_allergies	palg_reconciled
_435.patients_icd9_problems	pip_reconciled
_435.patients_medications	pms_reconciled
_435.patients_prescriptions	prx_reconciled
_436.patients_allergies	palg_reconciled
_436.patients_icd9_problems	pip_reconciled
_436.patients_medications	pms_reconciled
_436.patients_prescriptions	prx_reconciled
_436_archive_testing.patients_allergies	palg_reconciled
_436_archive_testing.patients_icd9_problems	pip_reconciled
_436_archive_testing.patients_medications	pms_reconciled
_436_archive_testing.patients_prescriptions	prx_reconciled
_437.patients_allergies	palg_reconciled
_437.patients_icd9_problems	pip_reconciled
_437.patients_medications	pms_reconciled
_437.patients_prescriptions	prx_reconciled
_8.patients_allergies	palg_reconciled
_8.patients_icd9_problems	pip_reconciled
_8.patients_medications	pms_reconciled
_8.patients_prescriptions	prx_reconciled
_81.patients_allergies	palg_reconciled
_81.patients_icd9_problems	pip_reconciled
_81.patients_medications	pms_reconciled
_81.patients_prescriptions	prx_reconciled
_999.patients_allergies	palg_reconciled
_999.patients_icd9_problems	pip_reconciled
_999.patients_medications	pms_reconciled
_999.patients_prescriptions	prx_reconciled
aurora_standard.hhtclokd	inv_reconciled

vendor_code

Table	Column
aurora_standard.hhtclokd	inv_vendor_code
aurora_standard.stmaintd	maint_vendor_code

debit_credit

Table	Column
aurora_standard.stpinvce	disc_debit_credit
aurora_standard.stpinvce	ap_debit_credit
aurora_standard.strinvce	disc_debit_credit
aurora_standard.strinvce	tax_debit_credit
aurora_standard.strinvce	frght_debit_credit
aurora_standard.strinvce	misc_debit_credit
aurora_standard.strinvce	ar_debit_credit