Information Technology Reference
In-Depth Information
nally identified record type, the foreign keys are their immediate parent segment
identifiers. The unloaded sequential files are thus:
Segment HOSPITAL
HOSPNAME
HOSPHONE
ADMINTOR
MAC NEAL
123-7890
SHU MAKE
RIVEREDGE
654-3210
PAY N E
Segment WARD
*
HOSPNAME
WARDNO
TOTROOMS
TOTBEDS
BEDAVAIL
WARDTYPE
MAC NEAL
01
20
30
018
CARDIOVASC
MAC NEAL
04
15
36
017
GERIATRIC
RIVEREDGE
05
10
10
008
ORTHOPEDI
Segment PATIENT
*WARDNO
PATNAME
PATPHONE
BEDIDENT
DATEADMT
01
MORIARTY
221-4123
0003
860823
01
ALLISON
222-2938
0008
860714
01
TEBO
223-2356
0017
860913
04
MORIARTY
321-7890
0004
860514
04
ALLISON
322-4878
0009
860602
05
TEBO
654-4213
0001
860721
Segment SYMPTOM
*BEDIDENT
DIAGNOSE
SYMPDATE
PREVTREA
TREADESC
0003
CHEST PAIN
860824
Y
HEART SURGE
0008
FAINT
860701
N
0004
ULCER
860513
N
0009
BLEEDING
860601
N
0009
FAINT
860602
N
0001
BROKEN LEG
860720
N
Segment TREATMNT
*
BEDIDENT
TRTYPE
TRDATE
MEDITYPE
0003
CHEST PAIN
860823
HEART DRUG
0008
REST
860714
NIL
0004
REST
860514
ZANTAC
0009
BANDAGE
860602
NIL
0009
REST
860603
INFLUENZA
0001
LEG SURGE
860721
NIL
Search WWH ::
Custom Search