sHelp
                                     PHA.CLV
     i   2
 main
   audit.trail
     audit.trail.detail
   classes
   comments
   drugs
   generics
   keywords
   lines
   queries
     queries.mult
   rxs
   sources
   staff.types
     staff.members
   txns
     txn.comments
   workload

 Ì   €   i   2
main
[urn]
*(T1)TCI[tci]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 urn                         10 URN      L                 tci                                                         
 bill.number                 10 FREE     L                 *(T1)TCI[tci]BI|0                                           
 charge                       9 MONEY    R                 *(T1)TCI[tci]BI|1                                           
 date                         8 DATE     L                 *(T1)TCI[tci]|3                                             
 days.req                     2 INT      R                 *(T1)TCI[tci]|7                                             
 end.date                     8 DATE     L                 *(T1)TCI[tci]|12                                            
 end.time                     4 HHMM     L                 *(T1)TCI[tci]|13                                            
 enter.date                   8 DATE     L                 *(T1)TCI[tci]|8                                             
 enter.time                   4 HHMM     L                 *(T1)TCI[tci]|9                                             
 hours.req                    2 INT      R                 *(T1)TCI[tci]|4                                             
 last.edit.date               8 DATE     L                 *(T1)TCI[tci]|14                                            
 last.edit.time               4 HHMM     L                 *(T1)TCI[tci]|15                                            
 last.edit.user              10 FREE     L  MIS.USER       *(T1)TCI[tci]|16                                        
 minutes.req                  2 INT      R                 *(T1)TCI[tci]|6                                             
 mri.urn                     25 URN      L  MRI.PAT        VAL=@PHA.PAT.mri.urn[@patient]                          
 outcome                     10 FREE     L  PHA.CLO        *(T1)TCI[tci]|17                                        
 patient                     30 FREE     L  PHA.PAT        *(T1)TCI[tci]|1                                         
 severity                    10 FREE     L  PHA.CLS        *(T1)TCI[tci]|18                                        
 site                        10 FREE     L  PHA.SITE       *(T1)TCI[tci]|19                                        
 start.date                   8 DATE     L                 *(T1)TCI[tci]|10                                            
 start.time                   4 HHMM     L                 *(T1)TCI[tci]|11                                            
 status                      10 FREE     L  PHA.CLC        *(T1)TCI[tci]|5                                         
 total.charges                9 MONEY    R                 *(T1)TCI[tci]BI|4                                           
 total.minutes                5 INT      R                 VAL=@days.req*1440+(@hours.req*60)+@minutes.req             
 total.units                  9 DEC      R                 *(T1)TCI[tci]BI|3                                           
 type                        10 FREE     L  PHA.CLT        *(T1)TCI[tci]|2                                         
 unit.eq                     25 FREE     L                 *(T1)TCI[tci]BI|2                                           
 user                        10 FREE     L  MIS.USER       *(T1)TCI[tci]|0                                         
 Ì   €   i   2
