aurora_standard.chmcapmt

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
pay_adj varchar(1) YES
tr_date date YES
tr_type varchar(3) YES
tr_desc varchar(30) YES
proc_date date YES
amt decimal(16,2) YES
ins_co_desc varchar(30) YES
comment varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

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
comment
TableColumn
_1.orders_commentsorc_comment
_1.orders_comments_templatesorct_comment
_1.precerts_commentsprc_comment
_1.radiology_order_notesradnot_comment
_1188.orders_commentsorc_comment
_1188.orders_comments_templatesorct_comment
_1188.precerts_commentsprc_comment
_1188.radiology_order_notesradnot_comment
_1218.orders_commentsorc_comment
_1218.orders_comments_templatesorct_comment
_1218.precerts_commentsprc_comment
_1218.radiology_order_notesradnot_comment
_1548.orders_commentsorc_comment
_1548.orders_comments_templatesorct_comment
_1548.precerts_commentsprc_comment
_1548.radiology_order_notesradnot_comment
_435.orders_commentsorc_comment
_435.orders_comments_templatesorct_comment
_435.precerts_commentsprc_comment
_435.radiology_order_notesradnot_comment
_436.orders_commentsorc_comment
_436.orders_comments_templatesorct_comment
_436.precerts_commentsprc_comment
_436.radiology_order_notesradnot_comment
_436_archive_testing.orders_commentsorc_comment
_436_archive_testing.orders_comments_templatesorct_comment
_436_archive_testing.precerts_commentsprc_comment
_436_archive_testing.radiology_order_notesradnot_comment
_437.orders_commentsorc_comment
_437.orders_comments_templatesorct_comment
_437.precerts_commentsprc_comment
_437.radiology_order_notesradnot_comment
_8.orders_commentsorc_comment
_8.orders_comments_templatesorct_comment
_8.precerts_commentsprc_comment
_8.radiology_order_notesradnot_comment
_81.orders_commentsorc_comment
_81.orders_comments_templatesorct_comment
_81.precerts_commentsprc_comment
_81.radiology_order_notesradnot_comment
_999.orders_commentsorc_comment
_999.orders_comments_templatesorct_comment
_999.precerts_commentsprc_comment
_999.radiology_order_notesradnot_comment
ahiWiki.archivear_comment
ahiWiki.logginglog_comment
ahiWiki.recentchangesrc_comment
ahiWiki.revisionrev_comment
aurora_standard.audppayddenial_comment
aurora_standard.chmabstrstatus_comment
aurora_standard.chmblogddenial_comment
aurora_standard.chmbremddenial_comment
aurora_standard.chmmcqudemp_comment
aurora_standard.chmmcqudsp_emp_comment
aurora_standard.chmozpcdacct_comment
aurora_standard.chmppayddenial_comment
aurora_standard.chpevaldreviewer_comment
aurora_standard.hl7ntesrc_comment
aurora_standard.hl7nteadsrc_comment
common.service_tickets_commentsstcp_comment
template_library.orders_comments_templatesorct_comment
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
proc_date
TableColumn
aurora_standard.chmutah7cpt_proc_date
aurora_standard.chmutahacpt_proc_date