PeopleSoft HRMS Functional Interview Questions

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

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

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

Ans:

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

Q3) 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 an 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 the Job table has a primary key structure: Employee id, employee record number, effective date, and effective sequence.

Q4) What is the regulatory region and usage?

Ans: A regulatory region is a region that 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.

Q5) What is the most important Record in PS HRMS?

Ans: JOB record

Q6) 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 use dynamic view.

Q7) 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.

Q8) 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.

Q9) How are 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 populated based on the job code, the standard hours and FTE will get refreshed. Also, values like regular/ temporary will get populated.

Q10) What is the difference between the Translate table and the Prompt table?

Ans: There are a few differences between Translate tables and prompt tables

1. Translate tables have a max length of 4 chars for each element. However, prompt table elements have no such limitation.
2. There can be only 30 entries in a translate table. Whereas a prompt table can have n number of entries.

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

Ans:

• 8.3 HRMS
  • PS_JOB
  • PS_EMPLOYMENT
  • PS_PERSONAL_DATA
• 8.9 HCM
  • PS_JOB
  • PS_PERSONAL_DATA
  • PS_PER_ORG_ASGN

Q12) What are all the various types of SJT?

Ans:

• SJT_CLASS
• SJT_CLASS_ALL
• SJT_PERSON
• SJT_DEPARTMENT

Q13) How to run the sqr in the 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:PT848binsqrDB2BINWsqrw.exe

D:pt848SQRinfup_file_name.sqr -i

D:pt848SQR-ZIF

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

D:pt848output_file_name.pdf -o

D:pt848log_file_name.log

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

Q14) What is the difference between a Transaction table and a setup table?

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

Q15) What are all the job level defaults?

Ans:

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

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

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

getrecord(record.level2record)getrow(3).

getrecord(record.level3record);

Q17) What are all the purposes 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

Q18) When a user logs into PS by virtue of which security attribute does the system default the user’s country, name format, 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. Set up 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.

Q19) 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 a 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 to be active as of today but 5 days later if I wish to make it inactive how does the system recognize the current status of the location 5 days in the future? It will be done by using the most effective dated row for that location.

Q20) 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, 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 flavours. 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- that have a row in job data and others that do not. POIs who do not have job information have a separate mechanism in PS to maintain their data security.

Q21) What are all the tree manager definitions?

Ans:

• Level
• Node
• Parent
• Siblings
• Child

Q22) What are all the job instances used for POIs?

Ans:

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

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

Ans: Global assignments enable the organization to assign employees to a global assignment and to monitor, compensate and track education, and 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

Q24) What are all the organizational instance components?

Ans:

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

Q25) 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.

Q26) What are all the components available under Setup HRMS?

Ans:

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

Q27) 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 the 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.

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

Ans:

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

Q29) 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 a 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.

Q30) What are all the statuses used to define templates?

Ans:

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

Q31) 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.

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

Ans:

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

PeopleSoft HRMS Functional Interview Questions and Answers for Fresher’s

1. What are all the components that will have data permission security control access?

• Departments
• Employee, Contingent Worker, and POI with Jobs.
• POI without jobs.
• Recruiting Federal People with jobs.
• Template-based hires.

2. What are all the organizational relationships available while hiring an employee?

• Contingent Worker
• Employee
• Person of Interest (POI).

3. 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.

4. What are all the People Tools Security?

• Permission List
• Roles
• User Profiles.

5. What are all the default programs you need to run after creating the user profile?

• Refresh SJT CLASS ALL
• Refresh Trans. SJT tables
• Refresh SJT OPR CLS.

6. What are all the default Permission List used while creating the User ID?

• Navigator Homepage Permission List
• Process Profile Permission List
• Primary Permission List.

7. What are all the methods for assigning Data Permission Access to Permission List?

• Tree-based data permission security
• Role-based data permission security.

8. What are all the Access types for Department security sets?

• Departments by Tree
• Departments by non–tree
• Departments by set id.

9. What are all the Access types for People with job security sets?

• Job department tree
• Job location
• Jon business unit
• Job Company
• Job regulatory region
• Job salary grade
• Person organization
• Department ID – nontree
• Company – Pay group.

10. What are all the Access types for People without job security sets?

• POI Business Unit
• POI Location
• POI Institution.
• Person of Interest

11. What are all the Access types for Recruiting Job-Opening security sets?

• RS Company
• RS Business Unit
• RS Department ID
• RS Location
• Recruiting Team

12. What are all the Access types for Template-Based Hire security sets?

• Template ID
• Template Category
• Person Organisation
• Country.

