How can the person be removed from all key database tables?

If HR admin creates a person by error in PeopleSoft, how can the person be removed from all key database tables using a delivered process?

Navigate to PeopleTools -> Security -> User Profiles -> Delete User Profiles. Here you can search by user id and there is an option to delete the user profile. This will remove the employee data from key tables like JOB, PERSON, COMPENSATION, PSOPRDEFN.
What is tableset sharing?
In PeopleSoft we have mainly 2 types of primary buckets for tables: Control tables and transaction tables. Control tables store information related to the org structure of the company and all business rules...
In order to setup a state what is the minimal setup requirement?
In order to setup a state, at a minimum, the country has to be setup....
What are the different action types in PeopleSoft?
Action types are used to access data within the system based on the user and/or the level of security. The four action types available are:...
Post your comment
Discussion Board
how to delete an employee from PS
We can not delete an employee from Peoplesoft by deleting User Profile. This would just delete the employee's profile and he will not be able to access PIA.

One can use Setup HRMS > System Administration > Database Processes > ID Delete > ID Delete.

Its an Application engine.

Apart from that, below SQL can be used:

select 'delete from PS_'||recname||' where emplid = ''your Empl ID'' ;'
from psrecdefn where rectype = '0' and recname in (select recname from psrecfield where fieldname = 'EMPLID');

select 'delete from PS_'||recname||'where oprid = ''your OPRID";'
from psrecdefn where rectype = '0' and recname in (select recname from psrecfield where fieldname = 'oprid');

Although, this is not advised in case when any financial transaction has taken place on the employee as this reconciliation would be a big pain.

Thanks,
Vinay
Vinay Patel 10-7-2015

Related Content

Follow us