PeopleSoft HRMS Functional Interview Questions

24 September, 2020


Related Blogs


PeopleSoft HRMS Functional Interview Questions

Are you planning to attend an interview for the PeopleSoft HRMS Functional Developer role but confused on how to crack that interview and also what would be the most probable PeopleSoft HRMS Functional Interview Questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked PeopleSoft HRMS Functional Interview Questions and answers which are often asked in multiple interviews.

 Categories of PeopleSoft HRMS Functional Interview Questions

1Q) What are checklists? Give an example from the delivered checklists. How will you create a checklist of your own? Explain by giving an example.

Ans:  A checklist is a handout type of utility for the user that can be referenced to ensure that all the tasks the user has to accomplish are done and noted. Say, a recruiter or HR admin wants to hire a new joiner in the HRMS system, there is a recruitment checklist the user can use. When the user is done with all the data entry, he can refer to this checklist in the system. The checklist has a bunch of tasks like passport and documents verified, bank documents sent, offer pack issued, identity check, etc. Users can put the status against each task like initiated, completed, etc.

This is a way of tracking that all formalities related to hiring are completed. Admin can create new checklists also from Setup HRMS -> Common Definitions -> Checklists -> Checklist. If needed new checklist items can also be created from Setup HRMS -> Common Definitions -> Checklists -> Checklist items

2Q) What are all the main components for setting the hiring template?


  1. Template Record/Field
  2. Template Section
  3. Template Category Table
  4. Template Creation

3Q) When do we use the concept of effective sequence?

Ans: An effective sequence concept is used in some key tables like Job. The job table has a high volume of employee transaction data. There are multiple types of transactions and they are all action-driven. It is very likely in a business scenario that employee has the same type of transaction more than once on the same day. For example, Employees can have a data change action happening on the same day more than once. In such a situation, for the same employment instance, we now have more than one row with the same effective date. In order to uniquely store this second transaction, we need another primary key which is where effective sequence comes into play. Hence Job table has a primary key structure: Employee id, employee record number, effective date, and effective sequence.

4Q) What is the regulatory region? Usage?

Ans: A regulatory region is a region which has laws and regulations that are used by functionality in PeopleSoft HRMS. A lot of transactions are driven by regulatory requirements. These requirements include areas like ethnicity, disability, and health and safety. When driven by Regulatory Region, the regulatory codes, People Code edits, and set processing in the system can vary by country and for each transaction.

5Q) What is the most important Record in PS HRMS?

Ans: JOB record

Inclined to build a profession as Peoplesoft HRMS Functional? Then here is the blog post on, explore "Peoplesoft HRMS Functional Training"

6Q) What is a dynamic view?

Ans: Dynamic View is similar to SQL View but we cannot build the dynamic view. When we do not want to store the database then us dynamic view.

7Q) What is the difference between SQL View and Query View?

Ans: In SQL view manually write the SQL statement, Query view uses the PS QUERY tool.

8Q) What is ERP and how it is related to SAP?

Ans: ERP is generally referred to as a class of business software that addresses a business firm in totality, rather than one or two functions. For example, there are accounting software, inventory software, etc. that addresses a specific function of a business. However, ERP class software addresses all the functions of the business and provides an integrated view of the business to the management. SAP is a German company and is the world leader in ERP software across various industries.

9Q) How is the standard hour and FTE auto-calculated when entering job details for a new hire?

Ans: The standard hour is defined in multiple ways in the system. Under Setup HRMS - Installation table in HRMS options, there is a standard hour rule setup. This is at the system level. Here the admin will define the minimum and maximum hours for the HR system and also the default hours. The second place where the setup can be done is in the job code table setup. Under Setup HRMS -> Foundation tables -> Job Attributes -> Job code table. When a user sets up a job code then the standard hour's value can be set specific to that job code. When employee job details are being populated based on the job code, the standard hours and FTE will get refreshed. Also, values like regular/ temporary will get populated.

10Q) What is the difference between the Translate table and the Prompt table?

Ans: There are a few differences between Translate tables and prompt tables1. Translate tables have a max length of 4 char for each element. However, prompt table elements have no such limitation.2. There can be only 30 entries in a translate table. Whereas prompt table can have n number of entries.

PeopleSoft HRMS Function Interview Questions for Freshers

12Q) Explain What is the most important Record in PS HRMS?


  • 8.3 HRMS
    • PS_JOB
  • 8.9 HCM
    • PS_JOB

13Q) What are all the various types of SJT?



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

Ans: PeopleTools is installed in D:PT848


D:pt848SQRinfup_file_name.sqr -i


D:pt848SQRpssqr.ini -S -DEBUGX -PRINTER:PD -EH_PDF -f

D:pt848output_file_name.pdf -o


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

15Q) What is the difference between Transaction table and setup tables?

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

16Q) What are all the job level defaults?


  • Work
  • Job Information
  • Job Labor
  • Payroll
  • Salary Plan
  • Compensation
  • Employment Information
  • Benefit Program Participation
  • Earnings Distribution

17Q) How to retrieve the data from the 3rd scroll, using traversing?

Ans: getlevel0.getrow(1).getrecord(record.level1record)getrow(2).



18Q) What are all the purpose of the Job Earnings Distribution Information Page?

Ans: We can distribute the worker’s compensation on the basis of the following:

  • Department
  • Job Code
  • Earnings Code
  • Business Unit
  • Shift
  • Position Number
  • General Ledger Pay type

