Ì i 2
enroll.yr.grp
[enroll.year,enroll.pp.db,enroll.grp]
*(HLF)HLY.FE[hlfyr,pp.db,hlfgr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
enroll.year 8 FREE L HR.FLEX.YR hlfyr
enroll.pp.db 12 FREE L MIS.APPL.DB pp.db
enroll.grp 8 FREE L HR.FLEX.GRP hlfgr
enroll.date 8 DATE L *(HLF)HLY.FE[hlfyr,pp.db,hlfgr]|1
enroll.user 10 FREE L MIS.USER *(HLF)HLY.FE[hlfyr,pp.db,hlfgr]|0
Ì i 2
input.dep.dates
[input.option.type, input.dp.q]
/DEP[hlfty]D[hlxxQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
input.dp.q 2 PINT R hlxxQ
input.change.date 8 DATE L /DEP[hlfty]D[hlxxQ]|4
input.dp.name 26 FREE L VAL=@HR.EMP.dp.name[employee,@input.dp.number]
input.dp.number 2 PINT R /DEP[hlfty]D[hlxxQ]|0
input.elig.date 8 DATE L /DEP[hlfty]D[hlxxQ]|1
input.end.date 8 DATE L /DEP[hlfty]D[hlxxQ]|3
input.start.date 8 DATE L /DEP[hlfty]D[hlxxQ]|2
Ì i 2
main
[employee]
$(HLF)HLA.F[hly]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L HR.EMP hly
id 42 URN L HR.EMP VAL=@HR.EMP.number_" "_@HR.EMP.name'=" "
sort.name 26 FREE L VAL=@HR.EMP.sort.name
Ì € i 2
years
[employee, year,pp.db]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]
Field Name Len Dat Typ J DPM Offset/Local/VAL
year 8 FREE L HR.FLEX.YR hlfyr
pp.db 12 FREE L MIS.APPL.DB pp.db
as.of.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]|8
cd.screen 15 FREE L MIS.SCREEN VAL=@HR.FLEX.OPS.cust.def.screen[option]
eligible 1 YN L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]|0
group 8 FREE L HR.FLEX.GRP $(HLF)HLA.F[hly]YR[hlfyr,pp.db]|1
history.date 8 DATE L
per.ee.in 8 MONEY R VAL=%HR.PER.FLEX.per.tots(employee,year,pp.db,4)
per.ee.net.pre.tax 8 MONEY R VAL=%HR.PER.FLEX.per.tots(employee,year,pp.db,6)
per.ee.out.aft.tax 8 MONEY R VAL=%HR.PER.FLEX.per.tots(employee,year,pp.db,7)
per.ee.out.pre.tax 8 MONEY R VAL=%HR.PER.FLEX.per.tots(employee,year,pp.db,5)
per.er.cr 8 MONEY R VAL=%HR.PER.FLEX.per.tots(employee,year,pp.db,1)
per.er.op 8 MONEY R VAL=%HR.PER.FLEX.per.tots(employee,year,pp.db,2)
per.er.tot 8 MONEY R VAL=%HR.PER.FLEX.per.tots(employee,year,pp.db,3)
print.cd.screen 0 FREE L VAL=IF{@cd.screen %MIS.SCREEN.print(@cd.screen,^@cust.
VAL=def.fields,"",3),""}
print.cd.screen.verbatim 0 FREE L VAL=IF{@cd.screen %MIS.SCREEN.print(@cd.screen,^@cust.
VAL=def.fields,1,0),""}
status 10 CHOICE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]|9
status.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]|10
Ì € i 2
credits
[employee,year,pp.db, credit]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]CR[hlfcr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
credit 8 FREE L HR.FLEX.CR hlfcr
credit.annual.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]CR[hlfcr]|0
credit.earning 8 FREE L VAL=%HR.FLEX.UTIL.earn.display(pp.db,@HR.FLEX.CR.assoc
VAL=.earning)
credit.period.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]CR[hlfcr]|1
Ì € i 2
cust.def.queries
[employee,year,pp.db, cd.query]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]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 $(HLF)HLA.F[hly]YR[hlfyr,pp.db]CD[ggv]|0
cd.yn.comment 75 FREE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]CD[ggv]|5
Ì € i 2
cust.def.mult.queries
[employee,year,pp.db,cd.query, cdm.seq.no]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]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 $(HLF)HLA.F[hly]YR[hlfyr,pp.db]CD[ggv]M[ggvN]|0
Ì € i 2
fsa.types
[employee,year,pp.db, fsa]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
fsa 9 FREE L HR.FSA hlfsa
fsa.ann.contrib 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]|0
fsa.claims.approved 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]|2
fsa.claims.paid 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]|3
fsa.claims.pending 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]|5
fsa.claims.submitted 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]|4
fsa.per.contrib 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]|1
fsa.whold 8 FREE L VAL=%HR.FLEX.UTIL.whold.display(pp.db,@HR.FSA.assoc.wh
VAL=old[fsa,pp.db])
Ì € i 2
fsa.claims
[employee,year,pp.db,fsa, fsa.claim.number]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
fsa.claim.number 3 PINT R hlyfxN
fsa.claim.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|5
fsa.claim.check.number 10 INT R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|7
fsa.claim.desc 30 FREE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|1
fsa.claim.entry.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|8
fsa.claim.reject.reason 10 FREE L HR.REASON $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|4
fsa.claim.service.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|0
fsa.claim.status 9 YN L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|2
fsa.claim.status.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|3
fsa.claim.submit.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]|6
Ì € i 2
void.checks
[employee,year,pp.db,fsa,fsa.claim.number, void.check.number]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]SA[hlfsa]CL[hlyfxN]VC[hlyfxV]
Field Name Len Dat Typ J DPM Offset/Local/VAL
void.check.number 10 INT R hlyfxV
Ì € i 2
option.types
[employee,year,pp.db, option.type]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]
Field Name Len Dat Typ J DPM Offset/Local/VAL
option.type 8 FREE L HR.FLEX.TYPE hlfty
annual.cost.ee 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|3
annual.cost.er 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|6
cov.category 8 FREE L HR.FLEX.COV $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|1
cov.change.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|12
cov.elig.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|9
cov.end.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|11
cov.start.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|10
option 8 FREE L HR.FLEX.OPS $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|0
option.ins.cov 40 FREE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|8
option.whold 8 FREE L VAL=%HR.FLEX.UTIL.whold.display(pp.db,@HR.FLEX.OPS.ass
VAL=oc.whold[@option,pp.db])
period.cost.ee 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|4
period.cost.er 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]TY[hlfty]|7
Ì € i 2
payrolls
[employee,year,pp.db, sben.payroll]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sben.payroll 8 FREE L PP.PAYROLL jdp
sold.sick.ann.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|5
sold.sick.earning 8 FREE L VAL=%HR.FLEX.UTIL.earn.display(pp.db,@HR.FLEX.SBEN.ass
VAL=oc.earning[@HR.FLEX.GRP.sell.sick.days[@group,year
VAL=,pp.db],pp.db])
sold.sick.hours 7 PDEC3 R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|4
sold.sick.per.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|6
sold.sick.proj.hours 7 PDEC3 R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|7
sold.vac.ann.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|1
sold.vac.earning 8 FREE L VAL=%HR.FLEX.UTIL.earn.display(pp.db,@HR.FLEX.SBEN.ass
VAL=oc.earning[@HR.FLEX.GRP.sell.vac.days[@group,year,
VAL=pp.db],pp.db])
sold.vac.hours 7 PDEC3 R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|0
sold.vac.per.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|2
sold.vac.proj.hours 7 PDEC3 R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]|3
Ì € i 2
sick.sales
[employee,year,pp.db,sben.payroll, sick.sale.num]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]SS[hlyfxR]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sick.sale.num 2 PINT R hlyfxR
sick.sale.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]SS[hlyfxR]|3
sick.sale.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]SS[hlyfxR]|0
sick.sale.hrs 7 PDEC3 R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]SS[hlyfxR]|1
sick.sale.rate 8 RATE R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]SS[hlyfxR]|2
Ì € i 2
vacation.sales
[employee,year,pp.db,sben.payroll, vac.sale.num]
$(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]VS[hlyfxQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vac.sale.num 2 PINT R hlyfxQ
vac.sale.amt 8 MONEY R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]VS[hlyfxQ]|3
vac.sale.date 8 DATE L $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]VS[hlyfxQ]|0
vac.sale.hrs 7 PDEC3 R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]VS[hlyfxQ]|1
vac.sale.rate 8 RATE R $(HLF)HLA.F[hly]YR[hlfyr,pp.db]P[jdp]VS[hlyfxQ]|2
Ì i 2
transactions
[employee.txn,year.txn,pp.db.txn]
*(HLF)HLA.FTX[hly,hlfyr,pp.db]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee.txn 42 URN L HR.EMP hly
year.txn 8 FREE L HR.FLEX.YR hlfyr
pp.db.txn 12 FREE L MIS.APPL.DB pp.db
Ì € i 2
audit.trail
[employee.txn,year.txn,pp.db.txn, audit.date,audit.time]
*(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L hlyfMD
audit.time 5 TIME L hlyfMT
audit.as.of.date 8 DATE L *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|8
audit.client 30 FREE L UNV.CLIENT *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]|1
audit.eligible 1 YN L *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|0
audit.group 8 FREE L HR.FLEX.GRP *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|1
audit.sold.sick.ann.amt 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|13
audit.sold.sick.hours 7 PDEC3 R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|12
audit.sold.sick.per.amt 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|14
audit.sold.sick.proj.hrs 8 PDEC3 R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|15
audit.sold.vac.ann.amt 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|4
audit.sold.vac.hours 7 PDEC3 R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|2
audit.sold.vac.per.amt 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|5
audit.sold.vac.proj.hours 7 PDEC3 R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|11
audit.status 10 CHOICE L *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|9
audit.status.date 8 DATE L *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]0|10
audit.user 10 FREE L MIS.USER *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]|0
Ì € i 2
audit.credits
[employee.txn,year.txn,pp.db.txn,audit.date,audit.time, audit.credit]
*(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]CR[hlfcr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.credit 8 FREE L HR.FLEX.CR hlfcr
audit.credit.annual.amt 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]CR[hlfcr]|0
audit.credit.period.amt 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]CR[hlfcr]|1
Ì € i 2
audit.fsa.types
[employee.txn,year.txn,pp.db.txn,audit.date,audit.time, audit.fsa]
*(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]SA[hlfsa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.fsa 9 FREE L HR.FSA hlfsa
audit.fsa.ann.contrib 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]SA[hlfsa]|0
audit.fsa.claims.approved 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]SA[hlfsa]|2
audit.fsa.claims.paid 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]SA[hlfsa]|3
audit.fsa.claims.pending 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]SA[hlfsa]|5
audit.fsa.claims.sbmttd 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]SA[hlfsa]|4
audit.fsa.per.contrib 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]SA[hlfsa]|1
Ì € i 2
audit.option.types
[employee.txn,year.txn,pp.db.txn,audit.date,audit.time, audit.option.type]
*(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.option.type 8 FREE L HR.FLEX.TYPE hlfty
audit.annual.cost.ee 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]|3
audit.annual.cost.er 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]|6
audit.cov.category 8 FREE L *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]|1
audit.option 8 FREE L *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]|0
audit.option.ins.cov 40 FREE L *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]|8
audit.period.cost.ee 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]|4
audit.period.cost.er 8 MONEY R *(HLF)HLA.FTX[hly,hlfyr,pp.db]0[hlyfMD,hlyfMT]TY[hlfty]|7
Index Files Subscripts/Physical Base
employee.x [employee]
?(HLF)HLYX[hly]
gl.approved.x [pp.db,fsa.claim.status.date,year,fsa,employee] = fsa.claim.amt
?(HLF)HLYF.GLA[pp.db,hlyfxD,hlfyr,hlfsa,hly]
gl.sick.sell.x [pp.db,sick.sale.date,year,employee,sben.payroll] = sick.sale.amt
?(HLF)HLYF.GLS[pp.db,hlyfxT,hlfyr,hly,jdp]
gl.vac.sell.x [pp.db,vac.sale.date,year,employee,sben.payroll] = vac.sale.amt
?(HLF)HLYF.GLV[pp.db,hlyfxS,hlfyr,hly,jdp]
grp.year.x [pp.db,group,year,employee]
?(HLF)HLY.FGY[pp.db,hlfgr,hlfyr,hly]
op.year.x [pp.db,option,year,employee]
?(HLF)HLY.FOY[pp.db,hlfop,hlfyr,hly]
year.grp.x [pp.db,year,group,employee]
?(HLF)HLY.FYG[pp.db,hlfyr,hlfgr,hly]
year.op.x [pp.db,year,option,employee]
?(HLF)HLY.FYO[pp.db,hlfyr,hlfop,hly]
years.x [pp.db,employee,year]
?(HLF)HLY.FY[pp.db,hly,hlfyr]
|
|
| | | | | | | | | | | | | | | | | |