13. What is the default tree name that needs to give while creating the new tree?

Dept_Security followed by any name as per your requirement.

14. What would be the default effective date for creating the new tree?

1/1/1900 or 1/1/1901.

15. What are all the tree manager definitions?

• Level
• Node
• Parent
• Sibling
• Child.

16. What are all the various types of SJT?

• SJT_CLASS
• SJT_CLASS_ALL
• SJT_PERSON
• SJT_DEPARTMENT.

17. What are all the organizational instance components?

• Add Employment Instance (Job_Data_Emp)
• Add Contingent Worker Instance (Job_Data_CWR)
• Add Person of Interest Job (Jon_Data_POI).

18. 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.

19. What are all the purposes 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.

20. What are all the job level defaults?

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

PeopleSoft HRMS Functional Interview Questions For Experienced

21: What are all the main components for setting the hiring template?

• Template Record/Field
• Template Section
• Template Category Table
• Template Creation.

22. What are all the statuses used to define templates?

• Test (Default Value)
• Active
• Inactive.

23. What are all the statuses available on the template hire status page?

• Pending Hires
• Cancelled Hires
• Processed Hires.

24. 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.

25. What are all the components available under Setup HRMS?

• Install
• Security
• Upgrade
• Foundation Tables
• Common Definitions
• Product-Related
• System Administration.

26 What is an Effective Date?

Information Component /Record linked to the data EFFDT. Information changes based on the EFFDT.

27. What is Effective Sequence?

Identifier to find the order of multiple transactions occurring on the same EFFDT.

28. What is the effective sequence’s default number?

Zero 0.

29. What’s the difference between a position number and a job code?

Position number is the unique identification number driven by business unit, department, location, job code, and other parameters.

30. What is the purpose of the update/display mode?

To add the new information on current and future as well as view the current data.

31. What is the purpose of the correct history mode?

To correct the past and current information based on the EFFDT.

32: What is the purpose of include history mode?

To view the past information based on the EFFDT.

33. What is the Employee Record Number?

Number to identify an employee’s different organizational relationships.

34. What are all the mandatory fields that need to be key in while adding a person to the system?

1. Name
2. Organizational relationship.

National ID, Address, and Birthdate give us a warning message.

35. What is an employment instance?

Employee relationship with the organization. Where employees can have multiple relationships (instances) with the organization.

36. What is the difference between Set Id and a Business Unit?

Where a Business Unit organizes your company or your organization, SetIDs help you organize your data within the system. The HRMS system uses tables (Control Tables or Prompt Tables) that use a high-level key that enables you to identify and retrieve data from the system. A secondary high-level key referred to as a SetID, has also been added to various tables. SetIDs are simply the labels used to identify a table set. Business Unit and SetID functionality in PeopleSoft also provides you with a higher business level for reporting purposes and other business data roll-up.

37. What is HCCPALL?

Delivered primary permission list with access to all the components and pages.

1. List the components that have data permission security control access.

Ans: Here are the components that have data permission security control access.

• Departments
• POI without jobs
• Employee, Contingent Worker, and POI with Jobs
• Template-based hires
• Recruiting Federal People with jobs

2. What are the components for setting a hiring template?

Ans: The main components for setting the hiring template are,

• Template Creation
• Template Section
• Template Record/Field
• Template Category Table

3. Tell the difference between the Translate table and the Prompt table.

Ans: The key differences between a translate table and a prompt table are as follows.

• The translate table can store values of length < 5. The prompt table can store values of length < 255.
• If we want to fetch the table values of the prompt table, we have to make a call to the database. The table values of the translate table are readily available as they get loaded into the buffer.
• There is a limitation of 30 entries in a translate table. The translate table does not have any limitations and can store any number of entries.

4. What are the POI types in PeopleSoft HRMS?

Ans: The following are the types of POIs in PeopleSoft HRMS.

• Unknown
• External Trainee
• External Instructor
• Campus Solutions Person
• Student Refund (Job)
• COBRA Beneficiary (Job)
• Pension Payee (Job)
• Stock – Board Members (Job)
• Stock – Non-HR Employee (Job)
• Global Payroll Payee (Job)
• Other

5. Explain effective sequence.

An effective sequence is an approach used in some key tables. There might be a need to add more than one row with the same effective date. This will make the unique identification process a bit difficult. In that case, the effective sequence assigns a unique sequence number to the row that has the same effective date.

6. What are the default programs that you have to run after creating a user profile?

Ans: After creating a user profile, we need to run the below programs.

• Refresh SJT CLASS ALL
• Refresh Trans. SJT tables
• Refresh SJT OPR CLS

