Storing URLs for System Source IDs and Versions

PeopleSoft EPM contains two tables—PS_SRC_CONFIG and PS_SRC_COMPONENT—that the Fusion Campus Solutions Intelligence application use to store the information that is needed to drill into PeopleSoft online transaction applications from Fusion Campus Solution Intelligence application.

• The PS_SRC_CONFIG table stores the URL for the PeopleSoft homepage for a particular source system ID and version.

  This is a deployment activity and will vary based on your particular PeopleSoft Internet Architecture (PIA) installation. The URL will be different for each implementation.

  Do not add a forward slash to the end of the URL. Add a row if the row does not exist for a particular source, or just update the row.

  This is an example of an SQL statement that sets up the functionality to drill into a PeopleSoft Campus Solutions instance:

  UPDATE PS_SRC_CONFIG
  SET URL_1 = 'HTTP://ADNTAS42.PEOPLESOFT.COM:6300/PSP/EM_HC890TS1_TS091824'
  WHERE SRC_SYS_ID='HCM'

• The PS_SRC_COMPONENT table stores the component paths for a particular version of the source system ID.

  The component paths may vary for different versions of the same PeopleSoft online transaction application.

  Create a URL for the path to the PIA online transaction application component in this table. Add a forward slash to the beginning of the string. Make sure that all the key fields are on the string, and that their parameter value is :1, :2, and so on, based on the number of keys in the component.

  This is an example of an SQL statement that sets up the functionality to drill into the Admission Application page in the Campus Solutions instance. In this example, the component path has three parameters:

  INSERT INTO PS_SRC_COMPONENT 
  VALUES ('HCM','ADM_APPL_PROG_MNT','CS ADMISSION APPLICATION 
  PIA PAGE', '/EMPLOYEE/HRMS/C/PROCESS_APPLICATIONS.ADM_APPL_
  MAINTNCE.GBL?PAGE=ADM_APPL_PROG_MNT&EMPLID=&APPL_PROG_NBR=&
  ACAD_CAREER=&ADM_APPL_NBR=:1&INSTITUTION=:2&ADMIT_TERM=:3');

Repeat this step to set up drill in place functionality for as many pages as necessary.