sHelp
                                     MRI.CHART.REQ
     i   2
 main
   charts.requested
     activity

 Ì     i   2
main
[request.no]
*(E1)ECR[ecr]

 Field Name                 Len Dat Typ  J  DPM            Offset/Local/VAL
 request.no                  10 PINT     R                 ecr                                                         
 dates.needed.from            8 DATE     L                 *(E1)ECR[ecr]|4                                             
 dates.needed.thru            8 DATE     L                 *(E1)ECR[ecr]|5                                             
 reason.for.request          40 FREE     L                 *(E1)ECR[ecr]|3                                             
 request.comment             40 FREE     L                 *(E1)ECR[ecr]|6                                             
 request.date                 8 DATE     L                 *(E1)ECR[ecr]|8                                             
 request.priority             1 FREE     L                 *(E1)ECR[ecr]|7                                             
 requestor                   10 FREE     L  MIS.USER       *(E1)ECR[ecr]|0                                         
 requestor.name              30                            VAL=@MIS.USER.name[@requestor]                              
 requestors.email            60 FREE     L                 *(E1)ECR[ecr]|2                                             
 requestors.location         10 FREE     L  MIS.USER.LOCN  *(E1)ECR[ecr]|9                                         
 requestors.phone            18 PHONE    L                 *(E1)ECR[ecr]|1                                             
 Ì   €   i   2
charts.requested
[request.no,  chart.seq.no]
*(E1)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                 *(E1)ECR[ecr]CH[ecrN]|4                                     
 chart.date.approved.from     8 DATE     L                 *(E1)ECR[ecr]CH[ecrN]|11                                    
 chart.date.approved.thru     8 DATE     L                 *(E1)ECR[ecr]CH[ecrN]|12                                    
 chart.dob                   10 BDATE    L                 *(E1)ECR[ecr]CH[ecrN]|3                                     
 chart.medical.record        10 FREE     L                 *(E1)ECR[ecr]CH[ecrN]|1                                     
 chart.name                  25 FREE     L                 *(E1)ECR[ecr]CH[ecrN]|0                                     
 chart.req.active             1 YN       L                 *(E1)ECR[ecr]CH[ecrN]|10                                    
 chart.req.ea.found          25 URN      L  MRI.PAT        *(E1)ECR[ecr]CH[ecrN]|9                                 
 chart.req.status             9 FREE     L                 *(E1)ECR[ecr]CH[ecrN]|7                                     
 chart.req.status.comment    40 FREE     L                 *(E1)ECR[ecr]CH[ecrN]|13                                    
 chart.req.status.date        8 DATE     L                 *(E1)ECR[ecr]CH[ecrN]|8                                     
 chart.sex                    1 FREE     L                 *(E1)ECR[ecr]CH[ecrN]|2                                     
 chart.soc                   12 FREE     L                 *(E1)ECR[ecr]CH[ecrN]|5                                     
 chart.visit.date             8 DATE     L                 *(E1)ECR[ecr]CH[ecrN]|6                                     
 Ì   €   i   2
activity
[request.no,chart.seq.no,  activity.date,activity.number]
*(E1)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                 *(E1)ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|2                        
 activity.event              20 FREE     L                 *(E1)ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|4                        
 activity.oa.msg             10 FREE     L                 *(E1)ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|5                        
 activity.time                4 HHMM     L                 *(E1)ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|3                        
 activity.type               15 CHOICE   L                 *(E1)ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|1                        
 activity.user               10 FREE     L  MIS.USER       *(E1)ECR[ecr]CH[ecrN]A[ecrD,ecrAN]|0                    

 Index Files                        Subscripts/Physical Base

 requestor.chart.x                  [requestor,request.no,chart.seq.no]
                                      ?(E)ERCI[gu,ecr,ecrN]

 requestor.patient.x                [requestor,chart.req.ea.found]
                                      ?(E)ECPTRX[gu,ea]

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

 submitted.x                        [request.no,chart.seq.no]
                                      ?(E)ECSUB[ecr,ecrN]

 worklist.compile.x                 [chart.medical.record,requestors.location,dates.needed.from,dates.needed.thru,ch
                                      ?(E)ECWLCI[ecmR,gul,ecdtF,ecdtT,ecrST,gu,ecprT,ecr,ecrN]