Ì € i 2
pp.att.workdates (att.workdates)
[employee, at.workdate]
:JTZ[jy]T[jtxT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
at.workdate 8 DATE L jtxT
at.current.dept 15 FREE L MIS.GL.DEPT :JTZ[jy]T[jtxT]|3
at.current.job 10 FREE L PP.JOB :JTZ[jy]T[jtxT]|2
at.current.payroll 8 FREE L PP.PAYROLL :JTZ[jy]T[jtxT]|0
at.current.shift 1 PINT R :JTZ[jy]T[jtxT]|1
at.workday 3 DAY L VAL=%Z.day.from.date(at.workdate)
total.workdate.hours 8 SDEC3 R VAL=%PP.ATT.DATA.total.workdate.hours(employee,at.work
VAL=date)
Ì € i 2
pp.att.earnings (att.earnings)
[employee,at.workdate, at.counter]
:JTZ[jy]T[jtxT]E[jtxC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
at.counter 2 INT R jtxC
at.dept 15 FREE L MIS.GL.DEPT :JTZ[jy]T[jtxT]E[jtxC]|4
at.earning 8 PDEC L PP.EARN :JTZ[jy]T[jtxT]E[jtxC]|0
at.hours 6 SDEC3 R :JTZ[jy]T[jtxT]E[jtxC]|1
at.job 10 FREE L PP.JOB :JTZ[jy]T[jtxT]E[jtxC]|3
at.nur.database 12 FREE L MIS.APPL :JTZ[jy]T[jtxT]E[jtxC]|8
at.nur.initials 10 FREE L MIS.USER :JTZ[jy]T[jtxT]E[jtxC]|9
at.pay.date 8 DATE L VAL=@PP.PAY.SCH.check.date
at.shift 1 PINT R :JTZ[jy]T[jtxT]E[jtxC]|2
at.tc.date 8 DATE L :JTZ[jy]T[jtxT]E[jtxC]|5
at.tc.line 2 INT R :JTZ[jy]T[jtxT]E[jtxC]|7
at.tc.line.prorated 1 YN L :JTZ[jy]T[jtxT]E[jtxC]|10
at.tc.pointer 8 URN L PP.PAY :JTZ[jy]T[jtxT]E[jtxC]|6
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
pp.att.counter.index [employee,at.tc.date,at.workdate,at.counter]
att.counter.x ?JTZA[jy,jzD,jtxT,jtxC]
pp.att.tc.counter.x [at.tc.pointer,at.tc.line,at.workdate,at.counter]
tc.counter.x ?JTZT[jz,jzT,jtxT,jtxC]
|
|
|