sHelp
                                     OE.ADE
     i   2
   oe.adverse.drug.events.file
     oe.ade.new.rx.values
       oe.ade.new.drugs
     oe.ade.old.rx.values
       oe.ade.rx.drugs
     oe.ade.pha.int.allergies
     oe.ade.pha.int.diseases
     oe.ade.pha.int.dose.errors
     oe.ade.pha.int.dose.type.err
       pha.dose.type.err.components
         oe.ade.pha.dose.type.err.text
     oe.ade.pha.int.duplicates
     oe.ade.pha.int.food.ints
     oe.ade.pha.int.interactions

 Ì     i   2
oe.adverse.drug.events.file    (main) 
[urn]
:PADE[pade]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 urn                         10 URN      L                 pade                                                        
 action                       1 CHOICE   L                 :PADE[pade]|6                                               
 device                      15 FREE     L                 :PADE[pade]|5                                               
 event.date                   8 DATE     L                 :PADE[pade]|0                                               
 event.time                   4 HHMM     L                 :PADE[pade]|1                                               
 location                    10 FREE     L  MIS.LOCN.DICT  :PADE[pade]|8                                           
 order.type.type             10 CHOICE   L                 :PADE[pade]|7                                               
 patient                     43 FREE     L  OE.PAT         :PADE[pade]|2                                           
 pha.all.comment             10 FREE     L                 :PADE[pade]CMT|2                                            
 pha.all.text                60 FREE     L                 :PADE[pade]CMT|3                                            
 pha.disease.comment         10 FREE     L                 :PADE[pade]CMT2|2                                           
 pha.disease.text            60 FREE     L                 :PADE[pade]CMT2|3                                           
 pha.dose.comment            10 FREE     L                 :PADE[pade]CMT2|4                                           
 pha.dose.text               60 FREE     L                 :PADE[pade]CMT2|5                                           
 pha.dup.comment             10 FREE     L                 :PADE[pade]CMT|4                                            
 pha.dup.text                60 FREE     L                 :PADE[pade]CMT|5                                            
 pha.food.comment            10 FREE     L                 :PADE[pade]CMT2|0                                           
 pha.food.text               60 FREE     L                 :PADE[pade]CMT2|1                                           
 pha.int.comment             10 FREE     L                 :PADE[pade]CMT|0                                            
 pha.int.text                60 FREE     L                 :PADE[pade]CMT|1                                            
 physician                   10 FREE     L  MIS.DOC.DICT   :PADE[pade]|3                                           
 user                        10 FREE     L  MIS.USER       :PADE[pade]|4                                           
 Ì     i   2
oe.ade.new.rx.values    (new.rx) 
[urn, new.bottle.type]
:PADE[pade]NEW[trABT]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 new.bottle.type              2 PINT     R                 trABT                                                       
 new.rate                    25 FREE     L                 :PADE[pade]NEW[trABT]|1                                     
 new.sig                     20 FREE     L  MIS.DIR        :PADE[pade]NEW[trABT]|0                                 
 Ì     i   2
oe.ade.new.drugs    (new.drugs) 
[urn,new.bottle.type, new.drug.q]
:PADE[pade]NEW[trABT]MED[ptfq]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 new.drug.q                   3 PINT     R                 ptfq                                                        
 new.drug                    10 FREE     L  PHA.DRUG       :PADE[pade]NEW[trABT]MED[ptfq]|0                        
 new.drug.dose                9 DEC      R                 :PADE[pade]NEW[trABT]MED[ptfq]|3                            
 new.drug.dose.units         10 FREE     L                 :PADE[pade]NEW[trABT]MED[ptfq]|4                            
 new.drug.name               30 FREE     L                 :PADE[pade]NEW[trABT]MED[ptfq]|1                            
 new.drug.use                 1 CHOICE   L                 :PADE[pade]NEW[trABT]MED[ptfq]|2                            
 Ì     i   2
