Ì 2
sch.stats.main (main)
[date]
?WD[wdD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 8 DATE L wdD
Ì € 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.resched 5 PINT R ?WD[wdD]AT[wat]|12
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.resched 3 PINT R ?WD[wdD]AT[wat]R[wre]|4
atr.walk.in 3 PINT R ?WD[wdD]AT[wat]R[wre]|5
Ì € 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.resched 3 PINT R ?WD[wdD]R[wre]AT[wat]|4
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.resched 3 PINT R ?WD[wdD]RG[wrg]|4
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.resched 3 PINT R ?WD[wdD]RG[wrg]AT[wat]R[wre]|4
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
|
|
| | | | | | | |