Ì i 2
pp.per.add.earn.ont.amounts (add.earn.ont.amounts)
[add.earn.ont.employee]
*JYZZO["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 *JYZZO["A",jy]|2
add.earn.ont.due 8 SMONEY R *JYZZO["A",jy]|3
add.earn.ont.min 8 SMONEY R *JYZZO["A",jy]|0
add.earn.ont.rec 8 SMONEY R *JYZZO["A",jy]|1
add.earn.ont.star 1 FREE L *JYZZO["A",jy]|4
Ì i 2
pp.per.add.xfer.errors (add.xfer.errors)
[add.xfer.err.ret.urn]
*JYWWE[jzr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.xfer.err.ret.urn 5 INT R jzr
Ì € i 2
pp.per.add.xfer.error (add.xfer.error)
[add.xfer.err.ret.urn, add.xfer.err.name,add.xfer.err.urn]
*JYWWE[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 *JYWWE[jzr]E[jySN,jy]|0
Ì i 2
pp.per.additional.earnings (additional.earnings)
[add.earn.employee,add.earning]
*JYZZ[jy,je]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.earn.employee 42 URN L PP.PER jy
add.earning 8 PDEC L PP.EARN je
add.earn.amount 8 SMONEY R *JYZZ[jy,je]
add.earn.with.reg.whld 1 YN L *JYZZ[jy,je]ORD|0
Ì i 2
pp.per.additional.wholdings (additional.wholdings)
[add.whold.employee,add.wholding]
*JYWW[jy,jw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.whold.employee 42 URN L PP.PER jy
add.wholding 8 PDEC L PP.WHOLD jw
add.whld.with.reg.whld 1 YN L *JYWW[jy,jw]ORD|0
add.whold.ee.amount 8 SMONEY R *JYWW[jy,jw]|0
add.whold.er.amount 8 SMONEY R *JYWW[jy,jw]|1
Ì i 2
pp.per.gl.post.x (benefit.adjustments)
[ben.adj.date,ben.adj.payroll,ben.adj.employee,ben.adj.account]
*JYGL[jyGD,ja,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 ja
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 *JYGL[jyGD,ja,jy,ga]|1
ben.adj.dr 10 MONEY R *JYGL[jyGD,ja,jy,ga]|0
ben.adj.hrs 8 SDEC3 R *JYGL[jyGD,ja,jy,ga]|2
Ì i 2
pp.empl.expense.to.periods (expense.to.periods)
[exp.activity.date]
*JYGLD[jyGLD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
exp.activity.date 8 DATE L jyGLD
exp.for.gl.period 8 DATE L *JYGLD[jyGLD]
Ì i 2
pp.employee.file (main)
[employee]
*JY[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L jy
activity.date 8 DATE L VAL=@.today
addr1 26 FREE L *JY[jy]|5
addr2 26 FREE L *JY[jy]|6
addr3 26 FREE L *JY[jy]|7
address1 30 FREE L *JY[jy]0|0
address2 30 FREE L *JY[jy]0|1
adj.hire.month.alpha 3 FREE L VAL=IF{@PP.PER.adjusted.hire.date "JANFEBMARAPRMAYJUNJ
VAL=ULAUGSEPOCTNOVDEC"'$((@PP.PER.adj.hire.month.numer
VAL=ic)-1*3)$3}
adj.hire.month.numeric 2 PINT R VAL=(@PP.PER.adjusted.hire.date%3$2)
adjusted.hire.date 8 DATE L *JY[jy]1|12
att.data.elig 1 YN L *JY[jy]|18
att.template 8 FREE L PP.ATT.TEMPLATE*JY[jy]11|0
attendance 3 FREE L TA.ATT *JY[jy]1|20
base.rate 8 RATE R *JY[jy]7|7
base.rate.date 8 DATE L *JY[jy]7|9
base.rate.reason 10 FREE L PP.REASON *JY[jy]7|8
being.paid 1 YN L *JY[jy]1|10
benefit.contr.hours 10 SDEC3 R *JY[jy]1|18
benefit.contr.hours.sort 10 SDEC3 R VAL=(1000000-@benefit.contr.hours:3D)
cd.screen.1 15 FREE L MIS.SCREEN VAL=@PP.TYPE.customer.def.screen[@empl.type]
cd.screen.2 15 FREE L MIS.SCREEN VAL=@PP.PAYROLL.customer.def.screen[@payroll]
cd.screen.3 15 FREE L MIS.SCREEN VAL=@PP.TYPE.customer.def.screen.2[@empl.type]
city 18 FREE L *JY[jy]0|2
cobra.number 42 URN L PP.PER.COBRA *JY[jy]M1|6
contract 8 FREE L PP.CONTRACT *JY[jy]1|17
date.of.birth 8 BDATE L *JY[jy]|11
dd.account.number 17 FREE L *JY[jy]7|13
dd.account.type 1 CHOICE L *JY[jy]7|14
dd.bank 17 FREE L PP.BANK *JY[jy]7|12
dd.notification.account 17 FREE L *JY[jy]7|16
dd.notification.bank 17 FREE L PP.BANK *JY[jy]7|15
dd.notification.date 8 DATE L *JY[jy]7|18
dd.notification.type 1 CHOICE L *JY[jy]7|17
dd.proration.method 1 CHOICE L *JY[jy]7|25
de6.wage.plan 1 CHOICE L *JY[jy]|17
deceased 1 YN L *JY[jy]7|23
dept 15 FREE L MIS.GL.DEPT *JY[jy]1|3
disability 1 YN L *JY[jy]M1|0
eeoc 18 CHOICE L *JY[jy]|13
email.address 40 FREE L *JY[jy]EM|0
emergency.phone 18 PHONE L *JY[jy]|10
empl.type 5 FREE L PP.TYPE *JY[jy]1|0
empl.type.date 8 DATE L *JY[jy]1|22
evaluation.date 8 DATE L *JY[jy]1|16
exclude.from.de6 1 YN L *JY[jy]|16
exempt 1 YN L *JY[jy]7|5
fit.exemptions 2 INT L *JY[jy]7|4
fit.tax.status 1 CHOICE L *JY[jy]7|3
flsa.per.week.calc 1 YN L *JY[jy]|15
fmla.start 4 INT R *JY[jy]M1|9
health.insurance 1 YN L *JY[jy]M1|3
hire.date 8 DATE L *JY[jy]1|11
hire.month.alpha 3 FREE L VAL=IF{@PP.PER.hire.date "JANFEBMARAPRMAYJUNJULAUGSEPO
VAL=CTNOVDEC"'$((@PP.PER.hire.month.numeric)-1*3)$3}
hire.month.numeric 2 PINT R VAL=(@PP.PER.hire.date%3$2)
home.phone 18 PHONE L *JY[jy]|9
hours.per.period 6 DEC3 R *JY[jy]1|6
hrs.per.period.date 8 DATE L *JY[jy]1|23
id 42 URN L PP.PER VAL=@PP.PER.number_" "_@PP.PER.name'=" "
incomplete.pay.fields 1 YN L *JY[jy]7|19
insurance.coverage 40 FREE L *JY[jy]7|20
job.code 10 FREE L PP.JOB *JY[jy]1|2
mail.notices 1 YN L *JY[jy]7|27
marital.status 10 FREE L MIS.MAR.STATUS *JY[jy]M1|4
marital.status.date 8 DATE L *JY[jy]M1|5
medicare.date 8 DATE L *JY[jy]M1|2
mis.user 10 FREE L MIS.USER *JY[jy]|19
misc.field.1 20 FREE L *JY[jy]3|1
misc.field.10 20 FREE L *JY[jy]3|10
misc.field.11 20 FREE L *JY[jy]3|11
misc.field.12 20 FREE L *JY[jy]3|12
misc.field.2 20 FREE L *JY[jy]3|2
misc.field.3 20 FREE L *JY[jy]3|3
misc.field.4 20 FREE L *JY[jy]3|4
misc.field.5 20 FREE L *JY[jy]3|5
misc.field.6 20 FREE L *JY[jy]3|6
misc.field.7 20 FREE L *JY[jy]3|7
misc.field.8 20 FREE L *JY[jy]3|8
misc.field.9 20 FREE L *JY[jy]3|9
month.and.day.of.birth 4 PINT R VAL=(@date.of.birth%3)
monthly.salary 8 MONEY R VAL=%PP.PER.monthly.salary(PP.PER.employee)
name 26 NAME L *JY[jy]|2
next.review.date 8 DATE L *JY[jy]1|13
next.review.reason 10 FREE L PP.REASON *JY[jy]1|14
number 14 FREE L *JY[jy]|4
ont.vac.calc.thru 8 DATE L *JY[jy]7|22
other.country 10 FREE L *JY[jy]0|6
other.country.choice 6 CHOICE L *JY[jy]0|5
other.country.print 10 FREE L VAL=IF{@other.country.choice="CANADA";@other.country}
outside.agency 1 YN L *JY[jy]|14
payroll 8 FREE L PP.PAYROLL *JY[jy]7|0
pension 1 YN L *JY[jy]7|24
pop.grp 8 FREE L PP.POPUL *JY[jy]M1|1
position.date 8 DATE L *JY[jy]1|24
position.number 18 FREE L PP.POS *JY[jy]1|1
postal.code 10 FREE L *JY[jy]0|4
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.2 0 FREE L VAL=IF{@cd.screen.2 %MIS.SCREEN.print(@cd.screen.2,^@c
VAL=ustomer.defined.fields,"",3),""}
print.cd.screen.3 0 FREE L VAL=IF{@cd.screen.3 %MIS.SCREEN.print(@cd.screen.3,^@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),""}
print.cd.screen.verbatm.2 0 FREE L VAL=IF{@cd.screen.2 %MIS.SCREEN.print(@cd.screen.2,^@c
VAL=ustomer.defined.fields,1,0),""}
print.cd.screen.verbatm.3 0 FREE L VAL=IF{@cd.screen.3 %MIS.SCREEN.print(@cd.screen.3,^@c
VAL=ustomer.defined.fields,1,0),""}
qual.diff 8 RATE R *JY[jy]7|11
reserved.position 18 FREE L PP.POS *JY[jy]1|25
review.contr.hours 10 SDEC3 R *JY[jy]1|19
review.contr.hours.sort 10 SDEC3 R VAL=(1000000-@review.contr.hours:3D)
roe.date 8 DATE L *JY[jy]1|21
seniority.date 8 DATE L *JY[jy]1|15
sex 1 CHOICE L *JY[jy]|12
shift 1 PINT L *JY[jy]1|4
shift.date 8 DATE L *JY[jy]1|5
shift.diff.amount 8 RATE R VAL=%PP.PER.diff.amount(employee)
si.number 12 FREE L *JY[jy]|1
si.number.govt 11 FREE L VAL=(@PP.PER.si.number$11)
sit.exemptions 2 INT L *JY[jy]7|2
sit.tax.status 1 CHOICE L *JY[jy]7|1
sort.base.rate 8 RATE R VAL=(10000-@base.rate)
sort.name 26 NAME L *JY[jy]|3
spouse.ssn 12 FREE L *JY[jy]1|26
ss.number 12 FREE L *JY[jy]|1
ss.number.govt 11 FREE L VAL=(@PP.PER.ss.number$11)
state 2 FREE L *JY[jy]0|3
status 7 CHOICE L *JY[jy]1|7
status.date 8 DATE L *JY[jy]1|8
status.reason 10 FREE L PP.REASON *JY[jy]1|9
statutory 1 YN L *JY[jy]7|26
step 2 PINT L *JY[jy]7|6
step.grade.base.hi 8 PDEC R VAL=%PP.PER.step.grade.base(employee,"HI")
step.grade.base.lo 8 PDEC R VAL=%PP.PER.step.grade.base(employee,"LO")
t4.country 10 FREE L *JY[jy]6|3
t4.country.choice 5 CHOICE L *JY[jy]6|2
t4.country.print 10 FREE L VAL=IF{@t4.country.choice="US";@t4.country}
t4.cpp.qpp.exempt 1 YN L *JY[jy]6|0
t4.ei.exempt 1 YN L *JY[jy]6|1
t4.employment.code 2 CHOICE L *JY[jy]6|4
t4.ppip.exempt 1 YN L *JY[jy]6|7
t4.stock.option 2 PINT R *JY[jy]6|5
t4a.business.no 15 FREE L *JY[jy]6|6
tax.year 4 YEAR L *JY[jy]7|21
tc.hours.pro.elig 1 YN L *JY[jy]M1|7
tc.hours.pro.pri.pct 6 DEC3 R *JY[jy]M1|8
td1.exemption 8 MONEY R *JY[jy]7|10
td1.exemption.prov 8 MONEY R *JY[jy]7|28
third.party.sick.pay 1 YN L *JY[jy]7|29
yearly.salary 9 MONEY R VAL=%PP.PER.yearly.salary(PP.PER.employee)
zip.code 9 PINT R *JY[jy]|8
Ì € i 2
pp.emp.benefit.balances (benefit.balances)
[employee, benefit]
*JY[jy]9[je]
Field Name Len Dat Typ J DPM Offset/Local/VAL
benefit 8 PDEC L PP.EARN je
benefit.accrued.balance 9 SDEC3 R *JY[jy]9[je]|3
benefit.avail.balance 9 SDEC3 R *JY[jy]9[je]|2
benefit.edit.reason 10 FREE L PP.REASON *JY[jy]9[je]|8
benefit.freeze 1 YN L *JY[jy]9[je]|5
benefit.freeze.contr.hrs 8 DEC3 R *JY[jy]9[je]|7
benefit.freeze.date 8 DATE L *JY[jy]9[je]|6
benefit.occurance 3 PINT R *JY[jy]9[je]|9
benefit.occurance.yr 4 YEAR L *JY[jy]9[je]|10
benefit.plan 8 FREE L *JY[jy]9[je]|1
benefit.update.gl 1 YN L *JY[jy]9[je]|4
Ì € i 2
pp.emp.customer.def.queries (customer.defined.queries)
[employee, cd.query]
*JY[jy]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 *JY[jy]CD[ggv]|0
view.cds 0 FREE L VAL=%PP.PER.view.cds.has.M.screen("")
view.cds.screen 0 FREE L VAL=IF{@PP.HAS.customer.def.screen %PP.PER.view.cds.ha
VAL=s.S("")}
Ì € i 2
pp.per.cust.defined.mult.query (customer.def.mult.queries)
[employee,cd.query, cdm.seq.no]
*JY[jy]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 *JY[jy]CD[ggv]M[ggvN]|0
Ì € i 2
pp.emp.dd.proration (dd.proration)
[employee, dd.pro.counter]
*JY[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 *JY[jy]2[mpC]|2
dd.pro.account.type 1 CHOICE L *JY[jy]2[mpC]|3
dd.pro.bank 17 FREE L PP.BANK *JY[jy]2[mpC]|1
dd.pro.note.account 17 FREE L *JY[jy]2[mpC]|6
dd.pro.note.bank 17 FREE L PP.BANK *JY[jy]2[mpC]|5
dd.pro.note.date 8 DATE L *JY[jy]2[mpC]|8
dd.pro.note.type 1 CHOICE L *JY[jy]2[mpC]|7
dd.pro.type 7 CHOICE L *JY[jy]2[mpC]|0
dd.pro.value 10 FREE L *JY[jy]2[mpC]|4
Ì € i 2
pp.empl.dependents (dependents)
[employee, dp.number]
*JY[jy]DP[jyDP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dp.number 2 INT R jyDP
dp.active 1 YN L *JY[jy]DP[jyDP]|5
dp.address1 30 FREE L *JY[jy]DP[jyDP]0|0
dp.address2 30 FREE L *JY[jy]DP[jyDP]0|1
dp.age 3 PINT R VAL=IF{@dp.birthdate^XX'>@.today %Z.age(XX,@.today)
VAL=^XX$L(XX,"Y")?0N!0}
dp.birthdate 8 BDATE L *JY[jy]DP[jyDP]|1
dp.city 18 FREE L *JY[jy]DP[jyDP]0|2
dp.cobra.number 42 URN L PP.PER.COBRA *JY[jy]DP[jyDP]|11
dp.email.address 40 FREE L *JY[jy]DP[jyDP]|13
dp.emergency.phone 18 PHONE L *JY[jy]DP[jyDP]|8
dp.home.phone 18 PHONE L *JY[jy]DP[jyDP]|7
dp.marital.status 10 FREE L MIS.MAR.STATUS *JY[jy]DP[jyDP]|9
dp.marital.status.date 8 DATE L *JY[jy]DP[jyDP]|10
dp.medicare.date 8 DATE L *JY[jy]DP[jyDP]|12
dp.more 0 FREE L VAL=%PP.PER.dependent.more(^@dependents)
dp.name 26 NAME L *JY[jy]DP[jyDP]|0
dp.other.country 10 FREE L *JY[jy]DP[jyDP]0|6
dp.other.country.choice 6 CHOICE L *JY[jy]DP[jyDP]0|5
dp.postal.code 10 FREE L *JY[jy]DP[jyDP]0|4
dp.relationship 10 FREE L MIS.RELAT.DICT *JY[jy]DP[jyDP]|2
dp.si.number 12 FREE L *JY[jy]DP[jyDP]|3
dp.sort.name 26 NAME L *JY[jy]DP[jyDP]|4
dp.ss.number 12 FREE L *JY[jy]DP[jyDP]|3
dp.state 2 FREE L *JY[jy]DP[jyDP]0|3
dp.student 1 YN L VAL=IF{@dp.student.thru.date^XX IF{@.today'>XX "Y";
VAL="N"}}
dp.student.thru.date 8 DATE L *JY[jy]DP[jyDP]|6
dp.text.dimensions 10 FREE L VAL=Q(17,21,84)
dp.text.editor 0 FREE L VAL=IF{@dp.text.dimensions^{T,B,W},%PP.TEXT.editor(^@d
VAL=ependent.comments,T,B,W,0,"D"),""}
dp.text.number 8 PINT R PP.TEXT *JY[jy]DP[jyDP]C
dp.text.view 0 FREE L VAL=@dp.text.dimensions^{T,B,W},%Z.view.text(^@Root(@P
VAL=P.TEXT.lines[@dp.text.number]),T,B-T+1,W,Q(@Z.colo
VAL=r.labels.2nd,@Z.color.data.2nd),"",T-1,"","",1)&""
Ì € i 2
pp.empl.supplemental.earn.file (earnings)
[employee, earning.counter]
*JY[jy]E[jyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
earning.counter 2 INT R jyEC
earning 8 PDEC L PP.EARN *JY[jy]E[jyEC]|0
earning.active 1 YN L *JY[jy]E[jyEC]|1
earning.created.by.flex 1 YN L *JY[jy]E[jyEC]|4
earning.expression 30 FREE L *JY[jy]E[jyEC]|2
earning.freeze 1 YN L *JY[jy]E[jyEC]|5
earning.wexpr 60 FREE L *JY[jy]E[jyEC]|3
Ì € i 2
pp.per.eff.base.rates (eff.base.rates)
[employee, eff.date]
*JY[jy]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
eff.date 8 DATE L jefd
eff.rate 8 RATE R *JY[jy]13[jefd]|1
eff.reason 10 FREE L PP.REASON *JY[jy]13[jefd]|2
eff.step 2 PINT L *JY[jy]13[jefd]|0
Ì € i 2
pp.employee.health.and.safety (health.and.safety)
[employee, has.mnemonic]
*JY[jy]HS[jhs]
Field Name Len Dat Typ J DPM Offset/Local/VAL
has.mnemonic 8 FREE L PP.HAS jhs
has.active 1 YN L *JY[jy]HS[jhs]|0
has.last.instr.date 8 DATE L *JY[jy]HS[jhs]|1
has.next.instr.date 8 DATE L *JY[jy]HS[jhs]|2
has.num.ceu 6 DEC2 L *JY[jy]HS[jhs]|3
has.num.cmu 6 DEC2 L *JY[jy]HS[jhs]|4
has.print.comments 0 FREE L VAL=%PP.TEXT.fr.print(^@health.and.safety.comment,@has
VAL=.text.number^c.number)
Ì € i 2
pp.emp.health.and.safety.query (health.and.safety.queries)
[employee,has.mnemonic, has.cd.query]
*JY[jy]HS[jhs]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
has.cd.query 10 FREE L MIS.QUERY ggv
has.cd.response 75 QRY.RESP L *JY[jy]HS[jhs]CD[ggv]|0
Ì € i 2
health.and.safety.mult.queries (health.and.safety.mul.qry)
[employee,has.mnemonic,has.cd.query, has.cdm.seq.no]
*JY[jy]HS[jhs]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
has.cdm.seq.no 3 PINT R ggvN
has.cdm.response 75 QRY.RESP L *JY[jy]HS[jhs]CD[ggv]M[ggvN]|0
Ì € i 2
pp.empl.sec.jobs (sec.jobs)
[employee, sec.job.counter]
*JY[jy]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 *JY[jy]SJ[jySC]|0
sec.job.contract 8 FREE L PP.CONTRACT *JY[jy]SJ[jySC]|4
sec.job.dept 15 FREE L MIS.GL.DEPT *JY[jy]SJ[jySC]|2
sec.job.hrs.percent 6 DEC3 R *JY[jy]SJ[jySC]|5
sec.job.pos.number 18 FREE L PP.POS *JY[jy]SJ[jySC]|6
sec.job.rate 8 RATE R *JY[jy]SJ[jySC]|1
sec.job.step 2 PINT L *JY[jy]SJ[jySC]|3
Ì € i 2
pp.per.sec.eff.rates (sec.eff.rates)
[employee,sec.job.counter, sec.eff.date]
*JY[jy]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 *JY[jy]SJ[jySC]SR[jefd]|1
sec.eff.step 2 PINT L *JY[jy]SJ[jySC]SR[jefd]|0
Ì € i 2
pp.emp.secondary.jobs (secondary.jobs)
[employee, secondary.job]
*JY[jy]8[jj]
Field Name Len Dat Typ J DPM Offset/Local/VAL
secondary.job 10 FREE L PP.JOB jj
secondary.dept 15 FREE L MIS.GL.DEPT *JY[jy]8[jj]|2
secondary.rate 8 RATE R *JY[jy]8[jj]|1
Ì € i 2
pp.emp.skills (skills)
[employee, skill]
*JY[jy]4[jk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
skill 10 FREE L PP.SKILL jk
Ì € i 2
pp.emp.withholdings.file (withholdings)
[employee, whold]
*JY[jy]10[jw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
whold 8 PDEC L PP.WHOLD jw
whold.account.number 14 FREE L *JY[jy]10[jw]|1
whold.active 1 YN L *JY[jy]10[jw]|0
whold.arrears 1 YN L *JY[jy]10[jw]|12
whold.balance 8 MONEY R *JY[jy]10[jw]|4
whold.bond.price 8 MONEY R *JY[jy]10[jw]|5
whold.created.by.flex 1 YN L *JY[jy]10[jw]|11
whold.employee.wexpr 60 FREE L *JY[jy]10[jw]|7
whold.employer.expr 30 FREE L *JY[jy]10[jw]|8
whold.employer.wexpr 60 FREE L *JY[jy]10[jw]|9
whold.expressions 30 FREE L *JY[jy]10[jw]|6
whold.from.date 8 DATE L *JY[jy]10[jw]|2
whold.more.below 1 FREE L *JY[jy]10[jw]|10
whold.thru.date 8 DATE L *JY[jy]10[jw]|3
Ì i 2
pp.per.positions (positions)
[indexed.position]
?JYPO[jp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
indexed.position 18 FREE L PP.POS jp
Ì € i 2
pp.per.position.employees (position.employees)
[indexed.position, pos.sort.name,pos.employee]
?JYPO[jp,jySN,jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pos.sort.name 26 FREE L jySN
pos.employee 42 URN L PP.PER jy
pos.fte 6 DEC R ?JYPO[jp,jySN,jy]
Ì i 2
pp.per.transactions (transactions)
[employee.txn]
:JYTX[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee.txn 42 URN L PP.PER jy
Ì € i 2
pp.per.add.earn.txns (add.earn.txns)
[employee.txn, atxn.earning,atxn.date,atxn.time]
:JYTX[jy]14[je,jyAED,jyAET]
Field Name Len Dat Typ J DPM Offset/Local/VAL
atxn.earning 8 PDEC L PP.EARN je
atxn.date 8 DATE L jyAED
atxn.time 5 TIME L jyAET
atxn.amount 8 SMONEY R :JYTX[jy]14[je,jyAED,jyAET]|1
atxn.balance 8 SMONEY R :JYTX[jy]14[je,jyAED,jyAET]|2
atxn.tc.pointer 8 URN L PP.PAY :JYTX[jy]14[je,jyAED,jyAET]|3
atxn.type 1 FREE L :JYTX[jy]14[je,jyAED,jyAET]|0
Ì € i 2
pp.per.add.wholding.txns (add.wholding.txns)
[employee.txn, add.wtxn.whold,add.wtxn.date,add.wtxn.time]
:JYTX[jy]15[jw,jyAWD,jyAWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.wtxn.whold 8 PDEC L PP.WHOLD jw
add.wtxn.date 8 DATE L jyAWD
add.wtxn.time 5 TIME L jyAWT
add.wtxn.ee.amount 8 SMONEY R :JYTX[jy]15[jw,jyAWD,jyAWT]|1
add.wtxn.ee.balance 8 SMONEY R :JYTX[jy]15[jw,jyAWD,jyAWT]|3
add.wtxn.er.amount 8 SMONEY R :JYTX[jy]15[jw,jyAWD,jyAWT]|2
add.wtxn.er.balance 8 SMONEY R :JYTX[jy]15[jw,jyAWD,jyAWT]|4
add.wtxn.tc.pointer 8 URN L PP.PAY :JYTX[jy]15[jw,jyAWD,jyAWT]|5
add.wtxn.type 1 FREE L :JYTX[jy]15[jw,jyAWD,jyAWT]|0
Ì € i 2
pp.per.audit.trail (audit.trail)
[employee.txn, audit.date,audit.time]
:JYTX[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.addr1 26 FREE L :JYTX[jy]0[jyMD,jyMT]0|5
audit.addr2 26 FREE L :JYTX[jy]0[jyMD,jyMT]0|6
audit.addr3 26 FREE L :JYTX[jy]0[jyMD,jyMT]0|7
audit.base.rate 8 RATE R :JYTX[jy]0[jyMD,jyMT]7|7
audit.base.rate.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]7|9
audit.base.rate.reason 10 FREE L PP.REASON :JYTX[jy]0[jyMD,jyMT]7|8
audit.contract 8 FREE L PP.CONTRACT :JYTX[jy]0[jyMD,jyMT]1|17
audit.dd.account.number 17 FREE L :JYTX[jy]0[jyMD,jyMT]7|13
audit.dd.account.type 1 CHOICE L :JYTX[jy]0[jyMD,jyMT]7|14
audit.dd.bank 17 FREE L PP.BANK :JYTX[jy]0[jyMD,jyMT]7|12
audit.dept 15 FREE L MIS.GL.DEPT :JYTX[jy]0[jyMD,jyMT]1|3
audit.disability 1 YN L :JYTX[jy]0[jyMD,jyMT]M1|0
audit.eeoc 18 CHOICE L :JYTX[jy]0[jyMD,jyMT]0|13
audit.empl.type 5 FREE L PP.TYPE :JYTX[jy]0[jyMD,jyMT]1|0
audit.empl.type.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]1|22
audit.hours.per.period 6 DEC3 R :JYTX[jy]0[jyMD,jyMT]1|6
audit.hrs.per.period.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]1|23
audit.job.code 10 FREE L PP.JOB :JYTX[jy]0[jyMD,jyMT]1|2
audit.next.review.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]1|13
audit.next.review.reason 10 FREE L PP.REASON :JYTX[jy]0[jyMD,jyMT]1|14
audit.payroll 8 FREE L PP.PAYROLL :JYTX[jy]0[jyMD,jyMT]7|0
audit.pension 1 YN L :JYTX[jy]0[jyMD,jyMT]7|24
audit.pop.grp 8 FREE L PP.POPUL :JYTX[jy]0[jyMD,jyMT]M1|1
audit.position.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]1|24
audit.position.number 18 FREE L PP.POS :JYTX[jy]0[jyMD,jyMT]1|1
audit.reserved.position 18 FREE L PP.POS :JYTX[jy]0[jyMD,jyMT]1|25
audit.roe.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]1|21
audit.sex 1 CHOICE L :JYTX[jy]0[jyMD,jyMT]0|12
audit.shift 1 PINT R :JYTX[jy]0[jyMD,jyMT]1|4
audit.shift.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]1|5
audit.status 7 CHOICE L :JYTX[jy]0[jyMD,jyMT]1|7
audit.status.date 8 DATE L :JYTX[jy]0[jyMD,jyMT]1|8
audit.status.reason 10 FREE L PP.REASON :JYTX[jy]0[jyMD,jyMT]1|9
audit.statutory 1 YN L :JYTX[jy]0[jyMD,jyMT]7|26
audit.step 2 PINT R :JYTX[jy]0[jyMD,jyMT]7|6
audit.t4.cpp.qpp.exempt 1 YN L :JYTX[jy]0[jyMD,jyMT]6|0
audit.t4.ei.exempt 1 YN L :JYTX[jy]0[jyMD,jyMT]6|1
audit.t4.employment.code 2 CHOICE L :JYTX[jy]0[jyMD,jyMT]6|4
audit.t4.ppip.exempt 1 YN L :JYTX[jy]0[jyMD,jyMT]6|7
audit.t4.stock.code 2 PINT R :JYTX[jy]0[jyMD,jyMT]6|5
audit.t4a.business.no 15 FREE L :JYTX[jy]0[jyMD,jyMT]6|6
audit.third.party.sick 1 YN L :JYTX[jy]0[jyMD,jyMT]7|29
audit.user 10 FREE L MIS.USER :JYTX[jy]0[jyMD,jyMT]
audit.zip.code 9 FREE L :JYTX[jy]0[jyMD,jyMT]0|8
Ì € i 2
audit.eff.base.rates (audit.eff.base.rates)
[employee.txn,audit.date,audit.time, audit.eff.date]
:JYTX[jy]0[jyMD,jyMT]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 :JYTX[jy]0[jyMD,jyMT]13[jefd]|1
audit.eff.reason 10 FREE L PP.REASON :JYTX[jy]0[jyMD,jyMT]13[jefd]|2
audit.eff.step 2 PINT R :JYTX[jy]0[jyMD,jyMT]13[jefd]|0
Ì € i 2
audit.sec.jobs (audit.sec.jobs)
[employee.txn,audit.date,audit.time, audit.sec.job.counter]
:JYTX[jy]0[jyMD,jyMT]8[jySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.sec.job.counter 2 PINT R jySC
audit.sec.job 10 FREE L PP.JOB :JYTX[jy]0[jyMD,jyMT]8[jySC]|0
audit.sec.job.contract 8 FREE L PP.CONTRACT :JYTX[jy]0[jyMD,jyMT]8[jySC]|4
audit.sec.job.dept 15 FREE L MIS.GL.DEPT :JYTX[jy]0[jyMD,jyMT]8[jySC]|2
audit.sec.job.hrs.percent 6 DEC3 R :JYTX[jy]0[jyMD,jyMT]8[jySC]|5
audit.sec.job.pos.number 18 FREE L PP.POS :JYTX[jy]0[jyMD,jyMT]8[jySC]|6
audit.sec.job.rate 8 RATE R :JYTX[jy]0[jyMD,jyMT]8[jySC]|1
audit.sec.job.step 2 PINT R :JYTX[jy]0[jyMD,jyMT]8[jySC]|3
Ì € i 2
pp.per.audit.trail.mult.values (audit.trail.mult.values)
[employee.txn,audit.date,audit.time, audit.subscript.1,audit.subscript.2]
:JYTX[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 :JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS]
audit.value.src 1 CHOICE L :JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS]S|0
Ì € i 2
audit.trail.mult.values.4 (audit.trail.mult.values.4)
[employee.txn,audit.date,audit.time,audit.subscript.1,audit.subscript.2, audit.subscript.3,audit.subscript.4]
:JYTX[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 :JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4]
Ì € i 2
audit.trail.mult.values.6 (audit.trail.mult.values.6)
[employee.txn,audit.date,audit.time,audit.subscript.1,audit.subscript.2,audit.subscript.3,audit.subscript.4, audit.subs
:JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4,jyMS5,jyMS6]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript.5 50 FREE L jyMS5
audit.subscript.6 50 FREE L jyMS6
audit.value.6 200 FREE L :JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4,jyMS5,jyMS6]
Ì € i 2
pp.per.audit.trail.values (audit.trail.values)
[employee.txn,audit.date,audit.time, audit.subscript]
:JYTX[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 :JYTX[jy]0[jyMD,jyMT,jyMS]
Ì € i 2
pp.per.benefit.transactions (benefit.transactions)
[employee.txn, btxn.earning,btxn.date,btxn.time]
:JYTX[jy]11[je,jyBD,jyBT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
btxn.earning 8 PDEC L PP.EARN je
btxn.date 8 DATE L jyBD
btxn.time 5 TIME L jyBT
btxn.accrued.balance 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|9
btxn.adjustment 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|7
btxn.avail.balance 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|8
btxn.award 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|5
btxn.benefit.freeze 1 YN L :JYTX[jy]11[je,jyBD,jyBT]|12
btxn.earned 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|3
btxn.earned.print 8 SDEC3 R VAL=(@btxn.earned+@btxn.award)
btxn.edit.reason 10 FREE L PP.REASON :JYTX[jy]11[je,jyBD,jyBT]|13
btxn.hour.basis 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|2
btxn.occurance 3 PINT R :JYTX[jy]11[je,jyBD,jyBT]|14
btxn.plan 8 FREE L :JYTX[jy]11[je,jyBD,jyBT]|0
btxn.taken 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|4
btxn.tc.pointer 8 URN L PP.PAY :JYTX[jy]11[je,jyBD,jyBT]|10
btxn.transfer 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|6
btxn.type 1 CHOICE L :JYTX[jy]11[je,jyBD,jyBT]|1
btxn.zero.avail.first 8 SDEC3 R :JYTX[jy]11[je,jyBD,jyBT]|11
Ì € i 2
pp.per.contr.hrs.transactions (contr.hrs.transactions)
[employee.txn, ctxn.date,ctxn.time]
:JYTX[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 :JYTX[jy]13[jyCD,jyCT]|1
ctxn.ben.hrs.balance 10 SDEC3 R :JYTX[jy]13[jyCD,jyCT]|2
ctxn.rvw.hrs 8 SDEC3 R :JYTX[jy]13[jyCD,jyCT]|3
ctxn.rvw.hrs.balance 10 SDEC3 R :JYTX[jy]13[jyCD,jyCT]|4
ctxn.type 1 CHOICE L :JYTX[jy]13[jyCD,jyCT]|0
Ì € i 2
pp.per.whold.transactions (whold.transactions)
[employee.txn, wtxn.whold,wtxn.date,wtxn.time]
:JYTX[jy]12[jw,jyWD,jyWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wtxn.whold 8 PDEC L PP.WHOLD jw
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 :JYTX[jy]12[jw,jyWD,jyWT]|7
wtxn.balance 8 SMONEY R :JYTX[jy]12[jw,jyWD,jyWT]|3
wtxn.bond.amount.pur 8 SMONEY R :JYTX[jy]12[jw,jyWD,jyWT]|5
wtxn.bond.num.pur 4 SINT R :JYTX[jy]12[jw,jyWD,jyWT]|4
wtxn.manual.amount 8 SMONEY R :JYTX[jy]12[jw,jyWD,jyWT]|2
wtxn.sub.amount 8 SMONEY R VAL=(@wtxn.manual.amount-@wtxn.whold.amount)
wtxn.tc.pointer 8 URN L PP.PAY :JYTX[jy]12[jw,jyWD,jyWT]|6
wtxn.type 1 CHOICE L :JYTX[jy]12[jw,jyWD,jyWT]|0
wtxn.whold.amount 8 SMONEY R :JYTX[jy]12[jw,jyWD,jyWT]|1
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
pp.per.activity.x [audit.date,employee]
activity.x ?JYA[jyMD,jy]
pp.per.add.earn.txn.x [atxn.date,atxn.earning,atxn.time,employee.txn]
add.earn.txn.x ?JYAEX[jyAED,je,jyAET,jy]
pp.per.add.whold.txn.x [add.wtxn.date,add.wtxn.whold,add.wtxn.time,employee.txn]
add.whold.txn.x ?JYAWX[jyAWD,jw,jyAWT,jy]
pp.per.arrears.activity.x [wtxn.date,wtxn.whold,wtxn.time,employee.txn]
arrears.activity.x ?JYAX[jyWD,jw,jyWT,jy]
pp.employee.att.template.index [att.template,employee]
att.template.x ?JYAT[jtx,jy]
pp.per.balances.activity.x [wtxn.date,wtxn.whold,wtxn.time,employee.txn]
balances.activity ?JYBX[jyWD,jw,jyWT,jy]
pp.empl.cobra.name.x [sort.name,cobra.number]
cobra.name.x ?JYCN[jySN,jyCB]
pp.employee.contract.index [contract,sort.name,employee]
contract.name.x ?JYUN[ju,jySN,jy]
pp.employee.dept.name.index [dept,sort.name,employee]
dept.name.x ?JYDN[gd,jySN,jy]
pp.per.ee.dt.letter.x [employee,print.date,letter,printing]
ee.dt.letter.x *JYEL[jy,letPD,let,letID]
pp.per.file.x [activity.date,employee]
file.x ?JYC[jyAD,jy]
pp.per.id.x [id,employee]
id.x ?JYI[jyI,jy]
pp.employee.name.index [sort.name,employee]
name.x ?JYN[jySN,jy]
pp.employee.number.index [number,employee]
number.x ?JYR[jyN,jy]
pp.employee.payroll.index [payroll,dept,sort.name,employee]
payroll.dept.name.x ?JYPDN[ja,gd,jySN,jy]
pp.per.payroll.dept.x [payroll,dept,employee]
payroll.dept.x ?JYPD[ja,gd,jy]
pp.employee.position.index [position.number,sort.name,employee]
position.x ?JYPO[jp,jySN,jy]
pp.empl.postal.code.index [postal.country,postal.code,sort.name,employee]
postal.code.x ?JYPX[pcnty,jyPC,jySN,jy]
pp.employee.reserved.pos.index [reserved.position,sort.name,employee]
reserved.pos.x ?JYRPO[jp,jySN,jy]
pp.employee.ss.si.index [ss.number] = employee
ss.x ?JYS[jySS]
pp.employee.withholding.index [tax.year,payroll,whold,sort.name,employee]
tax.whold.x ?JYTW[jyTY,ja,jw,jySN,jy]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |