Welcome message on PeopleSoft PIA.

As per a requirement, we have to show "Welcome xyz" as welcome screen on the PIA of PeopleSoft. This is not specific to user personalization.

Steps for Customization..

1. In Application Package PT_BRANDING, Application Class BrandingBase, Method GetIScriptHPDefaultHdrHTML. we have to do one customization to see welcome message on very first screen

delivered to be replaced
Greeting = &Portal.Homepage.Greeting;

With

Local string &EMP_NAME;
/* &Greeting = &Portal.Homepage.Greeting; */
SQLExec("SELECT A.FIRST_NAME FROM PS_NAMES A WHERE A.EMPLID = :1 AND A.NAME_TYPE = 'PRI' AND A.EFFDT = (SELECT MAX(AA.EFFDT) FROM PS_NAMES AA WHERE AA.EMPLID = A.EMPLID AND A.NAME_TYPE = A.NAME_TYPE AND AA.EFFDT <= :2)", %EmployeeId, %AsOfDate, &EMP_NAME); &Greeting = " Welcome " | &EMP_NAME;

2.To show on all pages over PeopleSoft we need to edit Application Package PT_BRANDING, Application Class BrandingBase, Method GetUniHeaderHTML and GetUniHeaderHTML_PIA.

by adding the following just before the ‘If &navTheme.isNS4x()’:
Local string &EMP_NAME;
SQLExec("SELECT A.FIRST_NAME FROM PS_NAMES A WHERE A.EMPLID = :1 AND A.NAME_TYPE = 'PRI' AND A.EFFDT = (SELECT MAX(AA.EFFDT) FROM PS_NAMES AA WHERE AA.EMPLID = A.EMPLID AND A.NAME_TYPE = A.NAME_TYPE AND AA.EFFDT <= :2)", %EmployeeId, %AsOfDate, &EMP_NAME); &Greeting = " Welcome " | &EMP_NAME;

N.B. We can also directly use the PS_PERSON_NAME record(View) to get the employee's name (i.e. PRI & max. effective dated).