Ì i 2
main
[employee]
*(HLQ)HLTYL[hly]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L HR.EMP hly
Ì € i 2
payroll.databases
[employee, pp.db]
*(HLQ)HLTYL[hly]DB[pp.db]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pp.db 12 FREE L MIS.APPL.DB pp.db
Ì € i 2
payrolls
[employee,pp.db, payroll]
*(HLQ)HLTYL[hly]DB[pp.db]P[jdp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
payroll 8 FREE L PP.PAYROLL jdp
eligible 1 YN L *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]|0
override 1 YN L *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]|2
sort.week 2 PINT R VAL=@start.week
start.week 2 PINT R *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]|3
template 12 FREE L HR.ATT.TEMPLATE*(HLQ)HLTYL[hly]DB[pp.db]P[jdp]|1
Ì € i 2
empl.att.weeks
[employee,pp.db,payroll, ea.week]
*(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ea.week 2 PINT R hltxW
Ì € i 2
empl.att.days
[employee,pp.db,payroll,ea.week, ea.day]
*(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ea.day 1 DAY L hltxD
Ì € i 2
empl.att.earnings
[employee,pp.db,payroll,ea.week,ea.day, ea.counter]
*(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ea.counter 2 INT R hltxC
ea.dept 15 FREE L MIS.GL.DEPT *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|
ea.earning 8 PDEC L PP.EARN *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|
ea.hours 6 DEC3 R *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|1
ea.job 10 FREE L PP.JOB *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|
ea.shift 1 PINT R *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|2
Ì € i 2
input.withholdings
[employee,pp.db,payroll, in.whold]
*(HLQ)HLTYL[hly]DB[pp.db]P[jdp]WH[jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
in.whold 8 PDEC L PP.WHOLD jdw
sys.compute 1 YN L *(HLQ)HLTYL[hly]DB[pp.db]P[jdp]WH[jdw]|0
Index Files Subscripts/Physical Base
override.x [payroll,pp.db,template,start.week,employee]
?(HLQ)HLTYOL[jdp,pp.db,hltx,hltxW,hly]
template.x [template,pp.db,payroll,start.week,employee]
?(HLQ)HLTYTL[hltx,pp.db,jdp,hltxW,hly]
|
|
| | | | | |