aurora_standard.chmibend

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
ins_rec_no int(11) YES MUL
priority_no varchar(1) YES
ps_code varchar(2) YES
recurring varchar(1) YES
complete varchar(1) YES
ins_co smallint(6) YES
pre_existing varchar(20) YES
i_ded_amt decimal(10,2) YES
i_ded_met varchar(10) YES
i_calyr varchar(1) YES
i_calyr_desc varchar(15) YES
i_towrds_oon_ded varchar(1) YES
i_copay_amt_ip decimal(10,2) YES
i_peradmocc_ip varchar(15) YES
i_copay_amt_op decimal(10,2) YES
i_peradmocc_op varchar(15) YES
i_perdiem decimal(10,2) YES
i_perdiem_max varchar(8) YES
i_coins_p1 decimal(3,0) YES
i_coins_p2 decimal(3,0) YES
i_coins_max decimal(10,2) YES
i_oop_max decimal(10,2) YES
i_oop_met varchar(10) YES
i_ded_included varchar(1) YES
i_tow_oon_oopmax varchar(1) YES
i_max_amt varchar(10) YES
i_max_desc varchar(15) YES
i_max_used decimal(10,2) YES
i_ip_max_dly decimal(10,2) YES
r_case_mgr_verbal varchar(1) YES
r_case_mgr_written varchar(1) YES
r_send_prog_notes varchar(1) YES
r_pre_existing varchar(1) YES
r_rehab_cov varchar(1) YES
r_pt_cov varchar(1) YES
r_ot_cov varchar(1) YES
r_sp_cov varchar(1) YES
r_work_cov varchar(1) YES
r_dme_cov varchar(1) YES
r_dme_amt decimal(10,2) YES
r_orthotics_cov varchar(1) YES
r_orthotics_amt decimal(10,2) YES
r_aquatic_cov varchar(1) YES
r_visits_approved smallint(6) YES
r_max_avail decimal(6,0) YES
r_max_used decimal(6,0) YES
precert_ip varchar(1) YES
precert_op varchar(1) YES
precert_obs varchar(1) YES
precert_ph varchar(20) YES
o_ded_amt decimal(10,2) YES
o_ded_met varchar(10) YES
o_calyr varchar(1) YES
o_calyr_desc varchar(15) YES
o_towrds_inn_ded varchar(1) YES
o_copay_amt_ip decimal(10,2) YES
o_peradmocc_ip varchar(15) YES
o_copay_amt_op decimal(10,2) YES
o_peradmocc_op varchar(15) YES
o_perdiem decimal(10,2) YES
o_perdiem_max varchar(8) YES
o_coins_p1 decimal(3,0) YES
o_coins_p2 decimal(3,0) YES
o_coins_max decimal(10,2) YES
o_oop_max decimal(10,2) YES
o_oop_met varchar(10) YES
o_ded_included varchar(1) YES
o_tow_inn_oopmax varchar(1) YES
o_max_amt varchar(10) YES
o_max_desc varchar(15) YES
o_max_used decimal(10,2) YES
o_ip_max_dly decimal(10,2) YES
subrogate varchar(1) YES
accident_rider varchar(1) YES
coord_w2nd_1 varchar(65) YES
coord_w2nd_2 varchar(65) YES
send_claims_adr1 varchar(30) YES
send_claims_adr2 varchar(20) YES
send_claims_city varchar(20) YES
send_claims_st varchar(2) YES
send_claims_zip1 decimal(5,0) YES
send_claims_zip2 decimal(4,0) YES
note1 varchar(65) YES
note2 varchar(65) YES
note3 varchar(65) YES
note4 varchar(65) YES
filing_days varchar(15) YES
input_from varchar(20) YES
input_date date YES
input_time time YES
input_by int(11) YES
dep_req decimal(10,2) YES
approved_by varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
approved_by
TableColumn
Azalea.pto_requestspto_approved_by
Azalea.timesheetsts_approved_by
complete
TableColumn
HSPI_CURES2015_B1.ipf_responsetransition_complete
HSPI_Central_Hospital.ipf_responsetransition_complete
HSPI_Dewitt.ipf_responsetransition_complete
HSPI_Fulton.ipf_responsetransition_complete
HSPI_Inferno.ipf_responsetransition_complete
HSPI_MU2015_E1.ipf_responsetransition_complete
HSPI_MU2015_G2.ipf_responsetransition_complete
HSPI_MU2015_G9.ipf_responsetransition_complete
HSPI_Sandbox.ipf_responsetransition_complete
HSPI_Summit_General.ipf_responsetransition_complete
HSPI_United_Physicians.ipf_responsetransition_complete
MPI.ipf_responsetransition_complete
_1.adjustment_rulesar_complete
_1.ledgerled_complete
_1.ordersord_complete
_1.orders_templatesordt_complete
_1.radiology_ordersrad_complete
_1.voided_paymentsvp_complete
_1188.ledgerled_complete
_1188.ordersord_complete
_1188.orders_templatesordt_complete
_1188.radiology_ordersrad_complete
_1188.voided_paymentsvp_complete
_1218.adjustment_rulesar_complete
_1218.ledgerled_complete
_1218.ordersord_complete
_1218.orders_templatesordt_complete
_1218.radiology_ordersrad_complete
_1218.voided_paymentsvp_complete
_1548.adjustment_rulesar_complete
_1548.ledgerled_complete
_1548.ordersord_complete
_1548.orders_templatesordt_complete
_1548.radiology_ordersrad_complete
_1548.voided_paymentsvp_complete
_435.adjustment_rulesar_complete
_435.ledgerled_complete
_435.ordersord_complete
_435.orders_templatesordt_complete
_435.radiology_ordersrad_complete
_435.voided_paymentsvp_complete
_436.adjustment_rulesar_complete
_436.ledgerled_complete
_436.ordersord_complete
_436.orders_templatesordt_complete
_436.radiology_ordersrad_complete
_436.voided_paymentsvp_complete
_436_archive_testing.adjustment_rulesar_complete
_436_archive_testing.ledgerled_complete
_436_archive_testing.ordersord_complete
_436_archive_testing.orders_templatesordt_complete
_436_archive_testing.radiology_ordersrad_complete
_436_archive_testing.voided_paymentsvp_complete
_437.adjustment_rulesar_complete
_437.ledgerled_complete
_437.ordersord_complete
_437.orders_templatesordt_complete
_437.radiology_ordersrad_complete
_437.voided_paymentsvp_complete
_8.adjustment_rulesar_complete
_8.ledgerled_complete
_8.ordersord_complete
_8.orders_templatesordt_complete
_8.radiology_ordersrad_complete
_8.voided_paymentsvp_complete
_81.ledgerled_complete
_81.ordersord_complete
_81.orders_templatesordt_complete
_81.radiology_ordersrad_complete
_81.voided_paymentsvp_complete
_999.adjustment_rulesar_complete
_999.ledgerled_complete
_999.ordersord_complete
_999.orders_templatesordt_complete
_999.radiology_ordersrad_complete
_999.voided_paymentsvp_complete
aurora_standard.chlmdaarmds_complete
aurora_standard.chlswbedmds_complete
aurora_standard.chm835pdbatch_complete
aurora_standard.chm835prbatch_complete
common.running_cronsrcron_complete
template_library.orders_templatesordt_complete
note2
TableColumn
_1.appointmentsapt_note2
_1188.appointmentsapt_note2
_1218.appointmentsapt_note2
_1548.appointmentsapt_note2
_435.appointmentsapt_note2
_436.appointmentsapt_note2
_436_archive_testing.appointmentsapt_note2
_437.appointmentsapt_note2
_8.appointmentsapt_note2
_81.appointmentsapt_note2
_999.appointmentsapt_note2
recurring
TableColumn
_1.reports_schedulesrsched_recurring
_1188.reports_schedulesrsched_recurring
_1218.reports_schedulesrsched_recurring
_1548.reports_schedulesrsched_recurring
_435.reports_schedulesrsched_recurring
_436.reports_schedulesrsched_recurring
_436_archive_testing.reports_schedulesrsched_recurring
_437.reports_schedulesrsched_recurring
_8.reports_schedulesrsched_recurring
_81.reports_schedulesrsched_recurring
_999.reports_schedulesrsched_recurring
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
pre_existing
TableColumn
aurora_standard.chmbenedi_pre_existing
aurora_standard.chmbenedo_pre_existing
precert_ph
TableColumn
aurora_standard.chmbenedi_precert_ph
aurora_standard.chmbenedo_precert_ph
precert_obs
TableColumn
aurora_standard.chmbenedi_precert_obs
aurora_standard.chmbenedo_precert_obs
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