aurora_standard.styactvv

Field	Type	Null
orig_journal	varchar(2)	YES
doc_no	int(11)	YES
post_no	int(11)	YES
post_date	date	YES
doc_date	date	YES
ref_code	varchar(6)	YES
doc_desc	varchar(30)	YES
check_no	varchar(12)	YES
pay_date	date	YES
eop_date	date	YES
act_code	varchar(6)	YES
act_type	varchar(1)	YES
amount	decimal(12,2)	YES
hours	decimal(12,2)	YES
rate	decimal(18,8)	YES
acct_no	int(11)	YES
dept_code	varchar(3)	YES
fac_no	varchar(3)	YES

References

Local Column

References

hours

Table	Column
Azalea.employees	emp_pto_hours
_1.reports_queue	rq_after_hours
_1188.reports_queue	rq_after_hours
_1218.reports_queue	rq_after_hours
_1548.reports_queue	rq_after_hours
_435.reports_queue	rq_after_hours
_436.reports_queue	rq_after_hours
_436_archive_testing.reports_queue	rq_after_hours
_437.reports_queue	rq_after_hours
_8.reports_queue	rq_after_hours
_81.reports_queue	rq_after_hours
_999.reports_queue	rq_after_hours
aurora_standard.chmhidic	observ_hours
aurora_standard.chpempid	inservice_hours
aurora_standard.chshotlr	tot_hours
aurora_standard.chtclokd	inc_hours
aurora_standard.chtemplr	review_hours
aurora_standard.chtemplr	add_vac_hours
aurora_standard.chtemplr	distribute_hours
aurora_standard.chtemplr	max_hours
aurora_standard.chtptord	num_hours
aurora_standard.chtsupvc	modify_own_hours
aurora_standard.chtwkhrd	carry_hours
aurora_standard.cmhrescr	max_hours
aurora_standard.hhtclokd	inc_hours
aurora_standard.oddpayre	total_hours
aurora_standard.odhpayre	total_hours
aurora_standard.styactpv	accr_hours
aurora_standard.styempid	inc_hours
aurora_standard.styemplr	avg_hours
aurora_standard.styemplr	total_hours
aurora_standard.styinccd	low_earned_hours
aurora_standard.styinccd	high_earned_hours
aurora_standard.styinccr	dflt_hours
aurora_standard.styoblcd	low_earned_hours
aurora_standard.styoblcd	high_earned_hours
aurora_standard.stypayre	total_hours
aurora_standard.styptodv	usable_hours
aurora_standard.stypyupd	total_hours
aurora_standard.styrevsd	total_hours
aurora_standard.styrtimd	inc_hours
aurora_standard.stytimed	inc_hours
aurora_standard.stytypid	inc_hours
aurora_standard.timetabl	inc_hours
aurora_standard.timetabl_in	inc_hours
common.applicants	app_employer_1_hours
common.applicants	app_employer_2_hours
common.applicants	app_employer_3_hours
common.applicants	app_employer_4_hours
common.customers	cus_office_hours
common.leads	lea_office_hours
common.reports_queue_orders	rqo_after_hours

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

rate

