quarterly notice Options

[Tom Poje]

This is an attempt (of course, use at your own risk - but someone has to try to make life a little easier) at generating the required participant quarterly notice.

In order for this report to work, the user fields in Plan Specs would have to be coded as follows:

Date field 26 = date vesting was last updated
alpha field 29 = hours needed to accrue a year of service (e.g. 1000)
alpha field 31 = vesting yr 1 (e.g. 0%)
alpha field 32 = vesting yr 2
alpha field 33 = vesting yr 3
alpha field 34 = vesting yr 4
alpha field 35 = vesting yr 5
alpha field 36 = vesting yr 6
must have something in these fields, e.g. put 100% fields 4 5 and 6 if fully vested after 4 years.
alpha field 37 = no if plan is not subject to permitted disparity.

This report will look at ees years of service and compare to the alpha field to print vesting %.

of course some modifications would always be necessary. this particular statement says you are always 100% vested in your deferral account and any rollover. If you have QNECs, safe harbor, etc you would have to add that as well.

[lippy]

You're my hero.

[Tom Poje]

hmmmm. probably poor choice of heroes, but if the report will work for you, fine.

one thing the vesting won't catch (unless you modify it) is ees who hit normal retirement (or early retirement) with less than the 'required' years of service.

Because of the way I have accounts set up on my system I don't have that problem because I can pull vesting. However, the idea of modifying things slightly and making the report available to others I didn't take NRD (and ERD) into consideration.

[Tom Poje]

by the way, if you are not aware of it,
if you select
utilities / user defined field labels / plan labels
you can enter a description of the user fields
e.g. 31 vesting % 1 yr
this should globally effect all plans and therefore when you go to enter the data, you wont have to 'remember' what fields to enter.

I modified the vesting % at my end to have the first line read
if {PLANEE.NRDATE}<={RPTPLAN.RPTTODATE} then '100%' else

that way if someone is at NRD the vesting will show as 100% (despite years of service) if NRD is before the reporting date

[Tom Poje]

though its getting late for quarterly notices, I am posting this simply to keep this post from going 30 days stale and disappearing off the radar blip.

hope it got people by, I realize it wasn't anything super, but time didn't permit me to do much more than modify something I had on hand.

[Tom Poje]

guess no one reads these things (including me) but upon my further review

part of one line in the description got left off


to perform very well often cause another asset category, or another particular security



thus the one line should read

This is because market or other economic conditions that cause one category of assets, or one particular security, to perform very well often cause another asset category, or another particular security to perform poorly.

so if you downloaded this report you would need to edit it for future use.

This post has been edited by Tom Poje: Jun 4 2007, 09:37 AM