Important PeopleSoft HRMS Interview Questions

Q – 1 Explain What is the most important Record in PS HRMS?

Ans- it depends on the version

8.3 HRMS :

PS_JOB
PS_EMPLOYMENT
PS_PERSONAL_DATA

8.9 HCM :

PS_JOB
PS_PERSONAL_DATA
PS_PER_ORG_ASGN

Q – 2 What is the difference between Transaction table and setup tables?

Ans- Table Data which is going to change on daily is transaction table , Table data (Organisation Address , Phone No , Locations) whcih is going to change as part of the organisation approval is called setup tables

Q – 3 What are the setup tables?

Ans- he data which is not going to change frequently such type of data is stored in setup tables.

Exp:

Company Address,Phone No,Company Locations,Company Name,Business Units,Departments , Positions.

Q – 4 How to run the sqr in command prompt. What are the parameters that are used for running the sqr from command prompt?

Ans- Let’s say your PeopleTools is installed in D:PT848

D:PT848binsqrDB2BINWsqrw.exe
D:pt848SQRinfup_file_name.sqr -iD:pt848SQR
-ZIFD:pt848SQRpssqr.ini -S -DEBUGX -PRINTER:PD -EH_PDF
-fD:pt848output_file_name.pdf -oD:pt848log_file_name.log

Where:

Options:

-i => Input file Directory
-f => Output File Name
-o => Log file Name
-ZIF => SQR Initialization File Name

Q – 5 How to retrieve the data from 3rd scroll, using traversing?

Ans- getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(3).
getrecord(record.level3record);
The above answer is for to retrieve the 3rd scroll recoed
level data only.

If u want the field level information use below syntax
getlevel0.getrow(1).getrecord(record.level1record)getrow(2).
getrecord(record.level2record)getrow(3).
getrecord(record.level3record)getfield(field.fieldname);

Q – 6 How to create field as mandatory?

Ans- using data buffer classes in people soft we have show required field que.using that we can conver it to mandatory