sHelp
                                     PHA.ADR
     i   2
   pha.adverse.drug.reactions
     pha.adr.classes
     pha.adr.comments
     pha.adr.drugs
     pha.adr.generics
     pha.adr.ingredients
     pha.adr.keywords
     pha.adr.lines
     pha.adr.queries
       pha.adr.multiple.queries
     pha.adr.rxs
     pha.adr.sources
     pha.adr.staff.types
       pha.adr.staff.members
     pha.adr.workload
   pha.adr.pci.index

 Ì     i   2
pha.adverse.drug.reactions    (main) 
[urn]
?TK[tk]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 urn                         10 URN      L                 tk                                                          
 cds                         15 FREE     L  MIS.SCREEN     ?TK[tk]|21                                              
 date                         8 DATE     L                 ?TK[tk]|3                                                   
 days.req                     2 INTZ     R                 ?TK[tk]|7                                                   
 end.date                     8 DATE     L                 ?TK[tk]|12                                                  
 end.time                     4 HHMM     L                 ?TK[tk]|13                                                  
 enter.date                   8 DATE     L                 ?TK[tk]|8                                                   
 enter.time                   4 HHMM     L                 ?TK[tk]|9                                                   
 hours.req                    2 INTZ     R                 ?TK[tk]|4                                                   
 last.edit.date               8 DATE     L                 ?TK[tk]|14                                                  
 last.edit.time               4 HHMM     L                 ?TK[tk]|15                                                  
 last.edit.user              10 FREE     L  MIS.USER       ?TK[tk]|16                                              
 minutes.req                  2 INTZ     R                 ?TK[tk]|6                                                   
 mri.urn                     25 URN      L  MRI.PAT        VAL=@PHA.PAT.mri.urn[@patient]                          
 on.med.rec.form              1 YN       L                 ?TK[tk]|20                                                  
 outcome                     10 FREE     L  PHA.ADR.OUT    ?TK[tk]|17                                              
 patient                     30 FREE     L  PHA.PAT        ?TK[tk]|1                                               
 severity                    10 FREE     L  PHA.ADR.SEV    ?TK[tk]|18                                              
 site                        10 FREE     L  PHA.SITE       ?TK[tk]|19                                              
 start.date                   8 DATE     L                 ?TK[tk]|10                                                  
 start.time                   4 HHMM     L                 ?TK[tk]|11                                                  
 status                      10 FREE     L  PHA.ADR.STT    ?TK[tk]|5                                               
 total.minutes                5 INT      R                 VAL=@days.req*1440+(@hours.req*60)+@minutes.req             
 type                        10 FREE     L  PHA.ADR.TYP    ?TK[tk]|2                                               
 user                        10 FREE     L  MIS.USER       ?TK[tk]|0                                               
 Ì     i   2
pha.adr.classes    (classes) 
[urn, class]
?TK[tk]C[tdc]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 class                       10 FREE     L  PHA.CLASS      tdc                                                     
 Ì     i   2
pha.adr.comments    (comments) 
[urn, comment.q]
?TK[tk]O[tkO]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 comment.q                    3 PINT     R                 tkO                                                         
 comment                     92 FREE     L                 ?TK[tk]O[tkO]                                               
 Ì     i   2
pha.adr.drugs    (drugs) 
[urn, drug]
?TK[tk]D[tf]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 drug                        10 FREE     L  PHA.DRUG       tf                                                      
 Ì     i   2
pha.adr.generics    (generics) 
[urn, generic]
?TK[tk]G[tdg]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 generic                     10 FREE     L  PHA.GENERIC    tdg                                                     
 Ì     i   2
pha.adr.ingredients    (ingredients) 
[urn, ingredient]
?TK[tk]I[tta]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 ingredient                  10 FREE     L  PHA.ALLERGY    tta                                                     
 Ì     i   2
pha.adr.keywords    (keywords) 
[urn, keyword]
?TK[tk]K[tkk]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 keyword                     10 FREE     L  PHA.ADR.KEY    tkk                                                     
 Ì     i   2
pha.adr.lines    (lines) 
[urn, line.q]
?TK[tk]T[tkT]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 line.q                       3 PINT     R                 tkT                                                         
 line                        92 FREE     L                 ?TK[tk]T[tkT]                                               
 Ì     i   2
pha.adr.queries    (queries) 
[urn, query]
?TK[tk]Q[ggv]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 query                       10 FREE     L  MIS.QUERY      ggv                                                     
 query.response              75 QRY.RESP L                 ?TK[tk]Q[ggv]|0                                             
 query.text                  60 FREE     L                 VAL=@MIS.QUERY.text[PHA.ADR.query]                          
 query.text.and.response    137 FREE     L                 VAL=@PHA.ADR.query.text_": "_%MIS.QUERY.int.to.ext(@PH      
                                                           VAL=A.ADR.query.response,PHA.ADR.query)                     
 Ì     i   2
