Ì i 2
main
[employee]
*(HLQ)HLTY[hly]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L HR.EMP hly
Ì € i 2
payrolls
[employee,pp.db, payroll]
*(HLQ)HLTY[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)HLTY[hly]DB[pp.db]P[jdp]|0
override 1 YN L *(HLQ)HLTY[hly]DB[pp.db]P[jdp]|2
sort.week 2 PINT R VAL=@start.week
start.week 2 PINT R *(HLQ)HLTY[hly]DB[pp.db]P[jdp]|3
template 12 FREE L HR.ATT.TEMPLATE*(HLQ)HLTY[hly]DB[pp.db]P[jdp]|1
Ì € i 2
empl.att.weeks
[employee,pp.db,payroll, ea.week]
*(HLQ)HLTY[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)HLTY[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)HLTY[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)HLTY[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|4
ea.earning 8 PDEC L PP.EARN *(HLQ)HLTY[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|0
ea.hours 6 DEC3 R *(HLQ)HLTY[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|1
ea.job 10 FREE L PP.JOB *(HLQ)HLTY[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|3
ea.shift 1 PINT R *(HLQ)HLTY[hly]DB[pp.db]P[jdp]W[hltxW]D[hltxD]E[hltxC]|2
Index Files Subscripts/Physical Base
override.x [payroll,pp.db,template,start.week,employee]
?(HLQ)HLTYO[jdp,pp.db,hltx,hltxW,hly]
template.x [template,pp.db,payroll,start.week,employee]
?(HLQ)HLTYT[hltx,pp.db,jdp,hltxW,hly]
|
|
| | | |