audit.trail
[urn,  audit.trail.seconds,audit.trail.type]
*(T1)TCI[tci]AU[tciAS,tciAT]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 audit.trail.seconds         13 PINT     R                 tciAS                                                       
 audit.trail.type             2 FREE     L                 tciAT                                                       
 audit.trail.actual.date      8 DATE     L                 *(T1)TCI[tci]AU[tciAS,tciAT]|1                              
 audit.trail.actual.time      4 HHMM     L                 *(T1)TCI[tci]AU[tciAS,tciAT]|2                              
 audit.trail.date             8 DATE     L                 VAL=%Z.date.in.magic(@audit.trail.seconds#.)                
 audit.trail.device          10 FREE     L                 *(T1)TCI[tci]AU[tciAS,tciAT]|3                              
 audit.trail.time             4 HHMM     L                 VAL=%Z.time.out(@audit.trail.seconds#.)                     
 audit.trail.type.name        6 FREE     L                 VAL=IF{@PHA.PARAM.audit.trail.type.name[PHA.CLV.audit.      
                                                           VAL=trail.type];PHA.CLV.audit.trail.type}                   
 audit.trail.user            10 FREE     L                 *(T1)TCI[tci]AU[tciAS,tciAT]|0                              
 Ì   €   i   2
audit.trail.detail
[urn,audit.trail.seconds,audit.trail.type,  audit.trail.q]
*(T1)TCI[tci]AU[tciAS,tciAT]D[tciAQ]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 audit.trail.q                2 PINT     R                 tciAQ                                                       
 audit.trail.line            70 FREE     L                 *(T1)TCI[tci]AU[tciAS,tciAT]D[tciAQ]                        
 Ì   €   i   2
classes
[urn,  class]
*(T1)TCI[tci]C[tdc]

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

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 comment.q                    3 PINT     R                 tcio                                                        
 comment                     92 TEXT     L                 *(T1)TCI[tci]O[tcio]                                        
 Ì   €   i   2
drugs
[urn,  drug]
*(T1)TCI[tci]D[tf]

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

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 generic                     12 FREE     L  PHA.GENERIC    tdg                                                     
 Ì   €   i   2
keywords
[urn,  keyword]
*(T1)TCI[tci]K[tdck]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 keyword                     10 FREE     L  PHA.CLK        tdck                                                    
 Ì   €   i   2
lines
[urn,  line.q]
*(T1)TCI[tci]T[tcit]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 line.q                       3 PINT     R                 tcit                                                        
 line                        92 TEXT     L                 *(T1)TCI[tci]T[tcit]                                        
 Ì   €   i   2
queries
[urn,  query]
*(T1)TCI[tci]Q[ggv]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 query                       10 FREE     L  MIS.QUERY      ggv                                                     
 query.response              70 FREE     L                 *(T1)TCI[tci]Q[ggv]|0                                       
 query.text                  60 FREE     L                 VAL=@MIS.QUERY.text[PHA.CLV.query]                          
 query.text.and.response    131 FREE     L                 VAL=@PHA.CLV.query.text_": "_IF{@MIS.QUERY.date.type.x      
                                                           VAL= %Z.date.query.out(@PHA.CLV.query.response);@PHA.C      
                                                           VAL=LV.query.response}                                      
 Ì   €   i   2
queries.mult
[urn,query,  query.mult.q]
*(T1)TCI[tci]Q[ggv]M[ggvQ]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 query.mult.q                 3 PINT     R                 ggvQ                                                        
 query.mult.resp             70 FREE     L                 *(T1)TCI[tci]Q[ggv]M[ggvQ]|0                                
 Ì   €   i   2
rxs
[urn,  rx]
*(T1)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         *(T1)TCI[tci]R[trN]|0                                   
 Ì   €   i   2
sources
[urn,  source.q]
*(T1)TCI[tci]S[tcis]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 source.q                     3 PINT     R                 tcis                                                        
 source                      92 TEXT     L                 *(T1)TCI[tci]S[tcis]                                        
 Ì   €   i   2
staff.types
[urn,  staff.type]
*(T1)TCI[tci]F[tdh]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 staff.type                  10 URN      L  PHA.STF        tdh                                                     
 Ì   €   i   2
staff.members
[urn,staff.type,  staff.member]
*(T1)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                 *(T1)TCI[tci]F[tdh]M[tciM]|0                                
 Ì   €   i   2
txns
[urn,  txn.q]
*(T1)TCI[tci]X[tcix]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 txn.q                        3 PINT     R                 tcix                                                        
 txn.batch.time               4 HHMM     L                 *(T1)TCI[tci]X[tcix]|9                                      
 txn.billing.code            10 FREE     L                 *(T1)TCI[tci]X[tcix]|5                                      
 txn.charge                   9 MONEY    R                 *(T1)TCI[tci]X[tcix]|4                                      
 txn.credited                 1 FREE     L                 *(T1)TCI[tci]X[tcix]|10                                     
 txn.enter.date               8 DATE     L                 VAL=%Z.date.in.magic(@txn.entered)                          
 txn.enter.time               4 HHMM     L                 VAL=%Z.time.out(@txn.entered)                               
 txn.entered                  9 PINT     R                 *(T1)TCI[tci]X[tcix]|2                                      
 txn.patient                 30 FREE     L  PHA.PAT        *(T1)TCI[tci]X[tcix]|1                                  
 txn.service                 10 FREE     L  MIS.SVC        *(T1)TCI[tci]X[tcix]|7                                  
 txn.service.date             8 DATE     L                 VAL=%Z.date.in.magic(@txn.service.seconds)                  
 txn.service.date.and.time   13 FREE     L                 VAL=IF{@txn.service.seconds^TSS %Z.date.out(%Z.date.in      
                                                           VAL=.magic(TSS))_"-"_%Z.time.out(TSS)}                      
 txn.service.seconds          9 PINT     R                 *(T1)TCI[tci]X[tcix]|8                                      
 txn.service.time             4 HHMM     L                 VAL=%Z.time.out(@txn.service.seconds)                       
 txn.signed.charge           10 MONEY    R                 VAL=IF{@txn.type'="C" @txn.charge;0-@txn.charge}            
 txn.signed.units            10 DEC2     R                 VAL=IF{@txn.type'="C" @txn.units;0-@txn.units}              
 txn.type                     1 CHOICE   L                 *(T1)TCI[tci]X[tcix]|0                                      
 txn.units                    9 PDEC     R                 *(T1)TCI[tci]X[tcix]|3                                      
 txn.user                    10 FREE     L  MIS.USER       *(T1)TCI[tci]X[tcix]|6                                  
 Ì   €   i   2
txn.comments
[urn,txn.q,  txn.comment.q]
*(T1)TCI[tci]X[tcix]CMT[tcixc]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 txn.comment.q                2 PINT     R                 tcixc                                                       
 txn.comment                 60 TEXT     L                 *(T1)TCI[tci]X[tcix]CMT[tcixc]                              
 Ì   €   i   2
workload
[urn,  wl.status]
*(T1)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 PINT     R                 *(T1)TCI[tci]WL[tdcc]|1                                     
 wl.date                      8 DATE     L                 *(T1)TCI[tci]WL[tdcc]|3                                     
 wl.function                 10 URN      L  PHA.WFUNC      *(T1)TCI[tci]WL[tdcc]|0                                 
 wl.time                      4 HHMM     L                 *(T1)TCI[tci]WL[tdcc]|4                                     
 wl.user                     10 FREE     L  MIS.USER       *(T1)TCI[tci]WL[tdcc]|2                                 

 Index Files                        Subscripts/Physical Base

 bill.x                             [txn.enter.date,txn.batch.time,urn,txn.q]
                                      ?(T)TCIBL[tcixd,txbtm,tci,tcix]

 class.x                            [class,urn]
                                      ?(T)TCIC[tdc,tci]

 date.x                             [date,urn]
                                      ?(T)TCID[tcid,tci]

 drug.x                             [drug,urn]
                                      ?(T)TCIM[tf,tci]

 generic.x                          [generic,urn]
                                      ?(T)TCIG[tdg,tci]

 keyword.x                          [keyword,urn]
                                      ?(T)TCIK[tdck,tci]

 mri.x                              [mri.urn,urn]
                                      ?(T)TCIU[ea,tci]

 outcome.x                          [outcome,urn]
                                      ?(T)TCIO[tdco,tci]

 patient.class.x                    [patient,class,urn]
                                      ?(T)TCIY[aa,tdc,tci]

 patient.date.x                     [patient,date,urn]
                                      ?(T)TCIA[aa,tcid,tci]

 patient.drug.x                     [patient,drug,urn]
                                      ?(T)TCIW[aa,tf,tci]

 patient.generic.x                  [patient,generic,urn]
                                      ?(T)TCIX[aa,tdg,tci]

 patient.keyword.x                  [patient,keyword,urn]
                                      ?(T)TCIZ[aa,tdck,tci]

 patient.rx.x                       [patient,rx.urn,urn]
                                      ?(T)TCIR[aa,tr,tci]

 patient.x                          [patient,urn]
                                      ?(T)TCIP[aa,tci]

 severity.x                         [severity,urn]
                                      ?(T)TCIV[tdcs,tci]

 staff.member.x                     [staff.member,urn]
                                      ?(T)TCIF[tciM,tci]

 staff.type.x                       [staff.type,urn]
                                      ?(T)TCIE[tdh,tci]

 statistics.x                       [date,user,type,urn]
                                      ?(T)TCIB[tcid,gu,tdct,tci]

 status.x                           [status,urn]
                                      ?(T)TCIS[tdcc,tci]

 type.x                             [type,urn]
                                      ?(T)TCIT[tdct,tci]

 user.x                             [user,urn]
                                      ?(T)TCII[gu,tci]