Ì € 2
sch.stats.appointment.type (appointment.type)
[date, appt.type]
?WD[wdD]AT[wat]
Field Name Len Dat Typ J DPM Offset/Local/VAL
appt.type 10 FREE L SCH.APPT.TYPE wat
appt.type.ack 5 PINT R ?WD[wdD]AT[wat]|10
appt.type.appts 5 PINT R ?WD[wdD]AT[wat]|8
appt.type.book.mins 5 PINT R ?WD[wdD]AT[wat]|0
appt.type.cancel 5 PINT R ?WD[wdD]AT[wat]|11
appt.type.exp.per 5 PINT R ?WD[wdD]AT[wat]|1
appt.type.no.show 5 PINT R ?WD[wdD]AT[wat]|9
appt.type.seen.ave 7 DEC2 R ?WD[wdD]AT[wat]|4
appt.type.seen.num 5 PINT R ?WD[wdD]AT[wat]|2
appt.type.seen.tot 5 PINT R ?WD[wdD]AT[wat]|3
appt.type.wait.ave 7 DEC2 R ?WD[wdD]AT[wat]|7
appt.type.wait.num 5 PINT R ?WD[wdD]AT[wat]|5
appt.type.wait.tot 5 PINT R ?WD[wdD]AT[wat]|6
appt.type.walk.in 5 PINT R ?WD[wdD]AT[wat]|13
Ì € 2
sch.stats.at.resource (at.resource)
[date,appt.type, atr.resource]
?WD[wdD]AT[wat]R[wre]
Field Name Len Dat Typ J DPM Offset/Local/VAL
atr.resource 15 FREE L SCH.RESOURCE wre
atr.ack 3 PINT R ?WD[wdD]AT[wat]R[wre]|2
atr.appts 3 PINT R ?WD[wdD]AT[wat]R[wre]|0
atr.cancel 3 PINT R ?WD[wdD]AT[wat]R[wre]|3
atr.no.show 3 PINT R ?WD[wdD]AT[wat]R[wre]|1
atr.walk.in 3 PINT R ?WD[wdD]AT[wat]R[wre]|5
Ì € 2
sch.stats.prof.dr.grp (prof.dr.grp)
[date, pdg.group]
?WD[wdD]DG[ggh]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pdg.group 10 FREE L MIS.DOC.GRP ggh
pdg.no.used 3 INT R ?WD[wdD]DG[ggh]|1
pdg.no.used.excl 5 INT R ?WD[wdD]DG[ggh]|11
pdg.no.used.out 3 INT R VAL=@pdg.no.used+0
pdg.no.used.ytd 4 INT R ?WD[wdD]DG[ggh]|6
pdg.no.used.ytd.out 4 INT R VAL=@pdg.no.used.ytd+0
pdg.oth.no.ytd 4 INT R ?WD[wdD]DG[ggh]|8
pdg.oth.percent.used 5 DEC R VAL=(@pdg.other.time*100:2D/@pdg.time.allocated:1D)
pdg.oth.percent.used.ytd 5 DEC R VAL=(@pdg.oth.time.ytd*100:2D/@pdg.time.alloc.ytd:1D)
pdg.oth.time.ytd 6 INT R ?WD[wdD]DG[ggh]|9
pdg.oth.time.ytd.out 6 FREE R VAL=(@pdg.oth.time.ytd/60_":"_(@pdg.oth.time.ytd\60+10
VAL=0%0))
pdg.other.no 3 INT R ?WD[wdD]DG[ggh]|3
pdg.other.time 5 INT R ?WD[wdD]DG[ggh]|4
pdg.other.time.out 5 FREE R VAL=(@pdg.other.time/60_":"_(@pdg.other.time\60+100%0)
VAL=)
pdg.percent.used 5 DEC R VAL=(@pdg.time.used*100:2D/@pdg.time.allocated:1D)
pdg.percent.used.ytd 5 DEC R VAL=(@pdg.time.used.ytd*100:2D/@pdg.time.alloc.ytd:1D)
pdg.time.alloc.out 5 FREE R VAL=(@pdg.time.allocated/60_":"_(@pdg.time.allocated\6
VAL=0+100%0))
pdg.time.alloc.ytd 6 INT R ?WD[wdD]DG[ggh]|5
pdg.time.alloc.ytd.out 6 FREE R VAL=(@pdg.time.alloc.ytd/60_":"_(@pdg.time.alloc.ytd\6
VAL=0+100%0))
pdg.time.allocated 5 INT R ?WD[wdD]DG[ggh]|0
pdg.time.allocated.excl 5 INT R ?WD[wdD]DG[ggh]|10
pdg.time.used 5 INT R ?WD[wdD]DG[ggh]|2
pdg.time.used.excl 5 INT R ?WD[wdD]DG[ggh]|12
pdg.time.used.out 5 FREE R VAL=(@pdg.time.used/60_":"_(@pdg.time.used\60+100%0))
pdg.time.used.ytd 6 INT R ?WD[wdD]DG[ggh]|7
pdg.time.used.ytd.out 6 FREE R VAL=(@pdg.time.used.ytd/60_":"_(@pdg.time.used.ytd\60+
VAL=100%0))
pdg.total.used 5 FREE R VAL=(@pdg.time.used+@pdg.other.time/60_":"_(@pdg.time.
VAL=used+@pdg.other.time\60+100%0))
Ì € 2
sch.stats.prof.dr (prof.doctor)
[date,pdg.group, pd.doctor]
?WD[wdD]DG[ggh]DR[ggg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pd.doctor 10 FREE L MIS.DOC.DICT ggg
pd.no.used 3 INT R ?WD[wdD]DG[ggh]DR[ggg]|1
pd.no.used.excl 5 INT R ?WD[wdD]DG[ggh]DR[ggg]|11
pd.no.used.out 3 INT R VAL=@pd.no.used+0
pd.no.used.ytd 4 INT R ?WD[wdD]DG[ggh]DR[ggg]|6
pd.no.used.ytd.out 4 INT R VAL=@pd.no.used.ytd+0
pd.oth.no.ytd 4 INT R ?WD[wdD]DG[ggh]DR[ggg]|8
pd.oth.percent.used 5 DEC R VAL=(@pd.other.time*100:2D/@pd.time.allocated:1D)
pd.oth.percent.used.ytd 5 DEC R VAL=(@pd.oth.time.ytd*100:2D/@pd.time.alloc.ytd:1D)
pd.oth.time.ytd 6 INT R ?WD[wdD]DG[ggh]DR[ggg]|9
pd.oth.time.ytd.out 6 FREE R VAL=(@pd.oth.time.ytd/60_":"_(@pd.oth.time.ytd\60+100%
VAL=0))
pd.other.no 3 INT R ?WD[wdD]DG[ggh]DR[ggg]|3
pd.other.time 5 INT R ?WD[wdD]DG[ggh]DR[ggg]|4
pd.other.time.out 5 FREE R VAL=(@pd.other.time/60_":"_(@pd.other.time\60+100%0))
pd.percent.used 5 DEC R VAL=(@pd.time.used*100:2D/@pd.time.allocated:1D)
pd.percent.used.ytd 5 DEC R VAL=(@pd.time.used.ytd*100:2D/@pd.time.alloc.ytd:1D)
pd.time.alloc.out 5 FREE R VAL=(@pd.time.allocated/60_":"_(@pd.time.allocated\60+
VAL=100%0))
pd.time.alloc.ytd 6 INT R ?WD[wdD]DG[ggh]DR[ggg]|5
pd.time.alloc.ytd.out 6 FREE R VAL=(@pd.time.alloc.ytd/60_":"_(@pd.time.alloc.ytd\60+
VAL=100%0))
pd.time.allocated 5 INT R ?WD[wdD]DG[ggh]DR[ggg]|0
pd.time.allocated.excl 5 INT R ?WD[wdD]DG[ggh]DR[ggg]|10
pd.time.used 5 INT R ?WD[wdD]DG[ggh]DR[ggg]|2
pd.time.used.excl 5 INT R ?WD[wdD]DG[ggh]DR[ggg]|12
pd.time.used.out 5 FREE R VAL=(@pd.time.used/60_":"_(@pd.time.used\60+100%0))
pd.time.used.ytd 6 INT R ?WD[wdD]DG[ggh]DR[ggg]|7
pd.time.used.ytd.out 6 FREE R VAL=(@pd.time.used.ytd/60_":"_(@pd.time.used.ytd\60+10
VAL=0%0))
pd.total.used 5 FREE R VAL=(@pd.time.used+@pd.other.time/60_":"_(@pd.time.use
VAL=d+@pd.other.time\60+100%0))
Ì € 2
sch.stats.prof.dr.fac (prof.dr.fac)
[date,pdg.group,pd.doctor, pdf.facility]
?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pdf.facility 10 FREE L MIS.FACILITY gqb
pdf.no.used 3 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|1
pdf.no.used.out 3 INT R VAL=@pdf.no.used+0
pdf.no.used.ytd 4 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|6
pdf.no.used.ytd.out 4 INT R VAL=@pdf.no.used.ytd+0
pdf.oth.no.ytd 4 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|8
pdf.oth.percent.used 5 DEC R VAL=(@pdf.other.time*100:2D/@pdf.time.allocated:1D)
pdf.oth.percent.used.ytd 5 DEC R VAL=(@pdf.oth.time.ytd*100:2D/@pdf.time.alloc.ytd:1D)
pdf.oth.time.ytd 6 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|9
pdf.oth.time.ytd.out 6 FREE R VAL=(@pdf.oth.time.ytd/60_":"_(@pdf.oth.time.ytd\60+10
VAL=0%0))
pdf.other.no 3 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|3
pdf.other.time 5 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|4
pdf.other.time.out 5 FREE R VAL=(@pdf.other.time/60_":"_(@pdf.other.time\60+100%0)
VAL=)
pdf.percent.used 5 DEC R VAL=(@pdf.time.used*100:2D/@pdf.time.allocated:1D)
pdf.percent.used.ytd 5 DEC R VAL=(@pdf.time.used.ytd*100:2D/@pdf.time.alloc.ytd:1D)
pdf.time.alloc.out 5 FREE R VAL=(@pdf.time.allocated/60_":"_(@pdf.time.allocated\6
VAL=0+100%0))
pdf.time.alloc.ytd 6 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|5
pdf.time.alloc.ytd.out 6 FREE R VAL=(@pdf.time.alloc.ytd/60_":"_(@pdf.time.alloc.ytd\6
VAL=0+100%0))
pdf.time.allocated 5 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|0
pdf.time.used 5 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|2
pdf.time.used.out 5 FREE R VAL=(@pdf.time.used/60_":"_(@pdf.time.used\60+100%0))
pdf.time.used.ytd 6 INT R ?WD[wdD]DG[ggh]DR[ggg]FAC[gqb]|7
pdf.time.used.ytd.out 6 FREE R VAL=(@pdf.time.used.ytd/60_":"_(@pdf.time.used.ytd\60+
VAL=100%0))
pdf.total.used 5 FREE R VAL=(@pdf.time.used+@pdf.other.time/60_":"_(@pdf.time.
VAL=used+@pdf.other.time\60+100%0))
Ì € 2
sch.stats.prof.type.grp (prof.typ.grp)
[date, ptg.group]
?WD[wdD]AG[wac]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ptg.group 10 FREE L SCH.APPT.GROUP wac
ptg.no.used 3 INT R ?WD[wdD]AG[wac]|1
ptg.no.used.out 3 INT R VAL=@ptg.no.used+0
ptg.no.used.ytd 4 INT R ?WD[wdD]AG[wac]|6
ptg.no.used.ytd.out 4 INT R VAL=@ptg.no.used.ytd+0
ptg.oth.no.ytd 4 INT R ?WD[wdD]AG[wac]|8
ptg.oth.percent.used 5 DEC R VAL=(@ptg.other.time*100:2D/@ptg.time.allocated:1D)
ptg.oth.percent.used.ytd 5 DEC R VAL=(@ptg.oth.time.ytd*100:2D/@ptg.time.alloc.ytd:1D)
ptg.oth.time.ytd 6 INT R ?WD[wdD]AG[wac]|9
ptg.oth.time.ytd.out 6 FREE R VAL=(@ptg.oth.time.ytd/60_":"_(@ptg.oth.time.ytd\60+10
VAL=0%0))
ptg.other.no 3 INT R ?WD[wdD]AG[wac]|3
ptg.other.time 5 INT R ?WD[wdD]AG[wac]|4
ptg.other.time.out 5 FREE R VAL=(@ptg.other.time/60_":"_(@ptg.other.time\60+100%0)
VAL=)
ptg.percent.used 5 DEC R VAL=(@ptg.time.used*100:2D/@ptg.time.allocated:1D)
ptg.percent.used.ytd 5 DEC R VAL=(@ptg.time.used.ytd*100:2D/@ptg.time.alloc.ytd:1D)
ptg.time.alloc.out 5 FREE R VAL=(@ptg.time.allocated/60_":"_(@ptg.time.allocated\6
VAL=0+100%0))
ptg.time.alloc.ytd 6 INT R ?WD[wdD]AG[wac]|5
ptg.time.alloc.ytd.out 6 FREE R VAL=(@ptg.time.alloc.ytd/60_":"_(@ptg.time.alloc.ytd\6
VAL=0+100%0))
ptg.time.allocated 5 INT R ?WD[wdD]AG[wac]|0
ptg.time.used 5 INT R ?WD[wdD]AG[wac]|2
ptg.time.used.out 5 FREE R VAL=(@ptg.time.used/60_":"_(@ptg.time.used\60+100%0))
ptg.time.used.ytd 6 INT R ?WD[wdD]AG[wac]|7
ptg.time.used.ytd.out 6 FREE R VAL=(@ptg.time.used.ytd/60_":"_(@ptg.time.used.ytd\60+
VAL=100%0))
ptg.total.used 5 FREE R VAL=(@ptg.time.used+@ptg.other.time/60_":"_(@ptg.time.
VAL=used+@ptg.other.time\60+100%0))
Ì € 2
sch.stats.prof.type (prof.type)
[date,ptg.group, pt.type]
?WD[wdD]AG[wac]AT[wat]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pt.type 10 FREE L SCH.APPT.TYPE wat
pt.no.used 3 INT R ?WD[wdD]AG[wac]AT[wat]|1
pt.no.used.out 3 INT R VAL=@pt.no.used+0
pt.no.used.ytd 4 INT R ?WD[wdD]AG[wac]AT[wat]|6
pt.no.used.ytd.out 4 INT R VAL=@pt.no.used.ytd+0
pt.oth.no.ytd 4 INT R ?WD[wdD]AG[wac]AT[wat]|8
pt.oth.percent.used 5 DEC R VAL=(@pt.other.time*100:2D/@pt.time.allocated:1D)
pt.oth.percent.used.ytd 5 DEC R VAL=(@pt.oth.time.ytd*100:2D/@pt.time.alloc.ytd:1D)
pt.oth.time.ytd 6 INT R ?WD[wdD]AG[wac]AT[wat]|9
pt.oth.time.ytd.out 6 FREE R VAL=(@pt.oth.time.ytd/60_":"_(@pt.oth.time.ytd\60+100%
VAL=0))
pt.other.no 3 INT R ?WD[wdD]AG[wac]AT[wat]|3
pt.other.time 5 INT R ?WD[wdD]AG[wac]AT[wat]|4
pt.other.time.out 5 FREE R VAL=(@pt.other.time/60_":"_(@pt.other.time\60+100%0))
pt.percent.used 5 DEC R VAL=(@pt.time.used*100:2D/@pt.time.allocated:1D)
pt.percent.used.ytd 5 DEC R VAL=(@pt.time.used.ytd*100:2D/@pt.time.alloc.ytd:1D)
pt.time.alloc.out 5 FREE R VAL=(@pt.time.allocated/60_":"_(@pt.time.allocated\60+
VAL=100%0))
pt.time.alloc.ytd 6 INT R ?WD[wdD]AG[wac]AT[wat]|5
pt.time.alloc.ytd.out 6 FREE R VAL=(@pt.time.alloc.ytd/60_":"_(@pt.time.alloc.ytd\60+
VAL=100%0))
pt.time.allocated 5 INT R ?WD[wdD]AG[wac]AT[wat]|0
pt.time.used 5 INT R ?WD[wdD]AG[wac]AT[wat]|2
pt.time.used.out 5 FREE R VAL=(@pt.time.used/60_":"_(@pt.time.used\60+100%0))
pt.time.used.ytd 6 INT R ?WD[wdD]AG[wac]AT[wat]|7
pt.time.used.ytd.out 6 FREE R VAL=(@pt.time.used.ytd/60_":"_(@pt.time.used.ytd\60+10
VAL=0%0))
pt.total.used 5 FREE R VAL=(@pt.time.used+@pt.other.time/60_":"_(@pt.time.use
VAL=d+@pt.other.time\60+100%0))
Ì € 2
sch.stats.rsrc (resource)
[date, res]
?WD[wdD]R[wre]
Field Name Len Dat Typ J DPM Offset/Local/VAL
res 15 FREE L SCH.RESOURCE wre
res.book.mins 5 PINT R ?WD[wdD]R[wre]|1
res.cap.mins 5 PINT R ?WD[wdD]R[wre]|0
res.util 5 PDEC R VAL=((@res.book.mins:4D/@res.cap.mins):2D)
Ì € 2
sch.stats.res.appt.type (res.appt.type)
[date,res, rat.appt.type]
?WD[wdD]R[wre]AT[wat]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rat.appt.type 10 FREE L SCH.APPT.TYPE wat
rat.ack 3 PINT R ?WD[wdD]R[wre]AT[wat]|2
rat.appts 3 PINT R ?WD[wdD]R[wre]AT[wat]|0
rat.book.mins 5 PINT R ?WD[wdD]R[wre]AT[wat]|6
rat.cancel 3 PINT R ?WD[wdD]R[wre]AT[wat]|3
rat.no.show 3 PINT R ?WD[wdD]R[wre]AT[wat]|1
rat.util 5 PDEC R VAL=((res.cap.mins:4D/res.book.mins):2D)
rat.walk.in 3 PINT R ?WD[wdD]R[wre]AT[wat]|5
Ì € 2
sch.stats.resrouce.group (resource.group)
[date, rsrc.grp]
?WD[wdD]RG[wrg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rsrc.grp 10 FREE L SCH.RSRC.GRP wrg
rsrc.grp.ack 3 PINT R ?WD[wdD]RG[wrg]|2
rsrc.grp.appts 3 PINT R ?WD[wdD]RG[wrg]|0
rsrc.grp.cancel 3 PINT R ?WD[wdD]RG[wrg]|3
rsrc.grp.cap.mins 5 PINT R ?WD[wdD]RG[wrg]|6
rsrc.grp.no.show 3 PINT R ?WD[wdD]RG[wrg]|1
rsrc.grp.util 5 PDEC R
rsrc.grp.walk.in 3 PINT R ?WD[wdD]RG[wrg]|5
Ì € 2
sch.stats.rg.appt.type (rg.appt.type)
[date,rsrc.grp, rgat.appt.type]
?WD[wdD]RG[wrg]AT[wat]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rgat.appt.type 10 FREE L SCH.APPT.TYPE wat
Ì € 2
sch.stats.rgat.resource (rgat.resource)
[date,rsrc.grp,rgat.appt.type, rgatr.resource]
?WD[wdD]RG[wrg]AT[wat]R[wre]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rgatr.resource 15 FREE L SCH.RESOURCE wre
rgatr.ack 3 PINT R ?WD[wdD]RG[wrg]AT[wat]R[wre]|2
rgatr.appts 3 PINT R ?WD[wdD]RG[wrg]AT[wat]R[wre]|0
rgatr.cancel 3 PINT R ?WD[wdD]RG[wrg]AT[wat]R[wre]|3
rgatr.no.show 3 PINT R ?WD[wdD]RG[wrg]AT[wat]R[wre]|1
rgatr.walk.in 3 PINT R ?WD[wdD]RG[wrg]AT[wat]R[wre]|5
Ì € 2
sch.stats.rg.resource (rg.resource)
[date,rsrc.grp, rgr.resource]
?WD[wdD]RG[wrg]R[wre]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rgr.resource 15 FREE L SCH.RESOURCE wre
Ì € 2
sch.stats.rgr.appt.type (rgr.appt.type)
[date,rsrc.grp,rgr.resource, rgrat.appt.type]
?WD[wdD]RG[wrg]R[wre]AT[wat]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rgrat.appt.type 10 FREE L SCH.APPT.TYPE wat
rgrat.ack 3 PINT R ?WD[wdD]RG[wrg]R[wre]AT[wat]|2
rgrat.appts 3 PINT R ?WD[wdD]RG[wrg]R[wre]AT[wat]|0
rgrat.cancel 3 PINT R ?WD[wdD]RG[wrg]R[wre]AT[wat]|3
rgrat.no.show 3 PINT R ?WD[wdD]RG[wrg]R[wre]AT[wat]|1
rgrat.resched 3 PINT R ?WD[wdD]RG[wrg]R[wre]AT[wat]|4
rgrat.walk.in 3 PINT R ?WD[wdD]RG[wrg]R[wre]AT[wat]|5
|
|
| | | | | | | | | | | |