Ì € i 2
main
[employee]
*(JQ)JTZ[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L PP.PER jy
Ì € i 2
att.workdates
[employee, at.workdate]
*(JQ)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 *(JQ)JTZ[jy]T[jtxT]|3
at.current.job 10 FREE L PP.JOB *(JQ)JTZ[jy]T[jtxT]|2
at.current.payroll 8 FREE L PP.PAYROLL *(JQ)JTZ[jy]T[jtxT]|0
at.current.shift 1 PINT R *(JQ)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
att.earnings
[employee,at.workdate, at.counter]
*(JQ)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 *(JQ)JTZ[jy]T[jtxT]E[jtxC]|4
at.earning 8 PDEC L PP.EARN *(JQ)JTZ[jy]T[jtxT]E[jtxC]|0
at.hours 6 SDEC3 R *(JQ)JTZ[jy]T[jtxT]E[jtxC]|1
at.job 10 FREE L PP.JOB *(JQ)JTZ[jy]T[jtxT]E[jtxC]|3
at.pay.date 8 DATE L VAL=@PP.PAY.SCH.check.date
at.shift 1 PINT R *(JQ)JTZ[jy]T[jtxT]E[jtxC]|2
at.ss.database 12 FREE L MIS.APPL.DB *(JQ)JTZ[jy]T[jtxT]E[jtxC]|8
at.ss.user 10 FREE L MIS.USER *(JQ)JTZ[jy]T[jtxT]E[jtxC]|9
at.tc.date 8 DATE L *(JQ)JTZ[jy]T[jtxT]E[jtxC]|5
at.tc.line 2 INT R *(JQ)JTZ[jy]T[jtxT]E[jtxC]|7
at.tc.line.prorated 1 YN L *(JQ)JTZ[jy]T[jtxT]E[jtxC]|10
at.tc.pointer 8 URN L PP.PAY *(JQ)JTZ[jy]T[jtxT]E[jtxC]|6
Index Files Subscripts/Physical Base
att.counter.x [employee,at.tc.date,at.workdate,at.counter]
?(JQ)JTZA[jy,jzD,jtxT,jtxC]
tc.counter.x [at.tc.pointer,at.tc.line,at.workdate,at.counter]
?(JQ)JTZT[jz,jzT,jtxT,jtxC]
|
|
| |