aurora_standard.chmnetwd

Field Type Null Default Key Extra Comment
network_no varchar(6) YES MUL
ps varchar(3) YES
fc varchar(5) YES
per_diem decimal(8,2) YES
percent_chrgs decimal(8,4) YES
fee_sched varchar(6) YES
percent_feesch decimal(8,4) YES
room_percent decimal(8,4) YES
room_rate decimal(8,2) YES
implants_cost decimal(8,4) YES
implants_chrgs decimal(8,4) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
fc
TableColumn
aurora_standard.abmmpii1_fc
aurora_standard.abmmpii2_fc
aurora_standard.abmmpii3_fc
aurora_standard.abmviscur_fc
aurora_standard.abmvispri_fc
aurora_standard.abmvisi2_fc
aurora_standard.abmvisi3_fc
aurora_standard.adshmdpri_fc
aurora_standard.adshrevpri_fc
aurora_standard.afcsum2pri_fc
aurora_standard.agingwkpri_fc
aurora_standard.agingwk2pri_fc
aurora_standard.ainsrvwpri_fc
aurora_standard.amcbdpri_fc
aurora_standard.anarccur_fc
aurora_standard.anarcpri_fc
aurora_standard.apsagingcur_fc
aurora_standard.apsarcur_fc
aurora_standard.apsarpri_fc
aurora_standard.apsar0cur_fc
aurora_standard.apsar0pri_fc
aurora_standard.apsarbdcur_fc
aurora_standard.apsarbdpri_fc
aurora_standard.apsarhistcur_fc
aurora_standard.apsarhistpri_fc
aurora_standard.apsunbcur_fc
aurora_standard.apsviscur_fc
aurora_standard.apsvispri_fc
aurora_standard.avtotspri_fc
aurora_standard.bdallvispri_fc
aurora_standard.bdallviscur_fc
aurora_standard.bdvispri_fc
aurora_standard.bdviscur_fc
aurora_standard.beviscur_fc
aurora_standard.bevisbdcur_fc
aurora_standard.bevisbd2cur_fc
aurora_standard.bevisbd2prev_fc
aurora_standard.bharcur_fc
aurora_standard.bharco1_fc
aurora_standard.bharco2_fc
aurora_standard.bharco3_fc
aurora_standard.bharco4_fc
aurora_standard.bharco5_fc
aurora_standard.bharco6_fc
aurora_standard.bmvispri_fc
aurora_standard.bmviscur_fc
aurora_standard.bparcur_fc
aurora_standard.bparco1_fc
aurora_standard.bparco2_fc
aurora_standard.bparco3_fc
aurora_standard.bparco4_fc
aurora_standard.bparco5_fc
aurora_standard.bparco6_fc
aurora_standard.bpar2cur_fc
aurora_standard.bpar2co1_fc
aurora_standard.bpar2co2_fc
aurora_standard.bpar2co3_fc
aurora_standard.bpar2co4_fc
aurora_standard.bpar2co5_fc
aurora_standard.bpar2co6_fc
aurora_standard.bsvispri_fc
aurora_standard.bsviscur_fc
aurora_standard.bsvisbdpri_fc
aurora_standard.bsvisbdcur_fc
aurora_standard.c7vispri_fc
aurora_standard.c7viscur_fc
aurora_standard.c9viscur_fc
aurora_standard.c9visbd_fc
aurora_standard.cafccur_fc
aurora_standard.catotspri_fc
aurora_standard.cavispri_fc
aurora_standard.caviscur_fc
aurora_standard.cavishpri_fc
aurora_standard.cavishcur_fc
aurora_standard.chmadmtrpri_fc
aurora_standard.chmarbexpri_fc
aurora_standard.chmardydage_fc
aurora_standard.chmarsipri_fc
aurora_standard.chmbadjdnew_fc
aurora_standard.chmblogdnew_fc
aurora_standard.chmbpaydnew_fc
aurora_standard.chmbremdnew_fc
aurora_standard.chmcampipri_fc
aurora_standard.chmchfcdold_fc
aurora_standard.chmchfcdnew_fc
aurora_standard.chmchpsdcur_fc
aurora_standard.chmcntrcroll_fc
aurora_standard.chmcntrcno_insur_fc
aurora_standard.chmcolacbd_fc
aurora_standard.chmexmpipri_fc
aurora_standard.chmexvispri_fc
aurora_standard.chmfcglcbd_fc
aurora_standard.chmhcaphpri_fc
aurora_standard.chmhcapspri_fc
aurora_standard.chminsrcinpatient_fc
aurora_standard.chminsrcoutpatient_fc
aurora_standard.chmpdemopri_fc
aurora_standard.chmpsvcdcur_fc
aurora_standard.chmradexpri_fc
aurora_standard.chmstatcdef_sp_fc
aurora_standard.chmtkl1dpri_fc
aurora_standard.chmtkl2dpri_fc
aurora_standard.chmtkl3dpri_fc
aurora_standard.chmtkl4dpri_fc
aurora_standard.chmtkl5dpri_fc
aurora_standard.chmtkl6dpri_fc
aurora_standard.chmtkl7dpri_fc
aurora_standard.chmtkl8dpri_fc
aurora_standard.chmtkl9dpri_fc
aurora_standard.chmvisivpri_fc
aurora_standard.chmvtotdpri_fc
aurora_standard.financial_class_changesold_fc
aurora_standard.financial_class_changesnew_fc
aurora_standard.kcvispri_fc
aurora_standard.kcviscur_fc
aurora_standard.kcvisitpri_fc
aurora_standard.kcvisitcur_fc
aurora_standard.strcntrcmtax_fc
aurora_standard.strcustrmtax_fc
ps
TableColumn
aurora_standard.chmabstrprimary_ps
aurora_standard.chmabstrsecondary_ps
aurora_standard.chmabstrtertiary_ps
aurora_standard.chmadmtrarrival_ps
aurora_standard.chmadmtrnew_pat_this_ps
aurora_standard.chmchfcdnew_ps
aurora_standard.chmchfcdold_ps
aurora_standard.chmchpsdold_ps
aurora_standard.chmchpsdnew_ps
aurora_standard.chmcostaprimary_ps
aurora_standard.chmcostasecondary_ps
aurora_standard.chmcostatertiary_ps
aurora_standard.chmhid4aprimary_ps
aurora_standard.chmhid4asecondary_ps
aurora_standard.chmhid4atertiary_ps
aurora_standard.chmhidiaprimary_ps
aurora_standard.chmhidicprimary_ps
aurora_standard.chmhidicsecondary_ps
aurora_standard.chmhidictertiary_ps
aurora_standard.chmradexarrival_ps
aurora_standard.financial_class_changesnew_ps
aurora_standard.financial_class_changesold_ps
aurora_standard.stxautodchg_inc_ps
aurora_standard.stxautodchg_exc_ps
aurora_standard.stxautodvis_inc_ps
aurora_standard.stxautodvis_exc_ps
aurora_standard.stxautodadj_inc_ps
aurora_standard.stxautodadj_exc_ps
aurora_standard.tmpmrrptprimary_ps
aurora_standard.tmpmrrptsecondary_ps