7. What is the difference between the transaction table and set up tables?

Ans: Below is the difference between a transaction and a setup table.

• A transaction table stores data that changes regularly. The transaction table values are also loaded into the buffer for better availability.
• A setup table is used for setting some standards across the organization. The data values of setup tables only change after organization approval.

8. What are the access types for People with job security sets?

Ans: The following are the access types for people with job security sets.

• Job Company
• Job location
• Job department tree
• Job business unit
• Job regulatory region
• Job salary grade
• Person organization
• Department ID – non-tree
• Company – Pay group.

9. List the job instances used for POIs.

Ans:The job instances used for POIs are,

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

10. What are tree manager definitions?

Tree manager definitions are used to graphically represent the hierarchy in an organization. These trees can be used in reports, OLAP, summary ledgers, etc. The tree manager definitions are,

• Level
• Node
• Parent
• Siblings
• Child

11. Name the various types of SJT.

Ans: There are four types of SJTs available in PeopleSoft HRMS.

• SJT_CLASS
• SJT_CLASS_ALL
• SJT_PERSON
• SJT_DEPARTMENT

12. What are the organizational instance components?

Ans: While creating a new organizational instance, we can use one of the below components.

• New Employment Instance (JOB_DATA_EMP)
• New Contingent Worker Instance (JOB_DATA_CWR)
• Template-Based Hire (HR_TBH_EULIST)
• Add Person of Interest Job Relationship (JOB_DATA_POI) 

13. What are the pages used for processing workers’ compensation?

Ans: PeopleSoft HRMS uses the below pages to process workers’ compensation.

• Batch Publish Rules
• Batch Programs
• Workers Comp Premium
• Workers Comp Accounting
• Batch Publish

14. What Organizational relationships will be available when hiring a new employee?

Following are the organizational relationships that are available when a new employee is hired:

• Employee
• Contingent Worker
• Person of Interest

15. What default Permission list is used during the creation of the User ID?

The default permission lists that are used during the creation of a User ID are as follows:

• Primary Permission list
• Navigation Home page permission list
• Process Profile permission list

16. What are the several methods to assign data permission access to the permission list?

The following are the methods used to assign data permission access to the permission list:

• Role Based data permission security
• Tree based data permission security

17. What access types are available to the department security sets?

Following are the Access types available to the department security sets:

• Departments by tree
• Departments by set id 
• Departments by non-tree

18. What access types are available to those who don’t have job security sets?

Following are the access types available to those who don’t have a job security sets:

• Person of Interest
• Person of Interest Location
• Person of Interest Business Unit
• Person of Interest Institution

19. What access types are available to recruit Job opening security sets?

Following are the access types available to recruit Job opening security sets:

• Recruiting team
• RS Location
• RS Company
• RS Department ID
• RS Business Unit

20. What access types are available for the template based hire security sets?

Following are the access types available for the template based hire security sets:

• Template Category
• Template ID
• Country 
• Person Organization

21. What should be entered as the default name for the new tree when it is created?

The default name for the new tree when it is created is written in such a way that Any name that satisfies your needs must come after the Dept_Security.

22) What are the various Statutes that are used for defining templates?

The following are the statuses that are used for defining templates:

• Active
• Inactive
• Test (it will be the default value)

23) What are the various statutes that are available on the template hire status page?

Following are the various statutes that are available on the template hire status page:

• Processed hires
• Canceled hires
• Pending hires

24) What methods are available for updating the compensation packages of the Workers?

Following are the methods that are available for updating the compensation packages of the Worker:

• Automated step increases
• Amount increases
• Step increases using review bands
• Seniority pay increases
• Percentage increases
• Grade Advance increases

25) What components are included in Setup HRMS?

The following are the components included in Setup HRMS:

• Install 
• Upgrade
• Security
• Common definitions
• Foundation tables
• System Administration
• Product related

26) Why is the update/display mode used?

The update or display mode is used for adding new statistics and also viewing the current data.

27) Why is the correct history mode used?

The correct history mode is used for correcting past and present information according to EFFDT.

28) What is the use of include history mode?

The include history mode is used for viewing past information according to the EFFDT.

29) What is meant by employee record number?

Employee record number refers to the number that helps us to identify different organizational relationships of an employee.

30) What fields are mandatory When a person is added to the system?

Following are the mandatory fields while adding any person to the system:

• Name
• Organizational relationship

Address, national ID, and Date of birth will show a warning message.

Conclusion