pha.adr.multiple.queries    (multiple.queries) 
[urn,query, mult.query.seq.no]
?TK[tk]Q[ggv]M[ggvN]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 mult.query.seq.no            3 PINT     R                 ggvN                                                        
 mult.query.response         75 QRY.RESP L                 ?TK[tk]Q[ggv]M[ggvN]|0                                      
 mult.query.text.and.resp   137 FREE     L                 VAL=@PHA.ADR.query.text_": "_%MIS.QUERY.int.to.ext(@PH      
                                                           VAL=A.ADR.mult.query.response,PHA.ADR.query)                
 Ì     i   2
pha.adr.rxs    (rxs) 
[urn, rx]
?TK[tk]R[trN]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 rx                          11 FREE     L                 trN                                                         
 rx.urn                      10 URN      L  PHA.RX         ?TK[tk]R[trN]|0                                         
 Ì     i   2
pha.adr.sources    (sources) 
[urn, source.q]
?TK[tk]S[tkS]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 source.q                     3 PINT     R                 tkS                                                         
 source                      92 FREE     L                 ?TK[tk]S[tkS]                                               
 Ì     i   2
pha.adr.staff.types    (staff.types) 
[urn, staff.type]
?TK[tk]F[tkh]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 staff.type                  10 URN      L  PHA.ADR.STF    tkh                                                     
 Ì     i   2
pha.adr.staff.members    (staff.members) 
[urn,staff.type, staff.member]
?TK[tk]F[tkh]M[tkM]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 staff.member                10 FREE     L                 tkM                                                         
 staff.name                  30 FREE     L                 ?TK[tk]F[tkh]M[tkM]|0                                       
 Ì     i   2
pha.adr.workload    (workload) 
[urn, wl.status]
?TK[tk]WL[tkc]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 wl.status                   10 FREE     L  PHA.ADR.STT    tkc                                                     
 wl.count                     2 PINTZ    R                 ?TK[tk]WL[tkc]|1                                            
 wl.date                      8 DATE     L                 ?TK[tk]WL[tkc]|3                                            
 wl.function                 10 URN      L  PHA.WFUNC      ?TK[tk]WL[tkc]|0                                        
 wl.time                      4 HHMM     L                 ?TK[tk]WL[tkc]|4                                            
 wl.user                     10 FREE     L  MIS.USER       ?TK[tk]WL[tkc]|2                                        
 Ì     i   2
pha.adr.pci.index    (pci.x) 
[pci.mri,pci.urn]
:TKQ[ea,tk]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pci.mri                     25 URN      L  PHA.MRI        ea                                                      
 pci.urn                     10 URN      L  PHA.ADR        tk                                                      
 pci.date                     8 DATE     L                 :TKQ[ea,tk]|1                                               
 pci.patient                 30 FREE     L  PHA.PAT        :TKQ[ea,tk]|0                                           
 Ì       2
 INDEX FILE/INTERNAL NAME           SUBSCRIPTS/PHYSICAL BASE

 pha.adr.class.index                [class,urn]
   class.x                            :TKIC[tdc,tk]

 pha.adr.date.index                 [date,urn]
   date.x                             :TKID[tkd,tk]

 pha.adr.drug.index                 [drug,urn]
   drug.x                             :TKIM[tf,tk]

 pha.adr.generic.index              [generic,urn]
   generic.x                          :TKIG[tdg,tk]

 pha.adr.ingredient.index           [ingredient,urn]
   ingredient.x                       :TKIN[tta,tk]

 pha.adr.keyword.index              [keyword,urn]
   keyword.x                          :TKIK[tkk,tk]

 pha.adr.mri.index                  [mri.urn,urn]
   mri.x                              :TKIU[ea,tk]

 pha.adr.outcome.index              [outcome,urn]
   outcome.x                          :TKIO[tko,tk]

 pha.adr.patient.class.index        [patient,class,urn]
   patient.class.x                    :TKIY[aa,tdc,tk]

 pha.adr.patient.date.index         [patient,date,urn]
   patient.date.x                     :TKIA[aa,tkd,tk]

 pha.adr.patient.drug.index         [patient,drug,urn]
   patient.drug.x                     :TKIW[aa,tf,tk]

 pha.adr.patient.generic.index      [patient,generic,urn]
   patient.generic.x                  :TKIX[aa,tdg,tk]

 pha.adr.patient.ingred.index       [patient,ingredient,urn]
   patient.ingredient.x               :TKII[aa,tta,tk]

 pha.adr.patient.keyword.index      [patient,keyword,urn]
   patient.keyword.x                  :TKIZ[aa,tkk,tk]

 pha.adr.patient.rx.index           [patient,rx.urn,urn]
   patient.rx.x                       :TKIR[aa,tr,tk]

 pha.adr.patient.index              [patient,urn]
   patient.x                          :TKIP[aa,tk]

 pha.adr.severity.index             [severity,urn]
   severity.x                         :TKIV[tks,tk]

 pha.adr.staff.member.index         [staff.member,urn]
   staff.member.x                     :TKIF[tkM,tk]

 pha.adr.staff.type.index           [staff.type,urn]
   staff.type.x                       :TKIE[tkh,tk]

 pha.adr.statistics.index           [date,user,type,urn]
   statistics.x                       :TKIB[tkd,gu,tkt,tk]

 pha.adr.status.index               [status,urn]
   status.x                           :TKIS[tkc,tk]

 pha.adr.type.index                 [type,urn]
   type.x                             :TKIT[tkt,tk]