aurora_standard.oddpaydd

Field Type Null Default Key Extra Comment
empl_ssn varchar(11) YES
ded_code varchar(20) YES
ded_rate decimal(18,8) YES
amount decimal(12,2) YES
check_no varchar(10) 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
ded_code
TableColumn
aurora_standard.stycdeddpy_ded_code
aurora_standard.styintfcsource_ded_code