A PeopleSoft HRMS functional developer role requires knowledge handling HR activities in PeopleSoft HRMS. They should have experience in working with Absence Management, PS Query/App Engine, Self-Service, Data Mover scripts, Benefits Administration, etc. Additionally, it will be good to have basic knowledge of PeopleCode, PS Query, SQR, Component Interface, etc. So make sure that you go through these topics before you attend your interview.

1. How an application approach is different from a general HRMS approach?

Ans: 

Application-based Approach	General Approach
A complete Portfolio of employees is defined	No complete information on employee Portfolio
Modification in the information is easy	Information modification is difficult
System Integration is possible	System Integration is not possible

2. What can be the benefits of Effective data in the HRMS system?

Ans: It is basically used in the handling and managing of core tables that can be the same or different from one another. Simply put separate the different transactions made by an employee on different dates. Several Setup tables can also be managed with this data easily. The effective data simply make sure no error remains present and the record always remains up to date. 

3. Define Performance management in your own words along with its significance?

Ans: It is basically a system that is considered when it comes to the management of the skills, potential, efficiency, as well as extra circular activities of an employee working in an organization. It also enables organizations to represent the drawbacks associated with the employees and how they can be eliminated.

Therefore, this approach is of significant importance and is best when it comes to keeping up the pace with error-free efficiency in an organization.

4. What exactly do you know about Human Resource management systems?

Ans: HRMS is basically a function with the help of which employees are recruited, monitored, managed, and utilized through line managers. These days, HRMS systems are good enough to be considered when it comes to dealing with the issues such as hiring, compensation, appraisal, development, safety, motivation, communication, benefits, as well as their effective training.

Being comprehensive systems, they are good in motivating the employees to be a productive and prime contributor to the growth of an organization. All that matters for an organization while dealing with the employees for the accomplishment of their goals can easily be accomplished. 

5. How can you put separate the Recruitment and selection?

Ans: In recruitment, a complete array of processes is responsible for the selection of an employee to work in an organization. Depending on the position and the responsibilities, as well as on the overall experience of the employee, these processes could vary largely. It often takes place after selection which in fact, is nothing but short-listing a candidate for a particular just through the interview. 

6. What do you know about Human Resource Information systems?

Ans: These are the systems that are utilized for the purpose of storing, acquiring, distributing, controlling, as well as analyzing the information that is shared among the stakeholders.

All the traditional processes can be improved significantly and the decision-making and other approaches can therefore be boosted to a good extent with this. Present days stems have a wide scope when it comes to maintaining functionality. They are capable to handle multiple tasks in a very reliable manner. 

7. Can you tell what the roles of a Human Resource Generalist are?

Ans: The prime role is to conduct Induction Training and other training for the welfare of the employees such as skills training or training for a particular domain. Designing the training program and the performance monitoring is also the responsibility of the HR Generalist.

8. What is the People Group in the People Soft Human Resource Management Systems?

Ans: It is basically an area where the users can define the assignment data in a clear manner. It is possible to utilize this data for the purpose of grouping the sets that matter a lot to the user. Whenever it comes to defining the eligibility of the elements, it is possible for the users to simply use them.

9. What exactly do you mean by Element Entry in the HRMS?

Ans: It is basically an element that is used for the salary calculation of an employee. All the information regarding the bonus paid, increment, deductions, medical claims, and other factors are considered in it. 

10. Can you tell me something about the terminal rules of an element?

Ans: There are three important rules for which it is responsible and they are:

1. Actual Termination: It is basically an approach that is used for the purpose of a nonrecurring element. Entries can be closed simply when the Pay Period ends
2. Final Close: This approach is considered whenever there is a need to open the entries beyond the leave period of an employee. 
3. Standard Process: It basically defaults to the day when the employee either left the job or is relieved from his/her responsibilities. It is possible to set this day at a later date. 

11. When there is actually a need to process the Human Resource Processes according to you?

Ans: It largely depends on the organization. Depending on the size of an organization and the overall number of tasks performed, there can be a very large number of processes that an organization has to deal with. With a few organizations, processes are often combined on a daily basis whereas, with a few, they are combined after a specific time gap. 

12. What is an effective sequence in the PeopleSoft HRMS and how it is useful for the organizations?

Ans: It is basically an approach that is considered best because it makes sure that the large sections of data dealing with the transactions of the employees can be handled in a reliable manner.

The fact is that almost all the transactions are actions driven and it is very common that employees made similar transactions multiple times during a specific period. When such a situation arrives at all the other transactions then the first needs prompt attention. This is done through the Job table which is prepared by effectively sequencing the information.

3. What exactly is a regulatory region in a Human Resource Management System?

