aurora_standard.ohosp

Field Type Null Default Key Extra Comment
row_no smallint(6) YES
pat_no varchar(20) YES
tot_ch varchar(20) YES
balance varchar(20) YES
fc varchar(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
balance
TableColumn
_1.encountersenc_balance
_1188.encountersenc_balance
_1218.encountersenc_balance
_1548.encountersenc_balance
_435.encountersenc_balance
_436.encountersenc_balance
_436_archive_testing.encountersenc_balance
_437.encountersenc_balance
_8.daily_close_calculationsdcc_balance
_8.encountersenc_balance
_81.encountersenc_balance
_999.encountersenc_balance
aurora_standard.chhcntrclarge_balance
aurora_standard.chhcntrcsmall_balance
aurora_standard.chmcntrclarge_balance
aurora_standard.chmcntrcsmall_balance
common.rcm_stats_generalrcmsg_hold_encounters_credit_balance
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
row_no
TableColumn
aurora_standard.apsagingapsar_row_no