aurora_standard.c7adj

Field Type Null Default Key Extra Comment
vis_no bigint(20) YES MUL
adj_dt varchar(20) YES MUL
amt decimal(16,2) YES
adj_typ varchar(20) YES
ins_co smallint(6) 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
vis_no
TableColumn
aurora_standard.bmvismoms_vis_no
ins_co
TableColumn
aurora_standard.chmemplrwc_ins_co
aurora_standard.chmpricaprev_ins_co
aurora_standard.chmpricacur_ins_co
aurora_standard.chmquesrwork_comp_ins_co
aurora_standard.chqliabdliab_ins_co