Ans: It is basically a region that clearly defines the rules and regulations that are of prime importance in a specific function performed. There are several general requirements and in order to accomplish them, a lot of transaction is to be made under some defined rules.

All such rules are present in the regulatory region. There are some specific codes that define each transaction it is not always necessary that all the codes remain the same in all the regions. 

14. In the PeopleSoft Human Resource Management system, what according to you is the most important record present?

Ans: It’s nothing but the Job Record

15. Can you tell me something about the ERP and how it is important?

Ans: It is an approach that is referred to as a specific class of application dealing with business modules. In order words, it is a blend of various software applications and can thus perform all the important tasks alone which were generally dependent on a number of software. It is an integrated approach and the users are free to save a lot of time through this approach

16. How a Prompt Table is different from a Translate Table in an HRMS system?

Ans: Both these tables are different from one another in a few ways. The strict upper limit on the translate table for the characters is a maximum of 4. On the other side, there is no such limit on the prompt table. The overall number of entries that can be accommodated in a translate table is 30 but the prompt table can have any number of entries available in it at any time. 

17. What are the modules on which the PeopleSoft HRMS can provide relevant information?

Ans: There are several modules actually that are useful and a few of them are Payroll, Job Information, Work, Employment information, Job Labor, Pattern for earning distribution, Overall compensation to the employees, Various programs for the benefits of the employee, Salary structure, and any other sort of information on the employment.

18. Name a few factors based on which the compensation to the worker can be distributed as per the PeopleSoft HRMS system?

Ans: This can be the Unit of business, the code of earning, department, Pay the type of the ledger, Shift of the employee, the job code, overall time, and so on.

19. What are the important tasks that can be managed through a Human Resource Management system?

Ans: It is basically a Human Resource application that is useful for combining the processes and systems in order to make sure that effective human resource management is going on in an organization. Several important and in fact, compiles HR functions are there which need to be combined to get the desired outcomes. This task is generally performed with the help of an HRM system. 

20. What are the various methods for the performance appraisal that an HRMS system can consider?

Ans: There are three important methods depending on the source of the feedback. The First is the 90 Degree Appraisals in which the source of the feedback of the employees is the Supervisor or the manager.

The second is the 180 Degree Appraisal in which the source of the feedback is nothing but the peers and the last one is the 306 Degree where the source of feedback is multiple such as managers, peers, supervisors, and so on.

21. What are the tasks that can be performed with the help of Human Resource Information Systems?

Ans: They are as follows:

1. Improving and tracking the efficiency of the process
2. Managing the hierarchy of origination
3. All the financial transactions can be made simple and useful
4. Complexity can be avoided in various departments

22. Compare the Hire Date and last hire date?

Ans: The hire date is the date when a person is hired in an organization. It is also called the date of joining an organization for an employee. The last hire date on the other side is the date when an organization leaves the job or is terminated from his/her services. 

24. Is it possible to retrieve the data using traversing in HRMS?

Ans: Yes, it is possible

24. What would be your strategy for an effective Human Resource management environment in your organization?

Ans: This can be done in many ways and there are actually a lot of factors that need to be considered for this. A few strategies are as follows:

1. Rewarding the employees for their good work
2. Made them feel they care
3. Considering an effective application such as PeopleSoft HRMS
4. Managing things in a rightful manner
5. Assuring effective communication in the organization

25. How a particular job is identified in the PeopleSoft HRMS?

Ans: This is done through a feature known as Job Family

26. Managing the resources can always generate leads? Do you agree with this statement?

Ans: Yes, this is actually true and there are a lot of things that can be done in a rightful manner only if the right methods are followed when it comes to managing the resources. Resource management simply makes sure everything can be accomplished on time and in a manner that is totally free from all bugs. You can simply make sure of things that are in your favor all the time. 

27. What are the challenges that are associated with proper Human Resource Management?

Ans: There are certain things that can go wrong. A few of them are as follows:

1. Employees often have conflicts among them that need to be addressed through an effective mechanism. Else, they can affect their efficiency
2. Nonavailability of skills can be another challenge
3. Lack of knowledge of the employees assigned a specific duty is another fact

28. Can you tell only one benefit of the Employees table present in the PeopleSoft HRMS?

Ans: It simply stores everything that is related to the employees.

29. What are the reasons to trust a Software Application that can be trusted for Human Resource Management in an organization?

Ans: Software Application always makes sure of the following

1. Reliability
2. Efficiency
3. Accuracy
4. Precision
5. Error-free results
6. Sensitivity
7. Regularity

30. What type of data would you store in the Setup tables?

Ans: The data that wouldn’t accept many changes are generally stored in it.

