What is Lookup Exclusion Table?

This is a way to stop auto look up facility.

For example when we click on position number field prompt on job data page, it gives all position numbers. But we don't require that but for showing all the values it takes time.

So if we assign that particular prompt table as Lookup Exclusion table then when we click on prompt button for position number it will give a chance to partial search for a value.

navigation to define a record as Lookup Exclusion Table :
PeopleTools --> Utilities --> Administration --> Lookup Exclusion Table.

Forgot Password Configuration on PeopleSoft

https://docs.google.com/fileview?id=0BxxPWr6VOcE1NzEzZjAwMzUtOTAwMS00ZTA0LWFjMWMtZDU2YTMwZDZhMDUw&hl=en

How to see different alerts on PIA.

How to configure birthday alert, anniversary Alert, Direct Reports etc.

Navigation :

PeopleTools --> Portal --> Structure & Content --> Portal Objects à HomePage -->Tabs --> Tab Content --> Check alerts --> Tab Layout (configure the alignment).

Thats all...

Careers site for External Applicants..

Lets discuss about how to create a career site for external applicants.


Step 1: Create a user id as Careers and set a password(PS) for it.Assign "External Applicant" & "Recruitment User" roles to this userid.Save it.

Important : DO NOT ATTACH ANY OTHER ROLE TO THIS USER ID.

Step2: go to PeopleTools --> Webprofile --> Webprofile Configuration.


Then choose the profile means the instance.(e.g. DEV)


Go to the "Security" tab and check "allow public access" and give the userid "Careers" and password "PS" and save it.

Step 3: To access the careers page type

"http://Your IP:Port/psc/ps/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_CE.GBL"

link and it will take to you the careers site.

Thats all...

Strings Table in PeopleSoft....

Strings table is a record which stores multilingual labels for SQRs.

Something confusing!!!

Let me explain...

There is a delivered sqc (i.e. sqrtran.sqc) which is used for multilingual sqrs.In customized sqrs we have to call this sqc and the respective procedure.
When we are running sqrs from process scheduler it fetches the language code and find the lables from Strings table (PS_STRINGS_LNG_TBL) with respect to language code except ENG.For ENG it refers PS_STRINGS_TBL.

We need not to hard code the lables for different languages in the sqr.

We can check also some delivered SQRs like PER001.sqr etc.

For doing this just logged in to PIA with a language other than ENG and follow the below navigation.

Main Menu > PeopleTools > Utilities > Strings Table

Then we can search per001 by giving as the program id.Then just translate a label to the particular language & save it.

Then try to run the sqr and see the label at output.

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).

After a long time of creation...

After a long time of creation of blog finally I decided to post something.

I am working as a Techno-Functional consultant.
Functional is very specific to Time & Labor of PeopleSoft 9.0.

Ok. Let's start.