15+ Must-Know PeopleSoft [HRMS] Interview Questions & Answers
Last updated on 04th Jul 2020, Blog, Interview Questions
These PeopleSoft HRMS Interview Questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of PeopleSoft HRMS . As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and later they continue based on further discussion and what you answer.we are going to cover top 100 PeopleSoft HRMS Interview questions along with their detailed answers. We will be covering PeopleSoft HRMS scenario based interview questions, PeopleSoft HRMS interview questions for freshers as well as PeopleSoft HRMS interview questions and answers for experienced.
1.What are checklists? Give an example from the delivered checklists. How will you create a checklist of your own? Explain by giving an example.
- Checklist is a handout type of a 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 a hire a new joinee in 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. Checklist has a bunch of tasks like passport and documents verified, bank documents sent, offer pack issued, identity check etc. User can put the status against each task like initiated, completed etc.
- This is a way of tracking that all formalities related to hire 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
2.What are all the main components for setting the hire template?
- Template Record/Field
- Template Section
- Template Category Table
- Template Creation
3.When do we use the concept of effective sequence?
Effective sequence concept is used in some key tables like Job. Job table has 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 same type of transaction more than once in the same day. For example: Employee 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.
4.What is regulatory region? Usage?
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.
5.How Is Last Hire Date Different Than The Hire Date?
Last hire date is the date a person is hired or rehired in the organization. Hire date is the date associated with a hire action job row. For example if a person is hired on 1st May 2010 first time in the company and then terminated on 1st May 2011. Hire date and last hire date both will be 1st May 2010. Let’s say now the person is rehired on 5th May 2011 then the hire date will still remain as 1st May 2010 but the last hire date will now be 5th May 2011.
6.What is dynamic view?
Dynamic View is similar to SQL View but we cannot build the dynamic view. When we do not want store the database then us dynamic view.
7.What is the difference between SQL View and Query View?
In Sql view manually write the SQL statement, Query view use the PS QUERY tool.
8.What is ERP and how it is related to SAP?
ERP is generally referred to 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.
9.How is standard hour and FTE auto calculated when entering job details for a new hire?
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 jobcode table setup. Under Setup HRMS -> Foundation tables -> Job Attributes -> Job code table. When a user sets up a job code then the standard hours value can be set specific to that job code. When employee job details are being populated based on the jobcode, the standard hours and FTE will get refreshed. Also values like regular/ temporary will get populated.
10.What is difference between Translate table and Prompt table?
There are 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. Where as prompt table can have n number of entries.
11. What is PeopleSoft Enterprise HRMS?
- PeopleSoft HRMS is an integrated suite of applications and business processes that are based on PeopleSoft’s Pure Internet Architecture (PIA) and enterprise portal technologies.
- The sophisticated features and collaborative, self-service functionality available in PeopleSoft HRMS enable you to manage your human resources from recruitment to retirement while aligning your workforce initiatives with strategic business goals and objectives.
12. What is PeopleSoft Enterprise HRMS Integrations?
PeopleSoft HRMS integrates with other PeopleSoft applications, such as PeopleSoft Enterprise Financials, PeopleSoft Enterprise Workforce Analytics, and PeopleSoft Enterprise Learning Management. PeopleSoft HRMS also integrates with other third-party applications. PeopleSoft HRMS uses various integration technologies to send and receive data.
13. What are the different components and component interfaces in PeopleSoft HRMS?
- Departments component (DEPARTMENT_TBL) – DEPARTMENT_TBL
- Establishment component (ESTABLISHMENT_DATA) – ESTABLISHMENT_DATA
- Job Code Task Table component (JOBCODE_TASK_TABLE) – JOBCODE_TASK_TABLE
- Job Code Table component (JOB_CODE_TBL) – CI_JOB_CODE_TBL
- Job Tasks component (JOB_TASK_TABLE) – JOB_TASK_TABLE
- Location component (LOCATION_TABLE) – LOCATION_TABLE
- FLSA Calendar Table (FLSA_CALENDAR) – FLSA_CALENDAR
- Pay Run Table (PAY_RUN_TABLE) – PAY_RUN_TABLE
- Tax Location Table component (TAX_LOCATION_TBL) – TAX_LOCATION_TBL
14.How PeopleSoft HRMS stores data?
PeopleSoft HRMS is a table-based system that stores critical general data, such as companies, work locations, and system specifications in a central location. The system enables users to access the same basic information while maintaining data accuracy and integrity.Tables that are central to PeopleSoft HRMS include control tables, transaction tables, and prompt tables.
15.What is a control table in Peoplesoft HRMS?
Control Tables – Control tables store information that is used to process and validate the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications.The information stored in control tables is common and shared across an organization, for example, master lists of customers, vendors, applications, items, or charts of accounts. By storing this shared information in a central location, control tables help to reduce data redundancy, maintain data integrity, and ensure that users have access to the same basic information.The information stored in control tables is generally static and is updated only when fundamental changes occur to business policies, organizational structures, or processing rules.
16. What are transaction tables in Peoplesoft HRMS?
- Transaction Tables – Transaction tables store information about the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications.
- The information stored in transaction tables often changes and is updated more frequently than the information stored in control tables.
17. What are Prompt Tables in PeopleSoft HRMS?
- Prompt Tables – Prompt tables are tables that are associated with fields on PeopleSoft application pages and which display valid data values for those fields when a user selects a prompt or search option.
- The data values stored in prompt tables are retrieved from control tables, transaction tables, or other PeopleSoft tables.
18. What are Business Units in PeopleSoft HRMS?
Business units are logical units that you create to track and report specific business information. Business units have no predetermined restrictions or requirements; they are a flexible structuring device that enable you to implement PeopleSoft HRMS based on how your business is organized.
19. What are Tablesets and SetIDs in PeopleSoft HRMS?
Tablesets and setIDs are devices that enable you to share – or restrict – information across business units. For example, with tablesets and setIDs you can centralize redundant information such as country codes while keeping information such as departments and job codes decentralized.The overall goal of tablesets and setIDs is to minimize data redundancy, maintain data consistency, and reduce system maintenance tasks.
20. What are Effective Dates and what are the benefits of it?
PeopleSoft HRMS uses effective dates to store historical, current, and future information.
Effective datesenable you to:
- Maintain a chronological history of your data. By storing effective-dated information in tables, the system enables you to review past transactions and plan for future events.
- For example, you can roll back your system to a particular time to perform historical analyses for your company. Or, you can set up tables and data ahead of time without using tickler or pending files.
- Maintain the accuracy of your data. By comparing the effective dates in prompt tables to the effective dates on application pages, the system displays only those values that are valid for the current time period.
- For example, you create a new department code with an effective date of May 1, 2008. Then, on the Job Data pages, you enter a new data row for an employee with an effective date before May 1, 2008. When you select the prompt for the department field, you won’t see the new department code because it is not in effect.
21.Explain What is the most important Record in PS HRMS?
- 8.3 HRMS
- 8.9 HCM
22.What are all the various types of SJT?
23.How to run the sqr in command prompt. What are the parameters that are used for running the sqr from command prompt?
- PeopleTools is installed in D:\PT848\
- D:\pt848\SQR\infup_file_name.sqr -i
- D:\pt848\SQR\pssqr.ini -S -DEBUGX -PRINTER:PD -EH_PDF -f
- D:\pt848\output_file_name.pdf -o
- -i => Input file Directory
- -f => Output File Name
- -o => Log file Name
- -ZIF => SQR Initialization File Name
24What is the difference between Transaction table and setup tables?
Table Data which is going to change on daily is transaction table, Table data (Organisation Address, Phone No, Locations) which is going to change as part of the organisation approval is called setup tables
25.What are all the job level defaults?
- Job Information
- Job Labor
- Salary Plan
- Employment Information
- Benefit Program Participation
- Earnings Distribution
26.How to retrieve the data from 3rd scroll, using traversing?
27.What are all the purpose of the Job Earnings Distribution Information Page?
We can distribute the worker’s compensation on the basis of the following:
- Job Code
- Earnings Code
- Business Unit
- Position Number
- General Ledger Pay type
28.When a user logs into PS by virtue of which security attribute does the system default users country, name format and company etc?
- 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, Setid, Company, Country, Regulatory region, Currency and name format.
29.Explain the concept of effective date and its advantages?
Effective date concept is used in multiple core tables in PS HRMS. For example in job this is a primary key. Purpose of this field is to differentiate multiple transaction rows for same employee that has happened on two different dates. Effective date is also used in a lot of setup tables for example location. A location is say 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 future. It will be done by using the most effective dated row for that location.
30.What are the different kinds of organizational relationships in HRMS? Explain each with relevant examples.
- Different organization relationships a person can have are: Employee, Contingent worker or Person of Interest as per the person model. Employee is a permanent staff member of the firm who is paid by company payroll and has a hire row in job with all associated information like company, department, location and paygroup etc. Example is a permanent position for a chief executive or sales manager in the firm.
- 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 person is not on the company payroll. Example can be a person from a third party company which 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 till the end of the project.
- 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 have a separate mechanism in PS to maintain their data security.
Get On-Demand PeopleSoft HRMS Training Course & Become JOB READYWeekday / Weekend BatchesSee Batch Details
31. What is Person or Position Structure in PeopleSoft HRMS?
PeopleSoft HRMS enables you to structure or drive your PeopleSoft Enterprise Human Resources system by person or by position. Before you set up information in the control tables, you must decide which method to use. The system processes the information differently depending on your choice.
32. What’s the Difference between Person or Position?
- When you drive PeopleSoft Human Resources by person, you use job codes to classify job data into groups. You use those codes to link person data to job data.
- When you drive PeopleSoft Human Resources by position, you still use job codes to create general groups, or job classifications, in your organization, such as EEO (equal employment opportunity) and salary survey data, but you also uniquely identify each position in a job code and link people to those positions.
- Job codes primarily have a one-to-many relationship with workers. Many workers share the same job code, even though they might perform the work in different departments, locations, or companies, as shown in the diagram below. You identify the job that a worker performs through the data that you enter in the worker’s job records.
- In contrast, positions usually have a one-to-one relationship with workers. However, you can have several positions with the same job code; positions track details of a particular job in a specific department or location.For example, in job code 1020, Administrative Assistant, you can define different administrative assistant positions with different position numbers—position 15 in accounting, position 16 in the human resources department, position 17 in your marketing department, and position 18 in your production group. Workers are then assigned to these specific positions.
33. Which Method Should You Use Person or Position?
To determine whether you should drive your system by person or position, consider the following:
- If your organization is fluid (that is, if you tend to look at broader groups of workers and create new jobs often), then driving the system by person is probably best for you.
- This method is useful if your organization is continually expanding or if new projects require that you create new jobs or job types regularly.
- If your organization is fairly static (that is, if jobs and job descriptions are mostly fixed, and people move in and out of the same positions), then driving the system by position is probably best for you.
- For example, government agencies and hospitals, which plan positions based on budgets (often well in advance of filling the positions), find this method very useful.
34. What is your understanding of PeopleSoft HRMS System Data Regulation?
- As companies grow larger and more complex, they often need to collect the same type of data across many locations. PeopleSoft business units and setIDs enable you to organize businesses into logical units other than companies and departments and to define how organizational data is shared among these units.
- PeopleSoft HRMS system data is regulated through the use of business units, tablesets and setIDs, and tableset sharing. Business units are logical devices that enable you to implement PeopleSoft HRMS based on how your business is organized.
- Tablesets, setIDs, and tableset sharing are organizational devices that enable you to share – or restrict – the information stored in your HRMS system across business units:
- Business – Unit A logical organizational entity.
- SetID – A high-level key on many control tables.
- TableSet – Set of rows on a control table, grouped by setID, that is available to specific business units.
35. What are Tablesets and how do you work with them?
To work with tablesets, you need to be able to distinguish between tablesets, setIDs, and tableset sharing:
- tableset – A set of data rows in a control table that is identified by the same highlevel key.
- setID – The highlevel key that identifies a set of data rows. There are two types of
- Physical SetIDs – The setID of a business unit (BUSINESS_UNIT = SETID). The rows of data in a physical setID have a one to one relationship with the business unit.
- Logical SetID – A logical setID that is generic and determined by business rules other than business unit. Logical setIDs enable you to share rows of data across multiple business units.
- tableset sharing – Sharing rows of data in a tableset across business units or limiting rows to a single business unit.
36.What are maximum number of actions possible in a step, list them?
Various actions possible in Application Engine step are as follows:
- Do while
- Do when
- Do select
- Call section
- Log Message
- Do until
- One action can be called only once in a step of an Application Engine program.
37.What is Data Permission Security for HRMS?
Data permission security refers to controlling access to the rows of data in your system. In PeopleSoft HRMS, you can control access to the following types of data:
- Contingent workers.
- People of interest (POIs) with jobs.
- People of interest (POIs) without jobs.
- Recruiting job openings.
38. What are Security Sets and Security Access Types?
- A security set is a grouping of data that is being secured. The sets differ by the origin of the transaction security data.
- For example, people of interest without jobs have a separate security set from people with jobs because the transaction data used to secure them does not come from the JOB record, but from the PER_POI_SCRTY record.
- Security access types are ways of securing the data within a security set. Each security set has a number of security access types that you can choose to enable. Among other things, security access types determine:
- The security transaction data.
- If there is data security for future-dated rows.
- If the access type uses a department security tree.
39. How do you implement data permission security?
To implement data permission security, use the Security Installation Settings component (SCRTY_INSTALL), the Security Sets component (SCRTY_SET_TBL), and the Security Access Type component (SCRTY_TYPE2_TBL).
40. What is Future-Dated Security?
The Security Installation Settings page enables you to select actions that, when used on the Work Location page (JOB_DATA1), trigger the SavePostChange PeopleCode to create a future-dated row in SJT_PERSON.
41. What would be the default effective date for creating the new tree?
Ans:1/1/1900 or 1/1/1901
42.What is employment instance?
Employee relationship with organization. Where employee can have multiple relationship (instances) with the organization.
43.What is the difference between a Process and a Report?
The Process receives a command line parameter where as the Report receives run controls from the page.
44. What are all the components will have data permission security control access?
- Employee, Contingent Worker, and POI with Jobs.
- POI without jobs.
- Recruiting Federal People with jobs.
- Template based hires.
45. What are all the organisational relationships available while hiring an employee?
- Contingent Worker
- Person of Interest (POI)
46. List down the people part of the POI?
- COBRA Participants
- Pension Payees
- Global Payroll Payees
- Stock non-HR Person
- Stock board members
- External Instructor
- Payroll Employees
- External Trainers
47.. What are all the People Tools Security?
- Permission List
- User Profiles
48. What are all the default programs you need to run after the creating the user profile?
- Refresh SJT CLASS ALL
- Refresh Trans. SJT tables
- Refresh SJT OPR CLS
49. What are all the default Permission List used while creating the User ID?
- Navigator Homepage Permission List
- Process Profile Permission List
- Primary Permission List
50. What are all the methods for assigning Data Permission Access to Permission List?
- Tree based data permission security
- Role based data permission security
Enroll in PeopleSoft HRMS Training from Industry Experts
- Instructor-led Sessions
- Real-life Case Studies
51. What are all the Access types for Department security sets?
- Departments by Tree
- Departments by non – tree
- Departments by set id
52. What are all the Access types for People with jobs security sets?
- Job department tree
- Job location
- Jon business unit
- Job Company
- Job regulatory region
- Job salary grade
- Person organisation
- Department ID – non tree
- Company – Pay group
53. What are all the Access types for People without jobs security sets?
- POI Business Unit
- POI Location
- POI Institution
- Person of Interest
54.What are all the tree manager definitions?
55.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
56.What are Global assignments? What is Home and Host concept? How is international assignments security implemented?
- Global assignments enables 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 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 is the Host location.
PeopleSoft delivers three options for International Security:
- Home can see Host
- Host can see Home
- International Security can be setup by navigating to: Setup HRMS -> Security -> Core Row Level Security -> Security Installation Settings
57.What are all the organisational instance components?
- Add Employment Instance (Job_Data_Emp)
- Add Contingent Worker Instance (Job_Data_CWR)
- Add Person of Interest Job (Jon_Data_POI)
58.When you access an HCM component, say, Job Data, certain values like business unit, company etc are defaulted. What governs this concept?
- Values like 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 tableset 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.
59.What are all the components available under Setup HRMS?
- Foundation Tables
- Common Definitions
- Product Related
- System Administration
60.What are the different options of determining reporting hierarchy in PS as delivered?
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 supervisor id defined in 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.
61.What are all the statuses available on the template hire status page?
- Pending Hires
- Cancelled Hires
- Processed Hires
62.What is job family? How is it different from job codes in PS?
To identify a particular job in PS HRMS we use job code. Example: You can have a job code representing Administrative assistant. This jobcode 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.
63.What are all the statuses used to define templates?
- Test (Default Value)
64.How is Geographic location code different from locations?
Location is the core table which 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 US payroll process.
65.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
66. How do you SetUp and Assigning Tree-Based Data Permission?
To set up and use tree-based data permission, use the Tree Manager component (PSTREEMGR), Security Tree Audit Report component (RUNCTL_PER506), Security by Dept Tree component (SCRTY_DATA), and Refresh SJT_CLASS_ALL component (SCRTY_OPR_RC).
67. How do you modify Security Trees?
You can modify an existing tree by changing either the nodes or the levels. When you modify a security tree, the tree node numbers usually change, so you need to refresh the numbers. You also need to run the Refresh SJT_CLASS_ALL process to update the data access profiles and security join tables.
68. How do you allow Workers to Update Their Own Data?
PeopleSoft HRMS doesn’t allow users to update their own data except in the self-service internet applications.However, sometimes you might want them to update some of their own data in other components. To allow users to update their own data, you implement the PeopleCode function Allow EmplIDChg (allow emplID change).The function looks for a single Boolean parameter. When the parameter is set to true, workers can update their own data; when it is set to false, they cannot.
69. How do you administer Country Codes?
To administer country codes, use the Country Table (COUNTRY_TABLE), the Country Table – HR (HR_COUNTRY_TABLE), and the State/Province (STATE_DEFN) components.
70. What is Search/Match?
To use the full functionality of your system, you must maintain the integrity of your database. With users from many departments entering data into your system, you want to minimize the entry of duplicate or multiple records. Search/Match enables you to define criteria to check for duplicate or multiple ID records.
The searchable ID types (called Search Types) are:
- Person (EmplID)
- Applicant (HRS_PERSON_ID within PeopleSoft Enterprise Talent Acquisition Manager)
71. How do you setup Search/Match?
To set up Search/Match use the Search Match Rules (HCR_SM_RULE), Search/Match Parameters (HCR_SM_PARM), Search/Match Result Fields (HCR_SM_RSLT_FLDS), Search/Match Results (HCR_SM_RESULT), and Search/Match (HCR_SM_SEARCH) components.
72. What is the difference between Search Box Search and Search/Match?
The difference between record search from search dialog pages and using Search/Match is this: You use search box pages to retrieve existing records using limited search criteria to view or update data, and you use Search/Match to use a larger set of search criteria that detect duplicate or multiple records in your database or to identify different records that contain duplicate data that should uniquely identify only one ID.
73. What are Frequency IDs?
Frequency IDs are used in PeopleSoft Enterprise Human Resources, Global Payroll, and Payroll for North America. Frequency IDs are defined on the Frequency Table component (FREQUENCY_TBL). Each frequency ID has a frequency type and an associated annualization factor that represents the number of times that the period occurs in the course of a year.
74. How do you setup person of interest types?
To set up person of interest types, use the Person of Interest Types (POI_TYPE_TBL) component.
75. What are Establishments?
You use the Establishment component to define distinct physical places of business (establishments) within your company, to enter address information, and to enter regulatory reporting information. In PeopleSoft Human Resources, you define establishments that are consistent with the regulatory requirements of your business operations.
In PeopleSoft Human Resources, an establishment:
- Has an address.
- Is associated with a company.
- Is used for regulatory purposes
76. What are all the Access types for Recruiting Job Opening security sets?
- RS Company
- RS Business Unit
- RS Department ID
- RS Location
- Recruiting Team
77. What are all the Access types for Template Based Hire security sets?
- Template ID
- Template Category
- Person Organisation
78. What is the default tree name need to give while creating the new tree?
Dept_Security followed by any name as per your requirement.
Dept_Security followed by any name as per your requirement.