sHelp
                                     PHA.CLV
     i   2
   pha.clinical.interventions
     pha.clin.inter.classes
     pha.clin.inter.comments
     pha.clin.inter.drugs
     pha.clin.inter.generics
     pha.clin.inter.keywords
     pha.clin.inter.text
     pha.clin.inter.queries
       pha.clin.inter.mult.queries
     pha.clin.inter.rxs
     pha.clin.inter.sources
     pha.clin.inter.staff.types
       pha.clin.inter.staff.members
     pha.clv.workload
   pha.clin.inter.pci.index

 Ì     i   2
pha.clinical.interventions    (main) 
[urn]
?TCI[tci]

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

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 class                       10 FREE     L  PHA.CLASS      tdc                                                     
 Ì     i   2
pha.clin.inter.comments    (comments) 
[urn, comment.q]
?TCI[tci]O[tcio]

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

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

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 generic                     10 FREE     L  PHA.GENERIC    tdg                                                     
 Ì     i   2
pha.clin.inter.keywords    (keywords) 
[urn, keyword]
?TCI[tci]K[tdck]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 keyword                     10 FREE     L  PHA.CLK        tdck                                                    
 Ì     i   2
pha.clin.inter.text    (lines) 
[urn, line.q]
?TCI[tci]T[tcit]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 line.q                       3 PINT     R                 tcit                                                        
 line                        92 FREE     L                 ?TCI[tci]T[tcit]                                            
 Ì     i   2
pha.clin.inter.queries    (queries) 
[urn, query]
?TCI[tci]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                 ?TCI[tci]Q[ggv]|0                                           
 query.text                  60 FREE     L                 VAL=@MIS.QUERY.text[PHA.CLV.query]                          
 query.text.and.response    137 FREE     L                 VAL=@PHA.CLV.query.text_": "_%MIS.QUERY.int.to.ext(@PH      
                                                           VAL=A.CLV.query.response,PHA.CLV.query)                     
 Ì     i   2
pha.clin.inter.mult.queries    (multiple.queries) 
[urn,query, mult.query.seq.no]
?TCI[tci]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                 ?TCI[tci]Q[ggv]M[ggvN]|0                                    
 mult.query.text.and.resp   137 FREE     L                 VAL=@PHA.CLV.query.text_": "_%MIS.QUERY.int.to.ext(@PH      
                                                           VAL=A.CLV.mult.query.response,PHA.CLV.query)                
 Ì     i   2
pha.clin.inter.rxs    (rxs) 
[urn, rx]
?TCI[tci]R[trN]

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

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 source.q                     3 PINT     R                 tcis                                                        
 source                      92 FREE     L                 ?TCI[tci]S[tcis]                                            
 Ì     i   2
pha.clin.inter.staff.types    (staff.types) 
[urn, staff.type]
?TCI[tci]F[tdh]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 staff.type                  10 URN      L  PHA.STF        tdh                                                     
 Ì     i   2
pha.clin.inter.staff.members    (staff.members) 
[urn,staff.type, staff.member]
?TCI[tci]F[tdh]M[tciM]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 staff.member                10 FREE     L                 tciM                                                        
 staff.name                  30 FREE     L                 ?TCI[tci]F[tdh]M[tciM]|0                                    
 Ì     i   2
pha.clv.workload    (workload) 
[urn, wl.status]
?TCI[tci]WL[tdcc]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 wl.status                   10 FREE     L  PHA.CLC        tdcc                                                    
 wl.count                     2 PINTZ    R                 ?TCI[tci]WL[tdcc]|1                                         
 wl.date                      8 DATE     L                 ?TCI[tci]WL[tdcc]|3                                         
 wl.function                 10 URN      L  PHA.WFUNC      ?TCI[tci]WL[tdcc]|0                                     
 wl.time                      4 HHMM     L                 ?TCI[tci]WL[tdcc]|4                                         
 wl.user                     10 FREE     L  MIS.USER       ?TCI[tci]WL[tdcc]|2                                     
 Ì     i   2
pha.clin.inter.pci.index    (pci.x) 
[pci.mri,pci.urn]
:TCIQ[ea,tci]

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

 pha.clin.inter.class.index         [class,urn]
   class.x                            :TCIC[tdc,tci]

 pha.clin.inter.date.index          [date,urn]
   date.x                             :TCID[tcid,tci]

 pha.clin.inter.drug.index          [drug,urn]
   drug.x                             :TCIM[tf,tci]

 pha.clin.inter.generic.index       [generic,urn]
   generic.x                          :TCIG[tdg,tci]

 pha.clin.inter.keyword.index       [keyword,urn]
   keyword.x                          :TCIK[tdck,tci]

 pha.clin.inter.mri.index           [mri.urn,urn]
   mri.x                              :TCIU[ea,tci]

 pha.clin.inter.outcome.index       [outcome,urn]
   outcome.x                          :TCIO[tdco,tci]

 pha.clin.inter.pat.class.index     [patient,class,urn]
   patient.class.x                    :TCIY[aa,tdc,tci]

 pha.clin.inter.pat.date.index      [patient,date,urn]
   patient.date.x                     :TCIA[aa,tcid,tci]

 pha.clin.inter.pat.drug.index      [patient,drug,urn]
   patient.drug.x                     :TCIW[aa,tf,tci]

 pha.clin.inter.pat.gen.index       [patient,generic,urn]
   patient.generic.x                  :TCIX[aa,tdg,tci]

 pha.clin.inter.pat.key.index       [patient,keyword,urn]
   patient.keyword.x                  :TCIZ[aa,tdck,tci]

 pha.clin.inter.pat.rx.index        [patient,rx.urn,urn]
   patient.rx.x                       :TCIR[aa,tr,tci]

 pha.clin.inter.patient.index       [patient,urn]
   patient.x                          :TCIP[aa,tci]

 pha.clin.inter.severity.index      [severity,urn]
   severity.x                         :TCIV[tdcs,tci]

 pha.clin.inter.staff.mem.index     [staff.member,urn]
   staff.member.x                     :TCIF[tciM,tci]

 pha.clin.inter.staff.typ.index     [staff.type,urn]
   staff.type.x                       :TCIE[tdh,tci]

 pha.clin.inter.stats.index         [date,user,type,urn]
   statistics.x                       :TCIB[tcid,gu,tdct,tci]

 pha.clin.inter.status.index        [status,urn]
   status.x                           :TCIS[tdcc,tci]

 pha.clin.inter.type.index          [type,urn]
   type.x                             :TCIT[tdct,tci]