aurora_standard.bppmts

Field Type Null Default Key Extra Comment
acct_no int(11) YES MUL
cdm_no char(7) YES
cdm_desc char(25) YES
pmt_adj char(1) YES
tran_dt char(6) YES
amt decimal(16,2) YES

References

Local Column References
amt
TableColumn
_1.immunizationsimz_admin_amt
_1.inventoryinv_init_amt
_1188.immunizationsimz_admin_amt
_1188.inventoryinv_init_amt
_1218.immunizationsimz_admin_amt
_1218.inventoryinv_init_amt
_1548.immunizationsimz_admin_amt
_1548.inventoryinv_init_amt
_435.immunizationsimz_admin_amt
_435.inventoryinv_init_amt
_436.immunizationsimz_admin_amt
_436.inventoryinv_init_amt
_436_archive_testing.immunizationsimz_admin_amt
_436_archive_testing.inventoryinv_init_amt
_437.immunizationsimz_admin_amt
_437.inventoryinv_init_amt
_8.immunizationsimz_admin_amt
_8.inventoryinv_init_amt
_81.immunizationsimz_admin_amt
_81.inventoryinv_init_amt
_999.immunizationsimz_admin_amt
_999.inventoryinv_init_amt
aurora_standard.addcdmcost_amt
aurora_standard.addcdmcharge_amt
aurora_standard.adjpaypay_amt
aurora_standard.adjpayadj_amt
aurora_standard.adshmdself_pay_amt
aurora_standard.adshpmtpmt_amt
aurora_standard.adshrevself_pay_amt
aurora_standard.afcdmcharge_amt
aurora_standard.afcsum2chrg_amt
aurora_standard.afcsum2rm_amt
aurora_standard.afcsum2adj_amt
aurora_standard.afcsum2pay_amt
aurora_standard.ainsrvwadj_amt
aurora_standard.ainsrvwpay_amt
aurora_standard.ainsrvwself_amt
aurora_standard.apsarwo_amt
aurora_standard.apsar0wo_amt
aurora_standard.apsarbdwo_amt
aurora_standard.apscdmcharge_amt
aurora_standard.apscdm2charge_amt
aurora_standard.apscdmacharge_amt
aurora_standard.arevenueinp_amt
aurora_standard.arevenueout_amt
aurora_standard.arevenuenon_pat_amt
aurora_standard.arevenuerm_amt
aurora_standard.arvuwkrvu_amt
aurora_standard.aseycmccharge_amt
aurora_standard.aseycmhcharge_amt
aurora_standard.aswcdmcharge_amt
aurora_standard.b2baddlast_dt_amt
aurora_standard.b2mrdrchg_amt
aurora_standard.bdcdmcharge_amt
aurora_standard.bdcdmcost_amt
aurora_standard.becdmcharge_amt
aurora_standard.bevisbdwo_amt
aurora_standard.bevisbd2wo_amt
aurora_standard.bfcdmcharge_amt
aurora_standard.bfcdminvcharge_amt
aurora_standard.bfcdmprocharge_amt
aurora_standard.bfcdmrhccharge_amt
aurora_standard.bfhoslast_pmt_amt
aurora_standard.bfpasrlast_pmt_amt
aurora_standard.bfrhccdmcharge_amt
aurora_standard.bgcdmcharge_amt
aurora_standard.bharpp_amt
aurora_standard.bhbaddlast_dt_amt
aurora_standard.bhmrdrchg_amt
aurora_standard.bhtmrdrchg_amt
aurora_standard.bmcdmcharge_amt
aurora_standard.bminsins_paid_amt
aurora_standard.bokcdmcost_amt
aurora_standard.bokcdmcharge_amt
aurora_standard.bparpp_amt
aurora_standard.bpar2pp_amt
aurora_standard.bpcdmhoscharge_amt
aurora_standard.bpcdmrhccharge_amt
aurora_standard.bvcdmcharge_amt
aurora_standard.bvclncdmcharge_amt
aurora_standard.c7cdm720charge_amt
aurora_standard.c7cdmoldcharge_amt
aurora_standard.c7cdmrxcharge_amt
aurora_standard.c7cdmxlscharge_amt
aurora_standard.c7dmecharge_amt
aurora_standard.c8bal0unb_amt
aurora_standard.c8bal0billed_amt
aurora_standard.c8bal0late_amt
aurora_standard.c8balsunb_amt
aurora_standard.c8balsbilled_amt
aurora_standard.c8balslate_amt
aurora_standard.chhl7in1policy_limit_amt
aurora_standard.chhl7in2rm_cvrg_typ_amt
aurora_standard.chhl7in2policy_type_amt
aurora_standard.chm835pdbilled_amt
aurora_standard.chm835pdpayment_amt
aurora_standard.chm835pdnon_cov_amt
aurora_standard.chm835pddrg_amt
aurora_standard.chm835pdallowed_amt
aurora_standard.chm835pddenied_amt
aurora_standard.chm835pdpps_outlier_amt
aurora_standard.chm835pscharge_amt
aurora_standard.chm835psadj_amt
aurora_standard.chm835pspmt_amt
aurora_standard.chm835psallow_amt
aurora_standard.chmadmqrlast_pmt_amt
aurora_standard.chmagesdage_1_amt
aurora_standard.chmagesdage_2_amt
aurora_standard.chmagesdage_3_amt
aurora_standard.chmagesdage_4_amt
aurora_standard.chmagesdage_5_amt
aurora_standard.chmagesdage_6_amt
aurora_standard.chmagesdage_7_amt
aurora_standard.chmagesdage_8_amt
aurora_standard.chmagesdage_9_amt
aurora_standard.chmagesdage_10_amt
aurora_standard.chmagesdage_11_amt
aurora_standard.chmagesdage_12_amt
aurora_standard.chmagesdage_13_amt
aurora_standard.chmarcpat_amt
aurora_standard.chmbenedi_ded_amt
aurora_standard.chmbenedi_copay_amt
aurora_standard.chmbenedi_dme_amt
aurora_standard.chmbenedi_orthotics_amt
aurora_standard.chmbenedo_ded_amt
aurora_standard.chmbenedo_copay_amt
aurora_standard.chmbenedo_dme_amt
aurora_standard.chmbenedo_orthotics_amt
aurora_standard.chmblogddrg_amt
aurora_standard.chmblogdreimburs_amt
aurora_standard.chmblogdoutlier_amt
aurora_standard.chmblogdother_amt
aurora_standard.chmbremddrg_amt
aurora_standard.chmbremdreimburs_amt
aurora_standard.chmbremddenied_amt
aurora_standard.chmbremdallowed_amt
aurora_standard.chmcashdref_amt
aurora_standard.chmcptcdchg_amt
aurora_standard.chmcptfcfee_amt
aurora_standard.chmexdtllab_amt
aurora_standard.chmexdtlnon_cov_amt
aurora_standard.chmgltcroth_ins_amt
aurora_standard.chmibendi_ded_amt
aurora_standard.chmibendi_max_amt
aurora_standard.chmibendr_dme_amt
aurora_standard.chmibendr_orthotics_amt
aurora_standard.chmibendo_ded_amt
aurora_standard.chmibendo_max_amt
aurora_standard.chminsrdper_diem_amt
aurora_standard.chmmbc41co_ins_amt
aurora_standard.chmmbc41paid_amt
aurora_standard.chmmbc50approved_amt
aurora_standard.chmmbc50paid_amt
aurora_standard.chmmbc55co_ins_amt
aurora_standard.chmmbc55deductible_amt
aurora_standard.chmmbc55paid_amt
aurora_standard.chmmhbcdded_amt
aurora_standard.chmmhbcdpaid_amt
aurora_standard.chmmhbcrapproved_amt
aurora_standard.chmnormdcharge_amt
aurora_standard.chmplogddrg_amt
aurora_standard.chmplogdreimburs_amt
aurora_standard.chmplogdoutlier_amt
aurora_standard.chmplogdother_amt
aurora_standard.chmpsvcdbill_amt
aurora_standard.chmpsvcdpaid_amt
aurora_standard.chmpsvcdadj_amt
aurora_standard.chmrefndrefund_amt
aurora_standard.chmrefndadj_amt
aurora_standard.chmub04rl_39_a_amt
aurora_standard.chmub04rl_39_b_amt
aurora_standard.chmub04rl_39_c_amt
aurora_standard.chmub04rl_39_d_amt
aurora_standard.chmub04rl_40_a_amt
aurora_standard.chmub04rl_40_b_amt
aurora_standard.chmub04rl_40_c_amt
aurora_standard.chmub04rl_40_d_amt
aurora_standard.chmub04rl_41_a_amt
aurora_standard.chmub04rl_41_b_amt
aurora_standard.chmub04rl_41_c_amt
aurora_standard.chmub04rl_41_d_amt
aurora_standard.chmub92rl_39_a_amt
aurora_standard.chmub92rl_39_b_amt
aurora_standard.chmub92rl_39_c_amt
aurora_standard.chmub92rl_39_d_amt
aurora_standard.chmub92rl_40_a_amt
aurora_standard.chmub92rl_40_b_amt
aurora_standard.chmub92rl_40_c_amt
aurora_standard.chmub92rl_40_d_amt
aurora_standard.chmub92rl_41_a_amt
aurora_standard.chmub92rl_41_b_amt
aurora_standard.chmub92rl_41_c_amt
aurora_standard.chmub92rl_41_d_amt
aurora_standard.chmub92vl_39a_amt
aurora_standard.chmub92vl_39b_amt
aurora_standard.chmub92vl_39c_amt
aurora_standard.chmub92vl_39d_amt
aurora_standard.chmub92vl_40a_amt
aurora_standard.chmub92vl_40b_amt
aurora_standard.chmub92vl_40c_amt
aurora_standard.chmub92vl_40d_amt
aurora_standard.chmub92vl_41a_amt
aurora_standard.chmub92vl_41b_amt
aurora_standard.chmub92vl_41c_amt
aurora_standard.chmub92vl_41d_amt
aurora_standard.chmutahtpat_est_amt
aurora_standard.chpcoberpremium_amt
aurora_standard.chpcobrdpayment_amt
aurora_standard.chrcntrcpercent_amt
aurora_standard.chrpriccadd_on_amt
aurora_standard.creditcredit_amt
aurora_standard.gary14posted_amt
aurora_standard.gary14correct_amt
aurora_standard.hhl7chgdcharge_amt
aurora_standard.hl7ft1ins_amt
aurora_standard.hl7in1policy_limit_amt
aurora_standard.hl7in1adpolicy_limit_amt
aurora_standard.hl7in2rm_cvrg_typ_amt
aurora_standard.hl7in2policy_type_amt
aurora_standard.hl7in2adrm_cvrg_typ_amt
aurora_standard.hl7in2adpolicy_type_amt
aurora_standard.hl7pv1contract_amt
aurora_standard.hl7pv1bd_trans_amt
aurora_standard.hl7pv1bd_recover_amt
aurora_standard.hl7pv1adcontract_amt
aurora_standard.hl7pv1adbd_trans_amt
aurora_standard.hl7pv1adbd_recover_amt
aurora_standard.logdetldreimburs_amt
aurora_standard.logdetldadjust_amt
aurora_standard.logdetlddrg_amt
aurora_standard.logdetldoutlier_amt
aurora_standard.logdetldother_amt
aurora_standard.logdetldtot_1500_amt
aurora_standard.logdetldub_amt
aurora_standard.ohorxcost_amt
aurora_standard.ohorxcharge_amt
aurora_standard.ohovisqrlast_pmt_amt
aurora_standard.samcdmccharge_amt
aurora_standard.stfdeprdbonus_amt
aurora_standard.stonwallcost_amt
aurora_standard.stonwallcharge_amt
aurora_standard.stp1099rtotal_amt
aurora_standard.stp1099rcat_1_amt
aurora_standard.stp1099rcat_2_amt
aurora_standard.stp1099rcat_3_amt
aurora_standard.stp1099rcat_4_amt
aurora_standard.stp1099rcat_5_amt
aurora_standard.stp1099rcat_6_amt
aurora_standard.stp1099rcat_7_amt
aurora_standard.stp1099rcat_8_amt
aurora_standard.stp1099rcat_9_amt
aurora_standard.stp1099rcat_10_amt
aurora_standard.stp1099rcat_11_amt
aurora_standard.stp1099rcat_12_amt
aurora_standard.stp1099rcat_13_amt
aurora_standard.stp1099rcat_14_amt
aurora_standard.stp1099rcat_15_amt
aurora_standard.stp1099rcat_16_amt
aurora_standard.stp1099rcat_17_amt
aurora_standard.stp1099rcat_18_amt
aurora_standard.stpcashddist_amt
aurora_standard.stpcashdgoods_amt
aurora_standard.stpcashddisc_amt
aurora_standard.stpcashecash_amt
aurora_standard.stpcasheoa_amt
aurora_standard.stpinvcdgoods_amt
aurora_standard.stpopenddisc_amt
aurora_standard.stpopendto_pay_amt
aurora_standard.stpvendron_acct_amt
aurora_standard.stpvendrtop_vnd_amt
aurora_standard.strcashddist_amt
aurora_standard.strcashdgoods_amt
aurora_standard.strcashddisc_amt
aurora_standard.strcashecash_amt
aurora_standard.strcasheoa_amt
aurora_standard.strcustron_acct_amt
aurora_standard.strnotedpayment_amt
aurora_standard.stropenddisc_amt
aurora_standard.strsuppdannual_amt
aurora_standard.stuinvcdexp_tax_amt
aurora_standard.stxbudgdbudget_amt
aurora_standard.stxmtaxdmtax_amt
aurora_standard.stxmtaxddisc_amt
aurora_standard.stxtaxldmtax_amt
aurora_standard.styapckddist_amt
aurora_standard.stydedcrdflt_hi_ded_amt
aurora_standard.stydedcrdflt_lo_ded_amt
aurora_standard.styempddlo_ded_amt
aurora_standard.styempddhi_ded_amt
aurora_standard.styempidlo_inc_amt
aurora_standard.styempidhi_inc_amt
aurora_standard.styinccrdflt_lo_inc_amt
aurora_standard.styinccrdflt_hi_inc_amt
aurora_standard.stypayddlo_ded_amt
aurora_standard.stypayddhi_ded_amt
aurora_standard.stypayidlo_inc_amt
aurora_standard.stypayidhi_inc_amt
aurora_standard.stytaxtdover_amt
aurora_standard.stytaxtdbase_amt
aurora_standard.stytypddlo_ded_amt
aurora_standard.stytypddhi_ded_amt
aurora_standard.stytypidlo_inc_amt
aurora_standard.stytypidhi_inc_amt
aurora_standard.timetabl_ininc_amt
aurora_standard.tmparinqbill_amt
aurora_standard.tmpbiggdm_amt
aurora_standard.tmpbiggdy_amt
aurora_standard.tmpub04rl_39_a_amt
aurora_standard.tmpub04rl_39_b_amt
aurora_standard.tmpub04rl_39_c_amt
aurora_standard.tmpub04rl_39_d_amt
aurora_standard.tmpub04rl_40_a_amt
aurora_standard.tmpub04rl_40_b_amt
aurora_standard.tmpub04rl_40_c_amt
aurora_standard.tmpub04rl_40_d_amt
aurora_standard.tmpub04rl_41_a_amt
aurora_standard.tmpub04rl_41_b_amt
aurora_standard.tmpub04rl_41_c_amt
aurora_standard.tmpub04rl_41_d_amt
acct_no
TableColumn
aurora_standard.chmcashdnon_pat_acct_no
aurora_standard.chmnbcgdnon_pat_acct_no
aurora_standard.chmnbpydnon_pat_acct_no
aurora_standard.chmnchgdnon_pat_acct_no
aurora_standard.chmnpatrnon_pat_acct_no
aurora_standard.chmnpaydnon_pat_acct_no
aurora_standard.chmrefndcontr_acct_no
aurora_standard.chpcashrcash_acct_no
aurora_standard.chpcobpdcash_acct_no
aurora_standard.chpcobpdbal_acct_no
aurora_standard.chrcntrcrx_inv_acct_no
aurora_standard.chrcntrcrx_exp_acct_no
aurora_standard.curs_tempcash_acct_no
aurora_standard.np_statmnon_pat_acct_no
aurora_standard.sticntrcinv_acct_no
aurora_standard.sticntrcsales_acct_no
aurora_standard.sticntrccog_acct_no
aurora_standard.sticntrcadj_acct_no
aurora_standard.sticntrccount_acct_no
aurora_standard.sticntrchold_acct_no
aurora_standard.stiinvtrinv_acct_no
aurora_standard.stiinvtrcog_acct_no
aurora_standard.stiinvtrsales_acct_no
aurora_standard.stiinvtrsupp_acct_no
aurora_standard.stitrandexp_acct_no
aurora_standard.stiwhserinv_acct_no
aurora_standard.stpcntrcap_acct_no
aurora_standard.stpcntrccd_cash_acct_no
aurora_standard.stpcntrccd_disc_acct_no
aurora_standard.stpinvcedisc_acct_no
aurora_standard.stpinvceap_acct_no
aurora_standard.stpinvcecash_acct_no
aurora_standard.stpopendap_acct_no
aurora_standard.stpopendcash_acct_no
aurora_standard.stpvendrcash_acct_no
aurora_standard.stpvendrexp_acct_no
aurora_standard.stpvendrhosp_acct_no
aurora_standard.strcntrcar_acct_no
aurora_standard.strcntrcar_sales_acct_no
aurora_standard.strcntrcar_tax_acct_no
aurora_standard.strcntrcar_frght_acct_no
aurora_standard.strcntrcar_misc_acct_no
aurora_standard.strcntrcar_fc_acct_no
aurora_standard.strcntrccr_cash_acct_no
aurora_standard.strcntrccr_disc_acct_no
aurora_standard.strinvcedisc_acct_no
aurora_standard.strinvcetax_acct_no
aurora_standard.strinvcefrght_acct_no
aurora_standard.strinvcemisc_acct_no
aurora_standard.strinvcear_acct_no
aurora_standard.stropendar_acct_no
aurora_standard.stucntrcap_acct_no
aurora_standard.stucntrcdisc_acct_no
aurora_standard.stucntrcfrght_acct_no
aurora_standard.stucntrcmisc_acct_no
aurora_standard.stucntrcinv_acct_no
aurora_standard.stucntrcadj_acct_no
aurora_standard.stucntrcprepaid_acct_no
aurora_standard.stucntrcsupp_acct_no
aurora_standard.stucntrccap_acct_no
aurora_standard.stucntrcnon_acct_no
aurora_standard.stucntrcdiff_acct_no
aurora_standard.stucntrccash_acct_no
aurora_standard.stucntrcret_acct_no
aurora_standard.stucntrcret_fee_acct_no
aurora_standard.stuinvcdgl_acct_no
aurora_standard.stultyprgl_acct_no
aurora_standard.stuordrdgl_acct_no
aurora_standard.stxcurrrex_diff_acct_no
aurora_standard.stxfinsdfin_acct_no
aurora_standard.stxinforsrc_acct_no
aurora_standard.stxmtaxrar_acct_no
aurora_standard.stxmtaxrar_disc_acct_no
aurora_standard.stxmtaxrap_acct_no
aurora_standard.stxmtaxrap_disc_acct_no
aurora_standard.stycntrcco_bank_acct_no
aurora_standard.styddepdbank_acct_no
aurora_standard.styemplrbank_acct_no
aurora_standard.styempodbal_acct_no
aurora_standard.stypayodbal_acct_no
aurora_standard.stypayrecash_acct_no
aurora_standard.stypddrdbank_acct_no
aurora_standard.styrevsdcash_acct_no
aurora_standard.stytypodbal_acct_no
aurora_standard.styuimmrui_acct_no
aurora_standard.ttiinvtrinv_acct_no
aurora_standard.ttiinvtrcog_acct_no
aurora_standard.ttiinvtrsales_acct_no
aurora_standard.ttiinvtrsupp_acct_no
aurora_standard.wkactvvinv_acct_no