Question:
How to deal with PeopleSoft Job Opening Ids are on Pending Status which had some approval path issue? or what is the best approach to delete that old Job Opening ID.
Answer:
In PeopleSoft, there is no direct "Delete" option available for Job Openings. The best practice is to "Data Archiving" process to archive the same.
Steps to Data Archive a old Job Opening or a Job Opening which is in “Pending Approval” status (Since you want to delete a pending job opening)
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.
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.
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.
4). After running the selection process, now run the process using 'Delete' option
This will delete that particular Job Opening.
if you do not want to use the above option..here are the tables that you use to delete the PeopleSoft Talent Acquisition Job OPening:
Records
HRS_JOB_OPENING
HRS_G_JO_PRI
HRS_JO2_LNG
HRS_JOBINDX_CTL
HRS_JOPSTDS_LNG
HRS_JO_ANS
HRS_JO_APRV
HRS_JO_APRV_STS
HRS_JO_ATCH
HRS_JO_ATCH_LNG
HRS_JO_EDUC_EXP
HRS_JO_EXP
HRS_JO_EXP_LNG
HRS_JO_HJ_HIST
HRS_JO_ITEMS
HRS_JO_LNG
HRS_JO_LOC
HRS_JO_LOC_AREA
HRS_JO_NAME
HRS_JO_NOTE
HRS_JO_NOTE_LNG
HRS_JO_OE_EVAL
HRS_JO_POSN
HRS_JO_POSTING
HRS_JO_PROFILE
HRS_JO_PST_DSCR
HRS_JO_PST_DST
HRS_JO_PST_LNG
HRS_JO_QSTN
HRS_JO_RPL
HRS_JO_RQMT
HRS_JO_STS
HRS_JO_TEAM
HRS_PSTDSCR_LNG
HRS_SCR_HIST
Hope this helps
How to delete a Job Opening?
Read more...