oe.ade.old.rx.values    (old.rx) 
[urn, old.bottle.type]
:PADE[pade]OLD[trABT]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 old.bottle.type              2 PINT     R                 trABT                                                       
 old.rate                    25 FREE     L                 :PADE[pade]OLD[trABT]|1                                     
 old.sig                     20 FREE     L  MIS.DIR        :PADE[pade]OLD[trABT]|0                                 
 Ì     i   2
oe.ade.rx.drugs    (old.drugs) 
[urn,old.bottle.type, old.drug.q]
:PADE[pade]OLD[trABT]MED[ptfq]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 old.drug.q                   3 PINT     R                 ptfq                                                        
 old.drug                    10 FREE     L  PHA.DRUG       :PADE[pade]OLD[trABT]MED[ptfq]|0                        
 old.drug.dose                9 DEC      R                 :PADE[pade]OLD[trABT]MED[ptfq]|3                            
 old.drug.dose.units         10 FREE     L                 :PADE[pade]OLD[trABT]MED[ptfq]|4                            
 old.drug.name               30 FREE     L                 :PADE[pade]OLD[trABT]MED[ptfq]|1                            
 old.drug.use                 1 CHOICE   L                 :PADE[pade]OLD[trABT]MED[ptfq]|2                            
 Ì     i   2
oe.ade.pha.int.allergies    (pha.int.allergies) 
[urn, pha.int.all.q]
:PADE[pade]IA[pia]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.int.all.q                3 PINT     R                 pia                                                         
 pha.int.all                 10 FREE     L                 :PADE[pade]IA[pia]|1                                        
 pha.int.all.adr              1 YN       L                 :PADE[pade]IA[pia]|3                                        
 pha.int.all.description     45 FREE     L                 :PADE[pade]IA[pia]|2                                        
 pha.int.all.excip            1 YN       L                 :PADE[pade]IA[pia]|5                                        
 pha.int.all.fsv.code        15 FREE     L                 :PADE[pade]IA[pia]|10                                       
 pha.int.all.fsv.icode       15 FREE     L                 :PADE[pade]IA[pia]|11                                       
 pha.int.all.fsv.mono        10 FREE     L                 :PADE[pade]IA[pia]|13                                       
 pha.int.all.fsv.warn        10 FREE     L                 :PADE[pade]IA[pia]|12                                       
 pha.int.all.med             10 FREE     L                 :PADE[pade]IA[pia]|7                                        
 pha.int.all.med.desc        60 FREE     L                 :PADE[pade]IA[pia]|8                                        
 pha.int.all.ndc             12 FREE     L                 :PADE[pade]IA[pia]|9                                        
 pha.int.all.ndc.unrev        1 YN       L                 :PADE[pade]IA[pia]|6                                        
 pha.int.all.sev              1 CHOICE   L                 :PADE[pade]IA[pia]|4                                        
 pha.int.all.type             2 FREE     L                 :PADE[pade]IA[pia]|0                                        
 Ì     i   2
oe.ade.pha.int.diseases    (pha.int.diseases) 
[urn, pha.int.disease.q]
:PADE[pade]IDIS[pidc]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.int.disease.q            3 PINT     R                 pidc                                                        
 pha.int.dis.contraind       10 FREE     L                 :PADE[pade]IDIS[pidc]|0                                     
 pha.int.dis.contraind.txt   45 FREE     L                 :PADE[pade]IDIS[pidc]|1                                     
 Ì     i   2
oe.ade.pha.int.dose.errors    (pha.int.dose.err) 
[urn, pha.int.dose.warn.q]
:PADE[pade]IDOS[pidwq]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.int.dose.warn.q          3 PINT     R                 pidwq                                                       
 pha.int.dose.warn.med       10 FREE     L  PHA.DRUG       :PADE[pade]IDOS[pidwq]|1                                
 pha.int.dose.warn.text      80 FREE     L                 :PADE[pade]IDOS[pidwq]|0                                    
 Ì     i   2
