Ì i 2
benefit.adjustments
[ben.adj.date,ben.adj.pp.db,ben.adj.payroll,ben.adj.employee,ben.adj.account]
*(HLY)HLYGL[hlyGD,pp.db,jdp,hly,ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ben.adj.date 8 DATE L hlyGD
ben.adj.pp.db 12 FREE L MIS.APPL.DB pp.db
ben.adj.payroll 8 FREE L PP.PAYROLL jdp
ben.adj.employee 42 URN L HR.EMP hly
ben.adj.account 25 FREE L MIS.GL.ACCOUNT ga
ben.adj.cr 10 MONEY R *(HLY)HLYGL[hlyGD,pp.db,jdp,hly,ga]|1
ben.adj.dr 10 MONEY R *(HLY)HLYGL[hlyGD,pp.db,jdp,hly,ga]|0
ben.adj.hrs 8 SDEC3 R *(HLY)HLYGL[hlyGD,pp.db,jdp,hly,ga]|2
Ì i 2
expense.to.periods
[exp.activity.date]
*(HLY)HLYGLD[hlyGLD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
exp.activity.date 8 DATE L hlyGLD
exp.for.gl.period 8 DATE L *(HLY)HLYGLD[hlyGLD]
Ì i 2
file
[file.segment]
/FILE[hlyFS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
file.segment 20 FREE L hlyFS
file.all 20 FREE L VAL=@file["all"]
Ì i 2
main
[employee]
$(HLY)HLY[hly]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L hly
activity.date 8 DATE L VAL=@.today
address1 30 FREE L $(HLY)HLY[hly]0|0
address2 30 FREE L $(HLY)HLY[hly]0|1
adj.hire.month.alpha 3 FREE L VAL=IF{@HR.EMP.adjusted.hire.date "JANFEBMARAPRMAYJUNJ
VAL=ULAUGSEPOCTNOVDEC"'$((@HR.EMP.adj.hire.month.numer
VAL=ic)-1*3)$3}
adj.hire.month.numeric 2 PINT R VAL=(@HR.EMP.adjusted.hire.date%3$2)
adjusted.hire.date 8 DATE L $(HLY)HLY[hly]1|12
age 3 PINT R VAL=IF{@date.of.birth %Z.age.in.years(@date.of.birth,@
VAL=.today)}
alias.last.name 20 FREE L $(HLY)HLY[hly]|8
being.paid 1 YN L $(HLY)HLY[hly]1|10
cd.screen.1 15 FREE L MIS.SCREEN VAL=@PP.PAYROLL.customer.def.screen[@payroll]
city 18 FREE L $(HLY)HLY[hly]0|2
cobra.number 42 URN L HR.PER.COBRA $(HLY)HLY[hly]M1|6
county 10 FREE L MIS.CNTY $(HLY)HLY[hly]0|7
date.of.birth 10 BDATE L $(HLY)HLY[hly]|11
disability 1 YN L $(HLY)HLY[hly]M1|0
eeoc 18 CHOICE L $(HLY)HLY[hly]M1|16
emp.user.mnemonic 10 FREE L MIS.USER $(HLY)HLY[hly]M1|12
empl.type 5 FREE L HR.TYPE $(HLY)HLY[hly]1|0
empl.type.date 8 DATE L $(HLY)HLY[hly]1|22
employee.picture 1 BMP L VAL=^@Appl.file.prefix(HR,PICRAD)[@HR.EMP.picture.fold
VAL=er_.._HR.EMP.employee_".JPG"]
eo.survey 18 CHOICE L $(HLY)HLY[hly]M1|17
evaluation.date 8 DATE L $(HLY)HLY[hly]1|16
exempt 1 YN L $(HLY)HLY[hly]1|23
first.name 20 FREE L $(HLY)HLY[hly]|5
health.insurance 1 YN L $(HLY)HLY[hly]M1|3
hire.date 8 DATE L $(HLY)HLY[hly]1|11
hire.month.alpha 3 FREE L VAL=IF{@HR.EMP.hire.date "JANFEBMARAPRMAYJUNJULAUGSEPO
VAL=CTNOVDEC"'$((@HR.EMP.hire.month.numeric)-1*3)$3}
hire.month.numeric 2 PINT R VAL=(@HR.EMP.hire.date%3$2)
home.email 40 FREE L $(HLY)HLY[hly]C|4
home.phone 18 PHONE L $(HLY)HLY[hly]C|0
last.name 20 FREE L $(HLY)HLY[hly]|6
loa.current.counter 3 PINT R $(HLY)HLY[hly]1|24
marital.status 10 FREE L MIS.MAR.STATUS $(HLY)HLY[hly]M1|4
marital.status.date 8 DATE L $(HLY)HLY[hly]M1|5
medicare.date 8 DATE L $(HLY)HLY[hly]M1|2
middle.name 20 FREE L $(HLY)HLY[hly]|7
mobile.phone 18 PHONE L $(HLY)HLY[hly]C|1
month.and.day.of.birth 4 PINT R VAL=(@HR.EMP.date.of.birth%3)
name 68 NAME L $(HLY)HLY[hly]|2
next.review.date 8 DATE L $(HLY)HLY[hly]1|13
next.review.reason 10 FREE L HR.REASON $(HLY)HLY[hly]1|14
nickname 15 FREE L $(HLY)HLY[hly]|10
number 14 FREE L $(HLY)HLY[hly]|4
other.country 10 FREE L $(HLY)HLY[hly]0|6
other.country.choice 6 CHOICE L $(HLY)HLY[hly]0|5
other.email 40 FREE L $(HLY)HLY[hly]C|5
other.phone 18 PHONE L $(HLY)HLY[hly]C|2
pager 18 PHONE L $(HLY)HLY[hly]C|3
picture.aspect 3 FREE L $(HLY)HLY[hly]M1|14
picture.date 8 DATE L $(HLY)HLY[hly]M1|8
picture.folder 4 FREE L $(HLY)HLY[hly]M1|7
pop.grp 8 FREE L HR.POPUL $(HLY)HLY[hly]M1|1
postal.code 10 FREE L $(HLY)HLY[hly]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.verbatm.1 0 FREE L VAL=IF{@cd.screen.1 %MIS.SCREEN.print(@cd.screen.1,^@c
VAL=ustomer.defined.fields,1,0),""}
res.address1 30 FREE L $(HLY)HLY[hly]RA|0
res.address2 30 FREE L $(HLY)HLY[hly]RA|1
res.city 18 FREE L $(HLY)HLY[hly]RA|2
res.county 10 FREE L MIS.CNTY $(HLY)HLY[hly]RA|7
res.other.country 10 FREE L $(HLY)HLY[hly]RA|6
res.other.country.choice 6 CHOICE L $(HLY)HLY[hly]RA|5
res.postal.code 10 FREE L $(HLY)HLY[hly]RA|4
res.state 2 FREE L $(HLY)HLY[hly]RA|3
roe.date 8 DATE L $(HLY)HLY[hly]1|21
seniority.date 8 DATE L $(HLY)HLY[hly]1|15
sex 1 CHOICE L $(HLY)HLY[hly]|12
si.number 12 FREE L $(HLY)HLY[hly]|1
si.number.govt 11 FREE L VAL=(@HR.EMP.si.number$11)
sort.name 68 NAME L $(HLY)HLY[hly]N|0
ss.number 12 FREE L $(HLY)HLY[hly]|1
ss.number.govt 11 FREE L VAL=(@HR.EMP.ss.number$11)
state 2 FREE L $(HLY)HLY[hly]0|3
status 7 CHOICE L $(HLY)HLY[hly]1|7
status.date 8 DATE L $(HLY)HLY[hly]1|8
status.reason 10 FREE L HR.REASON $(HLY)HLY[hly]1|9
suffix.name 8 FREE L $(HLY)HLY[hly]|9
t4.country 10 FREE L $(HLY)HLY[hly]6|3
t4.country.choice 5 CHOICE L $(HLY)HLY[hly]6|2
work.email 40 FREE L $(HLY)HLY[hly]M1|9
work.phone 18 PHONE L $(HLY)HLY[hly]M1|10
Ì € i 2
customer.defined.queries
[employee, cd.query]
$(HLY)HLY[hly]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 $(HLY)HLY[hly]CD[ggv]|0
cd.yn.comment 75 FREE L $(HLY)HLY[hly]CD[ggv]|5
Ì € i 2
customer.def.mult.queries
[employee,cd.query, cdm.seq.no]
$(HLY)HLY[hly]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 $(HLY)HLY[hly]CD[ggv]M[ggvN]|0
Ì € i 2
dependents
[employee, dp.number]
$(HLY)HLY[hly]DP[hlyDP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dp.number 2 PINT R hlyDP
dp.active 1 YN L $(HLY)HLY[hly]DP[hlyDP]|5
dp.address1 30 FREE L $(HLY)HLY[hly]DP[hlyDP]0|0
dp.address2 30 FREE L $(HLY)HLY[hly]DP[hlyDP]0|1
dp.age 3 PINT R VAL=IF{@dp.birthdate %Z.age.in.years(@dp.birthdate,@.t
VAL=oday)}
dp.birthdate 10 BDATE L $(HLY)HLY[hly]DP[hlyDP]|1
dp.city 18 FREE L $(HLY)HLY[hly]DP[hlyDP]0|2
dp.cobra.number 42 URN L HR.PER.COBRA $(HLY)HLY[hly]DP[hlyDP]|11
dp.desc 23 FREE L VAL=@MIS.RELAT.name[@dp.relationship]$23
dp.email.addr 40 FREE L $(HLY)HLY[hly]DP[hlyDP]|14
dp.emergency.phone 18 PHONE L $(HLY)HLY[hly]DP[hlyDP]|8
dp.home.phone 18 PHONE L $(HLY)HLY[hly]DP[hlyDP]|7
dp.marital.status 10 FREE L MIS.MAR.STATUS $(HLY)HLY[hly]DP[hlyDP]|9
dp.marital.status.date 8 DATE L $(HLY)HLY[hly]DP[hlyDP]|10
dp.medicare.date 8 DATE L $(HLY)HLY[hly]DP[hlyDP]|12
dp.mobile.phone 18 PHONE L $(HLY)HLY[hly]DP[hlyDP]|15
dp.name 26 NAME L $(HLY)HLY[hly]DP[hlyDP]|0
dp.other.country 10 FREE L $(HLY)HLY[hly]DP[hlyDP]0|6
dp.other.country.choice 6 CHOICE L $(HLY)HLY[hly]DP[hlyDP]0|5
dp.postal.code 10 FREE L $(HLY)HLY[hly]DP[hlyDP]0|4
dp.relationship 10 FREE L MIS.RELAT $(HLY)HLY[hly]DP[hlyDP]|2
dp.si.number 12 FREE L $(HLY)HLY[hly]DP[hlyDP]|3
dp.sort.name 26 NAME L $(HLY)HLY[hly]DP[hlyDP]|4
dp.ss.number 12 FREE L $(HLY)HLY[hly]DP[hlyDP]|3
dp.state 2 FREE L $(HLY)HLY[hly]DP[hlyDP]0|3
dp.student 1 YN L VAL=IF{@dp.student.thru.date<@.today "N";"Y"}
dp.student.thru.date 8 DATE L $(HLY)HLY[hly]DP[hlyDP]|6
dp.text.edit 1 YN L $(HLY)HLY[hly]DP[hlyDP]|13
Ì € i 2
dependent.comments
[employee,dp.number, dp.text.q]
$(HLY)HLY[hly]DP[hlyDP]C[hlyDPC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dp.text.q 8 PINT R hlyDPC
dp.text.line 92 TEXT L $(HLY)HLY[hly]DP[hlyDP]C[hlyDPC]
Ì € i 2
eligibility
[employee, i9.document]
$(HLY)HLY[hly]EL[hldi9]
Field Name Len Dat Typ J DPM Offset/Local/VAL
i9.document 12 FREE L HR.I9 hldi9
i9.desc 25 FREE L VAL=@HR.I9.description[@i9.document]$25
i9.expiration.date 8 DATE L $(HLY)HLY[hly]EL[hldi9]|0
i9.use 1 YN L $(HLY)HLY[hly]EL[hldi9]|1
Ì € i 2
emer.contacts
[employee, emer.number]
$(HLY)HLY[hly]EC[hlyec]
Field Name Len Dat Typ J DPM Offset/Local/VAL
emer.number 2 PINT R hlyec
emer.address1 30 FREE L $(HLY)HLY[hly]EC[hlyec]EA|0
emer.address2 30 FREE L $(HLY)HLY[hly]EC[hlyec]EA|1
emer.city 18 FREE L $(HLY)HLY[hly]EC[hlyec]EA|2
emer.desc 23 FREE L VAL=@MIS.RELAT.name[@emer.relationship]$23
emer.home.phone 18 PHONE L $(HLY)HLY[hly]EC[hlyec]|3
emer.home.phone.pri 1 YN L $(HLY)HLY[hly]EC[hlyec]|6
emer.name 26 NAME L $(HLY)HLY[hly]EC[hlyec]|0
emer.note 68 FREE L $(HLY)HLY[hly]EC[hlyec]|8
emer.other.country 10 FREE L $(HLY)HLY[hly]EC[hlyec]EA|6
emer.other.country.choice 6 CHOICE L $(HLY)HLY[hly]EC[hlyec]EA|5
emer.other.phone 18 PHONE L $(HLY)HLY[hly]EC[hlyec]|4
emer.other.phone.pri 1 YN L $(HLY)HLY[hly]EC[hlyec]|7
emer.postal.code 10 FREE L $(HLY)HLY[hly]EC[hlyec]EA|4
emer.pri.phone.value 18 PHONE L VAL=%HR.EMP.value.emer.phone(HR.EMP.employee,HR.EMP.em
VAL=er.number,1)
emer.relationship 10 FREE L MIS.RELAT $(HLY)HLY[hly]EC[hlyec]|1
emer.state 2 FREE L $(HLY)HLY[hly]EC[hlyec]EA|3
emer.work.phone 18 PHONE L $(HLY)HLY[hly]EC[hlyec]|2
emer.work.phone.pri 1 YN L $(HLY)HLY[hly]EC[hlyec]|5
Ì € i 2
licenses
[employee, license.counter]
$(HLY)HLY[hly]LC[hlyLCC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
license.counter 2 PINT R hlyLCC
license 10 FREE L HR.LICENSE $(HLY)HLY[hly]LC[hlyLCC]|0
license.comment 25 FREE L $(HLY)HLY[hly]LC[hlyLCC]|7
license.eff.date 8 DATE L $(HLY)HLY[hly]LC[hlyLCC]|3
license.exp.date 8 DATE L $(HLY)HLY[hly]LC[hlyLCC]|4
license.issue.date 8 DATE L $(HLY)HLY[hly]LC[hlyLCC]|5
license.number 10 FREE L $(HLY)HLY[hly]LC[hlyLCC]|1
license.state 2 FREE L $(HLY)HLY[hly]LC[hlyLCC]|2
license.status 8 CHOICE L $(HLY)HLY[hly]LC[hlyLCC]|6
Ì € i 2
loa.fields
[employee, loa.counter]
$(HLY)HLY[hly]L[hlyL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
loa.counter 3 PINT R hlyL
loa.date 8 DATE L $(HLY)HLY[hly]L[hlyL]|7
loa.from.date 8 DATE L $(HLY)HLY[hly]L[hlyL]|0
loa.hours 8 DEC R $(HLY)HLY[hly]L[hlyL]|4
loa.hrs.remain 8 DEC R $(HLY)HLY[hly]L[hlyL]|5
loa.medical.cert 1 YN L $(HLY)HLY[hly]L[hlyL]|6
loa.status 9 CHOICE L $(HLY)HLY[hly]L[hlyL]|3
loa.thru.date 8 DATE L $(HLY)HLY[hly]L[hlyL]|1
loa.type 10 FREE L HR.LOA.TYPE $(HLY)HLY[hly]L[hlyL]|2
Ì € i 2
loa.approvals
[employee,loa.counter, loa.approval.q]
$(HLY)HLY[hly]L[hlyL]A[hlyLA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
loa.approval.q 2 PINT R hlyLA
loa.approval.action 7 CHOICE L $(HLY)HLY[hly]L[hlyL]A[hlyLA]|3
loa.approval.date 8 DATE L $(HLY)HLY[hly]L[hlyL]A[hlyLA]|1
loa.approval.employee 42 URN L HR.EMP $(HLY)HLY[hly]L[hlyL]A[hlyLA]|6
loa.approval.order 1 CHOICE L $(HLY)HLY[hly]L[hlyL]A[hlyLA]|4
loa.approval.task 24 URN L HR.TASK $(HLY)HLY[hly]L[hlyL]A[hlyLA]|5
loa.approval.time 4 TIME L $(HLY)HLY[hly]L[hlyL]A[hlyLA]|2
loa.approval.user 10 FREE L MIS.USER $(HLY)HLY[hly]L[hlyL]A[hlyLA]|0
Ì € i 2
loa.approval.comments
[employee,loa.counter,loa.approval.q, approval.text.q]
$(HLY)HLY[hly]L[hlyL]A[hlyLA]C[hlyAC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
approval.text.q 8 PINT R hlyAC
approval.text.line 60 TEXT L $(HLY)HLY[hly]L[hlyL]A[hlyLA]C[hlyAC]
Ì € i 2
loa.comments
[employee,loa.counter, loa.text.q]
$(HLY)HLY[hly]L[hlyL]C[hlyLC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
loa.text.q 4 PINT R hlyLC
loa.text.line 60 TEXT L $(HLY)HLY[hly]L[hlyL]C[hlyLC]
Ì € i 2
payroll.databases
[employee, pp.db]
$(HLY)HLY[hly]DB[pp.db]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pp.db 12 FREE L MIS.APPL.DB pp.db
benefit.contr.hours 10 SDEC3 R $(HLY)HLY[hly]DB[pp.db]|18
benefit.contr.hours.sort 10 SDEC3 R VAL=(1000000-@benefit.contr.hours:3D)
dd.proration.method 1 CHOICE L $(HLY)HLY[hly]DB[pp.db]|17
de6.wage.plan 1 CHOICE L $(HLY)HLY[hly]DB[pp.db]|11
exclude.from.de6 1 YN L $(HLY)HLY[hly]DB[pp.db]|10
fit.exemptions 2 INT L $(HLY)HLY[hly]DB[pp.db]|1
fit.tax.status 1 CHOICE L $(HLY)HLY[hly]DB[pp.db]|0
flsa.per.week.calc 1 YN L $(HLY)HLY[hly]DB[pp.db]|9
fmla.start 4 INT R $(HLY)HLY[hly]DB[pp.db]|12
insurance.coverage 40 FREE L $(HLY)HLY[hly]DB[pp.db]|20
pension 1 YN L $(HLY)HLY[hly]DB[pp.db]|4
pp.urn 42 URN L PP.PER $(HLY)HLY[hly]DB[pp.db]|23
qual.diff 8 RATE R $(HLY)HLY[hly]DB[pp.db]|8
review.contr.hours 10 SDEC3 R $(HLY)HLY[hly]DB[pp.db]|19
review.contr.hours.sort 10 SDEC3 R VAL=(1000000-@review.contr.hours:3D)
sit.exemptions 2 INT L $(HLY)HLY[hly]DB[pp.db]|3
sit.tax.status 1 CHOICE L $(HLY)HLY[hly]DB[pp.db]|2
statutory 1 YN L $(HLY)HLY[hly]DB[pp.db]|5
t4.cpp.qpp.exempt 1 YN L $(HLY)HLY[hly]DB[pp.db]|13
t4.ei.exempt 1 YN L $(HLY)HLY[hly]DB[pp.db]|14
t4.employment.code 2 CHOICE L $(HLY)HLY[hly]DB[pp.db]|15
t4.stock.code 2 CHOICE L $(HLY)HLY[hly]DB[pp.db]|16
t4a.business.no 15 FREE L $(HLY)HLY[hly]DB[pp.db]|24
tax.year 4 YEAR L $(HLY)HLY[hly]DB[pp.db]|21
td1.exemption 8 MONEY R $(HLY)HLY[hly]DB[pp.db]|6
td1.exemption.prov 8 MONEY R $(HLY)HLY[hly]DB[pp.db]|7
third.party.sick.pay 1 YN L $(HLY)HLY[hly]DB[pp.db]|22
Ì € i 2
dd.proration
[employee,pp.db, dd.pro.counter]
$(HLY)HLY[hly]DB[pp.db]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 $(HLY)HLY[hly]DB[pp.db]2[mpC]|2
dd.pro.account.type 1 CHOICE L $(HLY)HLY[hly]DB[pp.db]2[mpC]|3
dd.pro.bank 17 FREE L PP.BANK $(HLY)HLY[hly]DB[pp.db]2[mpC]|1
dd.pro.note.account 17 FREE L $(HLY)HLY[hly]DB[pp.db]2[mpC]|6
dd.pro.note.bank 17 FREE L PP.BANK $(HLY)HLY[hly]DB[pp.db]2[mpC]|5
dd.pro.note.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]2[mpC]|8
dd.pro.note.type 1 CHOICE L $(HLY)HLY[hly]DB[pp.db]2[mpC]|7
dd.pro.type 7 CHOICE L $(HLY)HLY[hly]DB[pp.db]2[mpC]|0
dd.pro.value 10 FREE L $(HLY)HLY[hly]DB[pp.db]2[mpC]|4
Ì € i 2
payrolls
[employee,pp.db, payroll]
$(HLY)HLY[hly]DB[pp.db]P[jdp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
payroll 8 FREE L PP.PAYROLL jdp
base.rate 8 RATE R $(HLY)HLY[hly]DB[pp.db]P[jdp]|1
base.rate.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]|2
base.rate.reason 10 FREE L HR.REASON $(HLY)HLY[hly]DB[pp.db]P[jdp]|3
cd.pay.screen.1 15 FREE L MIS.SCREEN
contract 8 FREE L PP.CONTRACT $(HLY)HLY[hly]DB[pp.db]P[jdp]1|9
dept 15 FREE L MIS.GL.DEPT $(HLY)HLY[hly]DB[pp.db]P[jdp]1|4
dept.access.ok 1 FREE L VAL=%MIS.GL.DEPT.user.ok(@HR.EMP.dept)
frequency 8 FREE L VAL=@payroll's.frequency
hours.per.period 6 DEC3 R $(HLY)HLY[hly]DB[pp.db]P[jdp]1|7
hrs.per.period.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]1|8
incomplete.pay.fields 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]|5
job.code 10 FREE L PP.JOB $(HLY)HLY[hly]DB[pp.db]P[jdp]1|3
loa.template 10 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]|11
monthly.rate 10 RATE R
monthly.salary 8 MONEY R VAL=%HR.EMP.monthly.salary(HR.EMP.employee,payroll)
ont.vac.calc.thru 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]|6
outside.agency 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]|9
payroll.active 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]|0
period.rate 10 RATE R
position.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]1|1
position.id 4 PINT R $(HLY)HLY[hly]DB[pp.db]P[jdp]1|12
position.number 18 FREE L PP.POS $(HLY)HLY[hly]DB[pp.db]P[jdp]1|0
primary 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]|10
reserved.position 18 FREE L PP.POS $(HLY)HLY[hly]DB[pp.db]P[jdp]1|2
reserved.position.id 4 PINT R $(HLY)HLY[hly]DB[pp.db]P[jdp]1|13
shift 1 PINT L $(HLY)HLY[hly]DB[pp.db]P[jdp]1|5
shift.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]1|6
shift.diff.amount 8 RATE R VAL=%HR.EMP.diff.amount(employee,payroll)
sort.base.rate 8 RATE R VAL=(10000-@base.rate)
step 2 PINT L $(HLY)HLY[hly]DB[pp.db]P[jdp]|4
step.grade.base.hi 8 PDEC R VAL=%HR.EMP.step.grade.base(employee,"HI",payroll,pp.d
VAL=b)
step.grade.base.lo 8 PDEC R VAL=%HR.EMP.step.grade.base(employee,"LO",payroll,pp.d
VAL=b)
tc.hours.pro.elig 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]|7
tc.hours.pro.pri.pct 6 DEC3 R $(HLY)HLY[hly]DB[pp.db]P[jdp]|8
weekly.rate 10 RATE R
yearly.rate 10 RATE R
yearly.salary 9 MONEY R VAL=%HR.EMP.yearly.salary(HR.EMP.employee,payroll)
Ì € i 2
benefit.balances
[employee,pp.db,payroll, benefit]
$(HLY)HLY[hly]DB[pp.db]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 $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|3
benefit.avail.balance 9 SDEC3 R $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|2
benefit.edit.reason 10 FREE L HR.REASON $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|8
benefit.freeze 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|5
benefit.freeze.contr.hrs 8 DEC3 R $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|7
benefit.freeze.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|6
benefit.linked 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|12
benefit.loa.freeze 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|11
benefit.occurance 3 PINT R $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|9
benefit.occurance.yr 4 YEAR L $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|10
benefit.plan 8 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|1
benefit.update.gl 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]9[jde]|4
Ì € i 2
cust.defined.pay.queries
[employee,pp.db,payroll, cd.pay.query]
$(HLY)HLY[hly]DB[pp.db]P[jdp]CDP[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.pay.query 10 FREE L MIS.QUERY ggv
cd.pay.response 75 QRY.RESP L $(HLY)HLY[hly]DB[pp.db]P[jdp]CDP[ggv]|0
cd.pay.yn.comment 75 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]CDP[ggv]|5
Ì € i 2
cust.def.mult.pay.queries
[employee,pp.db,payroll,cd.pay.query, cdm.pay.seq.no]
$(HLY)HLY[hly]DB[pp.db]P[jdp]CDP[ggv]MP[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cdm.pay.seq.no 3 PINT R ggvN
cdm.pay.response 75 QRY.RESP L $(HLY)HLY[hly]DB[pp.db]P[jdp]CDP[ggv]MP[ggvN]|0
Ì € i 2
earnings
[employee,pp.db,payroll, earning.counter]
$(HLY)HLY[hly]DB[pp.db]P[jdp]E[hlyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
earning.counter 2 INT R hlyEC
earning 8 PDEC L PP.EARN $(HLY)HLY[hly]DB[pp.db]P[jdp]E[hlyEC]|0
earning.active 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]E[hlyEC]|1
earning.created.by.flex 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]E[hlyEC]|4
earning.expression 30 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]E[hlyEC]|2
earning.freeze 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]E[hlyEC]|5
earning.wexpr 60 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]E[hlyEC]|3
Ì € i 2
eff.base.rates
[employee,pp.db,payroll, eff.date]
$(HLY)HLY[hly]DB[pp.db]P[jdp]13[hlefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
eff.date 8 DATE L hlefd
eff.rate 8 RATE R $(HLY)HLY[hly]DB[pp.db]P[jdp]13[hlefd]|1
eff.reason 10 FREE L HR.REASON $(HLY)HLY[hly]DB[pp.db]P[jdp]13[hlefd]|2
eff.step 2 PINT L $(HLY)HLY[hly]DB[pp.db]P[jdp]13[hlefd]|0
Ì € i 2
eff.position.fields
[employee,pp.db,payroll, eff.pos.date]
$(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
eff.pos.date 8 DATE L hlyepd
eff.contract 8 FREE L PP.CONTRACT $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|9
eff.dept 15 FREE L MIS.GL.DEPT $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|4
eff.hours.per.period 6 DEC3 R $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|7
eff.job.code 10 FREE L PP.JOB $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|3
eff.pos.promotion 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|11
eff.position.id 4 PINT R $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|12
eff.position.number 18 FREE L PP.POS $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|0
eff.reserved.pos.edit 1 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|10
eff.reserved.position 18 FREE L PP.POS $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|2
eff.reserved.position.id 4 PINT R $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|13
eff.shift 1 PINT R $(HLY)HLY[hly]DB[pp.db]P[jdp]EP[hlyepd]|5
Ì € i 2
sec.jobs
[employee,pp.db,payroll, sec.job.counter]
$(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.job.counter 2 INT R hlySC
sec.job 10 FREE L PP.JOB $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|0
sec.job.contract 8 FREE L PP.CONTRACT $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|5
sec.job.dept 15 FREE L MIS.GL.DEPT $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|2
sec.job.hrs.percent 6 DEC3 R $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|3
sec.job.position 18 FREE L PP.POS $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|6
sec.job.position.id 4 PINT R $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|7
sec.job.rate 8 RATE R $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|1
sec.job.step 2 PINT L $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]|4
Ì € i 2
sec.eff.rates
[employee,pp.db,payroll,sec.job.counter, sec.eff.date]
$(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]SR[hlefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.eff.date 8 DATE L hlefd
sec.eff.rate 8 RATE R $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]SR[hlefd]|1
sec.eff.step 2 PINT L $(HLY)HLY[hly]DB[pp.db]P[jdp]SJ[hlySC]SR[hlefd]|0
Ì € i 2
withholdings
[employee,pp.db,payroll, whold]
$(HLY)HLY[hly]DB[pp.db]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 $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|1
whold.active 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|0
whold.arrears 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|12
whold.balance 8 MONEY R $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|4
whold.bond.price 8 MONEY R $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|5
whold.created.by.flex 1 YN L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|11
whold.employee.wexpr 60 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]WXEE
whold.employer.expr 30 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|8
whold.employer.wexpr 60 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]WXER
whold.expressions 30 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|6
whold.from.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|2
whold.more.below 1 FREE L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|10
whold.thru.date 8 DATE L $(HLY)HLY[hly]DB[pp.db]P[jdp]10[jdw]|3
Ì € i 2
skills
[employee, skill]
$(HLY)HLY[hly]4[gqk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
skill 10 FREE L MIS.SKILL gqk
sk.ceu 5 DEC2 R $(HLY)HLY[hly]4[gqk]|3
sk.cmu 5 DEC2 R $(HLY)HLY[hly]4[gqk]|5
sk.comment 30 FREE L $(HLY)HLY[hly]4[gqk]|1
sk.effective.date 8 DATE L $(HLY)HLY[hly]4[gqk]|2
sk.expiration.date 8 DATE L $(HLY)HLY[hly]4[gqk]|4
sk.use 1 FREE L $(HLY)HLY[hly]4[gqk]|0
Ì € i 2
vets100
[employee, vet.type]
$(HLY)HLY[hly]VT[hlyvt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vet.type 16 CHOICE L hlyvt
Ì i 2
missing.pos.id
[miss.pos.employee,miss.pos.pp.db,miss.pos.payroll,miss.pos,miss.pos.id]
*(HLY)HLYMID[hly,pp.db,jdp,jdr,hldpid]
Field Name Len Dat Typ J DPM Offset/Local/VAL
miss.pos.employee 42 URN L HR.EMP hly
miss.pos.pp.db 12 FREE L MIS.APPL.DB pp.db
miss.pos.payroll 8 FREE L PP.PAYROLL jdp
miss.pos 18 FREE L PP.POS jdr
miss.pos.id 4 PINT R hldpid
miss.pos.date 8 DATE L *(HLY)HLYMID[hly,pp.db,jdp,jdr,hldpid]|1
miss.pos.oc.employee 42 URN L HR.EMP *(HLY)HLYMID[hly,pp.db,jdp,jdr,hldpid]|3
miss.pos.time 4 HHMM L *(HLY)HLYMID[hly,pp.db,jdp,jdr,hldpid]|2
miss.pos.user 10 FREE L MIS.USER *(HLY)HLYMID[hly,pp.db,jdp,jdr,hldpid]|0
Ì i 2
process.web.empl.req
[pr.d.seq]
/HLY.PS["D",prdSQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pr.d.seq 10 FREE L prdSQ
pr.d.employee 42 URN L HR.EMP /HLY.PS["D",prdSQ]|6
pr.d.name 35 FREE L /HLY.PS["D",prdSQ]|4
pr.d.number 14 FREE L /HLY.PS["D",prdSQ]|5
pr.d.status 10 CHOICE L /HLY.PS["D",prdSQ]|3
pr.d.submit.date 8 DATE L /HLY.PS["D",prdSQ]|1
pr.d.submit.time 4 HHMM L /HLY.PS["D",prdSQ]|2
pr.d.urn 10 URN L /HLY.PS["D",prdSQ]|0
Ì i 2
transactions
[employee.txn]
*(HLY)HLYTX[hly]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee.txn 42 URN L HR.EMP hly
Ì € i 2
audit.trail
[employee.txn, audit.date,audit.time]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L hlyMD
audit.time 5 TIME L hlyMT
audit.address1 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|0
audit.address2 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|1
audit.adjusted.hire.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|12
audit.alias.last.name 20 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|8
audit.city 18 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|2
audit.client 30 FREE L UNV.CLIENT *(HLY)HLYTX[hly]0[hlyMD,hlyMT]|1
audit.cobra.number 42 URN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|6
audit.county 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|7
audit.date.of.birth 10 BDATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|11
audit.disability 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|0
audit.eeoc 18 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|16
audit.emp.user.mnemonic 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|12
audit.empl.type 5 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|0
audit.empl.type.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|22
audit.eo.survey 18 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|17
audit.evaluation.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|16
audit.exempt 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|23
audit.first.name 20 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|5
audit.health.insurance 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|3
audit.hire.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|11
audit.home.email 40 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]C|4
audit.home.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]C|0
audit.last.name 20 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|6
audit.marital.status 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|4
audit.marital.status.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|5
audit.medicare.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|2
audit.middle.name 20 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|7
audit.mobile.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]C|1
audit.name 26 NAME L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|2
audit.next.review.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|13
audit.next.review.reason 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|14
audit.nickname 15 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|10
audit.number 14 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|4
audit.other.country 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|6
audit.other.country.ch 6 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|5
audit.other.email 40 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]C|5
audit.other.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]C|2
audit.pager 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]C|3
audit.pop.grp 8 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|1
audit.postal.code 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|4
audit.res.address1 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|0
audit.res.address2 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|1
audit.res.city 18 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|2
audit.res.county 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|7
audit.res.other.country 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|6
audit.res.otr.country.ch 6 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|5
audit.res.postal.code 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|4
audit.res.state 2 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]RA|3
audit.roe.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|21
audit.seniority.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|15
audit.sex 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|12
audit.si.number 12 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|1
audit.sort.name 68 NAME L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]N|0
audit.ss.number 12 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|1
audit.state 2 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]5|3
audit.status 7 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|7
audit.status.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|8
audit.status.reason 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]1|9
audit.suffix.name 8 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]0|9
audit.supervisor 42 URN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|15
audit.user 10 FREE L MIS.USER *(HLY)HLYTX[hly]0[hlyMD,hlyMT]|0
audit.work.email 40 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|9
audit.work.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]M1|10
Ì € i 2
audit.cust.def.queries
[employee.txn,audit.date,audit.time, audit.cd.query]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]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 *(HLY)HLYTX[hly]0[hlyMD,hlyMT]CD[ggv]|0
audit.cd.yn.comment 75 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]CD[ggv]|5
Ì € i 2
audit.cust.def.mult
[employee.txn,audit.date,audit.time,audit.cd.query, audit.cdm.seq.no]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]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 *(HLY)HLYTX[hly]0[hlyMD,hlyMT]CD[ggv]M[ggvN]|0
Ì € i 2
audit.dependents
[employee.txn,audit.date,audit.time, audit.dp.number]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.dp.number 2 PINT R hlyDP
audit.dp.active 26 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|5
audit.dp.address1 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]0|0
audit.dp.address2 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]0|1
audit.dp.birthdate 10 BDATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|1
audit.dp.city 18 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]0|2
audit.dp.cobra.number 42 URN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|11
audit.dp.email.addr 40 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|14
audit.dp.emergency.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|8
audit.dp.home.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|7
audit.dp.marital.status 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|9
audit.dp.marital.sts.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|10
audit.dp.medicare.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|12
audit.dp.mobile.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|15
audit.dp.name 26 NAME L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|0
audit.dp.other.country 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]0|6
audit.dp.other.country.ch 6 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]0|5
audit.dp.postal.code 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]0|4
audit.dp.relationship 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|2
audit.dp.si.number 12 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|3
audit.dp.sort.name 26 NAME L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|4
audit.dp.ss.number 12 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|3
audit.dp.state 2 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]0|3
audit.dp.student.thru.dt 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DP[hlyDP]|6
Ì € i 2
audit.eligibility
[employee.txn,audit.date,audit.time, audit.i9.document]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]EL[hldi9]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.i9.document 12 FREE L hldi9
audit.i9.expiration.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EL[hldi9]|0
audit.i9.use 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EL[hldi9]|1
Ì € i 2
audit.emer.contacts
[employee.txn,audit.date,audit.time, audit.emer.number]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.emer.number 2 PINT R hlyec
audit.emer.address1 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]EA|0
audit.emer.address2 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]EA|1
audit.emer.city 18 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]EA|2
audit.emer.home.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|3
audit.emer.home.phone.pri 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|6
audit.emer.name 26 NAME L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|0
audit.emer.note 68 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|8
audit.emer.other.cntry.ch 6 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]EA|5
audit.emer.other.country 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]EA|6
audit.emer.other.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|4
audit.emer.otr.phone.pri 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|7
audit.emer.postal.code 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]EA|4
audit.emer.relationship 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|1
audit.emer.state 2 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]EA|3
audit.emer.work.phone 18 PHONE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|2
audit.emer.work.phone.pri 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]EC[hlyec]|5
Ì € i 2
audit.loa.fields
[employee.txn,audit.date,audit.time, audit.loa.counter]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]L[hlyL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.loa.counter 3 PINT R hlyL
audit.loa.from.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]L[hlyL]|0
audit.loa.hours 8 SDEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]L[hlyL]|4
audit.loa.hrs.remain 8 SDEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]L[hlyL]|5
audit.loa.status 9 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]L[hlyL]|3
audit.loa.thru.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]L[hlyL]|1
audit.loa.type 10 FREE L HR.LOA.TYPE *(HLY)HLYTX[hly]0[hlyMD,hlyMT]L[hlyL]|2
Ì € i 2
audit.payroll.databases
[employee.txn,audit.date,audit.time, audit.pp.db]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.pp.db 12 FREE L MIS.APPL.DB pp.db
audit.benefit.contr.hours 10 SDEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|18
audit.dd.proration.method 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|17
audit.de6.wage.plan 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|11
audit.exclude.from.de6 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|10
audit.fit.exemptions 2 INT L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|1
audit.fit.tax.status 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|0
audit.flsa.per.week.calc 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|9
audit.fmla.start 4 INT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|12
audit.insurance.coverage 40 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|20
audit.pension 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|4
audit.pp.urn 42 URN L PP.PER *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|23
audit.qual.diff 8 RATE R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|8
audit.review.contr.hours 10 SDEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|19
audit.sit.exemptions 2 INT L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|3
audit.sit.tax.status 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|2
audit.statutory 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|5
audit.t4.cpp.qpp.exempt 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|13
audit.t4.ei.exempt 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|14
audit.t4.employment.code 2 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|15
audit.t4.stock.code 2 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|16
audit.t4a.business.no 15 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|24
audit.tax.year 4 YEAR L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|21
audit.td1.exemption 8 MONEY R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|6
audit.td1.exemption.prov 8 MONEY R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|7
audit.third.party.sick 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]|22
Ì € i 2
audit.dd.proration
[employee.txn,audit.date,audit.time,audit.pp.db, audit.dd.pro.counter]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]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 *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|2
audit.dd.pro.account.type 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|3
audit.dd.pro.bank 17 FREE L PP.BANK *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|1
audit.dd.pro.note.account 17 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|6
audit.dd.pro.note.bank 17 FREE L PP.BANK *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|5
audit.dd.pro.note.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|8
audit.dd.pro.note.type 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|7
audit.dd.pro.type 7 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|0
audit.dd.pro.value 10 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]2[mpC]|4
Ì € i 2
audit.payrolls
[employee.txn,audit.date,audit.time,audit.pp.db, audit.payroll]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]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 *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|1
audit.base.rate.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|2
audit.base.rate.reason 10 FREE L PP.REASON *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|3
audit.contract 8 FREE L PP.CONTRACT *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|9
audit.dept 15 FREE L MIS.GL.DEPT *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|4
audit.hours.per.period 8 DEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|7
audit.hrs.per.period.date 6 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|8
audit.incomplete.pay.fld 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|5
audit.job.code 10 FREE L PP.JOB *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|3
audit.ont.vac.calc.thru 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|6
audit.outside.agency 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|9
audit.payroll.active 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|0
audit.position.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|1
audit.position.id 4 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|12
audit.position.number 18 FREE L PP.POS *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|0
audit.primary 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|10
audit.reserved.pos.id 4 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|13
audit.reserved.position 18 FREE L PP.POS *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|2
audit.shift 1 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|5
audit.shift.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]1|6
audit.step 2 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|4
audit.tc.hours.pro.elig 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|7
audit.tc.hrs.pro.pri.pct 6 DEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]|8
Ì € i 2
audit.benefit.balances
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll, audit.benefit]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]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 *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|3
audit.benefit.avail.bal 9 SDEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|2
audit.benefit.edit.reason 10 FREE L HR.REASON *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|8
audit.benefit.freeze 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|5
audit.benefit.freeze.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|6
audit.benefit.frz.con.hrs 8 DEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|7
audit.benefit.linked 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|12
audit.benefit.occur.yr 4 YEAR L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|10
audit.benefit.occurance 3 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|9
audit.benefit.plan 8 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|1
audit.benefit.update.gl 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]9[jde]|4
Ì € i 2
audit.cus.def.pay.queries
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll, audit.cd.pay.query]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]CDP[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.cd.pay.query 10 FREE L MIS.QUERY ggv
audit.cd.pay.response 75 QRY.RESP L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]CDP[ggv]|0
audit.cd.pay.yn.comment 75 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]CDP[ggv]|5
Ì € i 2
audit.cust.def.pay.mult
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll,audit.cd.pay.query, audit.cdm.pa
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]CDP[ggv]MP[ggvN
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.cdm.pay.seq.no 3 PINT R ggvN
audit.cdm.pay.response 75 QRY.RESP L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]CDP[ggv]MP[ggvN
Ì € i 2
audit.earnings
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll, audit.earning.counter]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.earning.counter 2 INT R hlyEC
audit.earning 8 PDEC L PP.EARN *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]|0
audit.earning.active 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]|1
audit.earning.created.flx 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]|4
audit.earning.expression 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]|2
audit.earning.freeze 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]|5
audit.earning.source 1 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]S|0
audit.earning.wexpr 60 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]E[hlyEC]|3
Ì € i 2
audit.eff.base.rates
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll, audit.eff.date]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]13[hlefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.eff.date 8 DATE L hlefd
audit.eff.rate 8 RATE R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]13[hlefd]|1
audit.eff.reason 10 FREE L HR.REASON *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]13[hlefd]|2
audit.eff.step 2 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]13[hlefd]|0
Ì € i 2
audit.eff.position.fields
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll, audit.eff.pos.date]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.eff.pos.date 8 DATE L hlyepd
audit.eff.contract 8 FREE L PP.CONTRACT *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|
audit.eff.dept 15 FREE L MIS.GL.DEPT *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|
audit.eff.hrs.per.period 6 DEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|7
audit.eff.job.code 10 FREE L PP.JOB *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|
audit.eff.pos.promotion 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|11
audit.eff.position.id 4 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|12
audit.eff.position.number 18 FREE L PP.POS *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|
audit.eff.reserved.pos 18 FREE L PP.POS *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|
audit.eff.rsrvd.pos.edit 1 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|10
audit.eff.rsrvd.pos.id 4 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|13
audit.eff.shift 1 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]EP[hlyepd]|5
Ì € i 2
audit.sec.jobs
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll, audit.sec.job.counter]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.sec.job.counter 2 INT R hlySC
audit.sec.job 10 FREE L PP.JOB *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|0
audit.sec.job.contract 8 FREE L PP.CONTRACT *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|5
audit.sec.job.dept 15 FREE L MIS.GL.DEPT *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|2
audit.sec.job.hrs.percent 6 DEC3 R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|3
audit.sec.job.position 18 FREE L PP.POS *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|6
audit.sec.job.position.id 4 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|7
audit.sec.job.rate 8 RATE R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|1
audit.sec.job.step 2 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]|4
Ì € i 2
audit.sec.eff.rates
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll,audit.sec.job.counter, audit.sec
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]SR[hle
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.sec.eff.date 8 DATE L hlefd
audit.sec.eff.rate 8 RATE R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]SR[hle
audit.sec.eff.step 2 PINT R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]SJ[hlySC]SR[hle
Ì € i 2
audit.withholdings
[employee.txn,audit.date,audit.time,audit.pp.db,audit.payroll, audit.whold]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]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 *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|1
audit.whold.active 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|0
audit.whold.arrears 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|12
audit.whold.balance 8 MONEY R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|4
audit.whold.bond.price 8 MONEY R *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|5
audit.whold.created.flex 1 YN L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|11
audit.whold.emplee.wexpr 60 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|7
audit.whold.empler.expr 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|8
audit.whold.empler.wexpr 60 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|9
audit.whold.expressions 30 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|6
audit.whold.from.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|2
audit.whold.more.below 1 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|10
audit.whold.source 1 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]S|0
audit.whold.thru.date 8 DATE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT]DB[pp.db]P[jdp]10[jdw]|3
Ì € i 2
audit.trail.mult.values
[employee.txn,audit.date,audit.time, audit.subscript.1,audit.subscript.2]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT,hlyMS,hlyMSS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript.1 2 FREE L hlyMS
audit.subscript.2 50 FREE L hlyMSS
audit.value.2 200 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT,hlyMS,hlyMSS]
Ì € i 2
audit.trail.mult.values.4
[employee.txn,audit.date,audit.time,audit.subscript.1,audit.subscript.2, audit.subscript.3,aud
*(HLY)HLYTX[hly]0[hlyMD,hlyMT,hlyMS,hlyMSS,hlyMS3,hlyMS4]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript.3 50 FREE L hlyMS3
audit.subscript.4 50 FREE L hlyMS4
audit.value.4 200 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT,hlyMS,hlyMSS,hlyMS3,hlyMS4]
audit.value.src 1 CHOICE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT,hlyMS,hlyMSS,hlyMS3,hlyMS4]S|0
Ì € i 2
audit.trail.values
[employee.txn,audit.date,audit.time, audit.subscript]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT,hlyMS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript 55 FREE L hlyMS
audit.value 200 FREE L *(HLY)HLYTX[hly]0[hlyMD,hlyMT,hlyMS]
Ì € i 2
audit.vets100
[employee.txn,audit.date,audit.time, audit.vet.type]
*(HLY)HLYTX[hly]0[hlyMD,hlyMT]VT[hlyvt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.vet.type 16 CHOICE L hlyvt
Ì € i 2
benefit.transactions
[employee.txn, btxn.pp.db,btxn.payroll,btxn.earning,btxn.date,btxn.time]
*(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
btxn.pp.db 12 FREE L MIS.APPL.DB pp.db
btxn.payroll 8 FREE L PP.PAYROLL jdp
btxn.earning 8 PDEC L PP.EARN jde
btxn.date 8 DATE L hlyBD
btxn.time 5 TIME L hlyBT
btxn.accrued.balance 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|9
btxn.adjustment 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|7
btxn.avail.balance 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|8
btxn.award 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|5
btxn.benefit.freeze 1 YN L *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|12
btxn.earned 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|3
btxn.earned.print 8 SDEC3 R VAL=(@btxn.earned+@btxn.award)
btxn.edit.reason 10 FREE L HR.REASON *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|13
btxn.hour.basis 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|2
btxn.linked 1 YN L *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|15
btxn.occurance 3 PINT R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|14
btxn.plan 8 FREE L *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|0
btxn.taken 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|4
btxn.tc.pointer 8 URN L PP.PAY *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|10
btxn.transfer 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|6
btxn.type 1 CHOICE L *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|1
btxn.zero.avail.first 8 SDEC3 R *(HLY)HLYTX[hly]11[pp.db,jdp,jde,hlyBD,hlyBT]|11
Ì € i 2
contr.hrs.transactions
[employee.txn, ctxn.pp.db,ctxn.date,ctxn.time]
*(HLY)HLYTX[hly]13[pp.db,hlyCD,hlyCT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ctxn.pp.db 12 FREE L MIS.APPL.DB pp.db
ctxn.date 8 DATE L hlyCD
ctxn.time 5 TIME L hlyCT
ctxn.ben.hrs 8 SDEC3 R *(HLY)HLYTX[hly]13[pp.db,hlyCD,hlyCT]|1
ctxn.ben.hrs.balance 10 SDEC3 R *(HLY)HLYTX[hly]13[pp.db,hlyCD,hlyCT]|2
ctxn.rvw.hrs 8 SDEC3 R *(HLY)HLYTX[hly]13[pp.db,hlyCD,hlyCT]|3
ctxn.rvw.hrs.balance 10 SDEC3 R *(HLY)HLYTX[hly]13[pp.db,hlyCD,hlyCT]|4
ctxn.type 1 CHOICE L *(HLY)HLYTX[hly]13[pp.db,hlyCD,hlyCT]|0
Ì € i 2
whold.transactions
[employee.txn, wtxn.whold.pp.db,wtxn.whold.payroll,wtxn.whold,wtxn.date,wtxn.time]
*(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wtxn.whold.pp.db 12 FREE L MIS.APPL.DB pp.db
wtxn.whold.payroll 8 FREE L PP.PAYROLL jdp
wtxn.whold 8 PDEC L PP.WHOLD jdw
wtxn.date 8 DATE L hlyWD
wtxn.time 5 TIME L hlyWT
wtxn.add.amount 8 SMONEY R VAL=(@wtxn.whold.amount+@wtxn.manual.amount)
wtxn.arrear.amount 8 SMONEY R *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|7
wtxn.balance 8 SMONEY R *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|3
wtxn.bond.amount.pur 8 SMONEY R *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|5
wtxn.bond.num.pur 4 SINT R *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|4
wtxn.manual.amount 8 SMONEY R *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|2
wtxn.sub.amount 8 SMONEY R VAL=(@wtxn.manual.amount-@wtxn.whold.amount)
wtxn.tc.pointer 8 URN L PP.PAY *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|6
wtxn.type 1 CHOICE L *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|0
wtxn.whold.amount 8 SMONEY R *(HLY)HLYTX[hly]12[pp.db,jdp,jdw,hlyWD,hlyWT]|1
Ì i 2
web.activity.q.empl.pay
[wbqp.date,wbqp.emp.urn,wbqp.pp.db,wbqp.form.urn]
*(HLY)HLY.WBQP[wbqpDT,hly,pp.db,wbfrp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wbqp.date 8 DATE L wbqpDT
wbqp.emp.urn 42 URN L HR.EMP hly
wbqp.pp.db 12 FREE L MIS.APPL.DB pp.db
wbqp.form.urn 10 URN L wbfrp
wbqp.time 4 HHMM L *(HLY)HLY.WBQP[wbqpDT,hly,pp.db,wbfrp]|0
Ì i 2
web.activity.q.empl.per
[wbqe.date,wbqe.emp.urn,wbqe.form.urn]
*(HLY)HLY.WBQE[wbqeDT,hly,wbfre]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wbqe.date 8 DATE L wbqeDT
wbqe.emp.urn 42 URN L HR.EMP hly
wbqe.form.urn 10 URN L wbfre
wbqe.time 4 HHMM L *(HLY)HLY.WBQE[wbqeDT,hly,wbfre]|0
Ì i 2
wf.req.empl.pay
[wfp.urn]
*(HLY)HLY.WBFP[wbfrp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfp.urn 10 URN L wbfrp
wfp.dd.proration.method 1 CHOICE L *(HLY)HLY.WBFP[wbfrp]DB|4
wfp.emp.urn 42 URN L HR.EMP *(HLY)HLY.WBFP[wbfrp]|0
wfp.fit.exemptions 2 INT L *(HLY)HLY.WBFP[wbfrp]DB|1
wfp.fit.tax.status 1 CHOICE L *(HLY)HLY.WBFP[wbfrp]DB|0
wfp.pp.db 12 FREE L MIS.APPL.DB *(HLY)HLY.WBFP[wbfrp]|1
wfp.sit.exemptions 2 INT L *(HLY)HLY.WBFP[wbfrp]DB|3
wfp.sit.tax.status 1 CHOICE L *(HLY)HLY.WBFP[wbfrp]DB|2
wfp.status 10 CHOICE L *(HLY)HLY.WBFP[wbfrp]|3
wfp.status.time 10 PINT R *(HLY)HLY.WBFP[wbfrp]|5
wfp.status.user 10 FREE L MIS.USER *(HLY)HLY.WBFP[wbfrp]|4
wfp.submit.secs 10 PINT R *(HLY)HLY.WBFP[wbfrp]|2
Ì € i 2
wf.req.empl.pay.dd
[wfp.urn, wfp.dd.pro.counter]
*(HLY)HLY.WBFP[wbfrp]DD[wfmpC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfp.dd.pro.counter 2 INT R wfmpC
wfp.dd.pro.account.number 17 FREE L *(HLY)HLY.WBFP[wbfrp]DD[wfmpC]|2
wfp.dd.pro.account.type 1 CHOICE L *(HLY)HLY.WBFP[wbfrp]DD[wfmpC]|3
wfp.dd.pro.bank 17 FREE L PP.BANK *(HLY)HLY.WBFP[wbfrp]DD[wfmpC]|1
wfp.dd.pro.type 7 CHOICE L *(HLY)HLY.WBFP[wbfrp]DD[wfmpC]|0
wfp.dd.pro.value 10 FREE L *(HLY)HLY.WBFP[wbfrp]DD[wfmpC]|4
Ì € i 2
wf.req.empl.pay.other
[wfp.urn, wfp.other.txt.q]
*(HLY)HLY.WBFP[wbfrp]OT[wbpOQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfp.other.txt.q 3 URN L wbpOQ
wfp.other.txt 60 TEXT L *(HLY)HLY.WBFP[wbfrp]OT[wbpOQ]
Ì i 2
wf.req.empl.per
[wfe.urn]
*(HLY)HLY.WBFE[wbfre]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfe.urn 10 URN L wbfre
wfe.address1 30 FREE L *(HLY)HLY.WBFE[wbfre]AD|0
wfe.address2 30 FREE L *(HLY)HLY.WBFE[wbfre]AD|1
wfe.city 18 FREE L *(HLY)HLY.WBFE[wbfre]AD|2
wfe.date.of.birth 10 BDATE L *(HLY)HLY.WBFE[wbfre]E|7
wfe.emp.urn 42 URN L HR.EMP *(HLY)HLY.WBFE[wbfre]|0
wfe.first.name 20 FREE L *(HLY)HLY.WBFE[wbfre]E|0
wfe.home.phone 18 PHONE L *(HLY)HLY.WBFE[wbfre]E|5
wfe.last.name 20 FREE L *(HLY)HLY.WBFE[wbfre]E|2
wfe.middle.name 20 FREE L *(HLY)HLY.WBFE[wbfre]E|1
wfe.mobile.phone 18 PHONE L *(HLY)HLY.WBFE[wbfre]E|6
wfe.nickname 15 FREE L *(HLY)HLY.WBFE[wbfre]E|4
wfe.postal.code 10 FREE L *(HLY)HLY.WBFE[wbfre]AD|4
wfe.state 2 FREE L *(HLY)HLY.WBFE[wbfre]AD|3
wfe.status 10 CHOICE L *(HLY)HLY.WBFE[wbfre]|2
wfe.status.time 10 PINT R *(HLY)HLY.WBFE[wbfre]|4
wfe.status.user 10 FREE L MIS.USER *(HLY)HLY.WBFE[wbfre]|3
wfe.submit.secs 10 PINT R *(HLY)HLY.WBFE[wbfre]|1
wfe.suffix.name 8 FREE L *(HLY)HLY.WBFE[wbfre]E|3
Ì € i 2
wf.req.empl.per.other
[wfe.urn, wfe.other.txt.q]
*(HLY)HLY.WBFE[wbfre]OT[wbeOQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wfe.other.txt.q 3 URN L wbeOQ
wfe.other.txt 60 TEXT L *(HLY)HLY.WBFE[wbfre]OT[wbeOQ]
Index Files Subscripts/Physical Base
cobra.name.x [sort.name,cobra.number]
?(HLY)HLYCN[hlySN,hlycb]
contract.name.x [contract,pp.db,payroll,sort.name,employee]
?(HLY)HLYUN[jdc,pp.db,jdp,hlySN,hly]
ee.dt.letter.x [employee,print.date,letter,printing]
?(HLY)HLYEL[hly,hlllPD,hlllt,hlllID]
employee.x [employee]
?(HLY)HLYX[hly]
file.x [activity.date,employee]
?(HLY)HLYC[hlAD,hly]
id.x [id,employee]
?(HLY)HLYI[hly,hly]
name.x [sort.name,employee]
?(HLY)HLYN[hlySN,hly]
number.x [number,employee]
?(HLY)HLYR[hlN,hly]
payroll.dept.name.x [pp.db,payroll,dept,sort.name,employee]
?(HLY)HLYPDN[pp.db,jdp,gd,hlySN,hly]
payroll.dept.x [payroll,pp.db,dept,employee]
?(HLY)HLYPD[jdp,pp.db,gd,hly]
position.id.x [pp.db,position.number,position.id] = employee
?(HLY)HLYPID[pp.db,jdr,hldpid]
position.x [position.number,pp.db,payroll,sort.name,employee]
?(HLY)HLYPO[jdr,pp.db,jdp,hlySN,hly]
postal.code.x [postal.country,postal.code,sort.name,employee]
?(HLY)HLYPX[pcnty,hlyPC,hlySN,hly]
pp.urn.x [pp.db,PP.PER.employee] = employee
?(HLY)HLYJY[pp.db,jy]
primary.x [employee,pp.db] = payroll
?(HLY)HLYP[hly,pp.db]
reserved.pos.x [reserved.position,pp.db,payroll,sort.name,employee]
?(HLY)HLYRPO[jdr,pp.db,jdp,hlySN,hly]
ss.temp [ss.number] = employee
/HLYS[hlySS]
ss.x [ss.number] = employee
?(HLY)HLYS[hlySS]
tax.whold.x [tax.year,pp.db,payroll,whold,sort.name,employee]
?(HLY)HLYTW[hlyTY,pp.db,jdp,jdw,hlySN,hly]
user.x [emp.user.mnemonic,employee]
?(HLY)HLYU[gu,hly]
wf.emp.pay.status.x [wfp.status,wfp.emp.urn,wfp.urn]
?(HLY)HLY.WBPS[wbfrpS,hly,wbfrp]
wf.emp.per.status.x [wfe.status,wfe.emp.urn,wfe.urn]
?(HLY)HLY.WBES[wbfreS,hly,wbfre]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |