Information Technology Reference
In-Depth Information
HOSPNAME
HOSPHONE
ADMINTOR
HOSPITAL
WARDNO
TOTROOMS
TOTBEDS
BEDAVAIL
WARDTYPE
FACTYPE
TOTFACIL
FACAVAIL
WARD
FACILITY
PATNAME
PATPHONE
BEDIDENT
DATEADMT
PATIENT
DIAGNOSE
SYMPDATE
PREVTREA
TREADESC
TRTYPE
TRDATE
MEDITYPE
SYMPTOM
TREATMENT
Fig. 6.2
Hierarchical schema for the patient information system
Segment PATIENT
PATNAME
PATPHONE
BEDIDENT
DATEADMT
MORIARTY
221-4123
0003
860823
ALLISON
222-2938
0008
860714
TEBO
223-2356
0017
860913
MORIARTY
321-7890
0004
860514
ALLISON
322-4878
0009
860602
TEBO
654-4213
0001
860721
Segment SYMPTOM
DIAGNOSE
SYMPDATE
PREVTREA
TREADESC
CHEST PAIN
860824
Y
HEART
FAINT
860701
N
SURGE
ULCER
860513
N
SURGE
BLEEDING
860601
N
SURGE
FAINT
860602
N
SURGE
BROKEN LEG
860720
N
SURGE
Search WWH ::
Custom Search