adp report

[Tom Poje]

dang, you put one report out there and you get someone who wants another. Ha!

This is the ADP report.

Same rules as before, be careful, save a copy of Relius's version somewhere if you hate this one. Also note, be careful when you download an update or anything because this report will be overwritten and then you will lose it if you actully happen to like it.

This report is different from Relius in that it:

sorts alphabetically rather than by comp. heck, the old 1/3 2/3 rule for determining HCEs went away a long time ago. Well, ok, I have been using this report so long, maybe Relius' report sorts alphbetically now, I don't know.

It is hardcoded that if an NHCE's comp is greater than 90,000 there will be a note indicating ee is an HCE next year. Maybe I should make it say 'maybe'. I did not look at top paid group or possible termination status.

Age will print if ee is 49 or more to indicate possible catch-up availability, now or in the near future. Verify in census, as I don't know if age nearest or last logic is coded in specs.

An indication if ee is excluded from ACP test, and the reason.

There might be a few other totals that show up as well.