oe.ade.pha.int.dose.type.err    (pha.int.dose.type) 
[urn, pha.dose.type,pha.dose.range,pha.dose.range.q,pha.dose.type.q]
:PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.dose.type               15 FREE     L                 tddt                                                        
 pha.dose.range              15 FREE     L                 tddc                                                        
 pha.dose.range.q             3 PINT     R                 tddcR                                                       
 pha.dose.type.q              3 PINT     R                 tddcQ                                                       
 pha.bottle.type              3 PINT     R                 :PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]|3                     
 pha.dose.condition.name     55 FREE     L                 :PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]|0                     
 pha.dose.drug.name          30 FREE     L                 :PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]|1                     
 pha.dose.range.name         30 FREE     L                 :PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]|2                     
 pha.dose.type.name          30 FREE     L                 :PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]|4                     
 Ì     i   2
pha.dose.type.err.components    (pha.dose.type.comp) 
[urn,pha.dose.type,pha.dose.range,pha.dose.range.q,pha.dose.type.q, pha.dose.type.component]
:PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]C[tddcC]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.dose.type.component      5 FREE     L                 tddcC                                                       
 pha.dose.type.comp.name     15 FREE     L                 :PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]C[tddcC]|0             
 Ì     i   2
oe.ade.pha.dose.type.err.text    (pha.dose.type.text) 
[urn,pha.dose.type,pha.dose.range,pha.dose.range.q,pha.dose.type.q,pha.dose.type.component, pha.dose.type.text.q]
:PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]C[tddcC]T[trDTQ]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.dose.type.text.q         3 PINT     R                 trDTQ                                                       
 pha.dose.type.text.line     80 FREE     L                 :PADE[pade]DWT[tddt,tddc,tddcR,tddcQ]C[tddcC]T[trDTQ]       
 Ì     i   2
oe.ade.pha.int.duplicates    (pha.int.duplicates) 
[urn, pha.int.dup.q]
:PADE[pade]ID[pid]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.int.dup.q                3 PINT     R                 pid                                                         
 pha.int.dup                 10 FREE     L                 :PADE[pade]ID[pid]|1                                        
 pha.int.dup.description     45 FREE     L                 :PADE[pade]ID[pid]|2                                        
 pha.int.dup.med             10 FREE     L  PHA.DRUG       :PADE[pade]ID[pid]|3                                    
 pha.int.dup.type             1 FREE     L                 :PADE[pade]ID[pid]|0                                        
 Ì     i   2
oe.ade.pha.int.food.ints    (pha.int.food.int) 
[urn, pha.food.int.q]
:PADE[pade]IF[pif]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.food.int.q               3 PINT     R                 pif                                                         
 pha.food.int                10 FREE     L                 :PADE[pade]IF[pif]|1                                        
 pha.food.int.description    60 FREE     L                 :PADE[pade]IF[pif]|2                                        
 pha.food.int.med            10 FREE     L  PHA.DRUG       :PADE[pade]IF[pif]|3                                    
 pha.food.int.severity        1 FREE     L                 :PADE[pade]IF[pif]|0                                        
 Ì     i   2
oe.ade.pha.int.interactions    (pha.int.interactions) 
[urn, pha.int.int.q]
:PADE[pade]II[pii]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 pha.int.int.q                3 PINT     R                 pii                                                         
 pha.int.auto.override        1 YN       L                 :PADE[pade]II[pii]|4                                        
 pha.int.int                 10 FREE     L                 :PADE[pade]II[pii]|1                                        
 pha.int.int.description     60 FREE     L                 :PADE[pade]II[pii]|2                                        
 pha.int.int.med             10 FREE     L  PHA.DRUG       :PADE[pade]II[pii]|3                                    
 pha.int.int.severity         1 FREE     L                 :PADE[pade]II[pii]|0                                        
 Ì       2
 INDEX FILE/INTERNAL NAME           SUBSCRIPTS/PHYSICAL BASE

 oe.ade.date.index                  [event.date,location,urn]
   date.x                             ?PADED[padeD,ggn,pade]

 oe.ade.location.index              [location,event.date,urn]
   location.x                         ?PADEL[ggn,padeD,pade]

 oe.ade.physician.index             [physician,event.date,location,urn]
   physician.x                        ?PADEP[ggg,padeD,ggn,pade]

 oe.ade.user.x                      [user,event.date,location,urn]
   user.x                             ?PADEU[gu,padeD,ggn,pade]