Please forgive this techie asking functional questions, but I'm doing an HR conversion and this seems a little odd to me.

Client has 40,000 employees and running the HR515 takes an inordinate amount of time. Checking the process I see that it's making massive calls to PGSELECT and PGEMPLOYEE. Further investigation shows that the client has set up 10,000+ employee groups and that employees may belong to as many as 100 of them - meaning that PGEMPLOYEE has over 4.8 MILLION entries!

It seems to me that this is a bit odd, but not having much HR savvy I'm asking here. Is that an extraordinary number of employee groups?

Thanks!

10000+ employee groups seems excessive to me. I can't imagine trying to manage that many groups.

As a point of reference we have 15000+ full and part-time employees and 105 employee groups. Some of the groups are only used for special processing such as raises or year end updates. Most or our full-time employees w/ benefits are members of a couple of dozen or so employee groups. We have no unions or shift work so that may be a factor.

I'm not sure if we would be considered a typical or not.

we have about 4,000 employees and 125 Emp Groups.

:wwf:

We have 9000 employees and 418 groups

having 10,000 groups may really slow down PA52, HR11, and PA100 also. I wonder how many groups it would take before HR11 and PA52 timed out prior to completing the transaction? You may want to warn the client of recurring processing time risks...

We've started our upgrade to LSF9, and one of our cleanup items was to review and delete groups no longer needed. In HR, we created groups for mass pay changes; those can be deleted after the change is done. Any group flagged for benefits can't be deleted - unless you change the flag, and it's really not being used on a plan.

Our clean up reduced the number of ee groups fro 200 to 100. We have 4000 employees.

Someone at your clinet is group-happy, Dave, and that's not necessarily a good thing! Maybe users are just building new groups rather than trying to search thru all those already built...

I, too, agree - seems like 10,000 groups is a bit excessive. As a federal employer, we do pretty much everything to excess, and with 10,600 employees, we have approximately 500 groups, only because each member office of the House of Reps was set up as an individual group (and we pretty much never use those particular groups!). I'll bet a review will show groups with the same criteria, which can definitely cause you problems! Have fun