50 PeopleSoft Interview Questions

Top 50 PeopleSoft Interview Questions.

• Explain about the work you have done on a Peoplesoft project?
• How do you use select data in People code (A) Fetch value (Record, recordname, field name, target_row ) OR Fetch value (record, record name, field name, current row number (123)?
• What is a scroll select?
• Limitations of SQLEXEC?
• What is the difference between Work record and Derived Record?
• What is the complicated code you have written in People code and why do you think it is complicated?
• What is the complicated code you have written in SQR and why do you think it is complicated?
• Explain how do you Debug (Application Reviewer)?
• What do you mean by Levels in Panel Designer?
• How do you link crystal reports?
• Differentiate between Ordinary record Vs Work record?
• What is a record in PS?
• Differentiate between Record and Table?
• How many types of records are there in PS?
• What do you mean by PS database management?
• Define Arrays in SQR?
• How do you arrange fields in SCROLL area?
• How do you sort the data in SQR in being select (Using ORDER BY clause)?
• Where do you write People code?
• How do you modify table/record in Peoplesoft?
• What are the limitations of Scroll select in Peoplesoft?
• When do you use nested select in SQR?
• What is Inner join / outer join in Peoplesoft?
• What is Show / display in sqr?
• What is Ask / Input in sqr?
• How do you audit in PS (In Menu designer)?
• How do you rename panel / field / record and what are the consequences / effects?
• What is ENCODE in oracle?
• Explain about Operator and Object security and differentiate operator security is at min level Object security for object level?
• Explain Add / Update display / Update display all / correction with respect to EFFDT?
• Explain what is the difference between EFFDT and EFFSEQ?
• What is the difference between Translate table and Prompt table?
• What are your strong and weak areas in Peoplesoft?
• Explain in brief what is your role in the project?
• What are the modifications or customization you have done in PS?
• Explain in detail about your project team size and your role?
• What are the modifications or customization you have done in existing SQR?
• Explain Batch process in HRMS?
• Explain whats are Audit tables?
• What is the difference between Import manager and SQR?
• What are the important tables that you use in Personal Administration?
• What are the important tables that you use in Benefits?
• Name the important tables that you use in Pay roll?
• Explain about your experience in a Peoplesoft project?
• What are new developments you have done in PS?
• What are the new reports you developed in SQR (Interface, Conversion, Formatted)?
• Describe the advantages of People Tools?
• Can you tell me the advantages of People Code?
• Why SQR is used and advantages of SQR?
• How are you running your HRMS systems either by JOBCODE or by POSITION_NBR?

Dear Readers, we request you to kindly provide the answers in the comment section. Thank you.