aurora_standard.wkactvv2

Field	Type	Null
doc_no	int(11)	YES
act_code	char(6)	YES
act_type	char(1)	YES
amount	decimal(12,2)	YES
number	decimal(18,8)	YES
hours	decimal(12,2)	YES
rate	decimal(18,8)	YES
fac_no	char(3)	YES
check_no	char(12)	YES
pay_date	date	YES
eop_date	date	YES
ref_code	char(6)	YES
doc_desc	char(30)	YES

References

Local Column

References

number

Table	Column
API.partner_accounts	phone_number
AzaleaStats.error_reports	err_source_line_number
EFaxes.efaxes_recipients	efr_number
HSPI_Bastrop.coverages	group_number
HSPI_Bastrop.coverages	policy_number
HSPI_Bastrop.locations	clia_number
HSPI_Bastrop.phone_numbers	phone_number
HSPI_CURES2015_B1.cbos_inventory_log	document_number
HSPI_CURES2015_B1.coverages	group_number
HSPI_CURES2015_B1.coverages	policy_number
HSPI_CURES2015_B1.locations	clia_number
HSPI_CURES2015_B1.phone_numbers	phone_number
HSPI_Central_Hospital.cbos_inventory_log	document_number
HSPI_Central_Hospital.coverages	group_number
HSPI_Central_Hospital.coverages	policy_number
HSPI_Central_Hospital.locations	clia_number
HSPI_Central_Hospital.phone_numbers	phone_number
HSPI_Dewitt.cbos_inventory_log	document_number
HSPI_Dewitt.coverages	group_number
HSPI_Dewitt.coverages	policy_number
HSPI_Dewitt.locations	clia_number
HSPI_Dewitt.phone_numbers	phone_number
HSPI_Fulton.cbos_inventory_log	document_number
HSPI_Fulton.coverages	group_number
HSPI_Fulton.coverages	policy_number
HSPI_Fulton.locations	clia_number
HSPI_Fulton.phone_numbers	phone_number
HSPI_Inferno.cbos_inventory_log	document_number
HSPI_Inferno.coverages	group_number
HSPI_Inferno.coverages	policy_number
HSPI_Inferno.locations	clia_number
HSPI_Inferno.phone_numbers	phone_number
HSPI_MU2015_E1.cbos_inventory_log	document_number
HSPI_MU2015_E1.coverages	group_number
HSPI_MU2015_E1.coverages	policy_number
HSPI_MU2015_E1.locations	clia_number
HSPI_MU2015_E1.phone_numbers	phone_number
HSPI_MU2015_G2.cbos_inventory_log	document_number
HSPI_MU2015_G2.coverages	group_number
HSPI_MU2015_G2.coverages	policy_number
HSPI_MU2015_G2.locations	clia_number
HSPI_MU2015_G2.phone_numbers	phone_number
HSPI_MU2015_G9.cbos_inventory_log	document_number
HSPI_MU2015_G9.coverages	group_number
HSPI_MU2015_G9.coverages	policy_number
HSPI_MU2015_G9.locations	clia_number
HSPI_MU2015_G9.phone_numbers	phone_number
HSPI_Ness.coverages	group_number
HSPI_Ness.coverages	policy_number
HSPI_Ness.phone_numbers	phone_number
HSPI_Sandbox.cbos_inventory_log	document_number
HSPI_Sandbox.coverages	group_number
HSPI_Sandbox.coverages	policy_number
HSPI_Sandbox.locations	clia_number
HSPI_Sandbox.phone_numbers	phone_number
HSPI_Summit_General.cbos_inventory_log	document_number
HSPI_Summit_General.coverages	group_number
HSPI_Summit_General.coverages	policy_number
HSPI_Summit_General.locations	clia_number
HSPI_Summit_General.phone_numbers	phone_number
HSPI_System.phone_numbers	phone_number
HSPI_United_Physicians.cbos_inventory_log	document_number
HSPI_United_Physicians.coverages	group_number
HSPI_United_Physicians.coverages	policy_number
HSPI_United_Physicians.locations	clia_number
HSPI_United_Physicians.phone_numbers	phone_number
MPI.cbos_inventory_log	document_number
MPI.coverages	group_number
MPI.coverages	policy_number
MPI.locations	clia_number
MPI.phone_numbers	phone_number
SSO.developer_profiles	phone_number
_1.client_contacts	clicon_fax_number
_1.encounters_claims_supplemental_informations	ecsi_control_number
_1.encounters_cpt_codes	ecp_prescription_number
_1.encounters_ub04	enc_ub04_81_a_number
_1.encounters_ub04	enc_ub04_81_b_number
_1.encounters_ub04	enc_ub04_81_c_number
_1.encounters_ub04	enc_ub04_81_d_number
_1.hl7_orders	ord_group_number
_1.inventory	inv_lot_number
_1.inventory	inv_product_number
_1.patients	pat_emergency_number
_1.patients_demographics_snapshots	pds_emergency_number
_1.patients_histories	ph_enc_version_number
_1.patients_inventory	pinv_lot_number
_1.patients_inventory	pinv_product_number
_1.patients_prescriptions	prx_order_number
_1188.client_contacts	clicon_fax_number
_1188.encounters_claims_supplemental_informations	ecsi_control_number
_1188.encounters_cpt_codes	ecp_prescription_number
_1188.encounters_ub04	enc_ub04_81_a_number
_1188.encounters_ub04	enc_ub04_81_b_number
_1188.encounters_ub04	enc_ub04_81_c_number
_1188.encounters_ub04	enc_ub04_81_d_number
_1188.hl7_orders	ord_group_number
_1188.inventory	inv_lot_number
_1188.inventory	inv_product_number
_1188.patients	pat_emergency_number
_1188.patients_demographics_snapshots	pds_emergency_number
_1188.patients_histories	ph_enc_version_number
_1188.patients_inventory	pinv_lot_number
_1188.patients_inventory	pinv_product_number
_1188.patients_prescriptions	prx_order_number
_1218.client_contacts	clicon_fax_number
_1218.encounters_claims_supplemental_informations	ecsi_control_number
_1218.encounters_cpt_codes	ecp_prescription_number
_1218.encounters_ub04	enc_ub04_81_a_number
_1218.encounters_ub04	enc_ub04_81_b_number
_1218.encounters_ub04	enc_ub04_81_c_number
_1218.encounters_ub04	enc_ub04_81_d_number
_1218.hl7_orders	ord_group_number
_1218.inventory	inv_lot_number
_1218.inventory	inv_product_number
_1218.patients	pat_emergency_number
_1218.patients_demographics_snapshots	pds_emergency_number
_1218.patients_histories	ph_enc_version_number
_1218.patients_inventory	pinv_lot_number
_1218.patients_inventory	pinv_product_number
_1218.patients_prescriptions	prx_order_number
_1548.client_contacts	clicon_fax_number
_1548.encounters_claims_supplemental_informations	ecsi_control_number
_1548.encounters_cpt_codes	ecp_prescription_number
_1548.encounters_ub04	enc_ub04_81_a_number
_1548.encounters_ub04	enc_ub04_81_b_number
_1548.encounters_ub04	enc_ub04_81_c_number
_1548.encounters_ub04	enc_ub04_81_d_number
_1548.hl7_orders	ord_group_number
_1548.inventory	inv_lot_number
_1548.inventory	inv_product_number
_1548.patients	pat_emergency_number
_1548.patients_demographics_snapshots	pds_emergency_number
_1548.patients_histories	ph_enc_version_number
_1548.patients_inventory	pinv_lot_number
_1548.patients_inventory	pinv_product_number
_1548.patients_prescriptions	prx_order_number
_435.client_contacts	clicon_fax_number
_435.encounters_claims_supplemental_informations	ecsi_control_number
_435.encounters_cpt_codes	ecp_prescription_number
_435.encounters_ub04	enc_ub04_81_a_number
_435.encounters_ub04	enc_ub04_81_b_number
_435.encounters_ub04	enc_ub04_81_c_number
_435.encounters_ub04	enc_ub04_81_d_number
_435.hl7_orders	ord_group_number
_435.inventory	inv_lot_number
_435.inventory	inv_product_number
_435.patients	pat_emergency_number
_435.patients_demographics_snapshots	pds_emergency_number
_435.patients_histories	ph_enc_version_number
_435.patients_inventory	pinv_lot_number
_435.patients_inventory	pinv_product_number
_435.patients_prescriptions	prx_order_number
_436.client_contacts	clicon_fax_number
_436.encounters_claims_supplemental_informations	ecsi_control_number
_436.encounters_cpt_codes	ecp_prescription_number
_436.encounters_ub04	enc_ub04_81_a_number
_436.encounters_ub04	enc_ub04_81_b_number
_436.encounters_ub04	enc_ub04_81_c_number
_436.encounters_ub04	enc_ub04_81_d_number
_436.hl7_orders	ord_group_number
_436.inventory	inv_lot_number
_436.inventory	inv_product_number
_436.patients	pat_emergency_number
_436.patients_demographics_snapshots	pds_emergency_number
_436.patients_histories	ph_enc_version_number
_436.patients_inventory	pinv_lot_number
_436.patients_inventory	pinv_product_number
_436.patients_prescriptions	prx_order_number
_436_archive_testing.client_contacts	clicon_fax_number
_436_archive_testing.encounters_claims_supplemental_informations	ecsi_control_number
_436_archive_testing.encounters_cpt_codes	ecp_prescription_number
_436_archive_testing.encounters_ub04	enc_ub04_81_a_number
_436_archive_testing.encounters_ub04	enc_ub04_81_b_number
_436_archive_testing.encounters_ub04	enc_ub04_81_c_number
_436_archive_testing.encounters_ub04	enc_ub04_81_d_number
_436_archive_testing.hl7_orders	ord_group_number
_436_archive_testing.inventory	inv_lot_number
_436_archive_testing.inventory	inv_product_number
_436_archive_testing.patients	pat_emergency_number
_436_archive_testing.patients_demographics_snapshots	pds_emergency_number
_436_archive_testing.patients_histories	ph_enc_version_number
_436_archive_testing.patients_inventory	pinv_lot_number
_436_archive_testing.patients_inventory	pinv_product_number
_436_archive_testing.patients_prescriptions	prx_order_number
_437.client_contacts	clicon_fax_number
_437.encounters_claims_supplemental_informations	ecsi_control_number
_437.encounters_cpt_codes	ecp_prescription_number
_437.encounters_ub04	enc_ub04_81_a_number
_437.encounters_ub04	enc_ub04_81_b_number
_437.encounters_ub04	enc_ub04_81_c_number
_437.encounters_ub04	enc_ub04_81_d_number
_437.hl7_orders	ord_group_number
_437.inventory	inv_lot_number
_437.inventory	inv_product_number
_437.patients	pat_emergency_number
_437.patients_demographics_snapshots	pds_emergency_number
_437.patients_histories	ph_enc_version_number
_437.patients_inventory	pinv_lot_number
_437.patients_inventory	pinv_product_number
_437.patients_prescriptions	prx_order_number
_8.client_contacts	clicon_fax_number
_8.encounters_claims_supplemental_informations	ecsi_control_number
_8.encounters_cpt_codes	ecp_prescription_number
_8.encounters_ub04	enc_ub04_81_a_number
_8.encounters_ub04	enc_ub04_81_b_number
_8.encounters_ub04	enc_ub04_81_c_number
_8.encounters_ub04	enc_ub04_81_d_number
_8.hl7_orders	ord_group_number
_8.inventory	inv_lot_number
_8.inventory	inv_product_number
_8.patients	pat_emergency_number
_8.patients_demographics_snapshots	pds_emergency_number
_8.patients_histories	ph_enc_version_number
_8.patients_inventory	pinv_lot_number
_8.patients_inventory	pinv_product_number
_8.patients_prescriptions	prx_order_number
_81.client_contacts	clicon_fax_number
_81.encounters_claims_supplemental_informations	ecsi_control_number
_81.encounters_cpt_codes	ecp_prescription_number
_81.encounters_ub04	enc_ub04_81_a_number
_81.encounters_ub04	enc_ub04_81_b_number
_81.encounters_ub04	enc_ub04_81_c_number
_81.encounters_ub04	enc_ub04_81_d_number
_81.hl7_orders	ord_group_number
_81.inventory	inv_lot_number
_81.inventory	inv_product_number
_81.patients	pat_emergency_number
_81.patients_demographics_snapshots	pds_emergency_number
_81.patients_histories	ph_enc_version_number
_81.patients_inventory	pinv_lot_number
_81.patients_inventory	pinv_product_number
_81.patients_prescriptions	prx_order_number
_999.client_contacts	clicon_fax_number
_999.encounters_claims_supplemental_informations	ecsi_control_number
_999.encounters_cpt_codes	ecp_prescription_number
_999.encounters_ub04	enc_ub04_81_a_number
_999.encounters_ub04	enc_ub04_81_b_number
_999.encounters_ub04	enc_ub04_81_c_number
_999.encounters_ub04	enc_ub04_81_d_number
_999.hl7_orders	ord_group_number
_999.inventory	inv_lot_number
_999.inventory	inv_product_number
_999.patients	pat_emergency_number
_999.patients_demographics_snapshots	pds_emergency_number
_999.patients_histories	ph_enc_version_number
_999.patients_inventory	pinv_lot_number
_999.patients_inventory	pinv_product_number
_999.patients_prescriptions	prx_order_number
aurora_standard.acptwrk	cpt_number
aurora_standard.acptwrk	dec_number
aurora_standard.addcdm	dept_number
aurora_standard.b2badd	mr_number
aurora_standard.bhbadd	mr_number
aurora_standard.bhldgr	mr_number
aurora_standard.bhphybak	mr_number
aurora_standard.bhtldgr	mr_number
aurora_standard.caadj	gl_number
aurora_standard.cachrg	gl_number
aurora_standard.cachrg2	gl_number
aurora_standard.cachrgca	gl_number
aurora_standard.cachrgevo	gl_number
aurora_standard.canullchrg	gl_number
aurora_standard.capay	gl_number
aurora_standard.caroom	gl_number
aurora_standard.cgsinptr	auto_number
aurora_standard.chcimmuc	join_number
aurora_standard.chcmanuc	join_number
aurora_standard.chcprovc	join_number
aurora_standard.chcseric	join_number
aurora_standard.chm15chd	phys_number
aurora_standard.chm835ps	svc_number
aurora_standard.chmbatex	mc_number
aurora_standard.chmblogd	seq_number
aurora_standard.chmmbc37	policy_number
aurora_standard.chmmbc37	ocna_number
aurora_standard.chmmbc50	payor_number
aurora_standard.chmmbc51	check_number
aurora_standard.chmmhbcr	check_number
aurora_standard.chmmneca	orig_number
aurora_standard.chmpatmd	mr_number
aurora_standard.chmphync	mr_number
aurora_standard.chmpress	client_number
aurora_standard.chpcobrd	cobra_number
aurora_standard.chpemphd	seq_number
aurora_standard.chpliced	license_number
aurora_standard.chpparba	cus_number
aurora_standard.chqcardd	phy_number
aurora_standard.chqchekd	phy_number
aurora_standard.chqchrtd	phy_number
aurora_standard.chqcmeud	phy_number
aurora_standard.chqletrd	phy_number
aurora_standard.chqliabd	phy_number
aurora_standard.chqlicnd	license_number
aurora_standard.chqlicnd	phy_number
aurora_standard.chqnpdbd	phy_number
aurora_standard.chqphync	phy_number
aurora_standard.chqstafd	phy_number
aurora_standard.chrdfile	id_number
aurora_standard.chtclokd	inc_number
aurora_standard.hhtclokd	inc_number
aurora_standard.oeorder	phy_number
aurora_standard.stfasstr	po_number
aurora_standard.stonwall	dept_number
aurora_standard.stpapckv	document_number
aurora_standard.stpapckv	posting_number
aurora_standard.stpapckv	check_number
aurora_standard.stpapckv	account_number
aurora_standard.stxerord	err_number
aurora_standard.stxerorh	err_number
aurora_standard.stxhelpd	hlp_number
aurora_standard.stxmssgr	mssg_number
aurora_standard.stycntrc	ein_number
aurora_standard.stycntrc	state_number
aurora_standard.stycntrc	suta_number
aurora_standard.stydeddv	document_number
aurora_standard.stydeddv	check_number
aurora_standard.stydeddv	empl_acct_number
aurora_standard.styempid	inc_number
aurora_standard.styincdv	document_number
aurora_standard.styincdv	check_number
aurora_standard.styobldv	document_number
aurora_standard.styobldv	check_number
aurora_standard.styoctcc	gov_entity_id_number
aurora_standard.styoctcc	form_1095c_number
aurora_standard.styoctcc	ale_form_1095c_number
aurora_standard.stypddrd	trace_number
aurora_standard.styptodv	document_number
aurora_standard.styrtimd	inc_number
aurora_standard.stytimed	inc_number
aurora_standard.stytypid	inc_number
aurora_standard.stywtwoe	state_number
aurora_standard.stywtwoe	local_number
aurora_standard.timetabl	inc_number
aurora_standard.timetabl_in	inc_number
aurora_standard.tmpmrrpt	control_number
aurora_standard.vault_relationships	relationship_code_number
common.appointments_clienttell_statuses	acs_number
common.card_connect_merchant_accounts	ccma_hsn_number
common.card_connect_merchant_devices_map	ccmdm_hsn_number
common.faxes	fax_number
xlnt.builds	bamboo_build_number
xlnt.selenium_test_queue	build_number
xlnt.selenium_test_results	build_number

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

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