aurora_standard.apsunb

Field Type Null Default Key Extra Comment
full_name char(25) YES
mr_no int(11) YES MUL
vis_no int(11) YES MUL
room char(10) YES
cur_fc varchar(6) YES MUL
adm_srvc varchar(2) YES MUL
phy_name varchar(25) YES
adm_dt char(8) YES MUL
curbal decimal(16,2) YES
totchrgs decimal(16,2) YES
dis_dt char(8) YES

References

Local Column References
adm_dt
TableColumn
aurora_standard.acampilast_adm_dt
aurora_standard.bhppatlast_adm_dt
aurora_standard.bhtppatlast_adm_dt
vis_no
TableColumn
aurora_standard.bmvismoms_vis_no
mr_no
TableColumn
aurora_standard.bsinsursnf_mr_no
aurora_standard.bsinsurprev_mr_no
aurora_standard.chhcntrcauto_snf_mr_no
aurora_standard.chhcntrcauto_mr_no
aurora_standard.chmarbexpat_mr_no
aurora_standard.chmarsipat_mr_no
aurora_standard.chmbatexpat_mr_no
aurora_standard.chmcampipat_mr_no
aurora_standard.chmcntrcauto_snf_mr_no
aurora_standard.chmcntrcauto_mr_no
aurora_standard.chmexmpipat_mr_no
aurora_standard.chmhstmrpat_mr_no
aurora_standard.chmhstrmpat_mr_no
aurora_standard.chmlastrmother_mr_no
aurora_standard.chmmhastco_mr_no
aurora_standard.chmmrhdrupd_mr_no
aurora_standard.chmnrcexpat_mr_no
aurora_standard.chmokipdpat_mr_no
aurora_standard.chmokopdpat_mr_no
aurora_standard.chmpatmrsnf_mr_no
aurora_standard.chmpatmrprev_mr_no
aurora_standard.chmradedpat_mr_no
aurora_standard.chmradexpat_mr_no
aurora_standard.chmreqsrofc_mr_no
aurora_standard.ncexmpipat_mr_no
room
TableColumn
aurora_standard.chhl7adtcurr_room
aurora_standard.chmadmtrcurr_room
aurora_standard.chmblogdpat_resp_room
aurora_standard.chmplogdpat_resp_room
aurora_standard.chmrtrndf_room
aurora_standard.chmrtrndt_room
aurora_standard.chmstatcreq_room
aurora_standard.hhmadmtrcurr_room
aurora_standard.logchrgddeliv_room
aurora_standard.logchrgdrec_room
aurora_standard.logchrgdob_room
aurora_standard.logdetldpat_resp_room
aurora_standard.schmultiorsurgery_room