sHelp
                                     MRI.CHART.REQ
     i   2
   chart.requests
     charts.requested
       chart.activity

 Ì     i   2
chart.requests    (main) 
[request.no]
:ECR[ecr]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 request.no                  10 PINT     R                 ecr                                                         
 dates.needed.from            8 DATE     L                 :ECR[ecr]|4                                                 
 dates.needed.thru            8 DATE     L                 :ECR[ecr]|5                                                 
 reason.for.request          40 FREE     L                 :ECR[ecr]|3                                                 
 request.comment             40 FREE     L                 :ECR[ecr]|6                                                 
 request.date                 8 DATE     L                 :ECR[ecr]|8                                                 
 request.priority             1 FREE     L                 :ECR[ecr]|7                                                 
 requestor                   10 FREE     L  MIS.USER       :ECR[ecr]|0                                             
 requestor.name              30                            VAL=@MIS.USER.name[@requestor]                              
 requestors.email            60 FREE     L                 :ECR[ecr]|2                                                 
 requestors.location         10 FREE     L  MIS.USER.LOCN  :ECR[ecr]|9                                             
 requestors.phone            18 PHONE    L                 :ECR[ecr]|1                                                 

 Ì   €�   i   2
charts.requested    (charts.requested) 
[request.no, chart.seq.no]
:ECR[ecr]CH[ecrN]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 chart.seq.no                 4 PINT     R                 ecrN                                                        
 chart.age                    7 AGE      L                 :ECR[ecr]CH[ecrN]|4                                         
 chart.date.approved.from     8 DATE     L                 :ECR[ecr]CH[ecrN]|11                                        
 chart.date.approved.thru     8 DATE     L                 :ECR[ecr]CH[ecrN]|12                                        
 chart.dob                    8 BDATE    L                 :ECR[ecr]CH[ecrN]|3                                         
 chart.medical.record        10 FREE     L                 :ECR[ecr]CH[ecrN]|1                                         
 chart.name                  25 FREE     L                 :ECR[ecr]CH[ecrN]|0                                         
 chart.req.active             1 YN       L                 :ECR[ecr]CH[ecrN]|10                                        
 chart.req.ea.found          25 URN      L  MRI.PAT        :ECR[ecr]CH[ecrN]|9                                     
 chart.req.status             9 CHOICE   L                 :ECR[ecr]CH[ecrN]|7                                         
 chart.req.status.comment    40 FREE     L                 :ECR[ecr]CH[ecrN]|13                                        
 chart.req.status.date        8 DATE     L                 :ECR[ecr]CH[ecrN]|8                                         
 chart.sex                    1 FREE     L                 :ECR[ecr]CH[ecrN]|2                                         
 chart.soc                   12 FREE     L                 :ECR[ecr]CH[ecrN]|5                                         
 chart.visit.date             8 DATE     L                 :ECR[ecr]CH[ecrN]|6                                         

 Ì   €�   i   2
chart.activity    (activity) 
[request.no,chart.seq.no, activity.date,activity.number]
:ECR[ecr]CH[ecrN]A[ecrD,ecrAN]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL                                        
 activity.date                8 DATE     L                 ecrD                                                        
 activity.number              3 PINT     R                 ecrAN                                                       
 activity.comment            40 FREE     L                 :ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|2                            
 activity.event              20 FREE     L                 :ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|4                            
 activity.oa.msg             10 FREE     L                 :ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|5                            
 activity.time                4 HHMM     L                 :ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|3                            
 activity.type               15 CHOICE   L                 :ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|1                            
 activity.user               10 FREE     L  MIS.USER       :ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|0                        

 Ì       2
 INDEX FILE/INTERNAL NAME           SUBSCRIPTS/PHYSICAL BASE

 requestor.chart.index              [requestor,request.no,chart.seq.no]
   requestor.chart.x                  ?ERCI[gu,ecr,ecrN]

 requestor.patient.index            [requestor,chart.req.ea.found]
   requestor.patient.x                ?ECPTRX[gu,ea]

 requestor.status.index             [requestor,chart.medical.record,request.no,chart.seq.no,chart.req.status,chart.r
   requestor.status.x                 ?ECRST[gu,ecmR,ecr,ecrN,ecrST,ecrDT]

 submitted.index                    [request.no,chart.seq.no]
   submitted.x                        ?ECSUB[ecr,ecrN]