19Q) When a user logs into PS by virtue of which security attribute does the system default users country, name format, and company, etc?

Ans: When a user logs in PS the system scans through the user profile to see the associated primary permission list.

There is a setup called org defaults by permission list. Setup HRMS -> Foundation tables -> Organization -> Org Defaults by Permission list.

For every permission list following field, defaults are set here: Business unit, Set, Company, Country, Regulatory region, Currency, and name format.

20Q) Explain the concept of an effective date and its advantages?

Ans: The effective date concept is used in multiple core tables in PS HRMS. For example, in job this is a primary key. The purpose of this field is to differentiate multiple transaction rows for the same employee that has happened on two different dates. The effective date is also used in a lot of setup tables for example location. A location is said active as of today but 5 days later if I wish to make it inactive how does the system recognize the current status of location 5 days in the future. It will be done by using the most effective dated row for that location.

PeopleSoft HRMS Functional Certification Questions

21Q) What are the different kinds of organizational relationships in HRMS? Explain each with relevant examples.

Ans: Different organization relationships a person can have are: Employee, Contingent Worker, or Person of Interest as per the person model. The employee is a permanent staff member of the firm who is paid by company payroll and has a hire row in a job with all associated information like company, department, location, and playgroup, etc. An example is a permanent position for a chief executive or sales manager in the firm.

A contingent worker is a contractor in the organization mostly on an assignment. Personal information and job information is stored for a contractor in the system but the person is not on the company payroll. An example can be a person from a third party company who is acting as a vendor for the firm to conduct a project for the firm needs. This person is a part of the project and working in the firm until the end of the project.

A person of interest has many flavors. There are various types of POI – Pension payee, external trainee, external instructor, or board member. They are members who are connected to the firm due to some business purpose. There are two types of POIs- who have a row in job data and others who do not have. POIs who do not have job information has a separate mechanism in PS to maintain their data security.

PeopleSoft HRMS Functional Training

22Q) What are all the tree manager definitions?


  1. Level
  2. Node
  3. Parent
  4. Siblings
  5. Child

23Q) What are all the job instances used for POIs?


  • COBRA qualified beneficiaries
  • Stock employees not administered in Human Resources
  • Global Payroll Employees
  • Pension Payees
  • Stock board members

 24Q) What are Global assignments? What is the Home and Host concept? How are international assignments security implemented?

Ans: Global assignments enable the organization to assign employees to a global assignment and to monitor, compensate and track education, qualifications for the employee and dependents as they move to multiple locations in the organization having a presence in different geographies.

Employees are based in a Home location. The employee data, benefits, and payroll information is maintained at the home location.

The new location where the employee moves are the Host location.

PeopleSoft delivers three options for International Security:

  • Home can see Host
  • The host can see Home
  • Both

International Security can be set up by navigating to: Setup HRMS -> Security -> Core Row Level Security -> Security Installation Settings

25Q) What are all the organizational instance components?


  1. Add Employment Instance (Job_Data_Emp)
  2. Add Contingent Worker Instance (Job_Data_CWR)
  3. Add Person of Interest Job (Jon_Data_POI)

26Q) When you access an HCM component, say, Job Data, certain values like a business unit, company, etc have defaulted. What governs this concept?

Ans: Values like a business unit, company, country get defaulted by virtue of the user’s primary permission list. These default values are associated with SetIDs on the Business Unit Options Default page.

Using the table set controls and business unit default options, the system determines the default values to enter in select fields on the component. So, when a user accesses a component that uses business unit defaults and selects a business unit, the system determines the setID which drives the defaults for the business unit on the Tableset Control –Record group page.

27Q) What are all the components available under Setup HRMS?


  1. Install
  2. Security
  3. Upgrade
  4. Foundation Tables
  5. Common Definitions
  6. Product-Related
  7. System Administration

28Q) What are the different options for determining the reporting hierarchy in PS as delivered?

Ans: To determine the reporting hierarchy for an employee in PS the delivered options are as follows:

  • If the organization is position driven and uses full position management then the reporting is based on reports to field.
  • If the organization is not position driven then the reporting can be driven based on the supervisor id defined in a job as one option.
  • If the organization is not position driven then the reporting hierarchy can be driven based on the department tree structure as well. Example: In job, if the employee is in department X then the line manager will be the manager of that Department X. If the employee happens to be the manager of that department as well, then the line manager will be the manager of the parent department to X in the department tree structure.

29Q) What are all the statuses available on the template hire status page?


  1. Pending Hires
  2. Cancelled Hires
  3. Processed Hires

30Q) What is a job family? How is it different from job codes in PS?

Ans: To identify a particular job in PS HRMS we use job code. Example: You can have a job code representing an Administrative assistant. This job code will have a defaulted salary grade and standard hours. A collection of multiple such jobs grouped together which use this job code will make a job family.

31Q) What are all the statuses used to define templates?


  1. Test (Default Value)
  2. Active
  3. Inactive

32Q) How is Geographic location code different from locations?

Ans: Location is the core table that is used to define all the office locations of the organization. All locations are tied to a company and setid. Location is also tied to a department. Geographic location is a US federal concept. This is specific to a State –City code. Locality pay area and law enforcement officer special pay area calculations are noted in this setup. Based on the geographic location code setup the locality pay percentages are calculated and used in the US payroll process.

33Q) What are the methods available to update worker’s compensation packages?


  • Seniority Pay increases
  • Grade Advance increases
  • Automated step increases
  • Step increases using review bands
  • Amount increases
  • Percentage increases
About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .