Ì i 2
add.earn.ont.vac.temp
[add.earn.ont.payroll]
*(JE)JYZZO[jdp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.earn.ont.payroll 8 FREE L PP.PAYROLL jdp
add.earn.ont.from 8 DATE L *(JE)JYZZO[jdp]|0
add.earn.ont.stars 1 FREE L *(JE)JYZZO[jdp]|3
add.earn.ont.thru 8 DATE L *(JE)JYZZO[jdp]|1
Ì € i 2
add.earn.ont.amounts
[add.earn.ont.payroll, add.earn.ont.employee]
*(JE)JYZZO[jdp]A[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.earn.ont.employee 42 URN L PP.PER jy
add.earn.ont.acc 8 SMONEY R *(JE)JYZZO[jdp]A[jy]|2
add.earn.ont.due 8 SMONEY R *(JE)JYZZO[jdp]A[jy]|3
add.earn.ont.min 8 SMONEY R *(JE)JYZZO[jdp]A[jy]|0
add.earn.ont.rec 8 SMONEY R *(JE)JYZZO[jdp]A[jy]|1
add.earn.ont.star 1 FREE L *(JE)JYZZO[jdp]A[jy]|4
Ì i 2
add.xfer.errors
[add.xfer.err.ret.urn]
*(JE)JY2WWE[jzr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.xfer.err.ret.urn 5 INT R jzr
Ì € i 2
add.xfer.error
[add.xfer.err.ret.urn, add.xfer.err.name,add.xfer.err.urn]
*(JE)JY2WWE[jzr]E[jySN,jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.xfer.err.name 26 FREE L jySN
add.xfer.err.urn 42 URN L PP.PER jy
add.xfer.err.reason 48 FREE L *(JE)JY2WWE[jzr]E[jySN,jy]|0
Ì i 2
additional.earnings
[add.earn.employee,add.earn.payroll,add.earning]
*(JE)JY2ZZ[jy,jdp,jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.earn.employee 42 URN L PP.PER jy
add.earn.payroll 8 FREE L PP.PAYROLL jdp
add.earning 8 PDEC L PP.EARN jde
add.earn.amount 8 SMONEY R *(JE)JY2ZZ[jy,jdp,jde]
add.earn.with.reg.whld 1 YN L *(JE)JY2ZZ[jy,jdp,jde]ORD|0
Ì i 2
additional.wholdings
[add.whold.employee,add.whold.payroll,add.wholding]
*(JE)JY2WW[jy,jdp,jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.whold.employee 42 URN L PP.PER jy
add.whold.payroll 8 FREE L PP.PAYROLL jdp
add.wholding 8 PDEC L PP.WHOLD jdw
add.whld.with.reg.whld 1 YN L *(JE)JY2WW[jy,jdp,jdw]ORD|0
add.whold.ee.amount 8 SMONEY R *(JE)JY2WW[jy,jdp,jdw]|0
add.whold.er.amount 8 SMONEY R *(JE)JY2WW[jy,jdp,jdw]|1
Ì i 2
benefit.adjustments
[ben.adj.date,ben.adj.payroll,ben.adj.employee,ben.adj.account]
*(JE)JY2GL[jyGD,jdp,jy,ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ben.adj.date 8 DATE L jyGD
ben.adj.payroll 8 FREE L PP.PAYROLL jdp
ben.adj.employee 42 URN L PP.PER jy
ben.adj.account 25 FREE L MIS.GL.ACCOUNT ga
ben.adj.cr 10 MONEY R *(JE)JY2GL[jyGD,jdp,jy,ga]|1
ben.adj.dr 10 MONEY R *(JE)JY2GL[jyGD,jdp,jy,ga]|0
ben.adj.hrs 8 SDEC3 R *(JE)JY2GL[jyGD,jdp,jy,ga]|2
Ì i 2
main
[employee]
$(JE)JY2[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L PP.PER jy
benefit.contr.hours 10 SDEC3 R $(JE)JY2[jy]|18
benefit.contr.hours.sort 10 SDEC3 R VAL=(1000000-@benefit.contr.hours:3D)
dd.proration.method 1 CHOICE L $(JE)JY2[jy]|17
de6.wage.plan 1 CHOICE L $(JE)JY2[jy]|11
exclude.from.de6 1 YN L $(JE)JY2[jy]|10
fit.exemptions 2 INT L $(JE)JY2[jy]|1
fit.tax.status 1 CHOICE L $(JE)JY2[jy]|0
flsa.per.week.calc 1 YN L $(JE)JY2[jy]|9
fmla.start 4 INT R $(JE)JY2[jy]|12
id 42 URN L PP.PER
insurance.coverage 40 FREE L $(JE)JY2[jy]|20
pension 1 YN L $(JE)JY2[jy]|4
qual.diff 8 RATE R $(JE)JY2[jy]|8
review.contr.hours 10 SDEC3 R $(JE)JY2[jy]|19
review.contr.hours.sort 10 SDEC3 R VAL=(1000000-@review.contr.hours:3D)
sit.exemptions 2 INT L $(JE)JY2[jy]|3
sit.tax.status 1 CHOICE L $(JE)JY2[jy]|2
statutory 1 YN L $(JE)JY2[jy]|5
t4.cpp.qpp.exempt 1 YN L $(JE)JY2[jy]|13
t4.ei.exempt 1 YN L $(JE)JY2[jy]|14
t4.employment.code 2 CHOICE L $(JE)JY2[jy]|15
t4.stock.code 2 CHOICE L $(JE)JY2[jy]|16
t4a.business.no 15 FREE L $(JE)JY2[jy]|23
tax.year 4 YEAR L $(JE)JY2[jy]|21
td1.exemption 8 MONEY R $(JE)JY2[jy]|6
td1.exemption.prov 8 MONEY R $(JE)JY2[jy]|7
third.party.sick.pay 1 YN L $(JE)JY2[jy]|22
Ì € i 2
dd.proration
[employee, dd.pro.counter]
$(JE)JY2[jy]2[mpC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dd.pro.counter 2 INT R mpC
dd.pro.account.number 17 FREE L $(JE)JY2[jy]2[mpC]|2
dd.pro.account.type 1 CHOICE L $(JE)JY2[jy]2[mpC]|3
dd.pro.bank 17 FREE L PP.BANK $(JE)JY2[jy]2[mpC]|1
dd.pro.note.account 17 FREE L $(JE)JY2[jy]2[mpC]|6
dd.pro.note.bank 17 FREE L PP.BANK $(JE)JY2[jy]2[mpC]|5
dd.pro.note.date 8 DATE L $(JE)JY2[jy]2[mpC]|8
dd.pro.note.type 1 CHOICE L $(JE)JY2[jy]2[mpC]|7
dd.pro.type 7 CHOICE L $(JE)JY2[jy]2[mpC]|0
dd.pro.value 10 FREE L $(JE)JY2[jy]2[mpC]|4
Ì € i 2
payrolls
[employee, payroll]
$(JE)JY2[jy]P[jdp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
payroll 8 FREE L PP.PAYROLL jdp
base.rate 8 RATE R $(JE)JY2[jy]P[jdp]|1
base.rate.date 8 DATE L $(JE)JY2[jy]P[jdp]|2
base.rate.reason 10 FREE L PP.REASON $(JE)JY2[jy]P[jdp]|3
cd.screen.1 15 FREE L MIS.SCREEN VAL=@PP.PAYROLL.customer.def.screen[@payroll]
contract 8 FREE L PP.CONTRACT $(JE)JY2[jy]P[jdp]1|9
dept 15 FREE L MIS.GL.DEPT $(JE)JY2[jy]P[jdp]1|4
dept.access.ok 1 FREE L VAL=%PP.EMP.user.ok(employee,PP.EMP.payroll,@Quote(@PP
VAL=.EMP.dept),@Quote(@HR.EMP.dept))
hours.per.period 6 DEC3 R $(JE)JY2[jy]P[jdp]1|7
hrs.per.period.date 8 DATE L $(JE)JY2[jy]P[jdp]1|8
incomplete.pay.fields 1 YN L $(JE)JY2[jy]P[jdp]|5
job.code 10 FREE L PP.JOB $(JE)JY2[jy]P[jdp]1|3
monthly.salary 8 MONEY R VAL=%PP.EMP.monthly.salary(PP.PER.employee,payroll)
ont.vac.calc.thru 8 DATE L $(JE)JY2[jy]P[jdp]|6
outside.agency 1 YN L $(JE)JY2[jy]P[jdp]|9
payroll.active 1 YN L $(JE)JY2[jy]P[jdp]|0
position.date 8 DATE L $(JE)JY2[jy]P[jdp]1|1
position.number 18 FREE L PP.POS $(JE)JY2[jy]P[jdp]1|0
primary 1 YN L $(JE)JY2[jy]P[jdp]|10
print.cd.screen.1 0 FREE L VAL=IF{@cd.screen.1 %MIS.SCREEN.print(@cd.screen.1,^@c
VAL=ustomer.defined.fields,"",3),""}
print.cd.screen.verbatm.1 0 FREE L VAL=IF{@cd.screen.1 %MIS.SCREEN.print(@cd.screen.1,^@c
VAL=ustomer.defined.fields,1,0),""}
reserved.position 18 FREE L PP.POS $(JE)JY2[jy]P[jdp]1|2
shift 1 PINT L $(JE)JY2[jy]P[jdp]1|5
shift.date 8 DATE L $(JE)JY2[jy]P[jdp]1|6
shift.diff.amount 8 RATE R VAL=%PP.EMP.diff.amount(employee,payroll)
sort.base.rate 8 RATE R VAL=(10000-@base.rate)
step 2 PINT L $(JE)JY2[jy]P[jdp]|4
step.grade.base.hi 8 PDEC R VAL=%PP.EMP.step.grade.base(employee,"HI",payroll)
step.grade.base.lo 8 PDEC R VAL=%PP.EMP.step.grade.base(employee,"LO",payroll)
tc.hours.pro.elig 1 YN L $(JE)JY2[jy]P[jdp]|7
tc.hours.pro.pri.pct 6 DEC3 R $(JE)JY2[jy]P[jdp]|8
yearly.salary 9 MONEY R VAL=%PP.EMP.yearly.salary(PP.PER.employee,payroll)
Ì € i 2
benefit.balances
[employee,payroll, benefit]
$(JE)JY2[jy]P[jdp]9[jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
benefit 8 PDEC L PP.EARN jde
benefit.accrued.balance 9 SDEC3 R $(JE)JY2[jy]P[jdp]9[jde]|3
benefit.avail.balance 9 SDEC3 R $(JE)JY2[jy]P[jdp]9[jde]|2
benefit.edit.reason 10 FREE L PP.REASON $(JE)JY2[jy]P[jdp]9[jde]|8
benefit.freeze 1 YN L $(JE)JY2[jy]P[jdp]9[jde]|5
benefit.freeze.contr.hrs 8 DEC3 R $(JE)JY2[jy]P[jdp]9[jde]|7
benefit.freeze.date 8 DATE L $(JE)JY2[jy]P[jdp]9[jde]|6
benefit.linked 1 YN L $(JE)JY2[jy]P[jdp]9[jde]|11
benefit.occurance 3 PINT R $(JE)JY2[jy]P[jdp]9[jde]|9
benefit.occurance.yr 4 YEAR L $(JE)JY2[jy]P[jdp]9[jde]|10
benefit.plan 8 FREE L $(JE)JY2[jy]P[jdp]9[jde]|1
benefit.update.gl 1 YN L $(JE)JY2[jy]P[jdp]9[jde]|4
Ì € i 2
customer.defined.queries
[employee,payroll, cd.query]
$(JE)JY2[jy]P[jdp]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.query 10 FREE L MIS.QUERY ggv
cd.response 75 QRY.RESP L $(JE)JY2[jy]P[jdp]CD[ggv]|0
cd.yn.comment 75 FREE L $(JE)JY2[jy]P[jdp]CD[ggv]|5
Ì € i 2
customer.def.mult.queries
[employee,payroll,cd.query, cdm.seq.no]
$(JE)JY2[jy]P[jdp]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cdm.seq.no 3 PINT R ggvN
cdm.response 75 QRY.RESP L $(JE)JY2[jy]P[jdp]CD[ggv]M[ggvN]|0
Ì € i 2
earnings
[employee,payroll, earning.counter]
$(JE)JY2[jy]P[jdp]E[jyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
earning.counter 2 INT R jyEC
earning 8 PDEC L PP.EARN $(JE)JY2[jy]P[jdp]E[jyEC]|0
earning.active 1 YN L $(JE)JY2[jy]P[jdp]E[jyEC]|1
earning.created.by.flex 1 YN L $(JE)JY2[jy]P[jdp]E[jyEC]|4
earning.expression 30 FREE L $(JE)JY2[jy]P[jdp]E[jyEC]|2
earning.freeze 1 YN L $(JE)JY2[jy]P[jdp]E[jyEC]|5
earning.wexpr 60 FREE L $(JE)JY2[jy]P[jdp]E[jyEC]|3
Ì € i 2
eff.base.rates
[employee,payroll, eff.date]
$(JE)JY2[jy]P[jdp]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
eff.date 8 DATE L jefd
eff.rate 8 RATE R $(JE)JY2[jy]P[jdp]13[jefd]|1
eff.reason 10 FREE L PP.REASON $(JE)JY2[jy]P[jdp]13[jefd]|2
eff.step 2 PINT L $(JE)JY2[jy]P[jdp]13[jefd]|0
Ì € i 2
sec.jobs
[employee,payroll, sec.job.counter]
$(JE)JY2[jy]P[jdp]SJ[jySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.job.counter 2 INT R jySC
sec.job 10 FREE L PP.JOB $(JE)JY2[jy]P[jdp]SJ[jySC]|0
sec.job.contract 8 FREE L PP.CONTRACT $(JE)JY2[jy]P[jdp]SJ[jySC]|5
sec.job.dept 15 FREE L MIS.GL.DEPT $(JE)JY2[jy]P[jdp]SJ[jySC]|2
sec.job.hrs.percent 6 DEC3 R $(JE)JY2[jy]P[jdp]SJ[jySC]|3
sec.job.rate 8 RATE R $(JE)JY2[jy]P[jdp]SJ[jySC]|1
sec.job.step 2 PINT L $(JE)JY2[jy]P[jdp]SJ[jySC]|4
Ì € i 2
sec.eff.rates
[employee,payroll,sec.job.counter, sec.eff.date]
$(JE)JY2[jy]P[jdp]SJ[jySC]SR[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.eff.date 8 DATE L jefd
sec.eff.rate 8 RATE R $(JE)JY2[jy]P[jdp]SJ[jySC]SR[jefd]|1
sec.eff.step 2 PINT L $(JE)JY2[jy]P[jdp]SJ[jySC]SR[jefd]|0
Ì € i 2
withholdings
[employee,payroll, whold]
$(JE)JY2[jy]P[jdp]10[jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
whold 8 PDEC L PP.WHOLD jdw
whold.account.number 14 FREE L $(JE)JY2[jy]P[jdp]10[jdw]|1
whold.active 1 YN L $(JE)JY2[jy]P[jdp]10[jdw]|0
whold.arrears 1 YN L $(JE)JY2[jy]P[jdp]10[jdw]|12
whold.balance 8 MONEY R $(JE)JY2[jy]P[jdp]10[jdw]|4
whold.bond.price 8 MONEY R $(JE)JY2[jy]P[jdp]10[jdw]|5
whold.created.by.flex 1 YN L $(JE)JY2[jy]P[jdp]10[jdw]|11
whold.employee.wexpr 60 FREE L $(JE)JY2[jy]P[jdp]10[jdw]|7
whold.employer.expr 30 FREE L $(JE)JY2[jy]P[jdp]10[jdw]|8
whold.employer.wexpr 60 FREE L $(JE)JY2[jy]P[jdp]10[jdw]|9
whold.expressions 30 FREE L $(JE)JY2[jy]P[jdp]10[jdw]|6
whold.from.date 8 DATE L $(JE)JY2[jy]P[jdp]10[jdw]|2
whold.more.below 1 FREE L $(JE)JY2[jy]P[jdp]10[jdw]|10
whold.thru.date 8 DATE L $(JE)JY2[jy]P[jdp]10[jdw]|3
Ì i 2
transactions
[employee.txn]
*(JE)JY2TX[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee.txn 42 URN L PP.PER jy
Ì € i 2
add.earn.txns
[employee.txn, atxn.payroll,atxn.earning,atxn.date,atxn.time]
*(JE)JY2TX[jy]14[jdp,jde,jyAED,jyAET]
Field Name Len Dat Typ J DPM Offset/Local/VAL
atxn.payroll 8 FREE L PP.PAYROLL jdp
atxn.earning 8 PDEC L PP.EARN jde
atxn.date 8 DATE L jyAED
atxn.time 5 TIME L jyAET
atxn.amount 8 SMONEY R *(JE)JY2TX[jy]14[jdp,jde,jyAED,jyAET]|1
atxn.balance 8 SMONEY R *(JE)JY2TX[jy]14[jdp,jde,jyAED,jyAET]|2
atxn.tc.pointer 8 URN L PP.PAY *(JE)JY2TX[jy]14[jdp,jde,jyAED,jyAET]|3
atxn.type 1 FREE L *(JE)JY2TX[jy]14[jdp,jde,jyAED,jyAET]|0
Ì € i 2
add.wholding.txns
[employee.txn, add.wtxn.payroll,add.wtxn.whold,add.wtxn.date,add.wtxn.time]
*(JE)JY2TX[jy]15[jdp,jdw,jyAWD,jyAWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.wtxn.payroll 8 FREE L PP.PAYROLL jdp
add.wtxn.whold 8 PDEC L PP.WHOLD jdw
add.wtxn.date 8 DATE L jyAWD
add.wtxn.time 5 TIME L jyAWT
add.wtxn.ee.amount 8 SMONEY R *(JE)JY2TX[jy]15[jdp,jdw,jyAWD,jyAWT]|1
add.wtxn.ee.balance 8 SMONEY R *(JE)JY2TX[jy]15[jdp,jdw,jyAWD,jyAWT]|3
add.wtxn.er.amount 8 SMONEY R *(JE)JY2TX[jy]15[jdp,jdw,jyAWD,jyAWT]|2
add.wtxn.er.balance 8 SMONEY R *(JE)JY2TX[jy]15[jdp,jdw,jyAWD,jyAWT]|4
add.wtxn.tc.pointer 8 URN L PP.PAY *(JE)JY2TX[jy]15[jdp,jdw,jyAWD,jyAWT]|5
add.wtxn.type 1 FREE L *(JE)JY2TX[jy]15[jdp,jdw,jyAWD,jyAWT]|0
Ì € i 2
audit.trail
[employee.txn, audit.date,audit.time]
*(JE)JY2TX[jy]0[jyMD,jyMT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L jyMD
audit.time 5 TIME L jyMT
audit.benefit.contr.hours 10 SDEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]0|18
audit.dd.proration.method 1 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|17
audit.de6.wage.plan 1 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|11
audit.exclude.from.de6 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]0|10
audit.fit.exemptions 2 INT L *(JE)JY2TX[jy]0[jyMD,jyMT]0|1
audit.fit.tax.status 1 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|0
audit.flsa.per.week.calc 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]0|9
audit.fmla.start 4 INT R *(JE)JY2TX[jy]0[jyMD,jyMT]0|12
audit.insurance.coverage 40 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|20
audit.pension 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]0|4
audit.qual.diff 8 RATE R *(JE)JY2TX[jy]0[jyMD,jyMT]0|8
audit.review.contr.hours 10 SDEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]0|19
audit.sit.exemptions 2 INT L *(JE)JY2TX[jy]0[jyMD,jyMT]0|3
audit.sit.tax.status 1 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|2
audit.statutory 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]0|5
audit.t4.cpp.qpp.exempt 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]0|13
audit.t4.ei.exempt 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]0|14
audit.t4.employment.code 2 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|15
audit.t4.stock.code 2 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|16
audit.t4a.business.no 15 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]0|23
audit.tax.year 4 YEAR L *(JE)JY2TX[jy]0[jyMD,jyMT]0|21
audit.td1.exemption 8 MONEY R *(JE)JY2TX[jy]0[jyMD,jyMT]0|6
audit.td1.exemption.prov 8 MONEY R *(JE)JY2TX[jy]0[jyMD,jyMT]0|7
audit.third.party.sick 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]0|22
audit.user 10 FREE L MIS.USER *(JE)JY2TX[jy]0[jyMD,jyMT]
Ì € i 2
audit.dd.proration
[employee.txn,audit.date,audit.time, audit.dd.pro.counter]
*(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.dd.pro.counter 2 INT R mpC
audit.dd.pro.account.num 17 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|2
audit.dd.pro.account.type 1 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|3
audit.dd.pro.bank 17 FREE L PP.BANK *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|1
audit.dd.pro.note.account 17 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|6
audit.dd.pro.note.bank 17 FREE L PP.BANK *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|5
audit.dd.pro.note.date 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|8
audit.dd.pro.note.type 1 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|7
audit.dd.pro.type 7 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|0
audit.dd.pro.value 10 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]2[mpC]|4
Ì € i 2
audit.payrolls
[employee.txn,audit.date,audit.time, audit.payroll]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.payroll 8 FREE L PP.PAYROLL jdp
audit.base.rate 8 RATE R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|1
audit.base.rate.date 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|2
audit.base.rate.reason 10 FREE L PP.REASON *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|3
audit.contract 8 FREE L PP.CONTRACT *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|9
audit.dept 15 FREE L MIS.GL.DEPT *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|4
audit.hours.per.period 8 DEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|7
audit.hrs.per.period.date 6 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|8
audit.incomplete.pay.fld 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|5
audit.job.code 10 FREE L PP.JOB *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|3
audit.ont.vac.calc.thru 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|6
audit.outside.agency 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|9
audit.payroll.active 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|0
audit.position.date 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|1
audit.position.number 18 FREE L PP.POS *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|0
audit.primary 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|10
audit.reserved.position 18 FREE L PP.POS *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|2
audit.shift 1 PINT R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|5
audit.shift.date 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]1|6
audit.step 2 PINT R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|4
audit.tc.hours.pro.elig 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|7
audit.tc.hrs.pro.pri.pct 6 DEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]0|8
Ì € i 2
audit.benefit.balances
[employee.txn,audit.date,audit.time,audit.payroll, audit.benefit]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.benefit 8 PDEC L PP.EARN jde
audit.benefit.accrued.bal 9 SDEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|3
audit.benefit.avail.bal 9 SDEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|2
audit.benefit.edit.reason 10 FREE L PP.REASON *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|8
audit.benefit.freeze 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|5
audit.benefit.freeze.date 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|6
audit.benefit.frz.con.hrs 8 DEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|7
audit.benefit.linked 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|11
audit.benefit.occur.yr 4 YEAR L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|10
audit.benefit.occurance 3 PINT R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|9
audit.benefit.plan 8 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|1
audit.benefit.update.gl 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]9[jde]|4
Ì € i 2
audit.cust.def.queries
[employee.txn,audit.date,audit.time,audit.payroll, audit.cd.query]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.cd.query 10 FREE L MIS.QUERY ggv
audit.cd.response 75 QRY.RESP L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]CD[ggv]|0
audit.cd.yn.comment 75 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]CD[ggv]|5
Ì € i 2
audit.cust.def.mult
[employee.txn,audit.date,audit.time,audit.payroll,audit.cd.query, audit.cdm.seq.no]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.cdm.seq.no 3 PINT R ggvN
audit.cdm.response 75 QRY.RESP L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]CD[ggv]M[ggvN]|0
Ì € i 2
audit.earnings
[employee.txn,audit.date,audit.time,audit.payroll, audit.earning.counter]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]E[jyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.earning.counter 2 INT R jyEC
audit.earning 8 PDEC L PP.EARN *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]E[jyEC]|0
audit.earning.active 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]E[jyEC]|1
audit.earning.created.flx 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]E[jyEC]|4
audit.earning.expression 30 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]E[jyEC]|2
audit.earning.freeze 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]E[jyEC]|5
audit.earning.wexpr 60 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]E[jyEC]|3
Ì € i 2
audit.eff.base.rates
[employee.txn,audit.date,audit.time,audit.payroll, audit.eff.date]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.eff.date 8 DATE L jefd
audit.eff.rate 8 RATE R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]13[jefd]|1
audit.eff.reason 10 FREE L PP.REASON *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]13[jefd]|2
audit.eff.step 2 PINT R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]13[jefd]|0
Ì € i 2
audit.sec.jobs
[employee.txn,audit.date,audit.time,audit.payroll, audit.sec.job.counter]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.sec.job.counter 2 INT R jySC
audit.sec.job 10 FREE L PP.JOB *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]|0
audit.sec.job.contract 8 FREE L PP.CONTRACT *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]|5
audit.sec.job.dept 15 FREE L MIS.GL.DEPT *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]|2
audit.sec.job.hrs.percent 6 DEC3 R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]|3
audit.sec.job.rate 8 RATE R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]|1
audit.sec.job.step 2 PINT R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]|4
Ì € i 2
audit.sec.eff.rates
[employee.txn,audit.date,audit.time,audit.payroll,audit.sec.job.counter, audit.sec.eff.date]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]SR[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.sec.eff.date 8 DATE L jefd
audit.sec.eff.rate 8 RATE R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]SR[jefd]|1
audit.sec.eff.step 2 PINT R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]SJ[jySC]SR[jefd]|0
Ì € i 2
audit.withholdings
[employee.txn,audit.date,audit.time,audit.payroll, audit.whold]
*(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.whold 8 PDEC L PP.WHOLD jdw
audit.whold.account.num 14 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|1
audit.whold.active 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|0
audit.whold.arrears 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|12
audit.whold.balance 8 MONEY R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|4
audit.whold.bond.price 8 MONEY R *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|5
audit.whold.created.flex 1 YN L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|11
audit.whold.emplee.wexpr 60 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|7
audit.whold.empler.expr 30 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|8
audit.whold.empler.wexpr 60 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|9
audit.whold.expressions 30 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|6
audit.whold.from.date 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|2
audit.whold.more.below 1 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|10
audit.whold.thru.date 8 DATE L *(JE)JY2TX[jy]0[jyMD,jyMT]P[jdp]10[jdw]|3
Ì € i 2
audit.trail.mult.values
[employee.txn,audit.date,audit.time, audit.subscript.1,audit.subscript.2]
*(JE)JY2TX[jy]0[jyMD,jyMT,jyMS,jyMSS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript.1 2 FREE L jyMS
audit.subscript.2 50 FREE L jyMSS
audit.value.2 200 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT,jyMS,jyMSS]
Ì € i 2
audit.trail.mult.values.4
[employee.txn,audit.date,audit.time,audit.subscript.1,audit.subscript.2, audit.subscript.3,aud
*(JE)JY2TX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript.3 50 FREE L jyMS3
audit.subscript.4 50 FREE L jyMS4
audit.value.4 200 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4]
audit.value.src 1 CHOICE L *(JE)JY2TX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4]S|0
Ì € i 2
audit.trail.values
[employee.txn,audit.date,audit.time, audit.subscript]
*(JE)JY2TX[jy]0[jyMD,jyMT,jyMS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript 55 FREE L jyMS
audit.value 200 FREE L *(JE)JY2TX[jy]0[jyMD,jyMT,jyMS]
Ì € i 2
benefit.transactions
[employee.txn, btxn.payroll,btxn.earning,btxn.date,btxn.time]
*(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
btxn.payroll 8 FREE L PP.PAYROLL jdp
btxn.earning 8 PDEC L PP.EARN jde
btxn.date 8 DATE L jyBD
btxn.time 5 TIME L jyBT
btxn.accrued.balance 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|9
btxn.adjustment 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|7
btxn.avail.balance 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|8
btxn.award 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|5
btxn.benefit.freeze 1 YN L *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|12
btxn.earned 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|3
btxn.earned.print 8 SDEC3 R VAL=(@btxn.earned+@btxn.award)
btxn.edit.reason 10 FREE L PP.REASON *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|13
btxn.hour.basis 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|2
btxn.linked 1 YN L *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|15
btxn.occurance 3 PINT R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|14
btxn.plan 8 FREE L *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|0
btxn.taken 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|4
btxn.tc.pointer 8 URN L PP.PAY *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|10
btxn.transfer 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|6
btxn.type 1 CHOICE L *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|1
btxn.zero.avail.first 8 SDEC3 R *(JE)JY2TX[jy]11[jdp,jde,jyBD,jyBT]|11
Ì € i 2
contr.hrs.transactions
[employee.txn, ctxn.date,ctxn.time]
*(JE)JY2TX[jy]13[jyCD,jyCT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ctxn.date 8 DATE L jyCD
ctxn.time 5 TIME L jyCT
ctxn.ben.hrs 8 SDEC3 R *(JE)JY2TX[jy]13[jyCD,jyCT]|1
ctxn.ben.hrs.balance 10 SDEC3 R *(JE)JY2TX[jy]13[jyCD,jyCT]|2
ctxn.rvw.hrs 8 SDEC3 R *(JE)JY2TX[jy]13[jyCD,jyCT]|3
ctxn.rvw.hrs.balance 10 SDEC3 R *(JE)JY2TX[jy]13[jyCD,jyCT]|4
ctxn.type 1 CHOICE L *(JE)JY2TX[jy]13[jyCD,jyCT]|0
Ì € i 2
whold.transactions
[employee.txn, wtxn.whold.payroll,wtxn.whold,wtxn.date,wtxn.time]
*(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wtxn.whold.payroll 8 FREE L PP.PAYROLL jdp
wtxn.whold 8 PDEC L PP.WHOLD jdw
wtxn.date 8 DATE L jyWD
wtxn.time 5 TIME L jyWT
wtxn.add.amount 8 SMONEY R VAL=(@wtxn.whold.amount+@wtxn.manual.amount)
wtxn.arrear.amount 8 SMONEY R *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|7
wtxn.balance 8 SMONEY R *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|3
wtxn.bond.amount.pur 8 SMONEY R *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|5
wtxn.bond.num.pur 4 SINT R *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|4
wtxn.manual.amount 8 SMONEY R *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|2
wtxn.sub.amount 8 SMONEY R VAL=(@wtxn.manual.amount-@wtxn.whold.amount)
wtxn.tc.pointer 8 URN L PP.PAY *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|6
wtxn.type 1 CHOICE L *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|0
wtxn.whold.amount 8 SMONEY R *(JE)JY2TX[jy]12[jdp,jdw,jyWD,jyWT]|1
Index Files Subscripts/Physical Base
add.earn.txn.x [atxn.date,atxn.payroll,atxn.earning,atxn.time,employee.txn]
?(JE)JY2AEX[jyAED,jdp,jde,jyAET,jy]
add.whold.txn.x [add.wtxn.date,add.wtxn.payroll,add.wtxn.whold,add.wtxn.time,employee.txn]
?(JE)JY2AWX[jyAWD,jdp,jdw,jyAWT,jy]
contract.name.x [contract,payroll,PP.PER.sort.name,employee]
?(JE)JY2UN[jdc,jdp,jySN,jy]
employee.x [employee]
?(JE)JY2X[jy]
payroll.dept.name.x [payroll,dept,PP.PER.sort.name,employee]
?(JE)JY2PDN[jdp,gd,jySN,jy]
payroll.dept.x [payroll,dept,employee]
?(JE)JY2PD[jdp,gd,jy]
position.x [position.number,payroll,PP.PER.sort.name,employee]
?(JE)JY2PO[jdr,jdp,jySN,jy]
primary.x [employee] = payroll
?(JE)JY2P[jy]
reserved.pos.x [reserved.position,payroll,PP.PER.sort.name,employee]
?(JE)JY2RPO[jdr,jdp,jySN,jy]
tax.whold.x [tax.year,payroll,whold,PP.PER.sort.name,employee]
?(JE)JY2TW[jyTY,jdp,jdw,jySN,jy]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |