Ì € i 2
main
[user]
&(S)SCN[gu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
user 10 FREE L MIS.USER gu
active 1 YN L &(S)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 &(S)SCN[gu]UPD
most.recent.only 1 YN L
name 34 FREE L VAL=@MIS.USER.name
Ì € i 2
effective.dates
[user, eff.date]
&(S)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 &(S)SCN[gu]E[scnF]|0
Ì € i 2
subsections
[user,eff.date, subsection]
&(S)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
days
[user,eff.date,subsection, day]
&(S)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 &(S)SCN[gu]E[scnF]S[scy]D[scnD]|0
day.shift.2.minutes 4 PINT R &(S)SCN[gu]E[scnF]S[scy]D[scnD]|1
day.shift.3.minutes 4 PINT R &(S)SCN[gu]E[scnF]S[scy]D[scnD]|2
day.shift.x.minutes 4 PINT R &(S)SCN[gu]E[scnF]S[scy]D[scnD]|3
Ì € i 2
days.times
[user,eff.date,subsection,day, from.time]
&(S)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 &(S)SCN[gu]E[scnF]S[scy]D[scnD,scnT]|0
Ì i 2
overrides
[override.user]
*(S)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 *(S)SCND[gu]UPD
Ì € i 2
dates
[override.user, date]
*(S)SCND[gu]D[scnC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 8 DATE L scnC
Ì € i 2
override.subsections
[override.user,date, override.subsection]
*(S)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 *(S)SCND[gu]D[scnC]S[scy]|4
date.shift.1.minutes 4 INT R *(S)SCND[gu]D[scnC]S[scy]|0
date.shift.2.minutes 4 INT R *(S)SCND[gu]D[scnC]S[scy]|1
date.shift.3.minutes 4 INT R *(S)SCND[gu]D[scnC]S[scy]|2
date.shift.x.minutes 4 INT R *(S)SCND[gu]D[scnC]S[scy]|3
Ì € i 2
dates.times
[override.user,date,override.subsection, date.from.time]
*(S)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 *(S)SCND[gu]D[scnC]S[scy]T[scnE]|0
Index Files Subscripts/Physical Base
subsection.x [subsection,user] = active
&(S)SCNI[scy,gu]
|
|
| | | | | | | |