Data Archive an old Job Opening

Steps to Data Archive an old Job Opening

Step 1: Create a new query of type ARCHIVE .
Here you can select a new record of PS_HRS_JOB_OPENING and select one field HRS_JOB_OPENING_ID.name it DELETE_JO.
This query will have a prompt field HRS_JOB_OPENING_ID whichever you want.

Step 2: Goto PeopleTools > Data Archive Manager > Manage Archive Templates. Create a new Template.
Select base object and archive object as HRS_JOB_OPENING. Select query name DELETE_JO as the new query you create with a prompt field.
Save the template.

Step 3: Go to PeopleTools > Data Archive Manager > Archive data to History. Select the newly created template.
Use 'Selection' and Query as the new query created. Click on Define Binds. Select 'Reset Query Bind Variables'
and enter the Job Opening ID to be deleted based on how your query is setup. Save and run the process.
This process adds all relevant PeopleSoft JO into PS_HRS_JOBOPEN_HST Table.

Step 4: After running the selection process, now run the process using 'Delete' option
This will delete that particular Job Opening.

This way we will have all the deleted jobopening information in the history record for future reference.