1) What is PeopleSoft Enterprise HRMS?

Answer # 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.

2) What is PeopleSoft Enterprise HRMS Integrations?

Answer # 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.

3) What are the different components and component interfaces in PeopleSoft HRMS?

Answer # Component Component Interface

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

4) How PeopleSoft HRMS stores data?

Answer # 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.

5) What is a control table in Peoplesoft HRMS?

Answer # 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.

6) What are transaction tables in Peoplesoft HRMS?

Answer # 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.

7) What are Prompt Tables in PeopleSoft HRMS?

Answer # 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.

8) What are Business Units in PeopleSoft HRMS?

Answer # 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.

You must define at least one business unit. The BUSINESS_UNIT field is included on all transaction tables.

9) What are Tablesets and SetIDs in PeopleSoft HRMS?

Answer # 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.

You must define at least one tableset (setID). The SETID key field is included on all control tables.

10) What are Effective Dates and what are the benefits of it?

Answer # PeopleSoft HRMS uses effective dates to store historical, current, and future information. Effective dates
enable 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.

11) What is Person or Position Structure in PeopleSoft HRMS?

Answer # 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.

12) What’s the Difference between Person or Position?

Answer # 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.

13) Which Method Should You Use Person or Position?

Answer # 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.

If you find that both methods work well in different areas of your organization, you can drive PeopleSoft Human Resources both ways.

14) What is your understanding of PeopleSoft HRMS System Data Regulation?

Answer # 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.

15) What are Business Units in PeopleSoft HRMS?

Answer # 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.

Business units share processing rules and you can create them at any level of the organization that makes sense and that reflect the needs of your internal human resources departments.

If you use the same processing rules across the organization, it may make sense to have a single business unit; if you use different rules in different companies, countries, or functional areas, you may choose to create multiple business units.

16) What are Tablesets and how do you work with them?

Answer # 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
• setIDs:
• • 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.

17) What is Data Permission Security for HRMS?

Answer # 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:

• People.
• Employees.
• Contingent workers.
• People of interest (POIs) with jobs.
• People of interest (POIs) without jobs.
• Recruiting job openings.
• Departments.

18) What are Security Sets and Security Access Types?

Answer # 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.

19) How do you implement data permission security?

Answer # 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).

20) What is Future-Dated Security?

Answer # 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.

21) How do you SetUp and Assigning Tree-Based Data Permission?

Answer # 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).

22) How do you modify Security Trees?

Answer # 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.

23) How do you allow Workers to Update Their Own Data?

Answer # 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.

24) How do you administer Country Codes?

Answer # To administer country codes, use the Country Table (COUNTRY_TABLE), the Country Table – HR (HR_COUNTRY_TABLE), and the State/Province (STATE_DEFN) components.

25) What is Search/Match?

Answer # 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)

26) How do you setup Search/Match?

Answer # 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.

27) What is the difference between Search Box Search and Search/Match?

Answer # 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.

28) What are Frequency IDs?

Answer # 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.

29) How do you setup person of interest types?

Ansewr # To set up person of interest types, use the Person of Interest Types (POI_TYPE_TBL) component.

30) What are Establishments?

Answer # 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.

HRMS Fundamentals 9.0

1. What are all the components will have data permission security control access?
• Departtments
• Employee, Contingent Worker, and POI with Jobs.
• POI without jobs.
• Recruiting Federal People with jobs.
• Template based hires.

2. What are all the organizational relationships available while hiring an employee?
• Employee
• Contingent Worker
• Person of Interest (POI)

3. 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

4. What are all the People Tools Security?
• Permission List
• Roles
• User Profiles

5. 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

6. What are all the default Permission List used while creating the User ID?
• Navigator Homepage Permission List
• Process Profile Permission List
• Primary Permission List

7. What are all the methods for assigning Data Permission Access to Permission List?
• Tree based data permission security
• Role based data permission security

8. What are all the Access types for Department security sets?
• Departments by Tree
• Departments by non – tree
• Departments by set id

9. 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 organization
• Department ID – non tree
• Company – Pay group

10. What are all the Access types for People without jobs security sets?
• POI Business Unit
• POI Location
• POI Institution
• Person of Interest

11. What are all the Access types for Recruiting Job Opening security sets?
• RS Company
• RS Business Unit
• RS Department ID
• RS Location
• Recruiting Team

12. What are all the Access types for Template Based Hire security sets?
• Template ID
• Template Category
• Person Organisation
• Country

13. What is the default tree name need to give while creating the new tree?
Dept Security followed by any name as per your requirement.

