NAME: Purge GSP Transactions in Staging Table
SHORT CODE: PQHGSPUR
MODULE: Oracle Public Sector HR

Description: Purging GSP Transactions in Staging Area
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_alias : Master Table alias name
• paramname1 : Short Name
• paramvalue1 : Value for Short Name
• paramname2 : Status
• paramvalue2 : Value for Status
• paramname3 : Start Action Date
• paramvalue3 : Value of Start Date
• paramname4 : End Action Date
• paramvalue4 : Value of End Date
• paramname5 :
• paramvalue5 :
• p_effective_date : Effective Date for Datetracked data