Ì i 2
mis.pd.prob.main (main)
[problem]
\GPDB[gpdb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
problem 75 FREE L gpdb
active 1 YN L \GPDB[gpdb]|0
confidential 1 YN L \GPDB[gpdb]|4
cus.active 1 YN L \GPDB[gpdb]C|0
cus.description 75 FREE L \GPDB[gpdb]C|4
last.update 10 FREE L \GPDB[gpdb]UPD|0
last.update.date 8 DATE L VAL=%Z.date.in.magic(@last.update)
last.update.date.time 15 FREE L VAL=%Z.date.out(@last.update.date,"",10)_"-"_@last.upd
VAL=ate.time'="-"
last.update.time 4 HHMM L VAL=%Z.time.out(@last.update)
last.update.user 10 FREE L MIS.USER \GPDB[gpdb]UPD|1
last.update.user.out 30 FREE L VAL=%Z.convert.to.mixed.case(@MIS.USER.name[@last.upda
VAL=te.user],"",1)
problem.uc 75 FREE L
restrict.edm 1 YN L \GPDB[gpdb]C|1
restrict.mpm 1 YN L \GPDB[gpdb]C|3
restrict.pcm 1 YN L \GPDB[gpdb]C|2
retired 1 YN L \GPDB[gpdb]|1
standard 1 YN L \GPDB[gpdb]|3
umls.cui 15 FREE L \GPDB[gpdb]|2
Ì € i 2
mis.pd.prob.codes (codes)
[problem, code.q]
\GPDB[gpdb]D[gpdbD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
code.q 3 PINT R gpdbD
code 15 FREE L \GPDB[gpdb]D[gpdbD]|1
code.active 1 YN L \GPDB[gpdb]D[gpdbD]|2
code.type 8 CHOICE L \GPDB[gpdb]D[gpdbD]|0
Ì € i 2
mis.pd.prob.codes.customer (codes.customer)
[problem, code.cus.q]
\GPDB[gpdb]DC[gpdbQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
code.cus.q 3 PINT R gpdbQ
code.cus 15 FREE L \GPDB[gpdb]DC[gpdbQ]|1
code.cus.type 8 CHOICE L \GPDB[gpdb]DC[gpdbQ]|0
Ì € i 2
mis.pd.prob.keywords (keywords)
[problem, keyword.q]
\GPDB[gpdb]K[gpdbK]
Field Name Len Dat Typ J DPM Offset/Local/VAL
keyword.q 3 PINT R gpdbK
keyword 25 FREE L \GPDB[gpdb]K[gpdbK]|0
keyword.active 1 YN L \GPDB[gpdb]K[gpdbK]|1
Ì € i 2
mis.pd.prob.keywords.customer (keywords.customer)
[problem, keyword.cus.q]
\GPDB[gpdb]KC[gpdbC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
keyword.cus.q 3 PINT R gpdbC
keyword.cus 25 FREE L \GPDB[gpdb]KC[gpdbC]|0
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mis.pd.prob.code.x [code.type,code,problem]
code.x \GPDBC[gpdbT,gpdbI,gpdb]
mis.pd.prob.keyword.x [keyword,problem]
keyword.x \GPDBK[gpdbW,gpdb]
|
|
| | | |