aurora_standard.bevis

Field Type Null Default Key Extra Comment
vis_no int(11) YES UNI
p_ssn varchar(20) YES
mrno varchar(20) YES MUL
cur_fc varchar(10) YES
pat_name varchar(40) YES
dob_mo varchar(2) YES
dob_dy varchar(2) YES
dob_yr varchar(2) YES
pat_type varchar(6) YES MUL
pat_sex varchar(1) YES
guar_no int(11) YES MUL
guar_rel varchar(10) YES
tot_chrgs decimal(12,2) YES
curbal decimal(16,2) YES
adm_dt varchar(10) YES
dis_dt varchar(10) YES

References

Local Column References
pat_sex
TableColumn
_1.clinical_alertsca_pat_sex
_1.clinical_interventionsci_pat_sex
_1188.clinical_alertsca_pat_sex
_1188.clinical_interventionsci_pat_sex
_1218.clinical_alertsca_pat_sex
_1218.clinical_interventionsci_pat_sex
_1548.clinical_alertsca_pat_sex
_1548.clinical_interventionsci_pat_sex
_435.clinical_alertsca_pat_sex
_435.clinical_interventionsci_pat_sex
_436.clinical_alertsca_pat_sex
_436.clinical_interventionsci_pat_sex
_436_archive_testing.clinical_alertsca_pat_sex
_436_archive_testing.clinical_interventionsci_pat_sex
_437.clinical_alertsca_pat_sex
_437.clinical_interventionsci_pat_sex
_8.clinical_alertsca_pat_sex
_8.clinical_interventionsci_pat_sex
_81.clinical_alertsca_pat_sex
_81.clinical_interventionsci_pat_sex
_999.clinical_alertsca_pat_sex
_999.clinical_interventionsci_pat_sex
mrno
TableColumn
aurora_standard.abmmpigu_mrno
aurora_standard.abmvisgu_mrno
aurora_standard.amrnowkgood_mrno
aurora_standard.amrnowkold_mrno
aurora_standard.apsmpi2ca_mrno
aurora_standard.aseympica_mrno
aurora_standard.b2baddnew_mrno
aurora_standard.b2mrdrnew_mrno
aurora_standard.bhbaddnew_mrno
aurora_standard.bhldgrnew_mrno
aurora_standard.bhmrdrnew_mrno
aurora_standard.bhtldgrnew_mrno
aurora_standard.bvmpinew_mrno
aurora_standard.bvmpi2new_mrno
aurora_standard.chmcntrcassign_mrno
aurora_standard.chxcntrcid_is_mrno
adm_dt
TableColumn
aurora_standard.acampilast_adm_dt
aurora_standard.bhppatlast_adm_dt
aurora_standard.bhtppatlast_adm_dt
guar_no
TableColumn
aurora_standard.anmpinew_guar_no
aurora_standard.apsmpinew_guar_no
aurora_standard.bs2mpinew_guar_no
aurora_standard.bsmpinew_guar_no
vis_no
TableColumn
aurora_standard.bmvismoms_vis_no