aurora_standard.aprevg

Field Type Null Default Key Extra Comment
fac_no varchar(3) YES
in_out varchar(1) YES
self_pay varchar(1) YES
ps varchar(3) YES
fc varchar(5) YES
ps_desc varchar(20) YES
fc_desc varchar(20) YES
rev_date date YES
amount decimal(16,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
amount
TableColumn
HSPI_CURES2015_B1.invoice_generation_rule_setsminimum_amount
HSPI_Central_Hospital.invoice_generation_rule_setsminimum_amount
HSPI_Dewitt.invoice_generation_rule_setsminimum_amount
HSPI_Fulton.invoice_generation_rule_setsminimum_amount
HSPI_Inferno.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_E1.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_G2.invoice_generation_rule_setsminimum_amount
HSPI_MU2015_G9.invoice_generation_rule_setsminimum_amount
HSPI_Sandbox.invoice_generation_rule_setsminimum_amount
HSPI_Summit_General.invoice_generation_rule_setsminimum_amount
HSPI_United_Physicians.invoice_generation_rule_setsminimum_amount
MPI.invoice_generation_rule_setsminimum_amount
_1.billing_codesbil_negative_amount
_1.billing_codesbil_positive_amount
_1.encounters_paymentsepay_amount
_1.encounters_ub04enc_ub04_39_a_amount
_1.encounters_ub04enc_ub04_39_b_amount
_1.encounters_ub04enc_ub04_39_c_amount
_1.encounters_ub04enc_ub04_39_d_amount
_1.encounters_ub04enc_ub04_40_a_amount
_1.encounters_ub04enc_ub04_40_b_amount
_1.encounters_ub04enc_ub04_40_c_amount
_1.encounters_ub04enc_ub04_40_d_amount
_1.encounters_ub04enc_ub04_41_a_amount
_1.encounters_ub04enc_ub04_41_b_amount
_1.encounters_ub04enc_ub04_41_c_amount
_1.encounters_ub04enc_ub04_41_d_amount
_1.insurances_allowables_cpt_mapiacm_amount
_1.insurances_contracted_pricingicp_amount
_1.ledgerled_amount
_1.ledgerled_orig_amount
_1.ledgerled_unit_amount
_1.patient_finance_recordspfr_min_due_amount
_1.patientspat_min_due_amount
_1.patients_immunizationspim_administered_amount
_1.patients_immunizations_templatespimt_administered_amount
_1.patients_inventorypinv_administered_amount
_1.patients_payments_schedulespps_amount
_1.patients_responsibility_estimatesprest_allowed_amount
_1.patients_responsibility_estimates_servicesprests_allowed_amount
_1.pre_services_line_adjustmentsprestsla_amount
_1.voided_paymentsvp_amount
_1.voided_paymentsvp_orig_amount
_1188.billing_codesbil_negative_amount
_1188.billing_codesbil_positive_amount
_1188.encounters_paymentsepay_amount
_1188.encounters_ub04enc_ub04_39_a_amount
_1188.encounters_ub04enc_ub04_39_b_amount
_1188.encounters_ub04enc_ub04_39_c_amount
_1188.encounters_ub04enc_ub04_39_d_amount
_1188.encounters_ub04enc_ub04_40_a_amount
_1188.encounters_ub04enc_ub04_40_b_amount
_1188.encounters_ub04enc_ub04_40_c_amount
_1188.encounters_ub04enc_ub04_40_d_amount
_1188.encounters_ub04enc_ub04_41_a_amount
_1188.encounters_ub04enc_ub04_41_b_amount
_1188.encounters_ub04enc_ub04_41_c_amount
_1188.encounters_ub04enc_ub04_41_d_amount
_1188.insurances_allowables_cpt_mapiacm_amount
_1188.insurances_contracted_pricingicp_amount
_1188.ledgerled_amount
_1188.ledgerled_orig_amount
_1188.ledgerled_unit_amount
_1188.patient_finance_recordspfr_min_due_amount
_1188.patientspat_min_due_amount
_1188.patients_immunizationspim_administered_amount
_1188.patients_immunizations_templatespimt_administered_amount
_1188.patients_inventorypinv_administered_amount
_1188.patients_payments_schedulespps_amount
_1188.patients_responsibility_estimatesprest_allowed_amount
_1188.patients_responsibility_estimates_servicesprests_allowed_amount
_1188.pre_services_line_adjustmentsprestsla_amount
_1188.voided_paymentsvp_amount
_1188.voided_paymentsvp_orig_amount
_1218.billing_codesbil_negative_amount
_1218.billing_codesbil_positive_amount
_1218.encounters_paymentsepay_amount
_1218.encounters_ub04enc_ub04_39_a_amount
_1218.encounters_ub04enc_ub04_39_b_amount
_1218.encounters_ub04enc_ub04_39_c_amount
_1218.encounters_ub04enc_ub04_39_d_amount
_1218.encounters_ub04enc_ub04_40_a_amount
_1218.encounters_ub04enc_ub04_40_b_amount
_1218.encounters_ub04enc_ub04_40_c_amount
_1218.encounters_ub04enc_ub04_40_d_amount
_1218.encounters_ub04enc_ub04_41_a_amount
_1218.encounters_ub04enc_ub04_41_b_amount
_1218.encounters_ub04enc_ub04_41_c_amount
_1218.encounters_ub04enc_ub04_41_d_amount
_1218.insurances_allowables_cpt_mapiacm_amount
_1218.insurances_contracted_pricingicp_amount
_1218.led_temporary_ledger_table_ANMled_amount
_1218.led_temporary_ledger_table_ANMled_orig_amount
_1218.ledgerled_amount
_1218.ledgerled_orig_amount
_1218.ledgerled_unit_amount
_1218.patient_finance_recordspfr_min_due_amount
_1218.patientspat_min_due_amount
_1218.patients_immunizationspim_administered_amount
_1218.patients_immunizations_templatespimt_administered_amount
_1218.patients_inventorypinv_administered_amount
_1218.patients_payments_schedulespps_amount
_1218.patients_responsibility_estimatesprest_allowed_amount
_1218.patients_responsibility_estimates_servicesprests_allowed_amount
_1218.pre_services_line_adjustmentsprestsla_amount
_1218.voided_paymentsvp_amount
_1218.voided_paymentsvp_orig_amount
_1548.billing_codesbil_negative_amount
_1548.billing_codesbil_positive_amount
_1548.encounters_paymentsepay_amount
_1548.encounters_ub04enc_ub04_39_a_amount
_1548.encounters_ub04enc_ub04_39_b_amount
_1548.encounters_ub04enc_ub04_39_c_amount
_1548.encounters_ub04enc_ub04_39_d_amount
_1548.encounters_ub04enc_ub04_40_a_amount
_1548.encounters_ub04enc_ub04_40_b_amount
_1548.encounters_ub04enc_ub04_40_c_amount
_1548.encounters_ub04enc_ub04_40_d_amount
_1548.encounters_ub04enc_ub04_41_a_amount
_1548.encounters_ub04enc_ub04_41_b_amount
_1548.encounters_ub04enc_ub04_41_c_amount
_1548.encounters_ub04enc_ub04_41_d_amount
_1548.insurances_allowables_cpt_mapiacm_amount
_1548.insurances_contracted_pricingicp_amount
_1548.ledgerled_amount
_1548.ledgerled_orig_amount
_1548.ledgerled_unit_amount
_1548.patient_finance_recordspfr_min_due_amount
_1548.patientspat_min_due_amount
_1548.patients_immunizationspim_administered_amount
_1548.patients_immunizations_templatespimt_administered_amount
_1548.patients_inventorypinv_administered_amount
_1548.patients_payments_schedulespps_amount
_1548.patients_responsibility_estimatesprest_allowed_amount
_1548.patients_responsibility_estimates_servicesprests_allowed_amount
_1548.pre_services_line_adjustmentsprestsla_amount
_1548.voided_paymentsvp_amount
_1548.voided_paymentsvp_orig_amount
_435.billing_codesbil_negative_amount
_435.billing_codesbil_positive_amount
_435.encounters_paymentsepay_amount
_435.encounters_ub04enc_ub04_39_a_amount
_435.encounters_ub04enc_ub04_39_b_amount
_435.encounters_ub04enc_ub04_39_c_amount
_435.encounters_ub04enc_ub04_39_d_amount
_435.encounters_ub04enc_ub04_40_a_amount
_435.encounters_ub04enc_ub04_40_b_amount
_435.encounters_ub04enc_ub04_40_c_amount
_435.encounters_ub04enc_ub04_40_d_amount
_435.encounters_ub04enc_ub04_41_a_amount
_435.encounters_ub04enc_ub04_41_b_amount
_435.encounters_ub04enc_ub04_41_c_amount
_435.encounters_ub04enc_ub04_41_d_amount
_435.insurances_allowables_cpt_mapiacm_amount
_435.insurances_contracted_pricingicp_amount
_435.ledgerled_amount
_435.ledgerled_orig_amount
_435.ledgerled_unit_amount
_435.patient_finance_recordspfr_min_due_amount
_435.patientspat_min_due_amount
_435.patients_immunizationspim_administered_amount
_435.patients_immunizations_templatespimt_administered_amount
_435.patients_inventorypinv_administered_amount
_435.patients_payments_schedulespps_amount
_435.patients_responsibility_estimatesprest_allowed_amount
_435.patients_responsibility_estimates_servicesprests_allowed_amount
_435.pre_services_line_adjustmentsprestsla_amount
_435.voided_paymentsvp_amount
_435.voided_paymentsvp_orig_amount
_436.billing_codesbil_negative_amount
_436.billing_codesbil_positive_amount
_436.encounters_paymentsepay_amount
_436.encounters_ub04enc_ub04_39_a_amount
_436.encounters_ub04enc_ub04_39_b_amount
_436.encounters_ub04enc_ub04_39_c_amount
_436.encounters_ub04enc_ub04_39_d_amount
_436.encounters_ub04enc_ub04_40_a_amount
_436.encounters_ub04enc_ub04_40_b_amount
_436.encounters_ub04enc_ub04_40_c_amount
_436.encounters_ub04enc_ub04_40_d_amount
_436.encounters_ub04enc_ub04_41_a_amount
_436.encounters_ub04enc_ub04_41_b_amount
_436.encounters_ub04enc_ub04_41_c_amount
_436.encounters_ub04enc_ub04_41_d_amount
_436.insurances_allowables_cpt_mapiacm_amount
_436.insurances_contracted_pricingicp_amount
_436.ledgerled_amount
_436.ledgerled_orig_amount
_436.ledgerled_unit_amount
_436.patient_finance_recordspfr_min_due_amount
_436.patientspat_min_due_amount
_436.patients_immunizationspim_administered_amount
_436.patients_immunizations_templatespimt_administered_amount
_436.patients_inventorypinv_administered_amount
_436.patients_payments_schedulespps_amount
_436.patients_responsibility_estimatesprest_allowed_amount
_436.patients_responsibility_estimates_servicesprests_allowed_amount
_436.pre_services_line_adjustmentsprestsla_amount
_436.voided_paymentsvp_amount
_436.voided_paymentsvp_orig_amount
_436_archive_testing.billing_codesbil_negative_amount
_436_archive_testing.billing_codesbil_positive_amount
_436_archive_testing.encounters_paymentsepay_amount
_436_archive_testing.encounters_ub04enc_ub04_39_a_amount
_436_archive_testing.encounters_ub04enc_ub04_39_b_amount
_436_archive_testing.encounters_ub04enc_ub04_39_c_amount
_436_archive_testing.encounters_ub04enc_ub04_39_d_amount
_436_archive_testing.encounters_ub04enc_ub04_40_a_amount
_436_archive_testing.encounters_ub04enc_ub04_40_b_amount
_436_archive_testing.encounters_ub04enc_ub04_40_c_amount
_436_archive_testing.encounters_ub04enc_ub04_40_d_amount
_436_archive_testing.encounters_ub04enc_ub04_41_a_amount
_436_archive_testing.encounters_ub04enc_ub04_41_b_amount
_436_archive_testing.encounters_ub04enc_ub04_41_c_amount
_436_archive_testing.encounters_ub04enc_ub04_41_d_amount
_436_archive_testing.insurances_allowables_cpt_mapiacm_amount
_436_archive_testing.insurances_contracted_pricingicp_amount
_436_archive_testing.ledgerled_amount
_436_archive_testing.ledgerled_orig_amount
_436_archive_testing.ledgerled_unit_amount
_436_archive_testing.patient_finance_recordspfr_min_due_amount
_436_archive_testing.patientspat_min_due_amount
_436_archive_testing.patients_immunizationspim_administered_amount
_436_archive_testing.patients_immunizations_templatespimt_administered_amount
_436_archive_testing.patients_inventorypinv_administered_amount
_436_archive_testing.patients_payments_schedulespps_amount
_436_archive_testing.patients_responsibility_estimatesprest_allowed_amount
_436_archive_testing.patients_responsibility_estimates_servicesprests_allowed_amount
_436_archive_testing.pre_services_line_adjustmentsprestsla_amount
_436_archive_testing.voided_paymentsvp_amount
_436_archive_testing.voided_paymentsvp_orig_amount
_437.billing_codesbil_negative_amount
_437.billing_codesbil_positive_amount
_437.encounters_paymentsepay_amount
_437.encounters_ub04enc_ub04_39_a_amount
_437.encounters_ub04enc_ub04_39_b_amount
_437.encounters_ub04enc_ub04_39_c_amount
_437.encounters_ub04enc_ub04_39_d_amount
_437.encounters_ub04enc_ub04_40_a_amount
_437.encounters_ub04enc_ub04_40_b_amount
_437.encounters_ub04enc_ub04_40_c_amount
_437.encounters_ub04enc_ub04_40_d_amount
_437.encounters_ub04enc_ub04_41_a_amount
_437.encounters_ub04enc_ub04_41_b_amount
_437.encounters_ub04enc_ub04_41_c_amount
_437.encounters_ub04enc_ub04_41_d_amount
_437.insurances_allowables_cpt_mapiacm_amount
_437.insurances_contracted_pricingicp_amount
_437.ledgerled_amount
_437.ledgerled_orig_amount
_437.ledgerled_unit_amount
_437.patient_finance_recordspfr_min_due_amount
_437.patientspat_min_due_amount
_437.patients_immunizationspim_administered_amount
_437.patients_immunizations_templatespimt_administered_amount
_437.patients_inventorypinv_administered_amount
_437.patients_payments_schedulespps_amount
_437.patients_responsibility_estimatesprest_allowed_amount
_437.patients_responsibility_estimates_servicesprests_allowed_amount
_437.pre_services_line_adjustmentsprestsla_amount
_437.voided_paymentsvp_amount
_437.voided_paymentsvp_orig_amount
_8.billing_codesbil_negative_amount
_8.billing_codesbil_positive_amount
_8.daily_close_calculationsdcc_last_payment_amount
_8.daily_close_calculationsdcc_bil_negative_amount
_8.daily_close_calculationsdcc_bil_positive_amount
_8.daily_close_calculationsdcc_led_amount
_8.daily_close_calculationsdcc_led_orig_amount
_8.encounters_paymentsepay_amount
_8.encounters_ub04enc_ub04_39_a_amount
_8.encounters_ub04enc_ub04_39_b_amount
_8.encounters_ub04enc_ub04_39_c_amount
_8.encounters_ub04enc_ub04_39_d_amount
_8.encounters_ub04enc_ub04_40_a_amount
_8.encounters_ub04enc_ub04_40_b_amount
_8.encounters_ub04enc_ub04_40_c_amount
_8.encounters_ub04enc_ub04_40_d_amount
_8.encounters_ub04enc_ub04_41_a_amount
_8.encounters_ub04enc_ub04_41_b_amount
_8.encounters_ub04enc_ub04_41_c_amount
_8.encounters_ub04enc_ub04_41_d_amount
_8.insurances_allowables_cpt_mapiacm_amount
_8.insurances_contracted_pricingicp_amount
_8.ledgerled_amount
_8.ledgerled_orig_amount
_8.ledgerled_unit_amount
_8.patient_finance_recordspfr_min_due_amount
_8.patientspat_min_due_amount
_8.patients_immunizationspim_administered_amount
_8.patients_immunizations_templatespimt_administered_amount
_8.patients_inventorypinv_administered_amount
_8.patients_payments_schedulespps_amount
_8.patients_responsibility_estimatesprest_allowed_amount
_8.patients_responsibility_estimates_servicesprests_allowed_amount
_8.pre_services_line_adjustmentsprestsla_amount
_8.voided_paymentsvp_amount
_8.voided_paymentsvp_orig_amount
_81.billing_codesbil_negative_amount
_81.billing_codesbil_positive_amount
_81.encounters_paymentsepay_amount
_81.encounters_ub04enc_ub04_39_a_amount
_81.encounters_ub04enc_ub04_39_b_amount
_81.encounters_ub04enc_ub04_39_c_amount
_81.encounters_ub04enc_ub04_39_d_amount
_81.encounters_ub04enc_ub04_40_a_amount
_81.encounters_ub04enc_ub04_40_b_amount
_81.encounters_ub04enc_ub04_40_c_amount
_81.encounters_ub04enc_ub04_40_d_amount
_81.encounters_ub04enc_ub04_41_a_amount
_81.encounters_ub04enc_ub04_41_b_amount
_81.encounters_ub04enc_ub04_41_c_amount
_81.encounters_ub04enc_ub04_41_d_amount
_81.insurances_allowables_cpt_mapiacm_amount
_81.insurances_contracted_pricingicp_amount
_81.ledgerled_amount
_81.ledgerled_orig_amount
_81.ledgerled_unit_amount
_81.patient_finance_recordspfr_min_due_amount
_81.patientspat_min_due_amount
_81.patients_immunizationspim_administered_amount
_81.patients_immunizations_templatespimt_administered_amount
_81.patients_inventorypinv_administered_amount
_81.patients_payments_schedulespps_amount
_81.patients_responsibility_estimatesprest_allowed_amount
_81.patients_responsibility_estimates_servicesprests_allowed_amount
_81.pre_services_line_adjustmentsprestsla_amount
_81.voided_paymentsvp_amount
_81.voided_paymentsvp_orig_amount
_999.billing_codesbil_negative_amount
_999.billing_codesbil_positive_amount
_999.encounters_paymentsepay_amount
_999.encounters_ub04enc_ub04_39_a_amount
_999.encounters_ub04enc_ub04_39_b_amount
_999.encounters_ub04enc_ub04_39_c_amount
_999.encounters_ub04enc_ub04_39_d_amount
_999.encounters_ub04enc_ub04_40_a_amount
_999.encounters_ub04enc_ub04_40_b_amount
_999.encounters_ub04enc_ub04_40_c_amount
_999.encounters_ub04enc_ub04_40_d_amount
_999.encounters_ub04enc_ub04_41_a_amount
_999.encounters_ub04enc_ub04_41_b_amount
_999.encounters_ub04enc_ub04_41_c_amount
_999.encounters_ub04enc_ub04_41_d_amount
_999.insurances_allowables_cpt_mapiacm_amount
_999.insurances_contracted_pricingicp_amount
_999.ledgerled_amount
_999.ledgerled_orig_amount
_999.ledgerled_unit_amount
_999.patient_finance_recordspfr_min_due_amount
_999.patientspat_min_due_amount
_999.patients_immunizationspim_administered_amount
_999.patients_immunizations_templatespimt_administered_amount
_999.patients_inventorypinv_administered_amount
_999.patients_payments_schedulespps_amount
_999.patients_responsibility_estimatesprest_allowed_amount
_999.patients_responsibility_estimates_servicesprests_allowed_amount
_999.pre_services_line_adjustmentsprestsla_amount
_999.voided_paymentsvp_amount
_999.voided_paymentsvp_orig_amount
aurora_standard.amcbdwo_amount
aurora_standard.chmnbcgrtot_amount
aurora_standard.chmnbpyrtot_amount
aurora_standard.chmtbtrrtot_amount
aurora_standard.chpempirlife_amount
aurora_standard.chrdrugcpurch_amount
aurora_standard.chtwkhrdcarry_amount
aurora_standard.mktcusproposal_amount
aurora_standard.oddpayrecash_amount
aurora_standard.odhpayrecash_amount
aurora_standard.stfactvddepr_amount
aurora_standard.stfactvvdepr_amount
aurora_standard.stoinvceitem_amount
aurora_standard.stoinvcetrd_ds_amount
aurora_standard.stoinvcest_tx_amount
aurora_standard.stoinvceco_tx_amount
aurora_standard.stoinvceci_tx_amount
aurora_standard.stoinvcefrght_amount
aurora_standard.stoinvcetotal_amount
aurora_standard.stoinvcetax_amount
aurora_standard.stoordrdtax_amount
aurora_standard.stoordrdnet_amount
aurora_standard.stoordreitem_amount
aurora_standard.stoordretrd_ds_amount
aurora_standard.stoordretax_amount
aurora_standard.stoordrefrght_amount
aurora_standard.stoordretotal_amount
aurora_standard.stoshipdtax_amount
aurora_standard.stoshipdnet_amount
aurora_standard.stpactvdhome_curr_amount
aurora_standard.stpinvcedisc_amount
aurora_standard.stpinvceap_amount
aurora_standard.stpinvcehome_curr_amount
aurora_standard.stpopendorig_amount
aurora_standard.stpopendhome_curr_amount
aurora_standard.stractvdhome_curr_amount
aurora_standard.strcustrstmt_amount
aurora_standard.strinvcedisc_amount
aurora_standard.strinvcetax_amount
aurora_standard.strinvcefrght_amount
aurora_standard.strinvcemisc_amount
aurora_standard.strinvcear_amount
aurora_standard.strinvcehome_curr_amount
aurora_standard.strnotedorig_amount
aurora_standard.stropendorig_amount
aurora_standard.stropendhome_curr_amount
aurora_standard.stuinvcemisc_amount
aurora_standard.stuinvcefrght_amount
aurora_standard.stuordreitem_amount
aurora_standard.stuordretrd_ds_amount
aurora_standard.stuordretax_amount
aurora_standard.stuordrefrght_amount
aurora_standard.stuordremisc_amount
aurora_standard.stuordregoods_amount
aurora_standard.stuordretotal_amount
aurora_standard.stuordreprepay_amount
aurora_standard.styinccrot_shift_amount
aurora_standard.stypayrecash_amount
aurora_standard.styrevsdcash_amount
aurora_standard.tmp04dchg_amount
aurora_standard.tmp15chdchg_amount
common.billing_codesbil_negative_amount
common.billing_codesbil_positive_amount
common.rcm_stats_agingrcmsa_0_30_amount
common.rcm_stats_agingrcmsa_31_60_amount
common.rcm_stats_agingrcmsa_61_90_amount
common.rcm_stats_agingrcmsa_91_120_amount
common.rcm_stats_agingrcmsa_121_amount
common.rcm_stats_agingrcmsa_total_amount
template_library.patients_immunizations_templatespimt_administered_amount
self_pay
TableColumn
_1.clients_fee_schedules_mapcfsm_price_self_pay
_1188.clients_fee_schedules_mapcfsm_price_self_pay
_1218.clients_fee_schedules_mapcfsm_price_self_pay
_1548.clients_fee_schedules_mapcfsm_price_self_pay
_435.clients_fee_schedules_mapcfsm_price_self_pay
_436.clients_fee_schedules_mapcfsm_price_self_pay
_436_archive_testing.clients_fee_schedules_mapcfsm_price_self_pay
_437.clients_fee_schedules_mapcfsm_price_self_pay
_8.clients_fee_schedules_mapcfsm_price_self_pay
_81.clients_fee_schedules_mapcfsm_price_self_pay
_999.clients_fee_schedules_mapcfsm_price_self_pay
fc
TableColumn
aurora_standard.abmmpii1_fc
aurora_standard.abmmpii2_fc
aurora_standard.abmmpii3_fc
aurora_standard.abmviscur_fc
aurora_standard.abmvispri_fc
aurora_standard.abmvisi2_fc
aurora_standard.abmvisi3_fc
aurora_standard.adshmdpri_fc
aurora_standard.adshrevpri_fc
aurora_standard.afcsum2pri_fc
aurora_standard.agingwkpri_fc
aurora_standard.agingwk2pri_fc
aurora_standard.ainsrvwpri_fc
aurora_standard.amcbdpri_fc
aurora_standard.anarccur_fc
aurora_standard.anarcpri_fc
aurora_standard.apsagingcur_fc
aurora_standard.apsarcur_fc
aurora_standard.apsarpri_fc
aurora_standard.apsar0cur_fc
aurora_standard.apsar0pri_fc
aurora_standard.apsarbdcur_fc
aurora_standard.apsarbdpri_fc
aurora_standard.apsarhistcur_fc
aurora_standard.apsarhistpri_fc
aurora_standard.apsunbcur_fc
aurora_standard.apsviscur_fc
aurora_standard.apsvispri_fc
aurora_standard.avtotspri_fc
aurora_standard.bdallvispri_fc
aurora_standard.bdallviscur_fc
aurora_standard.bdvispri_fc
aurora_standard.bdviscur_fc
aurora_standard.beviscur_fc
aurora_standard.bevisbdcur_fc
aurora_standard.bevisbd2cur_fc
aurora_standard.bevisbd2prev_fc
aurora_standard.bharcur_fc
aurora_standard.bharco1_fc
aurora_standard.bharco2_fc
aurora_standard.bharco3_fc
aurora_standard.bharco4_fc
aurora_standard.bharco5_fc
aurora_standard.bharco6_fc
aurora_standard.bmvispri_fc
aurora_standard.bmviscur_fc
aurora_standard.bparcur_fc
aurora_standard.bparco1_fc
aurora_standard.bparco2_fc
aurora_standard.bparco3_fc
aurora_standard.bparco4_fc
aurora_standard.bparco5_fc
aurora_standard.bparco6_fc
aurora_standard.bpar2cur_fc
aurora_standard.bpar2co1_fc
aurora_standard.bpar2co2_fc
aurora_standard.bpar2co3_fc
aurora_standard.bpar2co4_fc
aurora_standard.bpar2co5_fc
aurora_standard.bpar2co6_fc
aurora_standard.bsvispri_fc
aurora_standard.bsviscur_fc
aurora_standard.bsvisbdpri_fc
aurora_standard.bsvisbdcur_fc
aurora_standard.c7vispri_fc
aurora_standard.c7viscur_fc
aurora_standard.c9viscur_fc
aurora_standard.c9visbd_fc
aurora_standard.cafccur_fc
aurora_standard.cafccur_fc_desc
aurora_standard.catotspri_fc
aurora_standard.cavispri_fc
aurora_standard.caviscur_fc
aurora_standard.caviscur_fc_desc
aurora_standard.cavishpri_fc
aurora_standard.cavishcur_fc
aurora_standard.chmadmtrpri_fc
aurora_standard.chmarbexpri_fc
aurora_standard.chmardydage_fc
aurora_standard.chmarsipri_fc
aurora_standard.chmbadjdnew_fc
aurora_standard.chmblogdnew_fc
aurora_standard.chmbpaydnew_fc
aurora_standard.chmbremdnew_fc
aurora_standard.chmcampipri_fc
aurora_standard.chmchfcdold_fc
aurora_standard.chmchfcdnew_fc
aurora_standard.chmchpsdcur_fc
aurora_standard.chmcntrcroll_fc
aurora_standard.chmcntrcno_insur_fc
aurora_standard.chmcolacbd_fc
aurora_standard.chmexmpipri_fc
aurora_standard.chmexvispri_fc
aurora_standard.chmfcglcbd_fc
aurora_standard.chmhcaphpri_fc
aurora_standard.chmhcapspri_fc
aurora_standard.chminsrcinpatient_fc
aurora_standard.chminsrcoutpatient_fc
aurora_standard.chmpdemopri_fc
aurora_standard.chmpsvcdcur_fc
aurora_standard.chmradexpri_fc
aurora_standard.chmstatcdef_sp_fc
aurora_standard.chmtkl1dpri_fc
aurora_standard.chmtkl2dpri_fc
aurora_standard.chmtkl3dpri_fc
aurora_standard.chmtkl4dpri_fc
aurora_standard.chmtkl5dpri_fc
aurora_standard.chmtkl6dpri_fc
aurora_standard.chmtkl7dpri_fc
aurora_standard.chmtkl8dpri_fc
aurora_standard.chmtkl9dpri_fc
aurora_standard.chmvisivpri_fc
aurora_standard.chmvtotdpri_fc
aurora_standard.financial_class_changesold_fc
aurora_standard.financial_class_changesnew_fc
aurora_standard.kcvispri_fc
aurora_standard.kcviscur_fc
aurora_standard.kcvisitpri_fc
aurora_standard.kcvisitcur_fc
aurora_standard.strcntrcmtax_fc
aurora_standard.strcustrmtax_fc
ps
TableColumn
aurora_standard.chmabstrprimary_ps
aurora_standard.chmabstrsecondary_ps
aurora_standard.chmabstrtertiary_ps
aurora_standard.chmadmtrarrival_ps
aurora_standard.chmadmtrnew_pat_this_ps
aurora_standard.chmchfcdnew_ps
aurora_standard.chmchfcdold_ps
aurora_standard.chmchpsdold_ps
aurora_standard.chmchpsdnew_ps
aurora_standard.chmcostaprimary_ps
aurora_standard.chmcostasecondary_ps
aurora_standard.chmcostatertiary_ps
aurora_standard.chmhid4aprimary_ps
aurora_standard.chmhid4asecondary_ps
aurora_standard.chmhid4atertiary_ps
aurora_standard.chmhidiaprimary_ps
aurora_standard.chmhidicprimary_ps
aurora_standard.chmhidicsecondary_ps
aurora_standard.chmhidictertiary_ps
aurora_standard.chmradexarrival_ps
aurora_standard.financial_class_changesnew_ps
aurora_standard.financial_class_changesold_ps
aurora_standard.stxautodchg_inc_ps
aurora_standard.stxautodchg_exc_ps
aurora_standard.stxautodvis_inc_ps
aurora_standard.stxautodvis_exc_ps
aurora_standard.stxautodadj_inc_ps
aurora_standard.stxautodadj_exc_ps
aurora_standard.tmpmrrptprimary_ps
aurora_standard.tmpmrrptsecondary_ps
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no