Ì i 2
pp.empl.flex.year.grp.enrolled (enroll.yr.grp)
[enroll.year,enroll.grp]
*JY.FE[jyfeY,jyfeG]
Field Name Len Dat Typ J DPM Offset/Local/VAL
enroll.year 4 YEAR L jyfeY
enroll.grp 8 FREE L jyfeG
enroll.date 8 DATE L *JY.FE[jyfeY,jyfeG]|1
enroll.user 10 FREE L MIS.USER *JY.FE[jyfeY,jyfeG]|0
Ì i 2
pp.employee.flex.benefits (main)
[employee]
*JY.FX[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L PP.PER jy
id 42 URN L PP.PER VAL=@PP.PER.number_" "_@PP.PER.name'=" "
sort.name 26 FREE L VAL=@PP.PER.sort.name
Ì € i 2
pp.employee.flex.benefit.years (years)
[employee, year]
*JY.FX[jy]YR[jfyr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
year 8 FREE L PP.FLEX.YR jfyr
as.of.date 8 DATE L *JY.FX[jy]YR[jfyr]|8
cd.screen 15 FREE L MIS.SCREEN VAL=@PP.FLEX.OPS.cust.def.screen[option]
eligible 1 YN L *JY.FX[jy]YR[jfyr]|0
group 8 FREE L PP.FLEX.GRP *JY.FX[jy]YR[jfyr]|1
per.ee.in 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,4)
per.ee.net.pre.tax 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,6)
per.ee.out.aft.tax 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,7)
per.ee.out.pre.tax 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,5)
per.er.cr 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,1)
per.er.op 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,2)
per.er.tot 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,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),""}
sold.vac.ann.amt 8 MONEY R *JY.FX[jy]YR[jfyr]|4
sold.vac.earning 8 FREE L VAL=IF{@sold.vac.hours @PP.EARN.mnemonic[@PP.FLEX.SVAC
VAL=.assoc.earning]}
sold.vac.hours 7 PDEC3 R *JY.FX[jy]YR[jfyr]|2
sold.vac.per.amt 8 MONEY R *JY.FX[jy]YR[jfyr]|5
sold.vac.proj.hours 7 PDEC3 R *JY.FX[jy]YR[jfyr]|11
status 10 CHOICE L *JY.FX[jy]YR[jfyr]|9
status.date 8 DATE L *JY.FX[jy]YR[jfyr]|10
temp.per.ee.in 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,4,1)
temp.per.ee.net.pre.tax 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,6,1)
temp.per.ee.out.aft.tax 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,7,1)
temp.per.ee.out.pre.tax 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,5,1)
temp.per.er.cr 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,1,1)
temp.per.er.op 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,2,1)
temp.per.er.tot 8 MONEY R VAL=%PP.PER.FLEX.per.tots(PP.PER.FLEX.employee,PP.PER.
VAL=FLEX.year,3,1)
Ì € i 2
pp.employee.flex.credits (credits)
[employee,year, credit]
*JY.FX[jy]YR[jfyr]CR[jfcr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
credit 8 FREE L PP.FLEX.CR jfcr
credit.annual.amt 8 MONEY R *JY.FX[jy]YR[jfyr]CR[jfcr]|0
credit.earning 8 FREE L VAL=@PP.EARN.mnemonic[@PP.FLEX.CR.assoc.earning]
credit.period.amt 8 MONEY R *JY.FX[jy]YR[jfyr]CR[jfcr]|1
Ì € i 2
pp.emp.flx.op.cust.def.queries (cust.def.queries)
[employee,year, cd.query]
*JY.FX[jy]YR[jfyr]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.FX[jy]YR[jfyr]CD[ggv]|0
Ì € i 2
pp.per.flex.cust.def.mult.qry (cust.def.mult.queries)
[employee,year,cd.query, cdm.seq.no]
*JY.FX[jy]YR[jfyr]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.FX[jy]YR[jfyr]CD[ggv]M[ggvN]|0
Ì € i 2
pp.employee.fsa.types (fsa.types)
[employee,year, fsa.type]
*JY.FX[jy]YR[jfyr]SA[jfsa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
fsa.type 9 CHOICE L PP.FSA jfsa
fsa.ann.contrib 8 MONEY R *JY.FX[jy]YR[jfyr]SA[jfsa]|0
fsa.claims.approved 8 MONEY R *JY.FX[jy]YR[jfyr]SA[jfsa]|2
fsa.claims.paid 8 MONEY R *JY.FX[jy]YR[jfyr]SA[jfsa]|3
fsa.claims.pending 8 MONEY R *JY.FX[jy]YR[jfyr]SA[jfsa]|5
fsa.claims.submitted 8 MONEY R *JY.FX[jy]YR[jfyr]SA[jfsa]|4
fsa.per.contrib 8 MONEY R *JY.FX[jy]YR[jfyr]SA[jfsa]|1
fsa.whold 8 FREE L VAL=@PP.WHOLD.mnemonic[@PP.FSA.assoc.whold[fsa.type]]
Ì € i 2
pp.employee.fsa.claims (fsa.claims)
[employee,year,fsa.type, fsa.claim.number]
*JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
fsa.claim.number 3 PINT R jyfxN
fsa.claim.amt 8 MONEY R *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|5
fsa.claim.check.number 10 INT R *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|7
fsa.claim.desc 30 FREE L *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|1
fsa.claim.entry.date 8 DATE L *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|8
fsa.claim.reject.reason 10 FREE L PP.REASON *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|4
fsa.claim.service.date 8 DATE L *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|0
fsa.claim.status 9 YN L *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|2
fsa.claim.status.date 8 DATE L *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|3
fsa.claim.submit.date 8 DATE L *JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]|6
Ì € i 2
pp.empl.fsa.claim.void.check (void.checks)
[employee,year,fsa.type,fsa.claim.number, void.check.number]
*JY.FX[jy]YR[jfyr]SA[jfsa]CL[jyfxN]VC[jyfxV]
Field Name Len Dat Typ J DPM Offset/Local/VAL
void.check.number 10 INT R jyfxV
Ì € i 2
pp.employee.flex.option.types (option.types)
[employee,year, option.type]
*JY.FX[jy]YR[jfyr]TY[jfty]
Field Name Len Dat Typ J DPM Offset/Local/VAL
option.type 8 FREE L PP.FLEX.TYPE jfty
annual.cost.ee 8 MONEY R *JY.FX[jy]YR[jfyr]TY[jfty]|3
annual.cost.er 8 MONEY R *JY.FX[jy]YR[jfyr]TY[jfty]|6
cov.category 8 FREE L PP.FLEX.COV *JY.FX[jy]YR[jfyr]TY[jfty]|1
option 8 FREE L PP.FLEX.OPS *JY.FX[jy]YR[jfyr]TY[jfty]|0
option.ins.cov 40 FREE L *JY.FX[jy]YR[jfyr]TY[jfty]|8
option.whold 8 FREE L VAL=@PP.WHOLD.mnemonic[@PP.FLEX.OPS.assoc.whold[@optio
VAL=n]]
period.cost.ee 8 MONEY R *JY.FX[jy]YR[jfyr]TY[jfty]|4
period.cost.er 8 MONEY R *JY.FX[jy]YR[jfyr]TY[jfty]|7
Ì € i 2
pp.employee.vacation.sales (vacation.sales)
[employee,year, vac.sale.num]
*JY.FX[jy]YR[jfyr]VS[jyfxQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vac.sale.num 2 PINT R jyfxQ
vac.sale.amt 8 MONEY R *JY.FX[jy]YR[jfyr]VS[jyfxQ]|3
vac.sale.date 8 DATE L *JY.FX[jy]YR[jfyr]VS[jyfxQ]|0
vac.sale.hrs 7 PDEC3 R *JY.FX[jy]YR[jfyr]VS[jyfxQ]|1
vac.sale.rate 8 RATE R *JY.FX[jy]YR[jfyr]VS[jyfxQ]|2
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
gl.approved.fsa.claim.index [fsa.claim.status.date,year,fsa.type,employee] = fsa.claim.amt
gl.approved.x ?JYF.GLA[jyfxD,jfyr,jfsa,jy]
gl.vacation.selling.index [vac.sale.date,year,employee] = vac.sale.amt
gl.vac.sell.x ?JYF.GLV[jyfxS,jfyr,jy]
group.year.index [group,year,employee]
grp.year.x ?JY.FGY[jfgr,jfyr,jy]
option.year.index [option,year,employee]
op.year.x ?JY.FOY[jfop,jfyr,jy]
year.group.index [year,group,employee]
year.grp.x ?JY.FYG[jfyr,jfgr,jy]
year.option.index [year,option,employee]
year.op.x ?JY.FYO[jfyr,jfop,jy]
|
|
| | | | | | | | | |