14. What would be the default effective date for creating the new tree?
1/1/1900 or 1/1/1901

15. What are all the tree manager definitions?
• Level
• Node
• Parent
• Sibiling
• Child

16. What are all the various types of SJT?
• SJT_CLASS
• SJT_CLASS_ALL
• SJT_PERSON
• SJT_DEPARTMENT

Adding People in the PeopleSoft System

17. 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)

18. 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

19. 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

20. What are all the job level defaults?
• Work
• Job Information
• Job Labor
• Payroll
• Salary Plan
• Compensation
• Employment Information
• Benefit Program Participation
• Earnings Distribution

Adding Workers Through Template-Based Hires (Smart Hire)
21. What are all the main components for setting the hire template?
• Template Record/Field
• Template Section
• Template Category Table
• Template Creation

22. What are all the statuses used to define templates?
• Test (Default Value)
• Active
• Inactive

23. What are all the statuses available on the template hire status page?
• Pending Hires
• Cancelled Hires
• Processed Hires

Maintaining Person and Job Data

24. 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

25. What are all the components available under Setup HRMS?
• Install
• Security
• Upgrade
• Foundation Tables
• Common Definitions
• Product Related
• System Administration

26. What is Effective Date?
Information Component /Record linked to the data EFFDT. Information changes based on the EFFDT.

27. What is Effective Sequence?
Identifier to find the order of multiple transactions occurring on a same EFFDT.

28. What is the effective sequence’s default number?
0
29. What are all the two statuses will be available on the top of the job data?

30. What are all the different types of action/reasons available on the system?

31. What’s the difference between a position number and a job code?
Position number is the unique identification number for driven by business unit , department ,location , job code and other parameters

32. What do you mean by budget and incumbents?

34. What is the purpose of update/display mode?
To add the new information current and future as well view the current data.

35. What is the purpose of correct history mode?
To correct the past and current information based on the EFFDT.

36. What is the purpose of include history mode?
To view the past information based on the EFFDT.

37. What is difference between Person ID and Employee ID?

38. What is Employee Record Number?
Number to identify an employee’s different organizational relationships.

39. What are all the mandatory fields need to key in while add a person on the system?
1) Name
2) Organizational relationship

National ID , Address, Birthdate gives us warning message.

40. What is employment instance?
Employee relationship with organization. Where employee can have multiple relationship (instances) with the organization.
41. What is the difference between Set Id and a Business Unit?
Where a Business Unit organizes your company or your organization, SetIDs
help you organize your data within the system. The HRMS system uses tables
(Control Tables or Prompt Tables) that use a high-level key that enables
you to identify and retrieve data from the system. A secondary high-level
key,
referred to as a SetID, has also been added on various tables. SetIDs are
simply the labels used to identify a TableSet. Business Unit and SetID
functionality in PeopleSoft also provides you with a higher business
level for reporting purposes and other business data roll-up.


42. What is HCCPALL?
Delivered primary permission list with access to all the components and pages

43. What is HCDPALL?
Delivered row level security permission list with full access.

Q1. What is PeopleSoft?

Ans: PeopleSoft is an organization that provides e-business application software over the internet.  It provides software for Human resource management, Supply chain management, CRM or Customer Relationship Management, Enterprise Performance Management and so on.

Q2. Explain what does PeopleSoft query is used for?

Ans: PeopleSoft query is a way to generate ad-hoc and scheduled reports quickly from any source data stored in your PeopleSoft tables.  User can build and execute queries using any supported web browsers.

Q3. What is People Soft integration broker?

Ans: People soft integration broker provides SOA (service oriented architecture) technology, and enables the transferring of asynchronous and synchronous service operations.  You can use the PeopleSoft integration broker to

• To execute synchronous and asynchronous messaging among internal as well as third party systems
• Delivers PeopleSoft business logic as web services to PeopleSoft and third party systems
• Invoke and consume web services from third party and PeopleSoft systems

Q4. What are the two important components of PeopleSoft integration broker?

Ans: The two important components of PeopleSoft integration includes

1. Integration gateway: It is a platform that regulates the receipt and delivery of service operations passed among systems via PeopleSoft Integration Broker
2. Integration engine: It is an application server process that routes service operation to and from PeopleSoft application transforms service operation structure and translates data as per the specification

Q5. What is Related Content in PeopleSoft?

Ans: In PeopleSoft, related content services are the framework within which administrators can contextually link application pages with collaborative content in any PeopleSoft application.

Q6.  What is PeopleSoft Multi-Channel framework?

