Peoplesoft Hrms Technical Interview Questions

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.

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.

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.

File formats for File Layout?

xml

csv

fixed length

Prompt table with no edit to no edit?

user can enter values from prompt table

user can enter values from prompt table and default value will be populated

Meta-SQL where is it stored?

Temp Table

SQL Table

Query Table

Dynamic(Guess: Temp Table, check People books App Engine)

What are all stored in System Catalog?

SQL table

SQL View

Process Profile contains?

-Sequence of processes

-Sequence of jobs

-batch processes

File format for SQR?

PDF

txt

PeopleSoft clients wants to get info about PSPT where to find it?

Partner Alliance

Partner Connection

PeopleSoft Connect

Portal connect

PSU (check)

Which of the following are object definitions?

Mobile Page

File Layout

App Engine

What are the options for using SQL in people code?

Sqlexec

Record class methods (selectbykey, delete, insert, update)

Using sql class, its properties and methods.

What is the difference between component buffer and data buffer?

Component buffer contains all the data of the active component.

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)

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

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:

Department

Job Code

Earnings Code

Business Unit

Shift

Position Number

General Ledger Pay type

What are the main attributes of a Component Interface (CI)?

Keys, Properties & Collections, Methods and Name

Can a PeopleTools 8.4x and a PeopleTools 8.1x  database runs on the same machine?

Yes, databases can co-exist on the same physical machine In most cases, the databases themselves can exist within the same RDBMS; however, it is important to verify that the database version required by PeopleTools  is the same as for the current PeopleTools x implementation.

Does Application Messaging work between 8.1x  and 8.4x applications?

Application Messaging is used by PeopleSoft applications to communicate with one another This is true not just for x and  applications, but also between an x and an  application For example, the HRMS  applications, which are based on PeopleTools , can communicate with Financials  applications, which are based on PeopleTools , using Application Messaging If specific issues materialize relating to the Application Messages published by certain applications, these new messages will be made available to customers

Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?

User can type only prompt table values and the default values gets populated from the database

Which Data Type is NOT supported by the PeopleCode programming environment

TIMESTAMP

What are the statuses available in PeopleSoft Domain Status Menu?

Server, Client and Queue Status

What are parts of an AE program?

Section, Step and Action

Which peoplecode event is fired after the database is updated?

SavePostChange

PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

PSRELEASE

Which command is valid in both bootstrap and regular mode when operating the data mover?

GRANT_USER

PeopleCode events pertaining to Record Field:

FieldEdit, Save Edit and Row Delete

What views available in Application Designer project workspace?

Development and Upgrade

Which of the record definitions in PeopleSoft is NOT stored on the database and is therefore NOT required to be built?

Derived/Work Record

PS Query definition is stored on which server?

DB Server

How do you login into Boot strap mode?

Using DB Access Id

Where will you configure failover of Application Server ?

Configuration.Properties

What Record Changes does not affect Database?

Change in List box in Record Field properties

Which Web Services is only used as a Proxy Server?

MS IIS

Apache

Where does you set the web server cache?

Webserver configuration.properties file

Which task cannot be done through PSADMIN?

Starting Web Server

What is the configuration file that contains the entire collection configuration values for a given application server domain?

PSAPPSRV.CFG

Which of the following record is not found in database?

Derived /Work record