Table	Column
_1.encounters_soap_vitals	espv_resp_rate
_1.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_1.patients_vitals	pvs_resp_rate
_1188.encounters_soap_vitals	espv_resp_rate
_1188.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_1188.patients_vitals	pvs_resp_rate
_1218.encounters_soap_vitals	espv_resp_rate
_1218.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_1218.patients_vitals	pvs_resp_rate
_1548.encounters_soap_vitals	espv_resp_rate
_1548.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_1548.patients_vitals	pvs_resp_rate
_435.encounters_soap_vitals	espv_resp_rate
_435.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_435.patients_vitals	pvs_resp_rate
_436.encounters_soap_vitals	espv_resp_rate
_436.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_436.patients_vitals	pvs_resp_rate
_436_archive_testing.encounters_soap_vitals	espv_resp_rate
_436_archive_testing.patients_vitals	pvs_resp_rate
_437.encounters_soap_vitals	espv_resp_rate
_437.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_437.patients_vitals	pvs_resp_rate
_8.encounters_soap_vitals	espv_resp_rate
_8.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_8.patients_vitals	pvs_resp_rate
_81.encounters_soap_vitals	espv_resp_rate
_81.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_81.patients_vitals	pvs_resp_rate
_999.encounters_soap_vitals	espv_resp_rate
_999.encounters_soap_vitals	espv_oxy_inhaled_flow_rate
_999.patients_vitals	pvs_resp_rate
aurora_standard.cadrg	p_rate
aurora_standard.chhcntrc	int_rate
aurora_standard.chmaccoc	previous_rate
aurora_standard.chmapccc	pmt_rate
aurora_standard.chmcntrc	int_rate
aurora_standard.chmcontr	interest_rate
aurora_standard.chmfcglc	interest_rate
aurora_standard.chminsrd	drg_wts_rate
aurora_standard.chmnetwd	room_rate
aurora_standard.chmroomc	daily_rate
aurora_standard.chmvrsnc	prospective_rate
aurora_standard.chrordrr	flow_rate
aurora_standard.oddpaydd	ded_rate
aurora_standard.oddpayid	inc_rate
aurora_standard.oddpayod	obl_rate
aurora_standard.odhpaydd	ded_rate
aurora_standard.odhpayid	inc_rate
aurora_standard.odhpayod	obl_rate
aurora_standard.ohoemplr	pay_rate
aurora_standard.price2	prev_rate
aurora_standard.stfdtabd	depr_rate
aurora_standard.stfdtabr	depr_rate
aurora_standard.stilocar	usage_rate
aurora_standard.stistatd	usage_rate
aurora_standard.stoinvce	st_tx_rate
aurora_standard.stoinvce	co_tx_rate
aurora_standard.stoinvce	ci_tx_rate
aurora_standard.stoinvce	tax_rate
aurora_standard.stoinvce	trd_ds_rate
aurora_standard.stoinvce	currency_rate
aurora_standard.stoordre	trd_ds_rate
aurora_standard.stoordre	tax_rate
aurora_standard.stoordre	currency_rate
aurora_standard.stoshipd	tax_rate
aurora_standard.stpactvd	curr_ex_rate
aurora_standard.stpinvce	curr_ex_rate
aurora_standard.stpopend	curr_ex_rate
aurora_standard.stractvd	curr_ex_rate
aurora_standard.strinvce	curr_ex_rate
aurora_standard.stropend	curr_ex_rate
aurora_standard.stuinvce	currency_rate
aurora_standard.stuordre	currency_rate
aurora_standard.stxcurrr	curr_ex_rate
aurora_standard.stxcurrr	per_ex_rate
aurora_standard.stxmtaxr	mtax_rate
aurora_standard.stxtaxld	mtax_rate
aurora_standard.styaccrr	accr_rate
aurora_standard.styacmxr	accrual_rate
aurora_standard.styactpv	accr_rate
aurora_standard.stydedcr	dflt_rate
aurora_standard.stydeddv	deduction_rate
aurora_standard.styempdd	ded_rate
aurora_standard.styempid	inc_rate
aurora_standard.styempod	obl_rate
aurora_standard.styemrcd	old_rate
aurora_standard.styemrcd	new_rate
aurora_standard.styinccr	dflt_rate
aurora_standard.styincdv	pay_rate
aurora_standard.styjobcr	class1_rate
aurora_standard.styjobcr	class2_rate
aurora_standard.styjobcr	class3_rate
aurora_standard.styjobcr	class4_rate
aurora_standard.styjobcr	class5_rate
aurora_standard.styjobcr	class6_rate
aurora_standard.styjobcr	class7_rate
aurora_standard.styjobcr	class8_rate
aurora_standard.styjobcr	class9_rate
aurora_standard.styjobcr	class10_rate
aurora_standard.styoblcr	dflt_rate
aurora_standard.styobldv	obligation_rate
aurora_standard.stypacad	base_pay_rate
aurora_standard.stypayar	ded_rate
aurora_standard.stypaydd	ded_rate
aurora_standard.stypayid	inc_rate
aurora_standard.stypayod	obl_rate
aurora_standard.stypaypd	accr_rate
aurora_standard.styptoad	accr_rate
aurora_standard.styptoad	inc_rate
aurora_standard.styptodv	accrual_rate
aurora_standard.styrtimd	inc_rate
aurora_standard.stystwhr	fed_tax_rate
aurora_standard.stytaxtd	tax_rate
aurora_standard.stytimed	inc_rate
aurora_standard.stytimod	reg_rate
aurora_standard.stytimod	ot_rate
aurora_standard.stytimod	other_rate
aurora_standard.stytypdd	ded_rate
aurora_standard.stytypid	inc_rate
aurora_standard.stytypod	obl_rate
aurora_standard.tmplocar	usage_rate
aurora_standard.vault_accommodation_codes	previous_rate
aurora_standard.vault_room_beds	daily_rate
rcmroi.dev__rcm_roi_results	azalea_rcm_rate
rcmroi.prod__rcm_roi_results	azalea_rcm_rate
rcmroi.test__rcm_roi_results	azalea_rcm_rate

