Ì i 2
expense.to.periods
[exp.activity.date]
*(JY)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 *(JY)JYGLD[jyGLD]
Ì i 2
main
[employee]
$(JY)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[jy]|5
addr2 26 FREE L $(JY)JY[jy]|6
addr3 26 FREE L $(JY)JY[jy]|7
address1 30 FREE L $(JY)JY[jy]0|0
address2 30 FREE L $(JY)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[jy]1|12
being.paid 1 YN L $(JY)JY[jy]1|10
cd.screen.1 15 FREE L MIS.SCREEN VAL=@PP.TYPE.customer.def.screen[@empl.type]
cd.screen.3 15 FREE L MIS.SCREEN VAL=@PP.TYPE.customer.def.screen.2[@empl.type]
city 18 FREE L $(JY)JY[jy]0|2
cobra.number 42 URN L PP.PER.COBRA $(JY)JY[jy]M1|6
date.of.birth 10 BDATE L $(JY)JY[jy]|11
dd.account.number 17 FREE L $(JY)JY[jy]7|13
dd.account.type 1 CHOICE L $(JY)JY[jy]7|14
dd.bank 17 FREE L PP.BANK $(JY)JY[jy]7|12
dd.notification.account 17 FREE L $(JY)JY[jy]7|16
dd.notification.bank 17 FREE L PP.BANK $(JY)JY[jy]7|15
dd.notification.date 8 DATE L $(JY)JY[jy]7|18
dd.notification.type 1 CHOICE L $(JY)JY[jy]7|17
dept.access.ok 1 FREE L VAL=%PP.EMP.dept.access.ok(employee)
disability 1 YN L $(JY)JY[jy]M1|0
eeoc 18 CHOICE L $(JY)JY[jy]|13
email.addr 40 FREE L $(JY)JY[jy]M1|9
emergency.phone 18 PHONE L $(JY)JY[jy]|10
emp.user.mnemonic 10 FREE L MIS.USER $(JY)JY[jy]M1|12
empl.type 5 FREE L PP.TYPE $(JY)JY[jy]1|0
empl.type.date 8 DATE L $(JY)JY[jy]1|22
employee.picture 1 BMP L VAL=^@Appl.file.prefix(PP,PICRAD)[@PP.PER.picture.fold
VAL=er_.._PP.PER.employee_".JPG"]
evaluation.date 8 DATE L $(JY)JY[jy]1|16
exempt 1 YN L $(JY)JY[jy]7|5
health.insurance 1 YN L $(JY)JY[jy]M1|3
hire.date 8 DATE L $(JY)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[jy]|9
marital.status 10 FREE L MIS.MAR.STATUS $(JY)JY[jy]M1|4
marital.status.date 8 DATE L $(JY)JY[jy]M1|5
medicare.date 8 DATE L $(JY)JY[jy]M1|2
month.and.day.of.birth 4 PINT R VAL=(@PP.PER.date.of.birth%3)
name 26 NAME L $(JY)JY[jy]|2
next.review.date 8 DATE L $(JY)JY[jy]1|13
next.review.reason 10 FREE L PP.REASON $(JY)JY[jy]1|14
number 14 FREE L $(JY)JY[jy]|4
old.base.rate 8 RATE R $(JY)JY[jy]7|7
old.base.rate.date 8 DATE L $(JY)JY[jy]7|9
old.base.rate.reason 10 FREE L PP.REASON $(JY)JY[jy]7|8
old.benefit.contr.hours 10 SDEC3 R $(JY)JY[jy]1|18
old.benefit.ctr.hours.srt 10 SDEC3 R VAL=(1000000-@benefit.contr.hours:3D)
old.contract 8 FREE L PP.CONTRACT $(JY)JY[jy]1|17
old.dd.proration.method 1 CHOICE L $(JY)JY[jy]7|25
old.de6.wage.plan 1 CHOICE L $(JY)JY[jy]|17
old.deceased 1 YN L $(JY)JY[jy]7|23
old.dept 15 FREE L MIS.GL.DEPT $(JY)JY[jy]1|3
old.dept.access.ok 1 FREE L VAL=%MIS.GL.DEPT.user.ok(@PP.PER.dept)
old.exclude.from.de6 1 YN L $(JY)JY[jy]|16
old.fit.exemptions 2 INT L $(JY)JY[jy]7|4
old.fit.tax.status 1 CHOICE L $(JY)JY[jy]7|3
old.flsa.per.week.calc 1 YN L $(JY)JY[jy]|15
old.fmla.start 4 INT R $(JY)JY[jy]M1|13
old.hours.per.period 6 DEC3 R $(JY)JY[jy]1|6
old.hrs.per.period.date 8 DATE L $(JY)JY[jy]1|23
old.incomplete.pay.fields 1 YN L $(JY)JY[jy]7|19
old.insurance.coverage 40 FREE L $(JY)JY[jy]7|20
old.job.code 10 FREE L PP.JOB $(JY)JY[jy]1|2
old.monthly.salary 8 MONEY R VAL=%PP.PER.monthly.salary(PP.PER.employee)
old.ont.vac.calc.thru 8 DATE L $(JY)JY[jy]7|22
old.outside.agency 1 YN L $(JY)JY[jy]|14
old.payroll 8 FREE L PP.PAYROLL $(JY)JY[jy]7|0
old.pension 1 YN L $(JY)JY[jy]7|24
old.position.date 8 DATE L $(JY)JY[jy]1|24
old.position.number 18 FREE L PP.POS $(JY)JY[jy]1|1
old.qual.diff 8 RATE R $(JY)JY[jy]7|11
old.reserved.position 18 FREE L PP.POS $(JY)JY[jy]1|25
old.review.contr.hours 10 SDEC3 R $(JY)JY[jy]1|19
old.review.ctr.hours.srt 10 SDEC3 R VAL=(1000000-@review.contr.hours:3D)
old.shift 1 PINT L $(JY)JY[jy]1|4
old.shift.date 8 DATE L $(JY)JY[jy]1|5
old.shift.diff.amount 8 RATE R VAL=%PP.PER.diff.amount(employee)
old.sit.exemptions 2 INT L $(JY)JY[jy]7|2
old.sit.tax.status 1 CHOICE L $(JY)JY[jy]7|1
old.sort.base.rate 8 RATE R VAL=(10000-@base.rate)
old.statutory 1 YN L $(JY)JY[jy]7|26
old.step 2 PINT L $(JY)JY[jy]7|6
old.step.grade.base.hi 8 PDEC R VAL=%PP.EMP.step.grade.base(employee,"HI")
old.step.grade.base.lo 8 PDEC R VAL=%PP.EMP.step.grade.base(employee,"LO")
old.t4.cpp.qpp.exempt 1 YN L $(JY)JY[jy]6|0
old.t4.ei.exempt 1 YN L $(JY)JY[jy]6|1
old.t4.employment.code 2 CHOICE L $(JY)JY[jy]6|4
old.t4.stock.code 2 CHOICE L $(JY)JY[jy]6|5
old.t4a.business.no 15 FREE L $(JY)JY[jy]6|6
old.tax.year 4 YEAR L $(JY)JY[jy]7|21
old.tc.hours.pro.elig 1 YN L $(JY)JY[jy]M1|10
old.tc.hours.pro.pri.pct 6 DEC3 R $(JY)JY[jy]M1|11
old.td1.exemption 8 MONEY R $(JY)JY[jy]7|10
old.td1.exemption.prov 8 MONEY R $(JY)JY[jy]7|27
old.third.party.sick 1 YN L $(JY)JY[jy]7|28
old.yearly.salary 9 MONEY R VAL=%PP.PER.yearly.salary(PP.PER.employee)
other.country 10 FREE L $(JY)JY[jy]0|6
other.country.choice 6 CHOICE L $(JY)JY[jy]0|5
picture.aspect 3 FREE L $(JY)JY[jy]M1|14
picture.date 8 DATE L $(JY)JY[jy]M1|8
picture.folder 4 FREE L $(JY)JY[jy]M1|7
pop.grp 8 FREE L PP.POPUL $(JY)JY[jy]M1|1
postal.code 10 FREE L $(JY)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.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.3 0 FREE L VAL=IF{@cd.screen.3 %MIS.SCREEN.print(@cd.screen.3,^@c
VAL=ustomer.defined.fields,1,0),""}
roe.date 8 DATE L $(JY)JY[jy]1|21
seniority.date 8 DATE L $(JY)JY[jy]1|15
sex 1 CHOICE L $(JY)JY[jy]|12
si.number 12 FREE L $(JY)JY[jy]|1
si.number.govt 11 FREE L VAL=(@PP.PER.si.number$11)
sort.name 26 NAME L $(JY)JY[jy]|3
ss.number 12 FREE L $(JY)JY[jy]|1
ss.number.govt 11 FREE L VAL=(@PP.PER.ss.number$11)
state 2 FREE L $(JY)JY[jy]0|3
status 7 CHOICE L $(JY)JY[jy]1|7
status.date 8 DATE L $(JY)JY[jy]1|8
status.reason 10 FREE L PP.REASON $(JY)JY[jy]1|9
t4.country 10 FREE L $(JY)JY[jy]6|3
t4.country.choice 5 CHOICE L $(JY)JY[jy]6|2
Ì € i 2
customer.defined.queries
[employee, cd.query]
$(JY)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[jy]CD[ggv]|0
cd.yn.comment 75 FREE L $(JY)JY[jy]CD[ggv]|5
Ì € i 2
customer.def.mult.queries
[employee,cd.query, cdm.seq.no]
$(JY)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[jy]CD[ggv]M[ggvN]|0
Ì € i 2
dependents
[employee, dp.number]
$(JY)JY[jy]DP[jyDP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dp.number 2 PINT R jyDP
dp.active 1 YN L $(JY)JY[jy]DP[jyDP]|5
dp.address1 30 FREE L $(JY)JY[jy]DP[jyDP]0|0
dp.address2 30 FREE L $(JY)JY[jy]DP[jyDP]0|1
dp.age 3 PINT R VAL=%Z.age(@dp.birthdate,@.today)^XX$L(XX,"Y")?0N!0
dp.birthdate 10 BDATE L $(JY)JY[jy]DP[jyDP]|1
dp.city 18 FREE L $(JY)JY[jy]DP[jyDP]0|2
dp.cobra.number 42 URN L PP.PER.COBRA $(JY)JY[jy]DP[jyDP]|11
dp.desc 23 FREE L VAL=@MIS.RELAT.name[@dp.relationship]$23
dp.email.addr 40 FREE L $(JY)JY[jy]DP[jyDP]|14
dp.emergency.phone 18 PHONE L $(JY)JY[jy]DP[jyDP]|8
dp.home.phone 18 PHONE L $(JY)JY[jy]DP[jyDP]|7
dp.marital.status 10 FREE L MIS.MAR.STATUS $(JY)JY[jy]DP[jyDP]|9
dp.marital.status.date 8 DATE L $(JY)JY[jy]DP[jyDP]|10
dp.medicare.date 8 DATE L $(JY)JY[jy]DP[jyDP]|12
dp.name 26 NAME L $(JY)JY[jy]DP[jyDP]|0
dp.other.country 10 FREE L $(JY)JY[jy]DP[jyDP]0|6
dp.other.country.choice 6 CHOICE L $(JY)JY[jy]DP[jyDP]0|5
dp.postal.code 10 FREE L $(JY)JY[jy]DP[jyDP]0|4
dp.relationship 10 FREE L MIS.RELAT $(JY)JY[jy]DP[jyDP]|2
dp.si.number 12 FREE L $(JY)JY[jy]DP[jyDP]|3
dp.sort.name 26 NAME L $(JY)JY[jy]DP[jyDP]|4
dp.ss.number 12 FREE L $(JY)JY[jy]DP[jyDP]|3
dp.state 2 FREE L $(JY)JY[jy]DP[jyDP]0|3
dp.student 1 YN L VAL=IF{@dp.student.thru.date<@.today "N";"Y"}
dp.student.thru.date 8 DATE L $(JY)JY[jy]DP[jyDP]|6
dp.text.edit 1 YN L $(JY)JY[jy]DP[jyDP]|13
Ì € i 2
dependent.comments
[employee,dp.number, dp.text.q]
$(JY)JY[jy]DP[jyDP]C[jyDPC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dp.text.q 8 PINT R jyDPC
dp.text.line 92 TEXT L $(JY)JY[jy]DP[jyDP]C[jyDPC]
Ì € i 2
old.benefit.balances
[employee, old.benefit]
$(JY)JY[jy]9[jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.benefit 8 PDEC L PP.EARN jde
old.benefit.accr.balance 9 SDEC3 R $(JY)JY[jy]9[jde]|3
old.benefit.avail.balance 9 SDEC3 R $(JY)JY[jy]9[jde]|2
old.benefit.edit.reason 10 FREE L PP.REASON $(JY)JY[jy]9[jde]|8
old.benefit.freeze 1 YN L $(JY)JY[jy]9[jde]|5
old.benefit.freeze.date 8 DATE L $(JY)JY[jy]9[jde]|6
old.benefit.frze.cntr.hrs 8 DEC3 R $(JY)JY[jy]9[jde]|7
old.benefit.occurance 3 PINT R $(JY)JY[jy]9[jde]|9
old.benefit.occurance.yr 4 YEAR L $(JY)JY[jy]9[jde]|10
old.benefit.plan 8 FREE L $(JY)JY[jy]9[jde]|1
old.benefit.update.gl 1 YN L $(JY)JY[jy]9[jde]|4
Ì € i 2
old.dd.proration
[employee, old.dd.pro.counter]
$(JY)JY[jy]2[mpC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.dd.pro.counter 2 INT R mpC
old.dd.pro.account.number 17 FREE L $(JY)JY[jy]2[mpC]|2
old.dd.pro.account.type 1 CHOICE L $(JY)JY[jy]2[mpC]|3
old.dd.pro.bank 17 FREE L PP.BANK $(JY)JY[jy]2[mpC]|1
old.dd.pro.note.account 17 FREE L $(JY)JY[jy]2[mpC]|6
old.dd.pro.note.bank 17 FREE L PP.BANK $(JY)JY[jy]2[mpC]|5
old.dd.pro.note.date 8 DATE L $(JY)JY[jy]2[mpC]|8
old.dd.pro.note.type 1 CHOICE L $(JY)JY[jy]2[mpC]|7
old.dd.pro.type 7 CHOICE L $(JY)JY[jy]2[mpC]|0
old.dd.pro.value 10 FREE L $(JY)JY[jy]2[mpC]|4
Ì € i 2
old.earnings
[employee, old.earning.counter]
$(JY)JY[jy]E[jyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.earning.counter 2 INT R jyEC
old.earning 8 PDEC L PP.EARN $(JY)JY[jy]E[jyEC]|0
old.earning.active 1 YN L $(JY)JY[jy]E[jyEC]|1
old.earning.created.flex 1 YN L $(JY)JY[jy]E[jyEC]|4
old.earning.expression 30 FREE L $(JY)JY[jy]E[jyEC]|2
old.earning.freeze 1 YN L $(JY)JY[jy]E[jyEC]|5
old.earning.wexpr 60 FREE L $(JY)JY[jy]E[jyEC]|3
Ì € i 2
old.eff.base.rates
[employee, old.eff.date]
$(JY)JY[jy]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.eff.date 8 DATE L jefd
old.eff.rate 8 RATE R $(JY)JY[jy]13[jefd]|1
old.eff.reason 10 FREE L PP.REASON $(JY)JY[jy]13[jefd]|2
old.eff.step 2 PINT L $(JY)JY[jy]13[jefd]|0
Ì € i 2
old.sec.jobs
[employee, old.sec.job.counter]
$(JY)JY[jy]SJ[jySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.sec.job.counter 2 INT R jySC
old.sec.job 10 FREE L PP.JOB $(JY)JY[jy]SJ[jySC]|0
old.sec.job.contract 8 FREE L PP.CONTRACT $(JY)JY[jy]SJ[jySC]|5
old.sec.job.dept 15 FREE L MIS.GL.DEPT $(JY)JY[jy]SJ[jySC]|2
old.sec.job.hrs.percent 6 DEC3 R $(JY)JY[jy]SJ[jySC]|3
old.sec.job.rate 8 RATE R $(JY)JY[jy]SJ[jySC]|1
old.sec.job.step 2 PINT L $(JY)JY[jy]SJ[jySC]|4
Ì € i 2
old.sec.eff.rates
[employee,old.sec.job.counter, old.sec.eff.date]
$(JY)JY[jy]SJ[jySC]SR[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.sec.eff.date 8 DATE L jefd
old.sec.eff.rate 8 RATE R $(JY)JY[jy]SJ[jySC]SR[jefd]|1
old.sec.eff.step 2 PINT L $(JY)JY[jy]SJ[jySC]SR[jefd]|0
Ì € i 2
old.withholdings
[employee, old.whold]
$(JY)JY[jy]10[jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.whold 8 PDEC L PP.WHOLD jdw
old.whold.account.number 14 FREE L $(JY)JY[jy]10[jdw]|1
old.whold.active 1 YN L $(JY)JY[jy]10[jdw]|0
old.whold.balance 8 MONEY R $(JY)JY[jy]10[jdw]|4
old.whold.bond.price 8 MONEY R $(JY)JY[jy]10[jdw]|5
old.whold.created.by.flex 1 YN L $(JY)JY[jy]10[jdw]|11
old.whold.employee.wexpr 60 FREE L $(JY)JY[jy]10[jdw]|7
old.whold.employer.expr 30 FREE L $(JY)JY[jy]10[jdw]|8
old.whold.employer.wexpr 60 FREE L $(JY)JY[jy]10[jdw]|9
old.whold.expressions 30 FREE L $(JY)JY[jy]10[jdw]|6
old.whold.from.date 8 DATE L $(JY)JY[jy]10[jdw]|2
old.whold.more.below 1 FREE L $(JY)JY[jy]10[jdw]|10
old.whold.thru.date 8 DATE L $(JY)JY[jy]10[jdw]|3
Ì € i 2
skills
[employee, skill]
$(JY)JY[jy]4[gqk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
skill 10 FREE L MIS.SKILL gqk
sk.ceu 5 DEC2 R $(JY)JY[jy]4[gqk]|3
sk.cmu 5 DEC2 R $(JY)JY[jy]4[gqk]|5
sk.comment 30 FREE L $(JY)JY[jy]4[gqk]|1
sk.effective.date 8 DATE L $(JY)JY[jy]4[gqk]|2
sk.expiration.date 8 DATE L $(JY)JY[jy]4[gqk]|4
sk.use 1 FREE L $(JY)JY[jy]4[gqk]|0
Ì i 2
old.add.earn.ont.vac.temp
*(JY)JYZZO
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.add.earn.ont.from 8 DATE L *(JY)JYZZO|0
old.add.earn.ont.payroll 8 FREE L PP.PAYROLL *(JY)JYZZO|2
old.add.earn.ont.stars 1 FREE L *(JY)JYZZO|3
old.add.earn.ont.thru 8 DATE L *(JY)JYZZO|1
Ì € i 2
old.add.earn.ont.amounts
[old.add.earn.ont.employee]
*(JY)JYZZO["A",jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.add.earn.ont.employee 42 URN L PP.PER jy
old.add.earn.ont.acc 8 SMONEY R *(JY)JYZZO["A",jy]|2
old.add.earn.ont.due 8 SMONEY R *(JY)JYZZO["A",jy]|3
old.add.earn.ont.min 8 SMONEY R *(JY)JYZZO["A",jy]|0
old.add.earn.ont.rec 8 SMONEY R *(JY)JYZZO["A",jy]|1
old.add.earn.ont.star 1 FREE L *(JY)JYZZO["A",jy]|4
Ì i 2
old.additional.earnings
[old.add.earn.employee,old.add.earning]
*(JY)JYZZ[jy,jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.add.earn.employee 42 URN L PP.PER jy
old.add.earning 8 PDEC L PP.EARN jde
old.add.earn.amount 8 SMONEY R *(JY)JYZZ[jy,jde]
old.add.earn.wih.reg.whld 1 YN L *(JY)JYZZ[jy,jde]ORD|0
Ì i 2
old.additional.wholdings
[old.add.whold.employee,old.add.wholding]
*(JY)JYWW[jy,jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.add.whold.employee 42 URN L PP.PER jy
old.add.wholding 8 PDEC L PP.WHOLD jdw
old.add.whld.wih.reg.whld 1 YN L *(JY)JYWW[jy,jdw]ORD|0
old.add.whold.ee.amount 8 SMONEY R *(JY)JYWW[jy,jdw]|0
old.add.whold.er.amount 8 SMONEY R *(JY)JYWW[jy,jdw]|1
Ì i 2
old.benefit.adjustments
[old.ben.adj.date,old.ben.adj.payroll,old.ben.adj.employee,old.ben.adj.account]
*(JY)JYGL[jyGD,jdp,jy,ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.ben.adj.date 8 DATE L jyGD
old.ben.adj.payroll 8 FREE L PP.PAYROLL jdp
old.ben.adj.employee 42 URN L PP.PER jy
old.ben.adj.account 25 FREE L MIS.GL.ACCOUNT ga
old.ben.adj.cr 10 MONEY R *(JY)JYGL[jyGD,jdp,jy,ga]|1
old.ben.adj.dr 10 MONEY R *(JY)JYGL[jyGD,jdp,jy,ga]|0
old.ben.adj.hrs 8 SDEC3 R *(JY)JYGL[jyGD,jdp,jy,ga]|2
Ì i 2
old.input.eff.base.rates
[old.in.employee, old.in.eff.date]
/JY[jy]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.in.eff.date 8 DATE L jefd
old.in.eff.rate 8 RATE R /JY[jy]13[jefd]|1
old.in.eff.reason 10 FREE L PP.REASON /JY[jy]13[jefd]|2
old.in.eff.step 2 PINT L /JY[jy]13[jefd]|0
Ì i 2
old.input.sec.eff.rates
[old.in.employee,old.in.sec.job.counter, old.in.sec.eff.date]
/JY[jy]SJ[jySC]SR[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
old.in.sec.eff.date 8 DATE L jefd
old.in.sec.eff.rate 8 RATE R /JY[jy]SJ[jySC]SR[jefd]|1
old.in.sec.eff.step 2 PINT L /JY[jy]SJ[jySC]SR[jefd]|0
Ì i 2
transactions
[employee.txn]
*(JY)JYTX[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee.txn 42 URN L PP.PER jy
Ì € i 2
audit.trail
[employee.txn, audit.date,audit.time]
*(JY)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.address1 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|0
audit.address2 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|1
audit.adjusted.hire.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|12
audit.being.paid 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]1|10
audit.city 18 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|2
audit.cobra.number 42 URN L PP.PER.COBRA *(JY)JYTX[jy]0[jyMD,jyMT]M1|6
audit.date.of.birth 10 BDATE L *(JY)JYTX[jy]0[jyMD,jyMT]0|11
audit.disability 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]M1|0
audit.eeoc 18 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]0|13
audit.email.addr 40 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]M1|9
audit.emergency.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]0|10
audit.emp.user.mnemonic 10 FREE L MIS.USER *(JY)JYTX[jy]0[jyMD,jyMT]M1|12
audit.empl.type 5 FREE L PP.TYPE *(JY)JYTX[jy]0[jyMD,jyMT]1|0
audit.empl.type.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|22
audit.evaluation.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|16
audit.exempt 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|5
audit.health.insurance 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]M1|3
audit.hire.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|11
audit.home.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]0|9
audit.marital.status 10 FREE L MIS.MAR.STATUS *(JY)JYTX[jy]0[jyMD,jyMT]M1|4
audit.marital.status.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]M1|5
audit.medicare.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]M1|2
audit.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]0|2
audit.next.review.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|13
audit.next.review.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]1|14
audit.number 14 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]0|4
audit.other.country 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|6
audit.other.country.ch 6 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]5|5
audit.pop.grp 8 FREE L PP.POPUL *(JY)JYTX[jy]0[jyMD,jyMT]M1|1
audit.postal.code 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|4
audit.roe.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|21
audit.seniority.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|15
audit.sex 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]0|12
audit.si.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]0|1
audit.sort.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]0|3
audit.ss.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]0|1
audit.state 2 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|3
audit.status 7 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]1|7
audit.status.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|8
audit.status.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]1|9
audit.t4.country 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]6|3
audit.t4.country.choice 5 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]6|2
audit.user 10 FREE L MIS.USER *(JY)JYTX[jy]0[jyMD,jyMT]
xaudit.base.rate 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]7|7
xaudit.base.rate.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]7|9
xaudit.base.rate.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]7|8
xaudit.benefit.contr.hrs 10 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]1|18
xaudit.contract 8 FREE L PP.CONTRACT *(JY)JYTX[jy]0[jyMD,jyMT]1|17
xaudit.dd.pro.method 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]7|25
xaudit.de6.wage.plan 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]0|17
xaudit.deceased 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|23
xaudit.dept 15 FREE L MIS.GL.DEPT *(JY)JYTX[jy]0[jyMD,jyMT]1|3
xaudit.exclude.from.de6 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]0|16
xaudit.fit.exemptions 2 INT R *(JY)JYTX[jy]0[jyMD,jyMT]7|4
xaudit.fit.tax.status 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]7|3
xaudit.flsa.per.week.calc 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]0|15
xaudit.fmla.start 4 INT R *(JY)JYTX[jy]0[jyMD,jyMT]M1|13
xaudit.hours.per.period 6 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]1|6
xaudit.hrs.per.period.dat 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|23
xaudit.incomplete.pay.fld 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|19
xaudit.insurance.coverage 40 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]7|20
xaudit.job.code 10 FREE L PP.JOB *(JY)JYTX[jy]0[jyMD,jyMT]1|2
xaudit.ont.vac.calc.thru 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]7|22
xaudit.outside.agency 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]0|14
xaudit.payroll 8 FREE L PP.PAYROLL *(JY)JYTX[jy]0[jyMD,jyMT]7|0
xaudit.pension 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|24
xaudit.position.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|24
xaudit.position.number 18 FREE L PP.POS *(JY)JYTX[jy]0[jyMD,jyMT]1|1
xaudit.qual.diff 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]7|11
xaudit.reserved.position 18 FREE L PP.POS *(JY)JYTX[jy]0[jyMD,jyMT]1|25
xaudit.review.contr.hrs 10 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]1|19
xaudit.shift 1 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]1|4
xaudit.shift.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|5
xaudit.sit.exemptions 2 INT R *(JY)JYTX[jy]0[jyMD,jyMT]7|2
xaudit.sit.tax.status 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]7|1
xaudit.statutory 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|26
xaudit.step 2 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]7|6
xaudit.t4.cpp.qpp.exmp 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]6|0
xaudit.t4.ei.exempt 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]6|1
xaudit.t4.empl.code 2 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]6|4
xaudit.t4.stock.code 2 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]6|5
xaudit.t4a.business.no 15 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]6|6
xaudit.tax.year 4 YEAR L *(JY)JYTX[jy]0[jyMD,jyMT]7|21
xaudit.tc.hours.pro.elig 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]M1|10
xaudit.tc.hrs.pro.pri.pct 6 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]M1|11
xaudit.td1.exempt.prov 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]7|27
xaudit.td1.exemption 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]7|10
xaudit.third.party.sick 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|28
Ì € i 2
audit.cust.def.queries
[employee.txn,audit.date,audit.time, audit.cd.query]
*(JY)JYTX[jy]0[jyMD,jyMT]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 *(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]|0
audit.cd.yn.comment 75 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]|5
Ì € i 2
audit.cust.def.mult
[employee.txn,audit.date,audit.time,audit.cd.query, audit.cdm.seq.no]
*(JY)JYTX[jy]0[jyMD,jyMT]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 *(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]M[ggvN]|0
Ì € i 2
audit.dependents
[employee.txn,audit.date,audit.time, audit.dp.number]
*(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.dp.number 2 PINT R jyDP
audit.dp.active 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|5
audit.dp.address1 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|0
audit.dp.address2 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|1
audit.dp.birthdate 10 BDATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|1
audit.dp.city 18 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|2
audit.dp.cobra.number 42 URN L PP.PER.COBRA *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|11
audit.dp.email.addr 40 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|14
audit.dp.emergency.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|8
audit.dp.home.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|7
audit.dp.marital.status 10 FREE L MIS.MAR.STATUS *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|9
audit.dp.marital.sts.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|10
audit.dp.medicare.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|12
audit.dp.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|0
audit.dp.other.country 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|6
audit.dp.other.country.ch 6 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|5
audit.dp.postal.code 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|4
audit.dp.relationship 10 FREE L MIS.RELAT *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|2
audit.dp.si.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|3
audit.dp.sort.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|4
audit.dp.ss.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|3
audit.dp.state 2 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|3
audit.dp.student.thru.dt 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|6
Ì € i 2
audit.skills
[employee.txn,audit.date,audit.time, audit.skill]
*(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.skill 10 FREE L MIS.SKILL gqk
audit.sk.ceu 5 DEC2 R *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|3
audit.sk.cmu 5 DEC2 R *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|5
audit.sk.comment 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|1
audit.sk.effective.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|2
audit.sk.expiration.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|4
audit.sk.use 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|0
Ì € i 2
audit.trail.mult.values
[employee.txn,audit.date,audit.time, audit.subscript.1,audit.subscript.2]
*(JY)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 *(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS]
audit.value.src 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS]S|0
Ì € i 2
audit.trail.mult.values.4
[employee.txn,audit.date,audit.time,audit.subscript.1,audit.subscript.2, audit.subscript.3,aud
*(JY)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 *(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4]
Ì € i 2
audit.trail.values
[employee.txn,audit.date,audit.time, audit.subscript]
*(JY)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 *(JY)JYTX[jy]0[jyMD,jyMT,jyMS]
Ì € i 2
xaudit.benefit.balances
[employee.txn,audit.date,audit.time, xaudit.benefit]
*(JY)JYTX[jy]0[jyMD,jyMT]9[jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xaudit.benefit 8 PDEC R PP.BENEFIT jde
xaudit.benefit.accr.bal 9 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|3
xaudit.benefit.avail.bal 9 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|2
xaudit.benefit.ed.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|8
xaudit.benefit.freeze 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|5
xaudit.benefit.freeze.dat 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|6
xaudit.benefit.frz.hrs 8 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|7
xaudit.benefit.occr.yr 4 YEAR L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|10
xaudit.benefit.occurance 3 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|9
xaudit.benefit.plan 8 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|1
xaudit.benefit.update.gl 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|4
Ì € i 2
xaudit.dd.proration
[employee.txn,audit.date,audit.time, xaudit.dd.pro.counter]
*(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xaudit.dd.pro.counter 2 PINT R mpC
xaudit.dd.pro.account.num 17 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|2
xaudit.dd.pro.acct.type 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|3
xaudit.dd.pro.bank 17 FREE L PP.BANK *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|1
xaudit.dd.pro.note.acct 17 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|6
xaudit.dd.pro.note.bank 17 FREE L PP.BANK *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|5
xaudit.dd.pro.note.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|8
xaudit.dd.pro.note.type 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|7
xaudit.dd.pro.type 7 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|0
xaudit.dd.pro.value 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|4
Ì € i 2
xaudit.earnings
[employee.txn,audit.date,audit.time, xaudit.earning.counter]
*(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xaudit.earning.counter 2 PINT R jyEC
xaudit.earning 8 PDEC L PP.EARN *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|0
xaudit.earning.active 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|1
xaudit.earning.creatd.flx 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|4
xaudit.earning.expression 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|2
xaudit.earning.freeze 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|5
xaudit.earning.wexpr 60 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|3
Ì € i 2
xaudit.eff.base.rates
[employee.txn,audit.date,audit.time, xaudit.eff.date]
*(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xaudit.eff.date 8 DATE L jefd
xaudit.eff.rate 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]|1
xaudit.eff.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]|2
xaudit.eff.step 2 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]|0
Ì € i 2
xaudit.sec.jobs
[employee.txn,audit.date,audit.time, xaudit.sec.job.counter]
*(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xaudit.sec.job.counter 2 PINT R jySC
xaudit.sec.job 10 FREE L PP.JOB *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|0
xaudit.sec.job.contract 8 FREE L PP.CONTRACT *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|5
xaudit.sec.job.dept 15 FREE L MIS.GL.DEPT *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|2
xaudit.sec.job.hrs.pct 6 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|3
xaudit.sec.job.rate 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|1
xaudit.sec.job.step 2 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|4
Ì € i 2
xaudit.withholdings
[employee.txn,audit.date,audit.time, xaudit.whold]
*(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xaudit.whold 8 PDEC L PP.WHOLD jdw
xaudit.whold.account.num 14 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|1
xaudit.whold.active 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|0
xaudit.whold.balance 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|4
xaudit.whold.bond.price 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|5
xaudit.whold.created.flex 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|11
xaudit.whold.emplee.wexpr 60 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|7
xaudit.whold.empler.expr 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|8
xaudit.whold.empler.wexpr 60 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|9
xaudit.whold.expressions 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|6
xaudit.whold.from.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|2
xaudit.whold.more.below 1 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|10
xaudit.whold.thru.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|3
Ì € i 2
xadd.earn.txns
[employee.txn, xatxn.earning,xatxn.date,xatxn.time]
*(JY)JYTX[jy]14[jde,jyAED,jyAET]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xatxn.earning 8 PDEC L PP.EARN jde
xatxn.date 8 DATE L jyAED
xatxn.time 5 TIME L jyAET
xatxn.amount 8 SMONEY R *(JY)JYTX[jy]14[jde,jyAED,jyAET]|1
xatxn.balance 8 SMONEY R *(JY)JYTX[jy]14[jde,jyAED,jyAET]|2
xatxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]14[jde,jyAED,jyAET]|3
xatxn.type 1 FREE L *(JY)JYTX[jy]14[jde,jyAED,jyAET]|0
Ì € i 2
xadd.wholding.txns
[employee.txn, xadd.wtxn.whold,xadd.wtxn.date,xadd.wtxn.time]
*(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xadd.wtxn.whold 8 PDEC L PP.WHOLD jdw
xadd.wtxn.date 8 DATE L jyAWD
xadd.wtxn.time 5 TIME L jyAWT
xadd.wtxn.ee.amount 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|1
xadd.wtxn.ee.balance 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|3
xadd.wtxn.er.amount 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|2
xadd.wtxn.er.balance 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|4
xadd.wtxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|5
xadd.wtxn.type 1 FREE L *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|0
Ì € i 2
xbenefit.transactions
[employee.txn, xbtxn.earning,xbtxn.date,xbtxn.time]
*(JY)JYTX[jy]11[jde,jyBD,jyBT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xbtxn.earning 8 PDEC L PP.EARN jde
xbtxn.date 8 DATE L jyBD
xbtxn.time 5 TIME L jyBT
xbtxn.accrued.balance 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|9
xbtxn.adjustment 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|7
xbtxn.avail.balance 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|8
xbtxn.award 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|5
xbtxn.benefit.freeze 1 YN L *(JY)JYTX[jy]11[jde,jyBD,jyBT]|12
xbtxn.earned 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|3
xbtxn.earned.print 8 SDEC3 R VAL=(@btxn.earned+@btxn.award)
xbtxn.edit.reason 10 FREE L PP.REASON *(JY)JYTX[jy]11[jde,jyBD,jyBT]|13
xbtxn.hour.basis 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|2
xbtxn.occurance 3 PINT R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|14
xbtxn.plan 8 FREE L *(JY)JYTX[jy]11[jde,jyBD,jyBT]|0
xbtxn.taken 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|4
xbtxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]11[jde,jyBD,jyBT]|10
xbtxn.transfer 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|6
xbtxn.type 1 CHOICE L *(JY)JYTX[jy]11[jde,jyBD,jyBT]|1
xbtxn.zero.avail.first 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|11
Ì € i 2
xcontr.hrs.transactions
[employee.txn, xctxn.date,xctxn.time]
*(JY)JYTX[jy]13[jyCD,jyCT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xctxn.date 8 DATE L jyCD
xctxn.time 5 TIME L jyCT
xctxn.ben.hrs 8 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|1
xctxn.ben.hrs.balance 10 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|2
xctxn.rvw.hrs 8 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|3
xctxn.rvw.hrs.balance 10 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|4
xctxn.type 1 CHOICE L *(JY)JYTX[jy]13[jyCD,jyCT]|0
Ì € i 2
xwhold.transactions
[employee.txn, xwtxn.whold,xwtxn.date,xwtxn.time]
*(JY)JYTX[jy]12[jdw,jyWD,jyWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xwtxn.whold 8 PDEC L PP.WHOLD jdw
xwtxn.date 8 DATE L jyWD
xwtxn.time 5 TIME L jyWT
xwtxn.add.amount 8 SMONEY R VAL=(@wtxn.whold.amount+@wtxn.manual.amount)
xwtxn.balance 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|3
xwtxn.bond.amount.pur 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|5
xwtxn.bond.num.pur 4 SINT R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|4
xwtxn.manual.amount 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|2
xwtxn.sub.amount 8 SMONEY R VAL=(@wtxn.manual.amount-@wtxn.whold.amount)
xwtxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|6
xwtxn.type 1 CHOICE L *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|0
xwtxn.whold.amount 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|1
Ì i 2
web.activity.queue
[wbq.date,wbq.emp.urn,wbq.form.urn]
*(JY)JY.WBQ[wbqDT,jy,wbfr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wbq.date 8 DATE L wbqDT
wbq.emp.urn 42 URN L PP.PER jy
wbq.form.urn 10 URN L wbfr
wbq.time 4 HHMM L *(JY)JY.WBQ[wbqDT,jy,wbfr]|0
Ì i 2
web.form.req
[wf.urn]
*(JY)JY.WBFR[wbfr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wf.urn 10 URN L wbfr
wf.address1 30 FREE L *(JY)JY.WBFR[wbfr]AD|0
wf.address2 30 FREE L *(JY)JY.WBFR[wbfr]AD|1
wf.city 18 FREE L *(JY)JY.WBFR[wbfr]AD|2
wf.date.of.birth 10 BDATE L *(JY)JY.WBFR[wbfr]E|3
wf.emergency.phone 18 PHONE L *(JY)JY.WBFR[wbfr]E|2
wf.emp.urn 42 URN L PP.PER *(JY)JY.WBFR[wbfr]|0
wf.home.phone 18 PHONE L *(JY)JY.WBFR[wbfr]E|1
wf.name 26 FREE L *(JY)JY.WBFR[wbfr]E|0
wf.postal.code 10 FREE L *(JY)JY.WBFR[wbfr]AD|4
wf.state 2 FREE L *(JY)JY.WBFR[wbfr]AD|3
wf.status 10 CHOICE L *(JY)JY.WBFR[wbfr]|2
wf.status.time 10 PINT R *(JY)JY.WBFR[wbfr]|4
wf.status.user 10 FREE L MIS.USER *(JY)JY.WBFR[wbfr]|3
wf.submit.secs 10 PINT R *(JY)JY.WBFR[wbfr]|1
Ì € i 2
web.form.req.other.data
[wf.urn, wf.other.txt.q]
*(JY)JY.WBFR[wbfr]OT[wbfOQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wf.other.txt.q 3 URN L wbfOQ
wf.other.txt 60 TEXT L *(JY)JY.WBFR[wbfr]OT[wbfOQ]
Index Files Subscripts/Physical Base
activity.x [audit.date,employee]
?(JY)JYA[jyMD,jy]
balances.activity [xwtxn.date,xwtxn.whold,xwtxn.time,employee.txn]
?(JY)JYBX[jyWD,jdw,jyWT,jy]
cobra.name.x [sort.name,cobra.number]
?(JY)JYCN[jySN,jycb]
ee.dt.letter.x [employee,print.date,letter,printing]
?(JY)JYEL[jy,jllPD,jllt,jllID]
employee.x [employee]
?(JY)JYX[jy]
file.x [activity.date,employee]
?(JY)JYC[jyAD,jy]
id.x [id,employee]
?(JY)JYI[jyI,jy]
name.x [sort.name,employee]
?(JY)JYN[jySN,jy]
number.x [number,employee]
?(JY)JYR[jyN,jy]
old.add.earn.txn.x [xatxn.date,xatxn.earning,xatxn.time,employee.txn]
?(JY)JYAEX[jyAED,jde,jyAET,jy]
old.add.whold.txn.x [xadd.wtxn.date,xadd.wtxn.whold,xadd.wtxn.time,employee.txn]
?(J)JYAWX[jyAWD,jdw,jyAWT,jy]
old.contract.name.x [old.contract,sort.name,employee]
?(JY)JYUN[jdc,jySN,jy]
old.dept.name.x [old.dept,sort.name,employee]
?(JY)JYDN[gd,jySN,jy]
old.payroll.dept.name.x [old.payroll,old.dept,sort.name,employee]
?(JY)JYPDN[jdp,gd,jySN,jy]
old.payroll.dept.x [old.payroll,old.dept,employee]
?(JY)JYPD[jdp,gd,jy]
old.position.x [old.position.number,sort.name,employee]
?(JY)JYPO[jdr,jySN,jy]
old.reserved.pos.x [old.reserved.position,sort.name,employee]
?(JY)JYRPO[jdr,jySN,jy]
old.tax.whold.x [old.tax.year,old.payroll,old.whold,sort.name,employee]
?(JY)JYTW[jyTY,jdp,jdw,jySN,jy]
postal.code.x [postal.country,postal.code,sort.name,employee]
?(JY)JYPX[pcnty,jyPC,jySN,jy]
ss.x [ss.number] = employee
?(JY)JYS[jySS]
web.form.status.x [wf.status,wf.emp.urn,wf.urn]
?(JY)JY.WBS[wbfrS,jy,wbfr]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |