Ì i 2
lab.c.staffing.dictionary (main)
[user]
&SCN[gu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
user 10 FREE L MIS.USER gu
active 1 YN L &SCN[gu]|0
any.data.for.subsec.date 1 YN L VAL=%LAB.C.STAFF.any.data(user,subsection,date)
any.data.to.chart 1 YN L VAL=%LAB.C.STAFF.chart.by.date("CK",subsection,date)
any.subsecs.in.range 1 YN L VAL=%LAB.C.STAFF.subsecs.in.range(user)
by.user.or.subsec 10 CHOICE L
lab.user 10 FREE L MIS.USER
last.update 50 FREE L &SCN[gu]UPD
most.recent.only 1 YN L
name 20 FREE L VAL=@MIS.USER.name
Ì € i 2
lab.c.staff.effective.dates (effective.dates)
[user, eff.date]
&SCN[gu]E[scnF]
Field Name Len Dat Typ J DPM Offset/Local/VAL
eff.date 8 DATE L scnF
eff.active 1 YN L &SCN[gu]E[scnF]|0
Ì € i 2
lab.c.staffing.subsections (subsections)
[user,eff.date, subsection]
&SCN[gu]E[scnF]S[scy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
subsection 10 FREE L LAB.C.WL.SUBSECscy
Ì € i 2
lab.c.staffing.days (days)
[user,eff.date,subsection, day]
&SCN[gu]E[scnF]S[scy]D[scnD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
day 3 CHOICE L scnD
day.shift.1.minutes 4 PINT R &SCN[gu]E[scnF]S[scy]D[scnD]|0
day.shift.2.minutes 4 PINT R &SCN[gu]E[scnF]S[scy]D[scnD]|1
day.shift.3.minutes 4 PINT R &SCN[gu]E[scnF]S[scy]D[scnD]|2
day.shift.x.minutes 4 PINT R &SCN[gu]E[scnF]S[scy]D[scnD]|3
Ì € i 2
lab.c.staffing.days.and.times (days.times)
[user,eff.date,subsection,day, from.time]
&SCN[gu]E[scnF]S[scy]D[scnD,scnT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
from.time 4 HHMM L scnT
thru.time 4 HHMM L &SCN[gu]E[scnF]S[scy]D[scnD,scnT]|0
Ì i 2
lab.c.staff.overrides (overrides)
[override.user]
:SCND[gu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
override.user 10 FREE L LAB.C.STAFF gu
override.last.update 9 PINT R :SCND[gu]UPD
Ì € i 2
lab.c.staff.override.dates (dates)
[override.user, date]
:SCND[gu]D[scnC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 8 DATE L scnC
Ì € i 2
lab.c.staff.override.subsects (override.subsections)
[override.user,date, override.subsection]
:SCND[gu]D[scnC]S[scy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
override.subsection 10 FREE L LAB.C.WL.SUBSECscy
date.out 1 YN L :SCND[gu]D[scnC]S[scy]|4
date.shift.1.minutes 4 INT R :SCND[gu]D[scnC]S[scy]|0
date.shift.2.minutes 4 INT R :SCND[gu]D[scnC]S[scy]|1
date.shift.3.minutes 4 INT R :SCND[gu]D[scnC]S[scy]|2
date.shift.x.minutes 4 INT R :SCND[gu]D[scnC]S[scy]|3
Ì € i 2
lab.c.staffing.dates.and.times (dates.times)
[override.user,date,override.subsection, date.from.time]
:SCND[gu]D[scnC]S[scy]T[scnE]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date.from.time 4 HHMM L scnE
date.thru.time 4 FREE L :SCND[gu]D[scnC]S[scy]T[scnE]|0
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
lab.c.staff.subsection.index [subsection,user] = active
subsection.x &SCNI[scy,gu]
|
|
| | | | | | | |