[Download-List] Having Problems with BREAK.ON and FOOTING.ON
A. J. McCabe
ajmccabe at niagara.edu
Fri Aug 17 10:28:42 EDT 2012
Good Morning.
I have a Download that seems to be adding another line to my file.
Here is the download statement:
DOWNLOAD PERBENCS BREAK.ON N12.PBC.HRP.LFM.NAME N12.PBC.BENE.ID.DESC N12.PBC.EMPLYE.ANNUAL.COST N12.PBC.EMPLYR.ANNUAL.COST N12.PBC.ANNUAL.BENE.COST HEADING FIELD.LABELS FOOTING.ON FINAL LITERAL 'TOTAL COSTS' LITERAL '' TOTAL N12.PBC.EMPLYE.ANNUAL.COST TOTAL N12.PBC.EMPLYR.ANNUAL.COST TOTAL N12.PBC.ANNUAL.BENE.COST
And here are the results:
"Employee}Name","Benefit","Employee}Annual}Cost","Emplyr}Annual}Cost","Annual}Benefit}Costs"
"Smith, Charlie Sue","NUF1 Nuflex Medical - Part A",2400.00,0.00,$2400.00
"Smith, Charlie Sue","C315 Cafeteria Cash Credit Non-Fac",0.00,315.00,$315.00
"Smith, Charlie Sue","BL07 Basic Group Life $100,000",180.48,11.52,$192.00
"Smith, Charlie Sue","F06 TIAA-CREF RA NON-FACULTY",2750.46,7334.56,$10085.02
"Smith, Charlie Sue","LTDN Group LTD Non-Faculty",225.96,121.68,$347.64
"Smith, Charlie Sue","LTN1 Supplemental LTD Non Faculty",0.00,0.00,$0.00
"Smith, Charlie Sue","SU02 Supplemental Life - $50,000",181.20,0.00,$181.20
"Smith, Charlie Sue","SURV Survivor Benefit",0.00,0.00,$0.00
"Smith, Charlie Sue","SSC4 Supp Life Spous/Child $20/$4K",74.88,0.00,$74.88
"Smith, Charlie Sue","ACCH Supp. AD&D Child $2,500",1.92,0.00,$1.92
"Smith, Charlie Sue","ACEM Supp. AD&D Employee $25,000",9.00,0.00,$9.00
"Smith, Charlie Sue","ACSP Supp. AD&D Spouse $25,000",10.20,0.00,$10.20
"Smith, Charlie Sue","AD07 Basic AD&D $100,000",0.00,24.00,$24.00
"Smith, Charlie Sue","HNF HRA POS 226 Non-Fac Family",0.00,1200.00,$1200.00
"Smith, Charlie Sue","BN08 226 Non-Fac Family GE $43,150",1415.00,12732.04,$14147.04
"Smith, Charlie Sue","BN08 226 Non-Fac Family GE $43,150",1415.00,12732.04,$14147.04
"TOTAL COSTS","",7249.10,21738.80,$28987.90
Notice that the last two lines before the break are the same.
I have looked at the data - and there are no duplicates. The last two lines will change based on how the records are sorted.
Any help would be appreciated.
Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20120817/a62f0831/attachment.html>
More information about the download-list
mailing list