Ans: PeopleSoft multi-channel framework provides an integrated infrastructure to support multiple interaction channels for call center agents or other PeopleSoft users who must respond to notifications and incoming requests.  PeopleSoft multi-channel framework supports following channels.

• Web collaboration (Chat)
• Voice (Telephone)
• E-mail
• Instant Messaging

Q7. How  many ways you can run an application engine program in PeopleSoft ?

Ans: You can run an application in five ways

1. Application designer
2. Process Scheduler
3. AE people tools
4. Calling people code
5. Command line prompt(dos)

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

Ans: Keys, Properties & Collections, Methods and Name

Q9. Explain how you can export SQL results to Excel using SQLPLUS?

Ans: To export SQL results to Excel using SQLPLUS, you have to follow the following steps

• Step 1: Login into data-base using SQL PLUS
• Step 2: Set mark-up using command “ SET MARKUP HTML ON”
• Step 3: Spool the output to a file “SPOOL C:\TEMP\MYOUTPUT.XLS”
• Step 4: Execute your SQL QUERY
• Step 5: Set the Spool off
• Step 6: To view the output open the output XLS file

Q10. What is the role of PeopleSoft component Interfaces?

Ans: PeopleSoft component interfaces give a way to use the PeopleSoft database without using a graphical user interface.  A component interface wraps PeopleSoft component, which is a logical grouping of PeopleSoft pages representing a complete business transaction.

Q11.  Explain File Interfaces in PeopleSoft?

Ans: PeopleSoft interfaces provide the ability to exchange files with third-party system or legacy system that do not support messaging.  Files are exchanged using file layouts.
File Layouts supports following file types

• Comma delimited files
• Fixed format sequential files
• XML files

Q12. In what all ways you can use PeopleSoft Query?

Ans: PeopleSoft query can be used

• To display data in a grid
• To run queries as a discrete process
• To schedule a query
• To download query results to XML and Excel spreadsheet
• To cater as a data source for Crystal Reports
• To decide to whom to forward information
• To cater as a data source for defining online analytical processing cube (OLAP)
• To create a data source for PeopleSoft and Vision reports

Q13. What is the use of Publish Utility in PeopleSoft?

Ans: The publish utility automates the procedure of copying the contents of the entire table into a legacy system or remote database

Q14.  Mention where you can add a value to the underlying table in PeopleSoft?

Ans: In PeopleSoft, you can add a value into the “prompt table with no edit”.

Q15.  Mention what are the tools are provided by PeopleSoft for testing your integration development?

Ans: The tools that are provided by PeopleSoft for testing your integration development

• Send master utility
• Simple post utility
• Automated integration point testing
• Transformation test utility
• Handler tester
• Schema tester

Q16.  Mention what is the role of Schema Tester?

Ans: The Schema Tester utility allows you to validate rowset-based and non-rowset-based messages against message schemas during development to determine if messages link to defined message schemas.

Q17.  Mention what does feed publishing framework provides?

Ans: Feed publishing framework provides

• A set of API’s and code samples to assist application developers in making new types of feeds and synchronizing them with existing features
• Unified interfaces for administrative users and content owners to create, configure and maintained feed definition of various types
• Interfaces for end users to explore related feeds and search feed definitions

Q18.  Explain in what ways you can create exceptions in PeopleSoft?

Ans: In PeopleSoft, exceptions are handled in two ways

• Creating an exception base class that wraps the built-in function call and handles its function parameters consistently, which is more common way
• By calling the built-in function CreateException

Q19.  Mention what are the different types of service operation does PeopleSoft Integration Broker provides?

Ans: PeopleSoft integration broker supports four types of services

1. Asynchronous one-way
2. Asynchronous response/request
3. Asynchronous to synchronous
4. Synchronous

Q20. Mention what all technical things can PeopleSoft billing can do?

Ans: With this application of PeopleSoft many things can be done like

• Create bills
• Receive billing data from other PeopleSoft applications
• Receive billing data from other applications
• Create recurring bills, installment bills, inter & intraunit bills and so on
• Review and validate bills
• Adjust invoices
• Calculate sales, use, and value-added taxes
• Defer revenue accounting and so on

Q21. How the voucher build process flow works in PeopleSoft?

Ans: The voucher build process consists of two sub-processes voucher edit and pre-edit.  The pre-edit sub-processes create skeleton voucher record sets from the partial information that you provided online using the components like Quick Invoice Entry (VCHR_QUICK_PNL) or the Summary Invoice Entry (VCHR_SUMM_PNL), or that it obtains from other sources.  After the pre-edit sub-process creates voucher record sets successfully, it calls the voucher edit sub-process to complete the record sets.