Ì i 2
nur.nurse (main)
[initials]
&NN[gu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
initials 10 FREE L MIS.USER gu
access 10 FREE L NUR.ACCESS &NN[gu]|4
access.mar 10 FREE L NUR.MAR.ACCESS &NN[gu]|28
access.rai 10 FREE L NUR.RAI.ACCESS &NN[gu]|21
active 1 YN L &NN[gu]|0
agency 10 FREE L NUR.AGENCY.DICT&NN[gu]|17
close.sched 1 YN L &NN[gu]|26
cp.sprd.sht.fmt 6 CHOICE L &NN[gu]|20
dft.flowsheet.fmt 10 FREE L NUR.FD &NN[gu]|27
disp.name 15 FREE L &NN[gu]|15
document.for.other.users 1 YN L &NN[gu]|25
edit.all.dirs 1 YN L &NN[gu]|19
edit.orders.on.path 1 YN L &NN[gu]|24
edit.sched 1 YN L &NN[gu]|11
employee 41 URN L &NN[gu]|13
float 1 YN L &NN[gu]|10
hh.format 10 FREE L NUR.HH.FMT &NN[gu]|5
last.update 8 FREE L &NN[gu]UPD
monogram 3 FREE L VAL=@MIS.USER.monogram
name 20 FREE L VAL=@MIS.USER.name
note.category 10 FREE L NUR.NOTE.CAT &NN[gu]|3
number 14 FREE L &NN[gu]|14
nurse.type 5 FREE L NUR.NURSE.TYPE &NN[gu]|1
old.pha.ack 1 CHOICE L &NN[gu]PHA|11
old.pha.by.acct.or.mri 1 CHOICE L &NN[gu]PHA|5
old.pha.from.dc.date 8 DATE L &NN[gu]PHA|7
old.pha.from.dc.time 4 PINT R &NN[gu]PHA|8
old.pha.generic.or.trade 1 CHOICE L &NN[gu]PHA|6
old.pha.incl.canceled 1 YN L &NN[gu]PHA|9
old.pha.incl.dc 1 CHOICE L &NN[gu]PHA|3
old.pha.incl.deactivated 1 YN L &NN[gu]PHA|10
old.pha.incl.tech 1 YN L &NN[gu]PHA|4
old.pha.sort1 10 CHOICE L &NN[gu]PHA|0
old.pha.sort2 10 CHOICE L &NN[gu]PHA|1
old.pha.sort3 10 CHOICE L &NN[gu]PHA|2
payroll 8 FREE L PP.PAYROLL &NN[gu]|7
payroll.db 12 FREE L MIS.APPL &NN[gu]|6
per.diem 1 YN L &NN[gu]|18
post.sched 1 YN L &NN[gu]|12
prime.loc 10 FREE L MIS.LOCN.DICT &NN[gu]|2
rai.provider.id 12 FREE L &NN[gu]|23
rai.provider.type 5 ZINT L &NN[gu]|22
security 4 CHOICE L &NN[gu]|9
seniority.date 8 DATE L &NN[gu]|30
si.number 12 FREE L &NN[gu]|8
sort 3 CHOICE L &NN[gu]|16
spec.req.dist.grp 15 FREE L MIS.DIST.GROUP &NN[gu]A|0
spec.req.notify.sup 1 YN L &NN[gu]A|1
ss.number 12 FREE L &NN[gu]|8
suppress.time.cards 1 YN L &NN[gu]|29
team 10 FREE L NUR.TEAM &NN[gu]|31
zcus.age 7 AGE L &NN[gu]ZCUS.PI|8
zcus.annual.leave 6 PDEC2 R &NN[gu]ZCUSEI|4
zcus.annual.leave.option 9 CHOICE L &NN[gu]ZCUSEI|3
zcus.appraisal.date 8 DATE L &NN[gu]ZCUSEI|1
zcus.avail.comment 40 FREE L &NN[gu]ZCUSBI|15
zcus.avail.days 7 FREE L &NN[gu]ZCUSBI|14
zcus.avail.friday 1 YN L &NN[gu]ZCUSBI|8
zcus.avail.friday.time 9 FREE L &NN[gu]ZCUSBI|9
zcus.avail.monday 1 YN L &NN[gu]ZCUSBI|0
zcus.avail.monday.time 9 FREE L &NN[gu]ZCUSBI|1
zcus.avail.saturday 1 YN L &NN[gu]ZCUSBI|10
zcus.avail.saturday.time 9 FREE L &NN[gu]ZCUSBI|11
zcus.avail.sunday 1 YN L &NN[gu]ZCUSBI|12
zcus.avail.sunday.time 9 FREE L &NN[gu]ZCUSBI|13
zcus.avail.thursday 1 YN L &NN[gu]ZCUSBI|6
zcus.avail.thursday.time 9 FREE L &NN[gu]ZCUSBI|7
zcus.avail.tuesday 1 YN L &NN[gu]ZCUSBI|2
zcus.avail.tuesday.time 9 FREE L &NN[gu]ZCUSBI|3
zcus.avail.wednesday 1 YN L &NN[gu]ZCUSBI|4
zcus.avail.wednesday.time 9 FREE L &NN[gu]ZCUSBI|5
zcus.bank 1 YN L &NN[gu]ZCUSEI|9
zcus.birthdate 8 DATE L &NN[gu]ZCUS.PI|7
zcus.computed.birthdate 8 DATE L &NN[gu]ZCUS.PI|11
zcus.contract.daily 5 PDEC2 R &NN[gu]ZCUSCT|3
zcus.contract.date 8 DATE L &NN[gu]ZCUSCT|0
zcus.contract.hours 5 PDEC2 R &NN[gu]ZCUSCT|2
zcus.contract.type 10 FREE L NUR.UK.CONT.TYP&NN[gu]ZCUSCT|1
zcus.contract.wte 5 PDEC2 R &NN[gu]ZCUSCT|4
zcus.county 30 FREE L &NN[gu]ZCUS.PI|3
zcus.current.age 7 AGE R VAL=%Z.age(IF{@NUR.NURSE.zcus.computed.birthdate;@NUR.
VAL=NURSE.zcus.birthdate})
zcus.doc.med.co.sig.rqrd 1 YN L &NN[gu]ZCUSPP|6
zcus.edit.short.dict 4 CHOICE L &NN[gu]ZCUSPP|4
zcus.emergency.phone 18 FREE L &NN[gu]ZCUS.PI|10
zcus.employment.date 8 DATE L &NN[gu]ZCUSEI|0
zcus.grade 1 FREE L &NN[gu]ZCUSPP|0
zcus.home.phone 18 FREE L &NN[gu]ZCUS.PI|6
zcus.locality 30 FREE L &NN[gu]ZCUS.PI|1
zcus.marital.status 10 FREE L MIS.MAR.STATUS &NN[gu]ZCUS.PI|5
zcus.maternity.leave 2 PINT R &NN[gu]ZCUSEI|6
zcus.maternity.start 8 DATE L &NN[gu]ZCUSEI|5
zcus.maternity.week 2 FREE L VAL=(IF{@zcus.maternity.start %Z.date.sub(@.today,@zcu
VAL=s.maternity.start)/7+1})
zcus.mentor 1 YN L &NN[gu]ZCUSEI|18
zcus.nat.ins.num 10 FREE L &NN[gu]ZCUSEI|15
zcus.nok1.county 30 FREE L &NN[gu]ZCUSPNK|4
zcus.nok1.home.phone 18 FREE L &NN[gu]ZCUSPNK|7
zcus.nok1.locality 30 FREE L &NN[gu]ZCUSPNK|2
zcus.nok1.name 30 FREE L &NN[gu]ZCUSPNK|0
zcus.nok1.postal.code 10 ZIP.POST L MIS.ZIP &NN[gu]ZCUSPNK|5
zcus.nok1.relationship 10 FREE L MIS.RELAT.DICT &NN[gu]ZCUSPNK|6
zcus.nok1.street 30 FREE L &NN[gu]ZCUSPNK|1
zcus.nok1.town 30 FREE L &NN[gu]ZCUSPNK|3
zcus.nok1.work.phone 18 FREE L &NN[gu]ZCUSPNK|8
zcus.nok2.county 30 FREE L &NN[gu]ZCUSPN1|4
zcus.nok2.home.phone 18 FREE L &NN[gu]ZCUSPN1|7
zcus.nok2.locality 30 FREE L &NN[gu]ZCUSPN1|2
zcus.nok2.name 30 FREE L &NN[gu]ZCUSPN1|0
zcus.nok2.postal.code 10 ZIP.POST L MIS.ZIP &NN[gu]ZCUSPN1|5
zcus.nok2.relationship 10 FREE L MIS.RELAT.DICT &NN[gu]ZCUSPN1|6
zcus.nok2.street 30 FREE L &NN[gu]ZCUSPN1|1
zcus.nok2.town 30 FREE L &NN[gu]ZCUSPN1|3
zcus.nok2.work.phone 18 FREE L &NN[gu]ZCUSPN1|8
zcus.occ.code 5 FREE L &NN[gu]ZCUSEI|17
zcus.pay.scale 4 FREE L &NN[gu]ZCUSEI|16
zcus.personal.num 10 FREE L &NN[gu]ZCUSEI|14
zcus.pin.num 8 FREE L &NN[gu]ZCUSEI|11
zcus.pin.num.dt.obtained 8 DATE L &NN[gu]ZCUSEI|12
zcus.pin.num.renewal.date 8 DATE L &NN[gu]ZCUSEI|13
zcus.postal.code 10 ZIP.POST L MIS.ZIP &NN[gu]ZCUS.PI|4
zcus.primary.ward 10 FREE L MIS.LOCN.DICT VAL=IF{@MIS.LOCN.DICT.main[@prime.loc] @prime.loc}
zcus.restrict.edit.meds 1 YN L &NN[gu]ZCUSPP|5
zcus.sex 1 CHOICE L &NN[gu]ZCUS.PI|9
zcus.sick.leave 2 PINT R &NN[gu]ZCUSEI|8
zcus.sick.start 8 DATE L &NN[gu]ZCUSEI|7
zcus.sick.week 2 FREE L VAL=(IF{@zcus.sick.start %Z.date.sub(@.today,@zcus.sic
VAL=k.start)/7+1})
zcus.street 30 FREE L &NN[gu]ZCUS.PI|0
zcus.student 1 YN L &NN[gu]ZCUSEI|10
zcus.team 10 FREE L NUR.UK.TEAM &NN[gu]ZCUSPP|2
zcus.termination.date 8 DATE L &NN[gu]ZCUSEI|2
zcus.title 10 FREE L &NN[gu]ZCUSPP|1
zcus.tm.in.lu 6 SDEC2 R &NN[gu]ZCUSPP|3
zcus.town 30 FREE L &NN[gu]ZCUS.PI|2
zcus.verified 1 YN L &NN[gu]ZCUSP|0
zcus.verified.notes 1 YN L &NN[gu]ZCUSP|1
Ì € i 2
nur.display.shifts (display.shifts)
[initials, disp.shift]
&NN[gu]DS[nnDS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
disp.shift 1 CHOICE L nnDS
Ì € i 2
nur.nurse.note.categories (note.categories)
[initials, note.cat]
&NN[gu]N[nnc]
Field Name Len Dat Typ J DPM Offset/Local/VAL
note.cat 10 FREE L NUR.NOTE.CAT nnc
note.cat.edit 1 YN L &NN[gu]N[nnc]|1
note.cat.enter 1 YN L &NN[gu]N[nnc]|0
note.cat.view 1 YN L &NN[gu]N[nnc]|2
Ì € i 2
nur.nurse.secondary.locations (secondary.locs)
[initials, sec.loc]
&NN[gu]L[ggn]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.loc 10 FREE L MIS.LOCN.DICT ggn
sec.close.sched 1 YN L &NN[gu]L[ggn]|3
sec.edit.sched 1 YN L &NN[gu]L[ggn]|1
sec.post.sched 1 YN L &NN[gu]L[ggn]|2
sec.security 4 CHOICE L &NN[gu]L[ggn]|0
Ì € i 2
nur.sec.nurse.types (secondary.nurse.types)
[initials, sec.nurse.type]
&NN[gu]NT[nt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.nurse.type 5 FREE L NUR.NURSE.TYPE nt
Ì € i 2
nur.skills (skills)
[initials, skill]
&NN[gu]SK[nsk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
skill 10 FREE L NUR.SKILL.DICT nsk
ceu 5 DEC2 R &NN[gu]SK[nsk]|3
comment 54 FREE L &NN[gu]SK[nsk]|1
date 8 DATE L &NN[gu]SK[nsk]|2
use 8 FREE L &NN[gu]SK[nsk]|0
Ì € i 2
nur.nurse.sched.weeks (weeks)
[initials, week]
&NN[gu]LOC[ggn]W[nnW]
Field Name Len Dat Typ J DPM Offset/Local/VAL
week 2 PINT R nnW
Ì € i 2
nur.nurse.schedules (schedules)
[initials,week, sch.counter]
&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sch.counter 2 INT R nnSC
day1 3 FREE L NUR.SCHED.CODES&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|2
day2 3 FREE L NUR.SCHED.CODES&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|3
day3 3 FREE L NUR.SCHED.CODES&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|4
day4 3 FREE L NUR.SCHED.CODES&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|5
day5 3 FREE L NUR.SCHED.CODES&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|6
day6 3 FREE L NUR.SCHED.CODES&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|7
day7 3 FREE L NUR.SCHED.CODES&NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|8
job.code 10 FREE L PP.JOB &NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|1
nur.type 5 FREE L NUR.NURSE.TYPE &NN[gu]LOC[ggn]W[nnW]SCH[nnSC]|9
Ì € i 2
nur.annual.info (zcus.uk.annual.info)
[initials, zcus.fiscal.year]
&NN[gu]ZCUSFY[fy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
zcus.fiscal.year 4 FREE L fy
zcus.annual.leave.sched 6 FREE L &NN[gu]ZCUSFY[fy]|2
zcus.annual.leave.used 6 FREE L &NN[gu]ZCUSFY[fy]|1
zcus.annual.leave.year 6 FREE L &NN[gu]ZCUSFY[fy]|0
zcus.time.in.lieu 6 FREE L &NN[gu]ZCUSFY[fy]|3
Ì € i 2
nur.staff.bank.groups (zcus.uk.bank.groups)
[initials, zcus.bank.group]
&NN[gu]ZCUSBG[nukb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
zcus.bank.group 10 FREE L NUR.UK.BANK nukb
Ì € i 2
zcus.uk.courses (zcus.uk.courses)
[initials, zcus.crs.urn]
&NN[gu]ZCUSC[zcurn]
Field Name Len Dat Typ J DPM Offset/Local/VAL
zcus.crs.urn 4 FREE L zcurn
zcus.crs.ceu 6 DEC2 R &NN[gu]ZCUSC[zcurn]|2
zcus.crs.comment 35 FREE L &NN[gu]ZCUSC[zcurn]|3
zcus.crs.course 10 FREE L NUR.UK.COURSE &NN[gu]ZCUSC[zcurn]|1
zcus.crs.date 8 DATE L &NN[gu]ZCUSC[zcurn]|0
Ì € i 2
nur.nurse.uk.effective.info (zcus.uk.effective.info)
[initials, zcus.eff.date]
&NN[gu]ZCUSEFF[eff]
Field Name Len Dat Typ J DPM Offset/Local/VAL
zcus.eff.date 8 DATE L eff
zcus.eff.contract.daily 5 PDEC3 R &NN[gu]ZCUSEFF[eff]|6
zcus.eff.contract.hours 5 PDEC2 R &NN[gu]ZCUSEFF[eff]|5
zcus.eff.contract.type 10 FREE L NUR.UK.CONT.TYP&NN[gu]ZCUSEFF[eff]|4
zcus.eff.contract.wte 5 PDEC2 R &NN[gu]ZCUSEFF[eff]|7
zcus.eff.directorate 10 FREE L VAL=%NUR.NURSE.zcus.uk.get.effective("LOC",initials,ef
VAL=fective.date)
zcus.eff.grade 1 FREE L &NN[gu]ZCUSEFF[eff]|1
zcus.eff.location 10 FREE L MIS.LOCN.DICT &NN[gu]ZCUSEFF[eff]|2
zcus.eff.primary.ward 10 FREE L MIS.LOCN.DICT VAL=%NUR.NURSE.zcus.uk.get.effective("LOC",initials,ef
VAL=fective.date)
zcus.eff.team 10 FREE L NUR.TEAM &NN[gu]ZCUSEFF[eff]|3
zcus.eff.type 5 FREE L NUR.NURSE.TYPE &NN[gu]ZCUSEFF[eff]|0
Ì € i 2
nur.pp.student.info (zcus.uk.student.weeks)
[initials, zcus.student.week]
&NN[gu]ZCUSSW[swDT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
zcus.student.week 8 DATE L swDT
zcus.student.days 1 PINT R &NN[gu]ZCUSSW[swDT]|3
zcus.student.mentor 10 FREE L NUR.NURSE &NN[gu]ZCUSSW[swDT]|1
zcus.student.mentor.alt 10 FREE L NUR.NURSE &NN[gu]ZCUSSW[swDT]|2
zcus.student.ward 10 FREE L MIS.LOCN.DICT &NN[gu]ZCUSSW[swDT]|0
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
nur.skills.date.index [date,skill,initials]
date.x &NNSD[nnsD,nsk,gu]
nur.nurse.location.index [prime.loc,initials] = active
loc.x &NNL[ggn,gu]
nur.nurse.soc.number.index [ss.number,initials]
number.x &NNSN[jySS,gu]
nur.nurse.per.diem.index [initials]
per.diem.x &NNPI[gu]
nur.skill.code.index [skill,initials]
skill.x &NNSI[nsk,gu]
nur.bank.group.index [zcus.bank.group,initials] = active
zcus.uk.bank.group.x &NNZCUSBG[nukb,gu]
nur.bank.ward.index [zcus.primary.ward,initials] = active
zcus.uk.bank.ward.x &NNZCUSBWI[ggn,gu]
nur.last.employment.date.index [initials] = zcus.employment.date
zcus.uk.last.date.x &NNZCUSLD[gu]
|
|
| | | | | | | | | | | |