aurora_standard.cofybal

Field Type Null Default Key Extra Comment
visit_no int(11) YES
admit_date char(10) YES
dischg_date char(10) YES
pat_status char(3) YES
cur_bal decimal(8,2) YES
tot_chgs decimal(10,2) YES
mt_billed decimal(10,2) YES
adj_entry decimal(8,2) YES

References

Local Column References
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
cur_bal
TableColumn
aurora_standard.avtotstot_cur_bal
aurora_standard.catotstot_cur_bal
admit_date
TableColumn
aurora_standard.chmadmtrlast_admit_date
aurora_standard.hhmadmtrlast_admit_date
aurora_standard.hl7pv2expect_admit_date
dischg_date
TableColumn
aurora_standard.chmchdddold_dischg_date
aurora_standard.chmchdddnew_dischg_date
aurora_standard.chmchpsdchg_dischg_date
aurora_standard.hl7pv2exp_dischg_date
aurora_standard.tmpmrrptedit_dischg_date
pat_status
TableColumn
aurora_standard.chmgltcda_pat_status
aurora_standard.chmgltcdb_pat_status
aurora_standard.chmpricaprev_pat_status
aurora_standard.chmpricacur_pat_status