PeopleSoft HRMS System Configuration Insight (PSFTHRMSSCI)

To extract the files in script-based extraction:

  1. Edit the ExtractPSFTHRSCI.sql file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTHRSCI.sql file. To comment the query place /* before the SELECT statement and place */ as the end of the select statement please refer the example given below. 
    SET TERMOUT ON
PROMPT Extracting PSACCESSPRFL 
SET TERMOUT OFF
SPOOL &1\PSACCESSPRFL.txt 
/*SELECT NULL||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||SYMBOLICID||'$$$$!@**'
||VERSION||'$$$$! @**'||ACCESSID||'$$$$!@**'||ACCESSPSWD||'$$$$!@**'||ENCRYPTED
||'$$$$!@**###' FROM PSACCESSPRFL;*/
SPOOL OFF