Script - Remove Participants from Plan
Has anyone used scripts to remove participants for a plan? We have a plan sponsor that repeatedly loads payrolls into the wrong plan, resulting in participants that need to be deleted. I assume there is a way to go directly to the tables to delete the participants with a discrete list, I am just worried about leaving orphan data out there if we don't remove data from all the right places. If you have done this and are willing to share your scripts, I would appreciate it. We are on ASP and would just need to request DELETE access to the specific tables.
12 Views
Hey Asa -
We're installed, but we use the File > Data Administrator > Delete > Employees by Plan,SSnum File function to delete participants en masse. I'm not positive if you have access to this by default as an ASP client, but if you don't I'd see about getting access to that instead of potentially using some DELETE scripts - especially if the way they're being added to the plan is via a Payroll upload, because there's probably PAYROLL, USERPAYROLL and potentially other tables (TRANS, TRANSLED if transactions are generated with the wrong plan) that get affected outside of just PLANEE and PLANEE2.