doc_no

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

pay_date

Table	Column
aurora_standard.chmadmqr	self_pay_date
aurora_standard.chmagesd	last_pay_date
aurora_standard.chpcobrd	first_pay_date
aurora_standard.stpinvce	to_pay_date
aurora_standard.stpopend	to_pay_date
aurora_standard.stpopend	last_pay_date
aurora_standard.stpvendr	last_pay_date
aurora_standard.strcustr	last_pay_date
aurora_standard.stropend	last_pay_date

acct_no

Table	Column
aurora_standard.chmcashd	non_pat_acct_no
aurora_standard.chmnbcgd	non_pat_acct_no
aurora_standard.chmnbpyd	non_pat_acct_no
aurora_standard.chmnchgd	non_pat_acct_no
aurora_standard.chmnpatr	non_pat_acct_no
aurora_standard.chmnpayd	non_pat_acct_no
aurora_standard.chmrefnd	contr_acct_no
aurora_standard.chpcashr	cash_acct_no
aurora_standard.chpcobpd	cash_acct_no
aurora_standard.chpcobpd	bal_acct_no
aurora_standard.chrcntrc	rx_inv_acct_no
aurora_standard.chrcntrc	rx_exp_acct_no
aurora_standard.curs_temp	cash_acct_no
aurora_standard.np_statm	non_pat_acct_no
aurora_standard.sticntrc	inv_acct_no
aurora_standard.sticntrc	sales_acct_no
aurora_standard.sticntrc	cog_acct_no
aurora_standard.sticntrc	adj_acct_no
aurora_standard.sticntrc	count_acct_no
aurora_standard.sticntrc	hold_acct_no
aurora_standard.stiinvtr	inv_acct_no
aurora_standard.stiinvtr	cog_acct_no
aurora_standard.stiinvtr	sales_acct_no
aurora_standard.stiinvtr	supp_acct_no
aurora_standard.stitrand	exp_acct_no
aurora_standard.stiwhser	inv_acct_no
aurora_standard.stpcntrc	ap_acct_no
aurora_standard.stpcntrc	cd_cash_acct_no
aurora_standard.stpcntrc	cd_disc_acct_no
aurora_standard.stpinvce	disc_acct_no
aurora_standard.stpinvce	ap_acct_no
aurora_standard.stpinvce	cash_acct_no
aurora_standard.stpopend	ap_acct_no
aurora_standard.stpopend	cash_acct_no
aurora_standard.stpvendr	cash_acct_no
aurora_standard.stpvendr	exp_acct_no
aurora_standard.stpvendr	hosp_acct_no
aurora_standard.strcntrc	ar_acct_no
aurora_standard.strcntrc	ar_sales_acct_no
aurora_standard.strcntrc	ar_tax_acct_no
aurora_standard.strcntrc	ar_frght_acct_no
aurora_standard.strcntrc	ar_misc_acct_no
aurora_standard.strcntrc	ar_fc_acct_no
aurora_standard.strcntrc	cr_cash_acct_no
aurora_standard.strcntrc	cr_disc_acct_no
aurora_standard.strinvce	disc_acct_no
aurora_standard.strinvce	tax_acct_no
aurora_standard.strinvce	frght_acct_no
aurora_standard.strinvce	misc_acct_no
aurora_standard.strinvce	ar_acct_no
aurora_standard.stropend	ar_acct_no
aurora_standard.stucntrc	ap_acct_no
aurora_standard.stucntrc	disc_acct_no
aurora_standard.stucntrc	frght_acct_no
aurora_standard.stucntrc	misc_acct_no
aurora_standard.stucntrc	inv_acct_no
aurora_standard.stucntrc	adj_acct_no
aurora_standard.stucntrc	prepaid_acct_no
aurora_standard.stucntrc	supp_acct_no
aurora_standard.stucntrc	cap_acct_no
aurora_standard.stucntrc	non_acct_no
aurora_standard.stucntrc	diff_acct_no
aurora_standard.stucntrc	cash_acct_no
aurora_standard.stucntrc	ret_acct_no
aurora_standard.stucntrc	ret_fee_acct_no
aurora_standard.stuinvcd	gl_acct_no
aurora_standard.stultypr	gl_acct_no
aurora_standard.stuordrd	gl_acct_no
aurora_standard.stxcurrr	ex_diff_acct_no
aurora_standard.stxfinsd	fin_acct_no
aurora_standard.stxinfor	src_acct_no
aurora_standard.stxmtaxr	ar_acct_no
aurora_standard.stxmtaxr	ar_disc_acct_no
aurora_standard.stxmtaxr	ap_acct_no
aurora_standard.stxmtaxr	ap_disc_acct_no
aurora_standard.stycntrc	co_bank_acct_no
aurora_standard.styddepd	bank_acct_no
aurora_standard.styemplr	bank_acct_no
aurora_standard.styempod	bal_acct_no
aurora_standard.stypayod	bal_acct_no
aurora_standard.stypayre	cash_acct_no
aurora_standard.stypddrd	bank_acct_no
aurora_standard.styrevsd	cash_acct_no
aurora_standard.stytypod	bal_acct_no
aurora_standard.styuimmr	ui_acct_no
aurora_standard.ttiinvtr	inv_acct_no
aurora_standard.ttiinvtr	cog_acct_no
aurora_standard.ttiinvtr	sales_acct_no
aurora_standard.ttiinvtr	supp_acct_no
aurora_standard.wkactvv	inv_acct_no

post_no

Table	Column
aurora_standard.chmgltrc	ar_post_no
aurora_standard.stfcntrc	fa_post_no
aurora_standard.stgcntrc	genjrn_post_no
aurora_standard.stgcntrc	genled_post_no
aurora_standard.stpcntrc	ap_post_no
aurora_standard.stpcntrc	cd_post_no
aurora_standard.strcntrc	ar_post_no
aurora_standard.strcntrc	cr_post_no
aurora_standard.stucntrc	req_post_no
aurora_standard.stucntrc	rec_post_no
aurora_standard.stucntrc	inv_post_no
aurora_standard.stucntrc	ret_post_no
aurora_standard.stuinvce	inv_post_no
aurora_standard.sturqstd	req_post_no
aurora_standard.stycntrc	py_post_no

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

eop_date

Table	Column
aurora_standard.chtesigd	ta_eop_date
aurora_standard.chtwkhrd	carry_eop_date

post_date

Table	Column
aurora_standard.hl7ft1	trans_post_date
aurora_standard.stuinvce	inv_post_date