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.