PeopleSoft HRMS Interview Questions Answers

PeopleSoft HRMS Interview Questions And Answers For Experienced 2018. If you are looking for Peoplesoft HRMS interview questions, then you are at the right place. Here we are sharing a list of real-time Peoplesoft HRMS interview questions and answers. This list will help you to crack your next Peoplesoft HRMS job interview. All the best and happy learning from Coding compiler.

PeopleSoft HRMS Interview Questions

  1. What is PeopleSoft Enterprise HRMS?
  2. What is PeopleSoft Enterprise HRMS Integrations?
  3. What are the different components and component interfaces in PeopleSoft HRMS?
  4. How PeopleSoft HRMS stores data?
  5. What is a control table in Peoplesoft HRMS?
  6. What are transaction tables in Peoplesoft HRMS?
  7. What are Prompt Tables in PeopleSoft HRMS?
  8. What are Business Units in PeopleSoft HRMS?
  9. What are Tablesets and SetIDs in PeopleSoft HRMS?
  10. What are Effective Dates and what are the benefits of it?

PeopleSoft HRMS Interview Questions And Answers

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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

PeopleSoft HRMS Interview Questions 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.

Related Article For You: Peoplesoft Interview Questions

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

Related Article: Peoplesoft Technical Interview Questions

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions For Experienced

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

Related Article For You: PeopleSoft Functional Interview Questions

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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).

PeopleSoft HRMS Interview Questions 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.

Advanced PeopleSoft HRMS Interview Questions

Related Article: PeopleTools Interview Questions

PeopleSoft HRMS Interview Questions 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).

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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)

Real-Time PeopleSoft HRMS Interview Questions

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

PeopleSoft HRMS Interview Questions 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.

RELATED INTERVIEW QUESTIONS

  1. PeopleSoft Functional Interview Questions
  2. PeopleTools Interview Questions
  3. Peoplesoft Technical Interview Questions
  4. 199 Peoplesoft Interview Questions
  5. 200 Blue Prism Interview Questions
  6. Visualforce Interview Questions
  7. Salesforce Interview Questions
  8. 300 SSIS Interview Questions
  9. PHP Interview Questions And Answers
  10. Alteryx Interview Questions
  11. AWS Cloud Support Interview Questions
  12. Google Kubernetes Engine Interview Questions
  13. AWS Devops Interview Questions
  14. Apigee Interview Questions
  15. Actimize Interview Questions
  16. Kibana Interview Questions
  17. Nagios Interview Questions
  18. Jenkins Interview Questions
  19. Chef Interview Questions
  20. Puppet Interview Questions
  21. DB2 Interview Questions
  22. AnthillPro Interview Questions
  23. Angular 2 Interview Questions
  24. Hibernate Interview Questions
  25. ASP.NET Interview Questions
  26. Kubernetes Interview Questions
  27. Docker Interview Questions
  28. CEH Interview Questions
  29. CyberArk Interview Questions
  30. Appian Interview Questions

PeopleSoft Functional Interview Questions Answers

Peoplesoft Functional Interview Questions And Answers For Experienced 2018. Here Coding compiler sharing a very good list of 30 Peoplesoft interview questions with answers. We hope that these interview questions will help you to crack your next Peoplesoft job interview. All the best for your future and happy learning.

Peoplesoft Functional Interview Questions

  1. What are the different payment methods in PeopleSoft?
  2. What is the P2P Cycle in PeopleSoft?
  3. What is the main business process of Accounts Payable?
  4. What are the Voucher Staging tables available in PeopleSoft?
  5. What are the main components for setting the hire template in PeopleSoft?
  6. What are the methods available to update worker’s compensation packages?
  7. What is a regulatory region? What is the use of regulatory region?
  8. What are all the statuses used to define templates?
  9. List out different kinds of organizational relationships in PeopleSoft HRMS as per the person model?
  10. What are all the statuses available on the template hire status page?

Peoplesoft Functional Interview Questions And Answers

Peoplesoft Functional Interview Questions 1) What are the different payment methods in PeopleSoft?

Answer # System Check and EFT are two of the most common Payment Methods used by enterprises. Apart from these, PeopleSoft Payables also supports many other Payment Methods.

They are:

Most Common Payment Methods:

  • System Check
  • Electronic Funds Transfer — EFT

Other Payment Methods:

  • Manual Check
  • Draft Customer Intiated
  • Draft Customer EFT
  • Draft Vendor Intiated
  • Automated Clearing House — ACH
  • Direct Debit
  • Giro-EFT
  • Giro-Manual
  • Letter of Credit
  • Wire Transfer

Peoplesoft Functional Interview Questions 2) What is the P2P Cycle in PeopleSoft?

Answer # This Process includes Procurement to Payment cycle.

  1.  Requistion
  2.  Purchase Order
  3.  Receipt
  4.  Voucher
  5.  Payment

Peoplesoft Functional Interview Questions 3) You have an interface file coming into PeopleSoft from a third-party system that sends details of already approved vouchers. An App Engine loads the file into the Voucher Staging tables. When the Voucher build process runs, it would be apt to create pre-approved vouchers for this origin. How would you set the system up to mark the Vouchers created from this origin as pre-approved?

Answer # We need to do small set up change at Voucher Origin

Below are the steps:

  1.  Open the Voucher Origin Set-Up
    (Set Up Financials/Supply chain > Product Related > Procurement Options > Vouchers > Voucher Origin)
  2.  Click on Vouchering Options 1 Tab
  3.  Voucher Approval Options — Check the radio button : Pre-Approved

Peoplesoft Functional Interview Questions 4) What are main business process of Accounts Payable?

Answer # Payables Business process overview:

  • Create Vouchers and payments process using manual and automatic processes.
  • Country-specific tax withholding
  • Matching the vouchers with the purchase orders and receipts
  • Post the vouchers
  • Maintain vouchers throughout their life cycle.
  • Create drafts, single voucher payment, prepayments, and self-billed invoices.
  • Optionally, send electronic payments to PeopleSoft  Financial Gateway.
  • Analyze accounts payable information using online inquiries, and by generating reports.
  • Archive accounts payable data

Peoplesoft Functional Interview Questions 5) What are the Voucher Staging tables available in PeopleSoft?

Answer # To load vouchers into PeopleSoft, we first load them into the Voucher Staging tables and then run the Voucher Build to create Vouchers from the staged data.

PS_VCHR_HDR_STG;
PS_VCHR_LINE_STG;
PS_VCHR_DIST_STG;

PS_VCHR_HDR_QV;
PS_VCHR_LINE_QV;
PS_VCHR_DIST_QV;

These are two staging tables used to load data through voucher build process into main voucher tables

PS_VOUCHER;
PS_VOUCHER_LINE;
PS_DISTRUB_LINE;

Related Article For You: Peoplesoft Interview Questions

Peoplesoft Functional Interview Questions 6) What are the main components for setting the hire template in PeoplfSoft?

Answer # Template Record/Field

Template Section

Template Category Table

Template Creation

Peoplesoft Functional Interview Questions 7) What are the methods available to update worker’s compensation packages?

Answer # Seniority Pay Increases

Grade Advance increases

Automated step increases

Step increases using review bands

Amount increases

Percentage increases

Peoplesoft Functional Interview Questions 8) What is a regulatory region? What is the use of regulatory region?

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

Benefits of using regulatory region

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.

Peoplesoft Functional Interview Questions 9) What are all the statuses used to define templates?

Answer # Test (Default Value)

Active

Inactive

Peoplesoft Functional Interview Questions 10) List out different kinds of organizational relationships in PeopleSoft HRMS as per the person model?

Answer # Different organization relationships a person can have are:

Employee

Contingent worker

Person of Interest

Related Article: Peoplesoft Technical Interview Questions

Real-Time Peoplesoft Functional Interview Questions

Peoplesoft Functional Interview Questions 11) What are all the statuses available on the template hire status page?

Answer # Pending Hires

Cancelled Hires

Processed Hires

Peoplesoft Functional Interview Questions 12) What are the levels available in tree manager?

Answer # Level

Node

Parent

Sibling

Child

Peoplesoft Functional Interview Questions 13) What are Global assignments?

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

Peoplesoft Functional Interview Questions 14) What are all the various types of SJT?

Answer # SJT_CLASS

SJT_CLASS_ALL

SJT_PERSON

SJT_DEPARTMENT

Peoplesoft Functional Interview Questions 15) What is the most important Record in PS HRMS?

Answer # JOB record

Peoplesoft Functional Interview Questions 16) What is Home and Host concept?

Answer # 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 Functional Interview Questions 17) How is international assignments security implemented?

Answer # PeopleSoft delivers three options for International Security:

i) Home can see Host
ii) Host can see Home
iii) Both

International Security can be setup by navigating to:

Setup HRMS -> Security -> Core Row Level Security -> Security Installation Settings

Peoplesoft Functional Interview Questions 18) For the action of Short Term Disability, what is the resulting employee status?

Answer # Leave of Absence

Peoplesoft Functional Interview Questions 19) A company wants you to set the dependent age limit to 19 for all benefits. Which table should you use?

Answer # Benefit Program Table

Peoplesoft Functional Interview Questions 20) When working on a conversion, what does PeopleSoft recommend you use as the initial effective dates on the Job Code Table?

Answer # Accommodate your longest tenured employee.

Related Article: PeopleTools Technical Interview Questions

Peoplesoft Functional Interview Questions For Experienced

Peoplesoft Functional Interview Questions 21) Which table has SetID as a high-level key?

Answer # Location Table

Peoplesoft Functional Interview Questions 22) Which HRMS module does NOT use the Group Build functionality?

Answer # Payroll

Peoplesoft Functional Interview Questions 23) A customer asks you to set up a medical plan on the Benefit Plan Table. Which table must you set up first?

Answer # Provider/Vendor Table

24) our client has seasonal workers and wants to base the annual compensation rate on 125 work days per year. On which table do you define this requirement?

Answer # Frequency Table

25) Where do you enter default values that are specific to a PeopleSoft user?

Answer # Org Defaults by Permission List

26) A customer wants to set up a vacation plan and have the ability to track the vacation balances. Which three tables must be set up before you can track the vacation balances?

Answer # Provider/Vendor Table, Earnings Table and Benefit Program Table.

27) On the Job Earnings Distribution Page, what are three ways you can distribute the employee’s compensation?

Answer # To a different Department, To a different Job Codes and/or Position and To a different General Ledger Type.

28) Which deduction classification is used to set up a savings plan employer before-tax match?

Answer # Nontaxable Before-Tax Benefit

29) What is the purpose of EMPLOYEES table in PS? How is this table populated?

Answer # EMPLOYEES table is a current employee information table. This is primarily used in interfacing with third party systems or in business reporting as well in conjunction with EMPLOYMENT which is now a view.

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

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

RELATED INTERVIEW QUESTIONS

  1. PeopleTools Interview Questions
  2. Peoplesoft Technical Interview Questions
  3. 199 Peoplesoft Interview Questions
  4. 200 Blue Prism Interview Questions
  5. Visualforce Interview Questions
  6. Salesforce Interview Questions
  7. 300 SSIS Interview Questions
  8. PHP Interview Questions And Answers
  9. Alteryx Interview Questions
  10. AWS Cloud Support Interview Questions
  11. Google Kubernetes Engine Interview Questions
  12. AWS Devops Interview Questions
  13. Apigee Interview Questions
  14. Actimize Interview Questions
  15. Kibana Interview Questions
  16. Nagios Interview Questions
  17. Jenkins Interview Questions
  18. Chef Interview Questions
  19. Puppet Interview Questions
  20. DB2 Interview Questions
  21. AnthillPro Interview Questions
  22. Angular 2 Interview Questions
  23. Hibernate Interview Questions
  24. ASP.NET Interview Questions
  25. Kubernetes Interview Questions
  26. Docker Interview Questions
  27. CEH Interview Questions
  28. CyberArk Interview Questions
  29. Appian Interview Questions
  30. Drools Interview Questions

PeopleSoft PeopleTools Interview Questions Answers

45 PeopleSoft People Tools Interview Questions And Answers For Experienced 2018. Here Coding compiler sharing a very good list of people tools interview questions. We hope that these interview questions will help you to crack your next Peoplesoft job interview. All the best for your future and happy learning.

Peoplesoft People Tools Interview Questions

  1. What is the difference between Key and alternate search Key?
  2. Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?
  3. What types of audits are supported by people soft? In case of record level audit what is the structure of table?
  4. What are Table Edits?
  5. What conditions are required to establish parent child relationship between two records? What are the advantages with that?
  6. Can you hide a primary page in a component? Reason?
  7. Can you place Sub page into Grid? If yes How?
  8. What is an Expert Entry?
  9. What is Auto Update?
  10. What is Record Group? Which records can be included into a record group?

Peoplesoft People Tools Interview Questions And Answers

People Tools Interview Questions # 1) What is the difference between Key and alternate search Key?

Answer # KEY-It is the primary key of the record. Can be used as search key or need not be.
Alternate search key-it is used for searching purposes.

People Tools Interview Questions # 2) Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?

Answer # Update/display – can view current and future rows. Can update only future rows.
Update/display all – can view history, current and future rows. Can update only future rows.
Correction – can view and update history, current and future rows.

People Tools Interview Questions # 3) What types of audits are supported by people soft? In case of record level audit what is the structure of table?

Answer # We have field level audit and record level audit. The structure of the table in record
level audit is: AUDIT_OPRID, AUDIT_STAMP, AUDIT_ACTN, AUDIT_RECNAME and can
add fields from record.

People Tools Interview Questions # 4) What are Table Edits?

Answer # We have prompt table edit, yes/no table edit, translate table edit as the table edits.

People Tools Interview Questions # 5) What conditions are required to establish parent child relationship between two records? What are the advantages with that?

Answer # Conditions are:
1) The child record should have all the key fields of parent record and at least one more
key field other than the key fields of parent record.
2) We should mention the parent record in the record properties of child record.
3) We can not go for more than three levels of parent/child relationships.

Advantages are:
1) To have referential integrity.
2) No need to enter information again and again

Related Article For You: Peoplesoft Interview Questions

People Tools Interview Questions

People Tools Interview Questions # 6)

Answer # Can you place Sub page into Grid? If yes How?
Yes we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid. When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid.

People Tools Interview Questions # 7) Can you hide a primary page in a component? Reason?

Answer # No we can not hide the primary page of a component. If the component had only one page then by making this page also invisible we won’t have any component existing so we are not allowed to hide the primary page.

People Tools Interview Questions # 8) What is an Expert Entry?

Answer # Expert entry enables a user to change from interactive to deferred mode at runtime for appropriate transactions

People Tools Interview Questions # 9) What is Auto Update?

Answer # This record field property is used to update the date field of particular record with the server’s current date and time whenever a user creates or updates a row. Even the user enter the data into that field, the data which the user enters will be updated by the system’s current date and time.

People Tools Interview Questions # 10) What is Record Group? Which records can be included into a record group?

Answer # Record group consists of records with similar functionality. To setup a record in record group we should enter a set control field value in record properties.

Related Article: Peoplesoft Technical Interview Questions

People Tools Interview Questions And Answers

People Tools Interview Questions # 11) How can you improve the security and usability of a Prompt table edit?

Answer # Prompt table view

People Tools Interview Questions # 12) What are the different ways to setup row level security?

Answer # We can setup row-level security using a SQL view that joins the data table with an authorization table. andBy having Query search for data using a query security record definition. The query security record definition adds a security check to the search.

People Tools Interview Questions # 13) How does peoplesoft use views? Which are online functions?

Answer # People soft uses views for search records, summary pages, prompt views, reports. Search records and summary pages are online functions.

People Tools Interview Questions # 14) Why do PeopleSoft often use views as search records?

Answer # Search views are used for three main reasons.

  1.  Adding criteria to the search dialogue page
  2.  Providing row level security.
  3.  Implementing search page processing.

People Tools Interview Questions # 15) How can a component have more than one search record? Give a situation.

Answer # You might want to reuse the same component multiple times with different search records. You can accomplish this by overriding the component search record at runtime when the component is opened from a menu item without creating separate copies of the component.

The component override is temporary and occurs only when the component is opened from the menu item in which the override is set. It does not change the component definition.

16. What is PIA and what are its components?

Answer # It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services.
In database server we have system tables, peopletools tables and application tables.

People Tools Interview Questions # 17) Differentiate Field edit and Save edit?

Answer # In Field edit for each field change, a transition to the application server to the database is taken place.
In Saveedit for all the fields , only one transition to the application server to the Database is taken place.

People Tools Interview Questions # 18) What are think time functions?

Answer # Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion.

People Tools Interview Questions # 19) In which events error & warning are used most extensively.

Answer # Field edit, Save edit, Search save, row delete, row insert

People Tools Interview Questions # 20) Is there any way by which you can find out whether the user is in Add mode or Update mode?

Answer # %mode—returns A—for Add mode. Returns U –for Update mode.

People Tools Peoplesoft Interview Questions

People Tools Interview Questions # 21) What is the purpose of the SQLEXEC function? What are its benefits and draw backs?

Answer # SQLEXEC is used to execute the sql statements(select,insert,update,delete). We can get only one row at a time.

People Tools Interview Questions # 22) How is the searchinit event most often used by people soft application?

Answer # Searchinit fires before the search dialogue page is displayed to the end user.For this reason searchinit is often used to enhance roll level security by inserting and graying out certain values to the search dialogue page.

People Tools Interview Questions # 23) What are the options for using SQL in people code?

Answer #
a) sqlexec
b) Record class methods (selectbykey,delete,insert,update)
c) Using sql class, its properties and methods.

People Tools Interview Questions # 24) What is the difference between component buffer and data buffer?

Answer # Component buffer contains all the data of the active component. Data buffer contains the data other than the data in the component buffer (Data of other records)

People Tools Interview Questions # 25) What databuffer classes are available in people code?

Answer # Rowset, Row, Record, Field, Array, File, Sql, chart, grid and so on.

People Tools Interview Questions # 26) When we select a component what events will be fired?

Answer # If default mode for component is search mode: only searchinit will fired.
If default mode for component is new mode :field default, field formula, rowinit, searchinit.

People Tools Interview Questions # 27) What are different variables in people code and their Scope?

Answer # System variables and User defined variables. Scope —Global, Component, Local.

People Tools Interview Questions # 28) What is default processing?

Answer # In default processing, any blank fields in the component are set to their default value. You can specify the default value either in the Record Field Properties, or
in FieldDefault PeopleCode

People Tools Interview Questions # 29) What is difference between field default and Row init?

Answer # Field default specifies only the default value for a field when we are in Add mode. Row init fires only when a row of data coming from database to component buffer

People Tools Interview Questions # 30) What is difference between saveprechange and savepostchange?

Answer # Saveprechange—last event that executes before updating the data from component buffer to the database.

Savepostchange –fires after the updation of data in the database.

45 People Tools Peoplesoft Interview Questions And Answers

PeopleTools Interview Questions # 31) Which function directly interacts with the database?

Answer # SQLEXEC — function directly interacts with the database.

PeopleTools Interview Questions # 32) What is Getlevel0()? What is the use of %subrec and %selectall functions?

Answer # Getlevel0()—used the get the rowset of the level0.
%subrec–is used only in Dynamic View SQL where it expands to the columns of a subrecord:
%selectall–%SelectAll is shorthand for selecting all fields in the specified record, wrapping date/time fields with %DateOut, %TimeOut.

People Tools Interview Questions # 33) What is an array in people code? What is maximum dimension of an array?

Answer # An array is a collection of data storage locations, each of which holds the same type of data.
The maximum depth of a PeopleCode array is 15 dimensions.

PeopleTools Interview Questions # 34) Which function inserts values into an array? What is “pop”?

Answer # Push and unshift are the functions of the array used to add the elements into the array one from the end of the array and one from the beginning.
Pop is a function of array used to select and delete an element from the end of the array.

PeopleTools Interview Questions # 35) What is difference between Getrowset and Createrowset in people code?

Answer # Getrowset –is used to get rowset for a record in the component buffer.
Createrowset—is used to create rowset for a record which in database, and is also called a Standalone rowset

PeopleTools Interview Questions # 36) Can you save the component programmatically?

Answer # Using Dosave and Dosavenow functions.

PeopleTools Interview Questions # 37) What is differed processing and its advantages?

Answer # Postpones some user actions to reduce the number of trips to the database so that increases the performance (in system edits, field edit, and field change).

Advantages:
1) Reduces the network traffic.
2) Increases the performance.

PeopleTools Interview Questions # 38) Write the syntax to access third level record field using object oriented peoplecode?

Answer # &fld=Getlevel0()(1).GetRowset(Record.<level1 record>.GetRow(1),
GetRowset(Record.<level2record>).GetRow(1),
GetRowset(Record.<level3 record>).GetRow(1),
GetRecord(Record.<level3 record>).GetFieild(Field.<field name>))

PeopleTools Interview Questions # 39) What are the built-functions used to control translate values dynamically?

Answer # Adddropdownitem()
Deletedropdownitem()

PeopleTools Interview Questions # 40) How to populate data into grid in online?

Answer # &Rs.Select or Scrollselect().

SECURITY – Before accessing a people soft application what levels of security must be passed through.

  •  Field level security
  • Row level security
  •  Maintain security
  • Definition security
  •  Portal security

PeopleTools Interview Questions # 41) What is the use of primary permission list in user profile?

Answer # Primary permission list is used for mass change and definition security purposes

PeopleTools Interview Questions # 42) How to authorize the user to run a process or report?

Answer # To authorize a user to run a process, the process group which contains the process or report should be added to the permission list of that user.

PeopleTools Interview Questions # 43) How to give access to the records that are to be used in a query?

Answer # To give access to the records that are to be used in query, we have create a new query security tree and add the records which we want to give the access and then
assign a access group to the tree. After that we have to add that query tree and query access group to the permission list.

PeopleTools Interview Questions # 44) What are the rules used by the system to determine whether a user is authorized to update an object?

Answer # The user should have the permission to update the object. This is given by the Definition security. The group which holds the object should be added to the permission list of the user in update mode.

PeopleTools Interview Questions # 45) What are the different ways we can set up the portal security to access component in portal?

Answer #

  1.  Structure & content
  2.  Menu import
  3.  Register component

RELATED INTERVIEW QUESTIONS

  1. Peoplesoft Technical Interview Questions
  2. 199 Peoplesoft Interview Questions
  3. 200 Blue Prism Interview Questions
  4. Visualforce Interview Questions
  5. Salesforce Interview Questions
  6. 300 SSIS Interview Questions
  7. PHP Interview Questions And Answers
  8. Alteryx Interview Questions
  9. AWS Cloud Support Interview Questions
  10. Google Kubernetes Engine Interview Questions
  11. AWS Devops Interview Questions
  12. Apigee Interview Questions
  13. Actimize Interview Questions
  14. Kibana Interview Questions
  15. Nagios Interview Questions
  16. Jenkins Interview Questions
  17. Chef Interview Questions
  18. Puppet Interview Questions
  19. DB2 Interview Questions
  20. AnthillPro Interview Questions
  21. Angular 2 Interview Questions
  22. Hibernate Interview Questions
  23. ASP.NET Interview Questions
  24. Kubernetes Interview Questions
  25. Docker Interview Questions
  26. CEH Interview Questions
  27. CyberArk Interview Questions
  28. Appian Interview Questions
  29. Drools Interview Questions
  30. Talend Interview Questions

Peoplesoft Technical Interview Questions And Answers

Peoplesoft Technical Interview Questions And Answers. If you are looking for technical interview questions on Peoplesoft, then you are at right place. Here Coding compiler presenting a list of 25 Peoplesoft Technical Interview Questions. We hope that these questions will help you to crack your next Peoplesoft job interview. All the best for your future and happy learning.

PeopleSoft Technical Interview Questions

  1. What is the difference between Application Engine vs SQR?
  2. What is the difference between Exit(1) and Exit(0)?
  3. What is the order of people code events firing?
  4. What is the difference between FieldChange Event and FieldEdit Event?
  5. What is the difference between PostBuild Event and PreBuild Event?
  6. Describe RowInit Event?
  7. Explain SaveEdit Event in PeopleCode?
  8. What is the difference between SavePrechange and SavePostchange Events?
  9. What is the difference between SaveEdit and Fieldedit?
  10. What is the component processor?

PeopleSoft Technical Interview Questions And Answers

PeopleSoft Technical Interview Questions # 1

In PeopleSoft we extensively use both App engines and SQRs. In many cases, we can get an App engine to perform the same tasks that an SQR does. In certain other cases, this is not possible. Can you compare and contrast between Application Engine and SQR.

Answer # Application Engine vs SQR

The differences between Application engine and SQR are

1. Restartability:

AE : Application Engines are Restartable from the point where they had failed.
SQR: But SQRs are not Restartable. We will have to run them from first… i mean rerun.

2. Encapsulation:

AE: Can use Application packages, thus bringing in encapsulation and other object oriented programming concepts.
SQR: Code is not encapsulated, we will not be able to use App Packages but SQCs serve the purpose to an extent.

3. Reporting:

AE: Later versions of people tools enable AE to create reports with help of XMLP
SQR: Easy Report Creation with enhanced printing

4. Debugger:

AE: It has a built-in debugger
SQR: Lacks built-in debugger but we can make use of the “debug”.

5. Viewability:

AE:Can view only one block of code at a time
SQR:Can view the entire program at once

6. Use of Message Catalog

AE:Can use Message Catalogs which can be passed on easily through log messages action.
SQR:Cannot use Message Catalogs, it only has to access the message catalog meta table to fetch messages

7.Invoking the process via PeopleCode

AE:Can be called from People code [CallAppEng, create process request]
SQR:Can be called from People code [ create process request]

8. Parallel Processing:

AE:Parallel processing with help of temp tables for optimization
SQR:Load Lookup is used for optimization

9. Meta Data:

AE:Has Meta SQL like %selectinit , %updatestats
SQR:Lacks Meta SQL support

10.About the Tool:

AE:A PeopleSoft tool [Acquired by oracle]
SQR:A Hyperion tool [Acquired by oracle]

11.Data Dictionary:

AE: Data Dictionary Integration [Data Dictionary Integration is nothing but the synchronization of the definition changes like field name, length with those definitions in the AE program. This is possible because of AE resides within PeopleSoft database]
SQR: Not possible

PeopleSoft Technical Interview Questions # 2

In an App Engine PeopleCode, it’s not uncommon to see code that works on the following logic. You have a condition and if it’s TRUE, you want Exit(1) to execute.

If the condition is FALSE, you would like Exit(0) to execute.
Depending on the way in which you have designed the App Engine, this can completely change its flow.

Can you explain what is the difference between Exit(1) and Exit(0)?

Answer # Any non-zero return code is some kind of error. The way it will be handled depends on “On Return” value for each step of application engine.

So exit(0) – is success

exit(1) and On Return = Abort – is error and exit program immediately
exit(1) and On Return = Break – is exit current step and section
exit(1) and On Return = Skip Step – exits current step, continue with next step

Exit(1) : Terminate the AE immediately and rollback all DB changes made
exit(0) : Terminate the AE immediately but will not rollback the DB changes made.

PeopleSoft Technical Interview Questions # 3

We use a State Record to keep data accessible across Actions. We can have many State Records for an App Engine. Do you know if we can have an App Engine that does not have a State Record?

Answer # Yes. We can have an AE without any state record.

PeopleSoft Technical Interview Questions # 4

In some cases, we would like to take the users directly to the page rather than letting them go through a search page, ie; we would like to bypass the search page in a Component. How would you achieve this?

Answer # We can skip the search record using these 2 ways.
1. Search record should not have any search keys like INSTALLATION table.
2. We can skip search page through peoplecode as well, i.e, Write SetsearchBehavior() function in Search Init event.

PeopleSoft Technical Interview Questions # 5

It’s common to write PeopleCode that fires only when a Component is accessed in a particular mode. We use a System Variable called %Mode that returns a character based on the present mode and then, use it in a conditional statement to achieve this.

PeopleSoft PeopleCode Technical Interview Questions

Can you list the different modes available in PeopleSoft and the corresponding values that %Mode would return?

Answer # In peoplecode there are 6 types of mode:

Numeric Value Constant Value Description
A %Action_Add Add
U %Action_UpdateDisplay Update/Display
L %Action_UpdateDisplayAll Update/Display All
C %Action_Correction Correction
E %Action_DataEntry Data Entry
P %Action_Prompt Prompt

PeopleSoft Technical Interview Questions # 6

You are generating a file from an Application Engine and you need to have the date time stamp appended to the file name. You can do this in numerous ways, can you tell me one of the easiest ways to achieve this?

Answer # This can be done by appending this statement to the filename.

DateTimeToLocalizedString(%Datetime, “ddMMyy-HHmmss”);

PeopleSoft Technical Interview Questions # 7

Order of people code events firing?

Answer #

1. Searchinit
2. Searchsave
3. Rowselect
4. Prebuild
5. Field Default
6. Field Formula
7. RowInit
8. PostBuild
9. Activate
10. FieldEdit
11. FieldChange (PrePopup, ItemSelected)
12. RowInsert
13. RowDelete
14. SaveEdit
15. SavePreChange.
16. WorkFlow
17. SavePostChnage.

PeopleSoft Technical Interview Questions # 8

What is the difference between FieldChange Event and FieldEdit Event ?

Answer #

FieldChange Event – Use FieldChange PeopleCode to recalculate page field values, change the appearance of page controls, or perform other processing that results from a field change other than data validation. To validate the contents of the field, use the FieldEdit event.
The FieldChange event applies to the field and row that just changed.

FieldChange PeopleCode is often paired with RowInit PeopleCode. In these RowInit/FieldChange pairs, the RowInit PeopleCode checks values in the component and initializes the state or value of page controls accordingly. FieldChange PeopleCode then rechecks the values in the component during page execution and resets the state or value of page controls.

FieldEdit Event – Use FieldEdit PeopleCode to validate the contents of a field, supplementing standard system edits. If the data does not pass the validation, the PeopleCode program should display a message using the Error statement, which redisplays the page, displaying an error message and turning the field red.
FieldEdit PeopleCode can be associated with record fields and component record fields.

PeopleSoft Technical Interview Questions # 9

What is the difference between PostBuild Event and PreBuild Event ?

Answer #

PostBuild Event – The PostBuild event is initiated after all the other component build events have been initiated. This event is often used to hide or unhide pages. It’s also used to set component variables.

PostBuild PeopleCode is only associated with components.During the PostBuild event you will have access to the data read from the database into the component buffer structure. That’s why it is called PostBuild.

PreBuild Event – The PreBuild event is initiated before the rest of the component build events. This event is often used to hide or unhide pages. It’s also used to set component variables.

PreBuild fires before any PeopleCode events on all the rows and fields in the component such as FieldDefault and RowInit. During the PreBuild event there will not be any data in the component buffer structure other than search record as its executing prior to the component build process. That’s why it is called PreBuild.

PeopleSoft Technical Interview Questions # 10

Describe RowInit Event ?

Answer # The RowInit event is initiated the first time that the Component Processor encounters a row of data. IUse it to set the initial state of component controls.

This occurs during component build processing and row insert processing. It also occurs after a Select or SelectAll Rowset method, or a ScrollSelect or related function, is executed. RowInit is not field-specific.it triggers PeopleCode on all fields and on all rows in the component buffer.Do not use Error or Warning statements in RowInit PeopleCode: these cause a runtime error.

PeopleCode Technical Interview Questions

PeopleSoft Technical Interview Questions # 11

Explain SaveEdit Event in peoplecode ?

Answer # The SaveEdit event is intiated whenever a user attempts to save the component. You can use SaveEdit PeopleCode to validate the consistency of data in component fields. Whenever a validation involves more than one component field, you should use SaveEdit PeopleCode. If a validation involves only one page field, use FieldEdit PeopleCode. SaveEdit is not field-specific: it triggers associated PeopleCode on every row of data in the component buffers, except rows flagged as deleted.

PeopleSoft Technical Interview Questions # 12

Difference between SavePrechange and SavePostchange Events.

Answer #

SavePreChange Event -The SavePreChange event is initiated after SaveEdit completes without error.SavePreChange PeopleCode provides one final opportunity to manipulate data before the system updates the database.In Save Prechange we can get the data from Component Buffer for that particular Component.

SavePostChange Event – SavePostChg is different from all other Peoplecode events since it is performed after the updates are made on the database.SavePost change Component Buffer is cleared we have to get data from Database and this is used to update values outside the database.

PeopleSoft Technical Interview Questions # 13

Difference between SaveEdit and Fieldedit ?

Answer # Fieldedit event is fired every time for each row when field is edited where as
SaveEdit is fired only once when a user click on save button .

PeopleSoft Technical Interview Questions # 14

What is the component processor?

Answer # Component processor is a runtime engine that controls processing of an application from the time user request the component from the menu till the database is updated and processing of component is completed.

PeopleSoft Technical Interview Questions # 15

Explain about the component buffer and data buffer?

Answer # Component Buffer contains all the Data of active component. The data buffer is used to store data added from sources other than the component, such as from a PeopleSoft Application Engine program, an application message, and so on.

PeopleTools 8 provides an alternative to the scroll level, row, and field components in the form of the data buffer classes Rowset, Row, Record, and Field, which you reference using dot notation with object methods and properties.

Technical Peoplesoft Interview Questions

PeopleSoft Technical Interview Questions # 16

Difference between SQLExec and CreateSql?

Answer # SQLExec can only select a single row of data. If your SQL statement retrieves more than one row of data SQLExec sends only the first row to its output variables. Any subsequent rows are discarded. CreateSQL If you need to SELECT multiple rows of data use the CreateSQL or GetSQL functions and the Fetch SQL class method.

PeopleSoft Technical Interview Questions # 17

Explain about ACTIVE event?

Answer # The Activate event get fired each page gets activated. Active PeopleCode can only be associated with pages. The event is used for security validations such as field enabling and hiding a scroll, enabling user to programmatically control the display of that page controls. This event is used for component build processing in add mode and update mode.

PeopleSoft Technical Interview Questions # 18

What is deferred processing?

Answer # Deferred processing is used speed up the data-entry process. This means that the system does not validate the data for each field as you Tab through a page. You can enter in all the data for your page without unnecessary trips to the server for data validation. Entered data is validated when:

You navigate to another page in the component
Click the Save button
Click the Refresh button (access key: Alt+0)

If there are any errors in your data, you are notified at this time.
Field Edit event will not fire until we press the SAVE button if the deferred processing is ON.

PeopleSoft Technical Interview Questions # 19

Difference between Getrowset and Createrowset?

Answer # GetRowset is used to get rowset for a record in the component buffer.
CreateRowset is used to create rowset for a record which is in database, and is also called as standalone rowset.

PeopleSoft Technical Interview Questions # 20

What is scrollflush() function ?

Answer # Used to remove all rows inside target scroll area and frees it associated buffer. Rows that are flushed are not deleted from the database. This function is often used to clear work scroll before a call to ScrollSelect.
Syntax: ScrollFlush (scrollpath)

Frequently Asked PeopleSoft Technical Interview Questions

PeopleSoft Technical Interview Questions # 21

Explain about the workflow event?

Answer # WorkFlow PeopleCode executes immediately after SavePreChange and before database update that precedes SavePostChange. The main purpose of the workflow event is to segregate PeopleCode related to workflow from the rest of applications PeopleCode. Only PeopleCode related workflow (Such as triggerbusinessevent) should be in workflow programs. Your program should be deal with workflow only after my SavePreChange process completed.

PeopleSoft Technical Interview Questions # 22

Explain Think-time function?

Answer # Think-time functions suspended processing until the user has taken some actions (such by clicking button in message box), or until external function has run to completion (for example a remote process).
Think-time function hold avoids the following events: SavePreChange, Workflow, RowSelect, SavePostChange.

PeopleSoft Technical Interview Questions # 23

In which PC events dosave function is useful?

Answer # FieldEdit, FieldChange, or ItemSelected.

PeopleSoft Technical Interview Questions # 24

Where does you set the web server cache?

Answer # Webserver configuration.properties file

PeopleSoft Technical Interview Questions # 25

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

Answer # PSAPPSRV.CFG

 

RELATED INTERVIEW QUESTIONS

  1. 199 Peoplesoft Interview Questions
  2. 200 Blue Prism Interview Questions
  3. Visualforce Interview Questions
  4. Salesforce Interview Questions
  5. 300 SSIS Interview Questions
  6. PHP Interview Questions And Answers
  7. Alteryx Interview Questions
  8. AWS Cloud Support Interview Questions
  9. Google Kubernetes Engine Interview Questions
  10. AWS Devops Interview Questions
  11. Apigee Interview Questions
  12. Actimize Interview Questions
  13. Kibana Interview Questions
  14. Nagios Interview Questions
  15. Jenkins Interview Questions
  16. Chef Interview Questions
  17. Puppet Interview Questions
  18. DB2 Interview Questions
  19. AnthillPro Interview Questions
  20. Angular 2 Interview Questions
  21. Hibernate Interview Questions
  22. ASP.NET Interview Questions
  23. Kubernetes Interview Questions
  24. Docker Interview Questions
  25. CEH Interview Questions
  26. CyberArk Interview Questions
  27. Appian Interview Questions
  28. Drools Interview Questions
  29. Talend Interview Questions
  30. Selenium Interview Questions

PeopleSoft Interview Questions And Answers For Experienced

PeopleSoft Interview Questions And Answers For Experienced 2018. Here Coding compiler presenting a list of 199 PeopleSoft Interview Questions. These PeopleSoft questions are prepared by industry expert PeopleSoft developers. We hope that it helps you to crack your next PeopleSoft job interview. All the best and happy learning.

PeopleSoft Interview Questions

  1. What is an ERP?
  2. Describe the Life Cycle of a Project (ERP Implementation)?
  3. What is Component Processor?
  4. What is component buffer?
  5. What is the difference between component buffer and data buffer?
  6. What data buffer classes are available in people code?
  7. How do you bring component buffer into application engine program?
  8. Difference between field edit and save edit?
  9. Diff b/w save pre change and save post change?
  10. Arrays and Load lookup in SQR?
  11. How can we know from SQR, if environment is PSNT or PSUNX?
  12. What is SQL View and Temporary Table?
  13. Can the output of a SQL query be stored in a variable using PeopleCode? If so how it be done?
  14. How to migrate roles or PeopleCode from one database to another database?
  15. What is the use of set control field in record field properties?

PeopleSoft Interview Questions And Answers

1) What is an ERP?

A) It is a process of integrated flow of Information, which binds the organization together.
It is an integrated application software module providing operational, managerial and strategic Information for improving productivity, efficiency and quality.

PeopleSoft HRMS system provides complete support for all human resources needs with functionality for

  • Recruiting employees for jobs
  • Tracking training, employee skills and education
  • Administering base benefits programs and more

2) Describe the Life Cycle of a Project (ERP Implementation)?

A) The Project passes through the following stages.

  1.  Analysis
  2.  Designing
  3.  Coding
  4.  Testing
  5.  Implementation
  6.  Maintenance.

3) What is Component Processor?

A) The Component Processor Controls the PeopleSoft Applications from Initial data retrieval through updating the database.

The component processor manages the flow of data processing as users enter information on pages. Issues INSERT DELETE and UPDATE statements to maintain data in the database and SELECT statements to retrieve data

4) What is component buffer?

A) Component Buffer is the area in memory that stores data for the currently active component.

PeopleSoft Interview Questions

5) What is the difference between component buffer and data buffer?

A) Component buffer contains all the data of the active component.

Data buffer contains the data other than the data in the component buffer (Data of other records)

6) What data buffer classes are available in people code?

A) Rowset, Row, Record, Field, Array, File, Sql, chart, grid and so on.

7) How do you bring component buffer in to application engine program?

A) You can assign a record which is used in component buffer to a state record of Application engine.

8) Difference between field edit and save edit?

A) In Field edit for each field change, a transition to the application server to the database is taken place. In Save edit for all the fields, only one transition to the application server to the Database is taken place.

9) Diff b/w save pre change and save post change?

PeopleSoft Interview Questions

10) Arrays and Load lookup in SQR?

A) Load Lookup is used to reduce the complexity of joins – it populates the values of a certain field depending on the key field specified from a certain table. Then the users can query from the preloaded lookup table instead of joining tables. While arrays are used to store and retrieve data using the get and put commands

Load-lookup:
Load-lookup will be populated at compilation time.
We can adjust the size of load-lookup.
It is only for text data type

Array:
Array gets populated at Execution time.
We can’t modify size of the Array. If we given more than the size of the array, Array supports all data types.

11) How can we know from SQR, if environment is PSNT or PSUNX?

12) What is SQL

13) View Temporary Table?

A) SQL View: SQL View has fields from one or more tables in the reorganized way. This provides alternative view of information stored in the tables.

Temporary Table: are used for running application engine batch processes. Temporary tables can store data to update without risking the main application table.

14) Can the output of a SQL query be stored in a variable using PeopleCode? If so how it be done?

A) SQLExec (“SELECT EMPLID FROM JOB”, &Emplid);

Basic Peoplesoft Interview Questions and Answers

15) How to migrate roles or PeopleCode from one database to another database?

A) Include all the roles in a project by clicking on Insert -> Definitions into Project -> select Roles and add them into the project. Migrate the project to another database.

Create a data mover script to migrate roles from PSROLEDEFN or PSPCMPROG for peoplecode table.

  1.  Login to database through App Designer as a source database.
  2.  Click on upgrade tab and open the project which contains roles which you want to migrate.
  3.  Double click on Roles folder under the opened project.
  4.  Select Action as “Copy”.
  5.  Go to Tools > Copy Project > To Database…..
  6.  Give database name (Target Database) to which you want to migrate roles.
  7.  Click on “OK”
  8.  Select “Roles” from different objects and copy those roles.
  9.  After completion of Copying double click on Roles folder under the opened project and verify that “Done” checkbox should be checked.

PeopleSoft Interview Questions

16) What is the use of set control field in record field properties?

A) Set Control id is used when you want to share tables in PeopleTools applications.

17) How to create prompt table?

A) Using edit table option in record field properties

18) How is performance management taken care in People Tools?

A) – Indexing tables on the database side helps in batch processing a great deal.

  • Analyzing tables helps.
  • If there is custom code make sure the SQL queries used are written well with the use of proper keys and joins are correct as well.

19) What are state records?

A) – The state record will be used to pass variable information between two application engine sections.

  • It can be physical or derived work record. Physical record can be used when you have restart logic and when you have disabled the restart logic derived work record can be used.
  • There can be a max of 200 state records that can be used in a single AE but only one of them can be default state record name must end with _AET.

20) What is mandatory step of application engine program?

A) Main-Step-Action

  • Main is the required section in Application Engine.
  • There can be multiple steps in single application engine but at least one step should be part of AE.
  • Similarly you can have multiple actions in AE but you should have minimum 1 action part of step.

PeopleSoft Interview Questions

21) What is difference between component level peoplecode and record level peoplecode?

A) Component level PeopleCode is associated with unique component, where as record level peoplecode can be associated with any number of components

22. Types of PeopleCode functions?

A) People code supports these types of functions:

  • Built in
  • Internal
  • External people code
  • External non-people code

23) Explain with example where you used peoplecode extensively?

24) What is the difference between Prebuild & Postbuild events and saveprechange and savepostchange?

A) Prebuild can be used to validate your search data, discarding rows. Postbuild can be used to play with the pages (hide, unhide), filling up scrolls.
Saveprechange is the last event where you can validate and correct your data before updating the database. Once it is done, database will get updated. Savepostchange will be used to play with tables which are not present in your component buffer.

25) Sequence of peoplecode events?

A) Searchinit peoplecode performs before the search dialogue box displays.

Search save peoplecode performs after the operator clicks ok in the search record dialogue box.

  • Row select peoplecode is used to filter out rows of data.
  • Prebuild is often used to hide and unhide the pages.
  • Field default attempts to set defaults for fields without a value.
  • Field formula performs, after field default completes successfully.
  • Rowinit is used to initialize the rows.
  • Postbuild peoplecode performs after all the component build events have performed.
  • Activate event is fired every time the page is activated.

PeopleSoft Interview Questions

26) Difference between SQLEXEC and CREATESQL?

  • A) SqlExec means it bypasses the component buffer and it is directly contacts database to retrieve data. But it retrieves the data row by row and not possible for bulk insert.
  • But in the case of Create SQL we can able insert the data in bulk.

27. Where is peoplecode stored?

A) Database Server, PSPCMPROG

28) Is there any function in peoplecode which stops the processing of whole component?

A) Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion.
Think-time functions

Following are Think time functions:

  • DoCancel
  • DoModal
  • DoModalComponent
  • Exec (only when Synchronous)
  •  File attach functions
  • Prompt
  • RemoteCall
  • RevalidatePassword
  • WinExec(only when Synchronous)
  • WinMessage
  • WinMessageBox

29) Stages of program flow in SQR?

A) Compile stage
All the Preprocessor directives are compiled (which starts with #include).

Ex: All the SQC are run.

Check for the syntax errors for the conditions.

Ex: if for loop while loop are properly ended with the respective syntax.

Allocates memory structure if you are using the Arrays and load look up

Execution stage
starts interpreting the code line by line

Check for the
begin -program
Begin -heading
Begin- footer

30) Program flow of SQR?

A)

  • Setup section
  • heading section
  • footing section
  • program section
  • procedure section

Top PeopleSoft Interview Questions

31) Difference between Translate values and Prompt tables?

A) Translate Table:
Translate table is a special kind of table that is limited to validating data of four characters or less. The translate table serves as a universal prompt table and is effective-dated

Prompt Table:
Prompt table are used to provide users with validate values from other tables other values are generally populated by system users and are often application specific

32) What is .SQC and .SQT?

A) .SQC is a Function Library file. It is like a sub program is saved by extension .SQC and this program can be called in the SQR program

.SQT is compile time/Run time file. When a file with XXX.SQR is compiled we get the output as XXX.SQT and when is XXX.SQT is executed we get the output XXX.LIS (List file/Output file).

33) Important SQC that need to be attached to SQR program?

A)

  • – #include ‘setenv.sqc’
  • – #include ‘stdapi.sqc’
  • – #include ‘prcsdefn.sqc’
  • – #include ‘prcsapi.sqc’
  • – #include ‘curdtrim.sqc’
  • – #include ‘hrctlnld.sqc’
  • – #include ‘datwtime.sqc’

PeopleSoft Interview Questions

34) What is Normalization in Oracle?

A) The major goals of Normalization are

– Eliminating redundant data (for example storing the same data in more than one table

– Ensuring data dependencies (only storing related data in a table).

35) Performance tuning in SQR?

A)

  • – Load Look Up
  • – Arrays
  • – Multiple Report
  • – -Bnn
  • – Using SQT Files
  • – Run on the BATCH Server
  • – Proper Programming Logic
  • – Set processing
  • – SQL Tuning

36) Difference between search record and add search record?

A) Search Record: Specify the search record for the component. The search record controls access to rows of data in a table. Its keys and alternate search keys appear on the search page as criteria.

Add Search record: Specify if you want a different search record specifically for add actions.

37) What is difference between scroll and grid?

A) Scroll area is used to maintain parent child relationship we insert grid in low level scroll

Example: assume we have 3 scroll levels in our page level1 level2 and level3 we insert grid in level 3

PeopleSoft Interview Questions

38. How many ways we can run the application engine program?

  • A) – Running from Application Designer.
  • – By calling People Code function.
  • – Running from DOS Environment (Debugging).
  • – Running from Application Engine People Tool.
  • – Running from Peoplesoft Application.

39) Functional and Technical?

A) Based on Customer Business processes functional person maps requirements to PeopleSoft and performs the rules and the Configurations required. He is the one who collects the requirement and decides what customization is and what is delivered by PeopleSoft.

PeopleSoft Technical Guy is the Person who knows how to code in PeopleSoft to execute the requirement.

40) What are the new features added in PS 8 Application Designer?

A) The newly added features in PS 8 Application Designer are as follows:

  • The Application Reviewer has been integrated with Application Designer in 8.
  • The PeopleCode has become VBA style with objects properties and methods.
  • The Meta SQL variables are introduced. The new variables like component, record, SQL has been introduced.
  • The Application engine now supports PeopleCode.
  • The scroll bars have become scroll areas in PS 8.0 etc.

PeopleSoft Technical Interview Questions

41. What are the three actions that can be attached to menu?

A)

  • – Component
  • – Separator
  • – PeopleCode

42. What is the difference between a Process and a Report?

A) The Process receives a command line parameter where as the Report receives run controls from the page.

43) What are maximum number of actions possible in a step, list them

A) Various actions possible in Application Engine step are as follows:

  • – Do while
  • – Do when
  • – Do select
  • – PeopleCode
  • – SQL
  • – Call section
  • – Log Message
  • – Do until

One action can be called only once in a step of an Application Engine program.

PeopleSoft Interview Questions

44) Tell about application engine program you worked with?

45) What is built in restart logic in Application Engine programs?

A) Within each Application Engine program, you must define how frequently the program will issue a COMMIT. After doing so, each COMMIT becomes a “checkpoint” that Application Engine uses to locate where within a program to restart after an abend. This type of built-in logic does not exist in COBOL or SQR.

46) What are Application Engine State records?

A) The State Record is a PeopleSoft record that must be created and maintained by the Application Engine developer. This record defines the fields a program uses to pass values from one Action to another.

Think of the fields of the Application Engine State Record as comprising the working storage for the Application Engine program. An Application Engine State Record can be either a physical record or a work record, and any number of State Records can be associated with a program. Physical State Records must be keyed by process instance.

An Application Engine State Record must have PROCESS_INSTANCE defined as the first field and the only key field. And, so that the system recognizes the record as a State Record, all State Record names must end with the _AET identifier.

47) What is PIA and what are its components?

A) It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services.

In database server we have system tables, PeopleTools tables and application tables.

48) In which events error & warning are used most extensively.

A) Field edit, save edit, Search save, row delete, row insert.

PeopleSoft Interview Questions

49) Is there any way by which you can find out whether the user is in Add mode or Update mode?

A) %mode—returns A—for Add mode. Returns U –for Update mode

50) How is the searchinit event most often used by people soft application?

A) Searchinit fires before the search dialogue page is displayed to the end use. For this reason searchinit is often used to enhance row level security by inserting and graying out certain values to the search dialogue page.

PeopleSoft Technical Interview Questions and Answers

51) When we select a component what events will be fired?

A) If default mode for component is search mode: only searchinit will fired .If default mode for component is new mode. Field default, field formula, rowinit, searchinit.

52) What are different variables in people code and their Scope?

A) System variables and User defined variables.

Scope — Global, Component, Local.

53) What is default processing?

A) In default processing, any blank fields in the component are set to their default value. You can specify the default value either in the Record Field Properties, or in FieldDefault PeopleCode

PeopleSoft Interview Questions

54) What is the difference between field default and Rowinit?

A) Field default specifies only the default value for a field when we are in Add mode.
Row init fires only when a row of data coming from database to component buffer.

55) What is the difference between saveprechange and savepostchange? Which function directly interacts with the database?

A) Saveprechange—last event that executes before updating the data from component buffer to the database.

Savepostchange –fires after the updation of data in the database.

SQLEXEC — function directly interacts with the database.

56) What is Getlevel 0()? What is the use of %subrec and %selectall functions?

A) Getlevel0 () —used the get the rowset of the level0.

%subrec–is used only in Dynamic View SQL where it expands to the columns of a subrecord:

%selectall–%SelectAll is shorthand for selecting all fields in the specified record, wrapping date/time fields with %DateOut, %TimeOut.

57) What is an array in people code? What is maximum dimension of an array? Which function inserts values into an array? What is “pop”?

A) An array is a collection of data storage locations, each of which holds the same type of data.

The maximum depth of a PeopleCode array is 15 dimensions.

Push and unshift are the functions of the array used to add the elements into the array one from the end of the array and one from the beginning.

Pop is a function of array used to select and delete an element from the end of the array.

PeopleSoft Interview Questions

58) What is the difference between Getrowset and Createrowset in people code?

A) Getrowset –is used to get rowset for a record in the component buffer.

Createrowset—is used to create rowset for a record which in database, and is also called a Standalone rowset

59) Can you save the component programmatically?

A) Using Dosave and Dosavenow functions.

60) What are differed processing and its advantages?

A) Postpones some user actions to reduce the number of trips to the database so that increases the performance (in system edits, field edit, and field change).

Advantages:

1) Reduces the network traffic.

2) Increases the performance.

61) Write the syntax to access third level record field using object oriented peoplecode?

A) &fld=Getlevel0 ()(1).GetRowset(Record..GetRow(1),
GetRowset (Record.).GetRow(1),
GetRowset (Record.).GetRow(1),
GetRecord (Record.).GetFieild(Field))

62) What are the built-functions used to control translate values dynamically?

A) Adddropdownitem ()
Deletedropdownitem ()

63) Before accessing a people soft application what levels of security must be passed through.

A) a) Field level security
b) Row level security
c) Maintain security
d) Definition security
e) Portal security.

PeopleSoft Interview Questions

64) What is the use of primary permission list in user profile?

A) Primary permission list is used for mass change and definition security purposes.

65) How to authorize the user to run a process or report?

A) To authorize a user to run a process, the process group, which contains the process or report, should be added to the permission list of that user.

Advanced PeopleSoft Interview Questions

66) How to give access to the records that are to be used in a query?

A) To give access to the records that are to be used in query, we have create a new query security tree and add the records which we want to give the access and then assign a access group to the tree. After that we have to add that query tree and query access group to the permission list.

67) What are the rules used by the system to determine whether a user is authorized to update an object?

A) The user should have the permission to update the object. This is given by the Definition security. The group, which holds the object, should be added to the permission list of the user in update mode.

68) What are the different ways we can set up the portal security to access component in portal?

A) 1) Structure & content

2) Menu import

3) Register component

PeopleSoft Interview Questions

69. Steps involved in Data Conversion?

A)

  • – Extract data from the legacy system
  • – Reconcile the extracted data
  • – Identify the tables to be leaded with the new system
  • – Data Mapping
  • – Identify the tools (SQR or Import Manager or SQL Loader etc)
  • – Write programs to perform conversion
  • – Test the programs using test data
  • – Check the data outline
  • – Reconcile concerted data.

70) Why SQR is used?

  • A) – Data conversion
  • – Reports
  • – Interface programs.

71) How do you link SQR reports to process scheduler?

  • A) – Create/modify/add run control table if you have any new fields
  • – Create/modify/add run control page if you have any program inputs
  • – Create a menu definition (Note Menu group name: XYZ)
  • – Give operator security
  • – Create Process scheduler definition
  • – Use-Process definition – process definition add
  • – Give report name and report type

PeopleSoft Interview Questions

72) What are variable types in SQR?

  • A) – & Data base reference fields – Read only
  • – $ Character (Same for Date)
  • – # Numeric
  • – { } Variable in ASK or # define
  • – [$ variable] Dynamic variable referencing

73) What are the types of record definitions?

  • A) – SQL Tables
  • – SQL views
  • – Dynamic views
  • – Derived / Work Records
  • – Sub Records
  • – Query views

74) What is Dynamic View?

A) Dynamic view that can be used like a view in pages and PeopleCode, but is not actually stored as a SQL view in the database. Instead, the system uses the view text as a base for the SQL Select that is performed at runtime.

Dynamic views can provide superior performance in some situations, such as search records and in PeopleCode Selects, because they are optimized more efficiently than normal SQL views.

75) Table loading Sequence (installation)?

  • A) – Company table
  • – Installation
  • – Location
  • – Department
  • – Salary Plan
  • – Salary step
  • – Job code
  • – Pay group
  • – Benefit Programs

PeopleSoft Application Engine Interview Questions

76) What is Application Engine?

A) It is the tool, which performs, background SQL processing against our application data tables. It is an alternative for COBOL, SQL or SQR

77) What are the Different types of Application Engine?

A)

  1. Standard: Standard entry-point program.
  2. Upgrade Only: Used by PeopleSoft Upgrade utilities only.
  3. Import Only: Used by PeopleSoft Import utilities only
  4. Daemon Only: Use for daemon type programs.
  5. Transform Only: Support for XSLT Transform programs.

PeopleSoft Interview Questions

78) What is the advantage of using Application Engine?

A) The following are the advantages of using Application Engine.

Encapsulation
Unlike applications developed using COBOL or SQR, Application Engine applications reside completely within your database. With Application Engine, there are the programs to compile, no statements to store, and no need to directly interact with the operating environment in use. You can build, run and debug your applications without existing People Tools.

Effective Dating
Application sections are effective dated-meaning you can activate/deactivate a section as of a particular date. This enables you to archive sections as you modify them, instead of destroying them. In the future if you decide to revert to a previous incarnation of a section you can simply reactivate it.

SQL / Meta-SQL Support
In addition to writing your SQL within Application Engine, you can also copy SQL statements into Application Engine from SQL talk or any other SQL utility with few – if any changes.

RDBMS platforms have many differing syntax rules – especially in regard to date, time and other numeric calculations. For the most part you can work around this problem using Meta-SQL which Application Engine supports.

This language was created to handle different RDBMS SQL syntax’s by replacing them with a standard syntax, called Meta-strings.
With in Platform specific sections

You can also have the ability to call generic portions of SQL statements by using the & CLAUSE function. This means you can write your generic SQL portions just once, and reference them from your different platform versions.

Set Processing Support
Set processing is a SQL technique used to process groups (or sets) of rows of one time rather than one at a time. Application Engine is particularly effective of processing these types of applications.

Object Orientation
unless designed to anticipate changes in field attributes. COBOL applications may need to be modified when things change. If a developer increases a field’s length, then it may need to be changed in every instance where the COBOL program uses this field as a bind or select variable.

This can require a good bit of effort. And, if not handled properly, a change like this can cause confusing errors. For example, if the length of a field in the COBOL is wrong, it may work fine, or you may get an error, or the field may get truncated.

One of the corner stones of People soft functionality is Application Designer. Because of the way it works, most field attributes (type, length and scale) can be specified once, globally. If the field is used on more than one record, it has the same attributes in each of these records.

PORTABILITY
you can use Data Mover to import/export your applications. This means that you can export an application(s) into a file, and attach it to an e-mail message. Then, the recipient can simply use the IMPORT feature of Data Mover, and the application is ready to run.

79) Where are the search records assigned?

A) Search records are assigned to a component in a menu.

80) Does the search record for a panel have to be the same as the record being accessed on the panel? Why or Why not?

A) The search record for the panel does not have to be the same as the record being accessed on the panel because the search record is used to search for and or Filter the search key.

PeopleSoft Interview Questions

81. Differentiate Error V/s Warning statements in People code?

A) The error statement issues a message and the condition causing the error must be corrected before proceeding. The warning statement issues a message and the user can proceed without changing any values.

82. Where can you run Jobs?

A) The process scheduler can run jobs on the client or a server machine.

83. What restrictions are placed on multi-process jobs?

A) A multi process jobs can only be scheduled to run on a server.

84. List the three output destinations available through the Process Scheduler?

A) You can direct the output to a printer, file and windows screen.

85. What fields should be at the top of every search record definition that use table set Ids?

A) SET ID is the field that should be at the top of every record definition that uses table set Ids.

PeopleSoft Interview Questions

86. What is a Record Group ID?

A) A Record group ID is a group of record definitions that are Sharing the same set control field.

87. What are the types of layers in Crystal reports?

A) There are 4 types of layers in Crystal Reports. They are:

  1.  Report Header – In this, we will write title, date, and logos of the company.
  2.  Page Header – Used to write column headings.
  3.  Detail – Contains database column values.
  4.  Page Footer – Used to write page numbers and address.

88. Define security administrator?

A) Security administrator is used to control and access the various People soft menus.

89. How many types of security administrator profiles? Define?

A) There are three types of Security administrator profiles:

  1.  Access Profile: It is an RDBMS ID. It provides the necessary Ids and password for behind-the-scene process.
  2.  Class Profile: It is defined to organize the users into groups with common access rights or privileges.
  3.  Operator Profile: It is commonly referred as a Operator Ids or operator having associated sign on passwords.

90. Define Object Security?

A) The Security profile which is created as an operator security to restrict access to People soft data.

PeopleSoft Integration Broker Interview Questions and Answers

91. What is Translate Table?

A) A translate table is a prompt table that serves as data dictionary to store values for fields that don’t need individual prompt tables of their own.

92. What are the limitations of Translate table?

A) 1. Field type should be character
2. Minimum Field length should be 1 to 4 characters.
3. Field values should be small (static).

93. What is Effective Date?

A) Effective date is used to store history, Current and Future information.

PeopleSoft Interview Questions

94. History date Vs past Date?

A) Past date – Within 30 days of current date is called past date.
History date – Above 30 days of current date is called History Date.

95. What is a record?

A) A Group of non-repetitive fields is called a record.

96. How many types of records are there?

A) There are six types of records are there, they are:

  1. SQL table – Corresponding physical SQL table in the database we create with build option.
  2. SQL View – It is not a physical SQL table on the database, it gives the replicate of joined tables. It is used for security and faster access.
  3. Dynamic View – It is actually stored in the form of SQL view text and is executed at runtime. It uses the built in indexes. Whereas normal view is executed and stored in the database.
  4. Derived/Work record – It is a temporary workspace to be used during on line panel processing and is not stored in the database, therefore derived work records are not built. They cannot be seen in the update/display mode. Once the panel is cancelled it is removed from the buffer.
  5. Sub Records – A group of fields commonly used in multiple records.
  6. Query View – A Query view is a view constructed using People soft Query tool.

97. How many types of Displays are there in the tool bar?

A)

  1.  Field Display – It shows the field attributes (fieldname, Type, Len, Format, H, and Shortname, Long name
  2.  Use Display – It shows key related characteristics and default values for the fields (Field name, type, direction indicates, search key, list, system indicates, audit, H, default values)
  3.  Edit Display – It shows the auditing options available for the fields (field name, type required , edit, prompt table, reasonable date, people code)
  4.  People code display – It shows the different events and the user can choose required event to write people code.

PeopleSoft Interview Questions

98. What is application engine program?

A) PeopleSoft Application Engine program is a set of SQL statements, PeopleCode, and program control actions that enable looping and conditional logic.

99. Define People Tools?

A) A Collection of software programs, utility scripts, database tables and data that provide the frame work for creating, using and modifying people soft applications. People tools provide built in business functionality and maintain the capability that directly increase productivity and simplify system design.

100. What does Application Designer mean?

A) It is an integrated development environment that is used to develop People soft applications

PeopleSoft Interview Questions Application Engine

101. Functionality of Application Designer?

A) The following are the uses of Application Designer.

  1.  Design and create database tables.
  2.  Design on-line pages
  3.  Controlling on-line processing flow.
  4.  Providing security for the database.

102. What is a project?

A) User defined collection of related definitions (fields, records, pages, components and menus).

103. What are the physicals attributes Applications designer screen?

A) The following are the attributes of Application Designer are,

  1.  Title bar
  2.  Menus
  3.  Toolbar
  4.  Project Workspace – it arranges PeopleSoft objects in Windows explorer format
  5.  Objects Workspace – Open Multiple Object and store in main window.
  6.  Output Window – Deals about the output generated by using project development or up gradation.
  7.  View tabs – Development tools / Upgrade

104. How is data stored, retrieved, manipulated and processed in People soft applications?

A) PeopleSoft is a table-based system and it contains three major sets of tables,
1. System catalog tables; it stores physical attributes of tables and views. (e.g. Sys, Columns, Sys tables)
2. People Tools tables; it contains information that you define using People Tools (e.g. PSRECDEFN, PSMENUDEFN)
3. Application Data Tables; Store the actual data users enter and access through People Soft application windows and pages. (E.g. PS_ <>)

105. How many types of RDBMS support PeopleSoft?

A) The following are the list of RDBMS supporting PeopleSoft application.
DB2, SQL Base, Oracle, Microsoft SQI Server, Informix

PeopleSoft Interview Questions And Answers

106. Define a Field, Field attributes, and Field properties?

A) Fields are basic building blocks in People soft and can be used in application when they are added to at least one record. Fields are globally defined.

The common filed attributes are:
1. Data type 2. Field name 3. Long name 4. Short name 5. Formatting 6. Help context number 7. Translate values – stored in separate table (XLATTABLE).

Fields are:

1.Globally defined
2.Reusable components and can be shared across multiple record definitions
3.A change to the Field properties affects all the records that include the field.

107. Explain briefly about record properties?

A) KEY: The record knows a field, which uniquely identifies each row, as a key.

  1.  We will search and retrieve data from the database according to the key field.
  2.  This will not allow duplicate and null values.
  3.  It is a primary key
  4.  It allows multiple keys
  5.  Maximum keys allowed in a record is 15
  6.  It should be placed at the top of the record definition.

Duplicate Order Key:

1. It provides a way of ordering data in the table when the duplicate values are allowed.
2. It will create index for the column. However the index can be disabled.

Alternate Search key:

1. it identifies the field as a key that provides an alternative path into table data.
2. Due to alternate search key the system becomes slow, because database index will be created when SQL creates the tables, so it will consume the disk space.
3. It allows duplicate values.
4. Alternate search will be seen in the search dialog box when update/display mode is selected.

Descending order key:
It is used to retrieve data in the form of 3-2-1 or C-B-A and normally it is used in Effective date.

PeopleSoft Interview Questions And Answers

108. How many types of securities are available in People soft?

A) There are 6 types of securities:

1. RDBMS Security 2. Network security 3.Operator security 4. Object security 5.Tree level security 6. Query security (row level security)

109. Types of Menus?

A)
1. Standard menu: It appears in the menu bar of a PeopleSoft application.
2. Popup menu: Allows the user to navigate related information in other areas of application by right clicking on a page or component.

110. What is the difference between Key and alternate search Key?

A) KEY-It is the primary key of the record. Can be used as search key or need not be. Alternate search key-it is used for searching purposes.

111. Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?

A) Update/display – can view current and future rows. Can update only future rows.
Update/display all – can view history, current and future rows. Can update only future rows.
Correction – can view and update history, current and future rows.

112. What types of audits are supported by people soft? In case of record level audit what is the structure of table?

A) We have field level audit and record level audit. The structure of the table in record level audit is: AUDIT_OPRID, AUDIT_STAMP, AUDIT_ACTN, AUDIT_RECNAME and can add fields from record.

PeopleSoft Interview Questions And Answers

113. What are Table Edits?

A) We have prompt table edit, yes/no table edit, translate table edit as the table edits.

114. What conditions are required to establish parent child relationship between two records? What are the advantages with that?

A) Conditions are:
1) The child record should have all the key fields of parent record and at least one more key field other than the key fields of parent record.
2) We should mention the parent record in the record properties of child record.
3) We cannot go for more than three levels of parent/child relationships.

Advantages are:
1) To have referential integrity.
2) Data dependencies
3) Eliminate redundant data

115. Can you place Sub page into Grid? If yes How?

A) Yes we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid. When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid.

PeopleSoft  Interview Questions on Peoplecode

115. Can you hide a primary page in a component? Reason?

A) No we cannot hide the primary page of a component. If the component had only one page then by making this page also invisible we won’t have any component existing so we are not allowed to hide the primary page.

PeopleSoft Interview Questions And Answers

116. What is an Expert Entry?

A) Expert entry enables a user to change from interactive to deferred mode at runtime for appropriate transactions

117. What is Auto Update?

A) This record field property is used to update the date field of particular record with the server’s current date and time whenever a user creates or updates a row. Even the user enter the data into that field, the data which the user enters will be updated by the system’s current date and time.

118. What is Record Group? Which records can be included into a record group?

A) Record group consists of records with similar functionality. To setup a record in record group we should enter a set control field value in record properties

119. How can you improve the security and usability of a Prompt table edit.?

A) Prompt table view

120. What are the different ways to setup row level security?

A) We can setup row-level security using a SQL view that joins the data table with an authorization table. And by having Query search for data using a query security record definition. The query security record definition adds a security check to the search.

PeopleSoft Testing Interview Questions and Answers

121. How does PeopleSoft use views? Which are online functions?

A) People soft uses views for search records, summary pages, prompt views, reports Search records and summary pages are online functions.

122. Why do PeopleSoft often use views as search records?

A) Search views are used for three main reasons.
Adding criteria to the search dialogue page
Providing row level security
Implementing search page processing

PeopleSoft Interview Questions And Answers

123. How can a component have more than one search record? Give a situation.

A) You might want to reuse the same component multiple times with different search records. You can accomplish this by overriding the component search record at runtime when the component is opened from a menu item without creating separate copies of the component.

The component override is temporary and occurs only when the component is opened from the menu item in which the override is set. It does not change the component definition.

124. What is PIA and what are its components?

A) It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services.

In database server we have system tables, peopletools tables and application tables.

125. Differentiate Field edit and Save edit?

A) In Field edit for each field change, a transition to the application server to the database is taken place.

In Saveedit for all the fields , only one transition to the application server to the Database is taken place.

126. What are think time functions?

A) Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion.

127. In which events error & warning are used most extensively.

A) Field edit, Save edit, Search save, row delete, row insert

PeopleSoft Interview Questions And Answers

128. Is there any way by which you can find out whether the user is in Add mode or Update mode?

A) %mode—returns A—for Add mode.
Returns U –for Update mode

129) How is the searchinit event most often used by people soft application?

A) Searchinit fires before the search dialogue page is displayed to the end user. For this reason searchinit is often used to enhance roll level security by inserting and graying out certain values to the search dialogue page.

130. What are the options for using SQL in people code?

A) SqlExec
Record class methods (selectbykey, delete, insert, update)
Using Sql class, its properties and methods

PeopleSoft Interview Questions For Experienced

132. What data buffer classes are available in people code?

A) Rowset, Row, Record, Field, Array, File, Sql, chart, grid and so on

133. When we select a component what events will be fired?

A) If default mode for component is search mode: only searchinit will fired .If default mode for component is new mode: field default, field formula, rowinit, searchinit.

PeopleSoft Interview Questions And Answers

134. What are different variables in people code and their Scope?

A) System variables and User defined variables.
Scope —Global, Component, Local.

135. What is default processing?

A) In default processing, any blank fields in the component are set to their default value. You can specify the default value either in the Record Field Properties, or in FieldDefault PeopleCode

136. What is difference between field default and Rowinit?

A) Field default specifies only the default value for a field when we are in Add mode.

Row init fires only when a row of data coming from database to component buffer

137. What is difference between saveprechange and savepostchange? Which function directly interacts with the database?

A) Saveprechange—last event that executes before updating the data from component buffer to the database.

Savepostchange –fires after the updation of data in the database.

SQLEXEC — function directly interacts with the database.

PeopleSoft Interview Questions And Answers

138. What is Getlevel0()? What is the use of %subrec and %selectall functions?

A) Getlevel0()—used the get the rowset of the level0.

%subrec–is used only in Dynamic View SQL where it expands to the columns of a subrecord:

%selectall–%SelectAll is shorthand for selecting all fields in the specified record, wrapping date/time fields with %DateOut, %TimeOut.

139. What is an array in people code? What is maximum dimension of an array? Which function inserts values into an array? What is “pop”?

A) An array is a collection of data storage locations, each of which holds the same type of data.

The maximum depth of a PeopleCode array is 15 dimensions.

Push and unshift are the functions of the array used to add the elements into the array one from the end of the array and one from the beginning.

Pop is a function of array used to select and delete an element from the end of the array.

PeopleSoft Interview Questions And Answers For Experienced

140. What is difference between Getrowset and Createrowset in people code?

A) Getrowset –is used to get rowset for a record in the component buffer.

Createrowset—is used to create rowset for a record which in database, and is also called a Standalone rowset

141. Can you save the component programmatically?

A) Using Dosave and Dosavenow functions

142. What is differed processing and its advantages?

A) Postpones some user actions to reduce the number of trips to the database so that increases the performance (in system edits, field edit, and field change)
Advantages:

Reduces the network traffic

Increases the performance

PeopleSoft Interview Questions And Answers

143. Write the syntax to access third level record field using object oriented peoplecode?

A) &fld=Getlevel0()(1).GetRowset(Record.<level1 record>.GetRow(1),
GetRowset(Record.<level2record>).GetRow(1),
GetRowset(Record.<level3 record>).GetRow(1),
GetRecord(Record.<level3 record>).GetFieild(Field.<field name>))

144. What are the built-functions used to control translate values dynamically?

A) Adddropdownitem()
Deletedropdownitem()

145. How to populate data into grid in online?

A) &Rs.Select() Scrollselect()

146. Before accessing a people soft application what levels of security must be passed through.

A) Field level security, Row level security, Maintain security, definition security, Portal security

147. What is the use of primary permission list in user profile?

A) Primary permission list is used for mass change and definition security purposes.

199 PeopleSoft Interview Questions And Answers

148. How to authorize the user to run a process or report?

A) To authorize a user to run a process, the process group, which contains the process or report, should be added to the permission list of that user.

149. What are the rules used by the system to determine whether a user is authorized to update an object?

A) The user should have the permission to update the object. This is given by the Definition security. The group, which holds the object, should be added to the permission list of the user in update mode.

PeopleSoft Real-Time Interview Questions And Answers

150. What are the different ways we can set up the portal security to access component in portal?

A) – Structure & content
– Menu import
– Register component

151. What are the main elements in the component Interface?

A) – Component interface name
– Keys
– Properties and collections
– Methods

152. Difference between Get keys, find keys and Create Keys ?

A) Get keys: – These are mapped to the fields marked as scrh in the component’s search record. Automatically “Search key” fields in search record become Get keys.
We cannot change it.

Find keys: – These are mapped to fields marked as Alt or Srch in the component search record. You may remove Find keys that you do not wish to make available for searching.

Create Keys: – It is generated from the key fields for the search record. If Add search record is present then its key fields are taken. We cannot change it.

PeopleSoft Interview Questions And Answers

153. How do you provide security for the component interface?

A) Open the Permission list
On the Component Interface tab
Add row and select the newly created Component Interface
Edit the permissions to give permission for the standard methods
Get, Create, Save, cancel, find.

154. What the steps that you need to do in people code to invoke Component Interface?

A) Establish a user section
Get the component interface definition
Populate the create keys
Create an instance of the component interface
Populate the required fields
Save the component Interface.

&Session = GetSession();
&CI = &Session.GetcompIntfc(CompIntfc.INTERFACE_NAME)
&CI.KEY_FILED_NAME = ‘NEW’
If not &CI.Create () Then
Else
Populate other fields
End-if;
Populate the other fields
If not &CI.Save () Then
Else
End-if;

155. How do you test Component Interface?

A) Using the Component Interface tester
Give values in the tester for options
Get Existing, Create new, Find and perform the operation from the CI Tester

PeopleSoft Interview Questions And Answers

156. Catching error message in the component Interface? Or Use of PSMessages in the CI ?

A) This function needs to be called when ever methods like Find, Save, Create methods return false.

Error text and Error type can be printed in the log message for any other action in to the log message.

Function CheckErrorCodes()
&PSMessages = &Session.PSMessages;
&ErrorCount = &PSMessages.Count;
For &i = 1 To &ErrorCount
&ErrorText = &PSMessages.Item(&i).Text;
&ErrorType = &PSMessages.Item(&i).Type;
End-For;
End-Function;

157. What is method? What are the different types of method?

A) Methods: – A method is an object that performs a very specific function on a component interface at run-time.

Standard methods and user-defined methods.

Standard methods: – Automatically generated upon the creation of a new component Interface in Application.
Apart from the Standard methods there are Standard methods available for the use with any collection.

User-Defined methods: – User-defined methods are those that you can create to meet the requirements of an individual component interface.

158. What are properties?

A) The Fields in the level 0 in the component are the properties of the component.

Standard properties:

  • Createkeyinfocollection
  • Findkeyinfocollection
  • Property Info collection
  • GetHistoryItems (Update/Display mode or Correction mode)
  • EditHistory Items
  • InteractiveMode.

User-Defined properties

  • Developer can further control the exposed Getkeyinfocollection field properties.

PeopleSoft Interview Questions And Answers

159. How do you login in correction mode in the Component Interface?

A) Get History Items and Edit History items property to should be set to true.
Get History Items alone: – Update display all – modes will be used.

PeopleSoft Scenario Based Interview Questions And Answers

160. This is an example of how to grab the most recent/correct row from an effective dated/effective sequenced table such as PS_JOB
SELECT A.EMPLID FROM PS_JOB A
WHERE A.EMPLID = ‘12345’
AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED
WHERE A.EMPLID = A_ED.EMPLID AND A.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.EFFDT <= GETDATE())
AND A.EFFSEQ = (SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES
WHERE A.EMPLID = A_ES.EMPLID AND A.EMPL_RCD = A_ES.EMPL_RCD AND A.EFFDT = A_ES.EFFDT)

161. Types of Tables in PeopleSoft?

A) Base tables, Control tables, Views, Reporting Tables and Application data tables

A base table is the place where nearly every query starts. These tables store information about an employee and contain data about the employee. A base table stores live data that is continually changing.

The table could store information about employees, their dependents, their earnings, taxes, deductions or benefits. In short, these tables hold the real data.

EX: PS_PERSONAL_DATA, PS_JOB

A control table contains values that classify and categorize. For example, a table that contains all of the possible earnings codes (regular, bonus, overtime, etc.) is a control table, whereas the table that contains the actual earning amounts is a base table.

Control tables are also commonly known as ‘lookup’ or ‘prompt’ tables. Control tables are usually identified by suffix of ‘_TBL’.
PS_DEPT_TBL, PS_LOCATION_TBL, PS_JOBCODE_TBL, PS_EARNINGS_TBL

Views are timesavers; they are the result set of an SQL statement. For example, the benefits view table takes fields from several tables, links them together correctly, and presents the result as a new table.

Views link to original tables (base or control), so no data is duplicated or out of sync. Views are usually identified by a suffix of ‘_VW’.

Reporting Tables: In an attempt to appease those toiling away, searching for the location of basic employee data, PeopleSoft created three tables that contain the most-often-used human resources fields.

These tables are similar to views, but are not dynamic. Their data is only current after a program is executed every night. Their chief benefit is performance. Instead of joining 10 tables every time you look something up, the tables are joined once at night and then used throughout the next day as a single table.

EX: PS_EMPLOYEES, PS_BEN_PER_DATA and PS_BEN_PLAN_DATA are reporting tables

Application Tables: The PeopleSoft application stores application rules and definitions in application Tables. Occasionally these tables temporarily store data in the middle of a process.

With few exceptions, these tables store data that is not relevant to the organization. Most of these tables are not discussed in this book since they contain application data, not HR data. System tables often do not include an underscore after the ‘PS’ prefix

199 PeopleSoft Interview Questions And Answers

162. When working with PeopleSoft system tables, what are setup considerations that you need to make?

A)
– Sequence of table setup
– Default values
– Effective dates
– Actions

163. The system categorizes effective-dated rows into three basic types:

A) Effective dates allow you to keep history, current, and future information in tables. When you update existing information, you do not want to lose or overwrite the data already stored in the database.

To retain historical data, you can add a new data row identified by the date when the information goes into effect: an effective date. An effective date is a column in a table that is a key, but it is not typically a search key.

  •  Future: row greater than current row
  •  Current: row less than or equal to sysdate
  •  History: less than current row

164. The action you select tells PeopleSoft the type of activity you want to perform on the database.

A) The following four action types are available:

  • – Add : add new row/value
  • – Update/Display:
  • – Include History
  • – Correct History

165. What are Setid’s and Table set sharing?

A) Setid is the highest level key in the PeopleSoft.

Location, Department and Jobcode tables are control tables and setid’s control the control tables during the transaction.

Table set sharing is a place where control tables are listed. It is accessed by business unit.

EX: If we have two locations Arizona and Ohio with setid’s xyz and abc, suppose if we change Ohio’s setid to xyz then we can access all information related to Arizona/xyz like jobcodes etc.

PeopleSoft Interview Questions And Answers

166. PeopleSoft application data table types?

A)

  • – Translate Tables
  • – These values are between one and four characters long
  • – They do no need to be updated often
  • – They are effective dated
  • – Implementation Processing and Defaulting tables
  • – Installation Table
  • – Organization defaults by Permission lists
  • – Business unit HR defaults table
  • – Table set control table
  • – Control tables: These tables serve as foundation for the Organization.
  • – Company Table
  • – Business Unit Table
  • – Location Table
  • – Compensation Rate Code Table
  • – Job Code Table
  • – Table SetId (SetId table)
  • – Establishment Table
  • – Department Table
  • – Salary plan, Grade and Step Table
  • – Pay group Table
  • – Transaction tables: Records change often in these tables
  • – Personal Information
  • – Employment table
  • – Job table
  • – Benefits program participation tables

167. Sequence of table setup in HR?

A)

  • – Installation Table
  • – Company Table
  • – Table SetId (SetId table)
  • – Business Unit Table
  • – Tableset Control Table
  • – Organization defaults by Permission lists
  • – Business unit HR defaults table
  • – Establishment Tables
  • – Location Table
  • – Department Table
  • – Compensation Rate Code Table
  • – Salary plan, Grade and Step Table
  • – Job Code Table
  • – Pay group Table

168. What are Metastrings or MetaSQL?

A) Metastrings are special type of SQL expressions preceded by % sign.

Metastrings are used in the following:
– SQLExec
– In application designer to build dynamic views
– With rowset object methods (select, fill)
– SQL objects
– Record class methods (Insert, Update)
– Application Engine
– Cobol

PeopleSoft Interview Questions And Answers

169. What are classes in PeopleCode?

A) A class is the formal definition of an object and acts as a template from which an instance of an object is created at runtime. The class defines the properties of the object and the methods used to control the object’s behavior.

PeopleSoft delivers predefined classes (such as Array, File, Field, SQL, and so on). You can create your own classes using the Application class. You can also extend the functionality of the existing classes using the Application class.

170. What are Objects in Peoplecode?

A) An object represents a unique instance of a data structure defined by the template provided by its class.

Each object has its own values for the variables belonging to its class and responds to methods defined by that class. This is the same for classes provided by PeopleSoft and for classes you create yourself.

A property is an attribute of an object. Properties define:
– Object characteristics, such as name or value.
– The state of an object, such as deleted or changed.

PeopleSoft Consultant Interview Questions And Answers

171. Define SQR and steps for performance tuning?

A) SQR stands for Structured Query report. SQR performs database processing and used as reporting tool.

When program contains begin-sql, begin-select or execute commands, it performs sql statements, processing of sql statements consumes significant computing resources hence tuning sql statements yields higher performance.

Following are the steps for simplifying sql statements and reducing number of sql executions:

  • – Simplify a complex select paragraph.
  • – Use LOAD-LOOKUP to simplify joins.
  • – Improve SQL performance with dynamic SQL.
  • – Examine SQL cursor status.
  • – Avoid temporary database tables.
  • – Create multiple reports in one pass.
  • – Tune SQR numerics.
  • – Compile SQR programs and use SQR Execute.
  • – Set processing limits.
  • – Buffer fetched rows.
  • – Run programs on the database server.

PeopleSoft Interview Questions And Answers

172. Structure of SQR?

A) – Begin-Setup
– Begin-Heading
– Begin-Footing
– Begin-Report or Begin-Program
– Begin-Procedure

173. Commands that can be called from setup section?

A)
– Ask
– Define-Chart
– Define-Layout
– Define-Image
– Define-Printer
– Define-Procedure
– Define-Report
– Dollar-Symbol

174. How to run SQR in PeopleCode?

A) To call SQR from peoplecode we use peoplecode functions CreateProcessRequest() and Schedule()

175. Important Tables in HRMS?

A) PS_PERSONALDATA, PS_PERS_NID, PS_EMPLOYMENT, PS_JOB, PS_JOB_TBL, PS_DEPT_TBL, PS_LOCATION_TBL, PS_FED_TAX_DATA, PS_STATE_TAX_DATA, PS_LOCAL_TAX_DATA, PS_BEN_PROG_PRATIC, PS_HEALTH_BEN, PS_LEAVE_PLANS, PS_LIFE_BEN, PS_RTRMNT_PLN, PS_PAY_CHECK, PS_PAY_LINE, PS_PAY_BONUS, PS_PAY_DEDUCTIONS, PS_POSITION_DATA

PeopleSoft Interview Questions And Answers

176. About events in PeopleCode?

A) Record fields have 15 events, Components have 2 events and Page has 1 event.

177. Security?

A) Security Tree A security structure that graphically represents the hierarchy of your organization.

Tree Level Represents a logical division in your business hierarchy (ex: department, branch or region).

Tree Node Represents an organizational entity on the tree.

Tree Manager A PeopleSoft tool that provides a visual means to build a hierarchy of security for all organizational entities.
Query Trees Graphical representation of Tables to which you wish to control query access.

Access Groups Nodes in Query Trees where you would group Operators and assign them access to all tables under the node.

User Profiles: A User Profile describes a particular user of the PeopleSoft system. User Profiles define individual PeopleSoft users. You define User Profiles and then link them to one or more Roles.

Typically, a User Profile must be linked to at least one Role in order to be a valid profile. User Profiles maintain the Roles that are assigned to the user.

Roles are assigned to User Profiles. Roles are intermediate objects that link User Profiles to Permission Lists. Multiple Roles can be assigned to a User Profile, and you can assign multiple Permission Lists to a Role. Some examples of Roles might be Employee, Manager, Customer, and so on.

Permission Lists are lists, or groups, of authorizations that you assign to Roles. Permission Lists store Sign-on times, Page access, PeopleTools access, and so on.

A Permission List may contain one or more types of permissions. The more types of permissions in Permission List the more modular and scalable your implementation.

A User Profile inherits most of its permissions through the roles that have been assigned to the User Profile.

Data permissions, or row-level security, appear either through a Primary Permissions List or a Row Security Permissions list

Row-level security controls access to the subset of data rows within tables the user is authorized to read or update. The decision to implement row-level security will be based on the need to provide that level of data security.

To establish row-level security, you must first decide the necessary data security level required, which key fields to secure, and whether security will be defined through User IDs or Permission Lists. With row-level support, PeopleSoft security can restrict individual users or Permission Lists from specific rows of data that are controlled by key fields, for example:

– Business unit
– Set ID
– Ledger (and ledger group)
– Book
– Project

Therefore, users would only be able to view those rows for which they have security access for a specified Business Unit or Project, for example. Once row-level security is turned on in for a particular PeopleSoft module, it applies to all applications within that module, not specific applications.

Additionally, a method for implementing row-level security can be by User ID. Key fields can be associated to User IDs as well as Projects. Projects will also perform row-level security by User ID through the Use List. This sets up Projects to implement row-level security in a team-based method.

PeopleSoft security mainly depends on Rowlevel security.

Security works best if it is based on organizational structure.

Types of security supplied by PeopleSoft:

– Departmental security
– No security
– International security

Tree Manager:

3 steps in setting up department security:

– Create the security tree
– Update department security tree
– Grant and restrict access to the entities

PeopleSoft Interview Questions And Answers

178. What are steps involved in new employee hire process?

A) Personal Information: Name, Address, Identity

Job Data: Work Location, Job Information, Payroll, Salary Plan, Compensation

Employment Data: Employment Information

Earnings Distribution: Job earning distribution

Benefit Programs Participation: enrollment of benefit programs

179. How many sub pages, secondary pages can be created in one level?

A) We can create only one Secondary Page. But where as we can create N no of Sub Page in one Level

180. What is Integration Broker?

A) PeopleSoft’s Integration Broker is a messaging hub, that allows for data to be shared between different systems (e.g. PeopleSoft HRMS to Payroll [can be PeopleSoft or third party], HRMS to Finance, HRMS to CRM, etc.).

PeopleSoft Tool Interview Questions Ans Answers

181. Types of tools in PeopleSoft?

A) Development Tools:

– Application Designer
– Application Engine
– PeopleCode
– Internet Technology and Portal Technology

Integration Tools:

– Integration Broker
– Component Interfaces
– Workflow Technology

Analytic Tools:

– PeopleSoft Process Scheduler
– XML Publisher
– PS n/Vision
– Crystal Reports
– PeopleSoft Query
– Tree Manger
– SQRs

Administration Tools:

– Data Management
– Security Administration
– System and Server Administration
– Performance Monitor

LifeCycle Management:

– PeopleSoft Software Update
– Change Impact Analyzer
– PeopleSoft Setup Manager

PeopleSoft Interview Questions And Answers

182. Explain about Data Mover?

A) PeopleSoft Data Mover is a stand-alone two-tier program, which you can run through a graphical interface on Microsoft Windows, or a with a command line interface on either Microsoft Windows or UNIX systems.

PeopleSoft Data Mover enables you to perform the following tasks:

– Transfer application data between PeopleSoft databases.
– Move PeopleSoft databases across operating systems and database platforms.
– Execute Structured Query Language (SQL) statements against any PeopleSoft database, regardless of the underlying operating system or database platform.
– Export data in a platform-independent manner.
– Control database security and access.
– Create, edit, and run scripts which combine SQL commands and PeopleSoft Data Mover commands for exporting and importing data.

183. What are Data Mover operating modes?

A)
– Regular Mode: Using PeopleSoft User Id
– Bootstrap Mode: Using Database access Id

184. Commands in Data Mover?

A)

  • – ENCRYPT_PASSWORD: Encrypt one or all user passwords (operator and access) defined in PSOPRDEFN for users.
  • – EXPORT: Select record information and data from records and store the result set in a file. You can use the generated export file as input for migrating to another platform.
  • – IMPORT: Insert data into tables using the information in an export file. If a tablespace or table does not exist, this command creates tablespace, table, and indexes for the record, using the information in the export file, and inserts the data.
  • – REM: For Remarks
  • – RENAME: Rename a PeopleSoft record, a field in one record, or a field in all records.
  • – REPLACE_ALL: This is a variation of the IMPORT command. If a table already exists, use this command to drop the table and its indexes from the database and create the table and indexes using the information in the export file. Then, the command inserts data into the table using the information in the export file.
  • – REPLACE_DATA: This is a variation of the IMPORT command. Delete data in existing tables and insert the corresponding data from the export file.
  • – REPLACE_VIEW: Recreate specified views found in the database.
  • – RUN: Run a specified .DMS file from within a PeopleSoft Data Mover script. The file cannot contain nested RUN commands.
  • – SET: When a command is followed by valid SET parameters, it forms a statement that establishes the conditions under which PeopleSoft Data Mover runs the PeopleSoft Data Mover and SQL commands that follow.
  • – SET IGNORE_ERRORS: If this command is set, then all errors produced by the SWAP_BASE_LANGUAGE command are ignored. Otherwise, the system stops on errors.

PeopleSoft Interview Questions And Answers

185. Sample data mover code?

A) set output c:\temp\position_data.dat;
set log c:\temp\position_logfile.txt;

export position_data where location in (‘11490’, ‘11730’,’11804′,’11720′) and position_nbr not in (‘00002025′,’00002026′,’00002027′,’00002029′,’00002030′,’00002031′,’00002032’);

set input c:\temp\position_data.dat;
set log c:\temp\position_inputlogfile.txt;

import *;

186. Ensuring Data Integrity?

A) You may want to use these tools during upgrades and system customizations, to verify the PeopleSoft system and check how it compares to the actual SQL objects.

– Run SQL Alter: The primary purpose of the PeopleSoft Application Designer SQL Alter function is to bring SQL tables into accordance with PeopleTools record definitions.

– Run DDDAudit: The Database Audit Report (DDDAUDIT) finds inconsistencies between PeopleTools record and index definitions and the database objects. This audit consists of nine queries: four on tables, two on views, and three on indexes.

– Run SYSAUDIT: The System Audit (SYSAUDIT) identifies orphaned PeopleSoft objects and other inconsistencies within the system. An example of an orphaned object is a module of PeopleCode that exists, but which does not relate to any other objects in the system.

187. Database level Auditing?

A) PeopleSoft provides trigger-based auditing functionality as an alternative to the record-based auditing that PeopleSoft Application Designer provides. This level of auditing is not only for maintaining the integrity of the data, but it is also a heightened security measure.

PeopleSoft – The information that a trigger records could include the user that made a change, the type of change that is made, when the change is made, and so on.

PeopleSoft Integration Broker Questions

188. PeopleSoft Integration Broker?

A) PeopleSoft Integration Broker facilitates synchronous and asynchronous messaging with other PeopleSoft applications and with third-party systems. PeopleSoft Integration Broker uses a variety of communication protocols, while managing message structure, message content, and transport disparities.

The two major components of PeopleSoft Integration Broker are the integration gateway and the integration engine.

The integration gateway is a platform that manages the receipt and delivery of messages passed among systems through PeopleSoft Integration Broker.

The integration engine is an application server process that routes messages to and from PeopleSoft applications as well as transforms the structure of messages and translates data according to specifications that you define.

PeopleSoft Interview Questions And Answers

189. Upgrade Assistant?

A) To use PeopleSoft Upgrade Assistant, you run a process using an upgrade job and upgrade template.

The upgrade job is a set of filtered steps that are specific to your upgrade and relevant only to the release, platform, and products you are using.

For PeopleSoft supported upgrades, PeopleSoft provides predefined upgrade templates on Customer Connection. These templates comprise the steps necessary to complete an upgrade for a supported upgrade path. Depending on your configuration.

Editing Templates:

– Add steps: You may need to add custom steps to the template—for example, steps for dropping and adding indexes or running a backup of the target database.

– Edit steps: You can modify the delivered settings by changing the step properties. Setting these properties determines the conditions that apply when you run the upgrade process.

– Delete chapters, tasks, or steps.

– Rename chapters, tasks, or steps.

Creating Templates:

– Creating Custom templates: You can create a custom template for your upgrade. When you create a custom template, you also insert chapters, tasks, and steps. In addition, you specify step properties.

– Creating Chapters: You can add a chapter to a new or existing upgrade template. A chapter is a section heading for a group of tasks.

– Creating Tasks: You can add a task to a new or existing upgrade template. A task is a section heading for a group of steps.

– Creating Steps: You can add a step to a new or existing upgrade template. A step can be any process needed to perform the upgrade.

PeopleSoft Upgrade Assistant uses the PROCESSREQUEST component interface object to submit jobs to run on the PeopleSoft Process Scheduler server. You must configure your environment for PeopleSoft Upgrade Assistant to submit processes.

190. Define Workflow?

A) Workflow enables to efficiently automate flow of time-consuming business processes and deliver the right information to the right people at the right time throughout enterprise.

You can merge the activities of multiple users into flexible business processes to increase efficiency, cut costs, and keep up with rapidly changing customer and competitive challenges.

For example, when you order supplies, you are really initiating an approval process: someone else reviews the order and either approves or denies it. If the order is approved, a purchase order is sent to the vendor.

If it is denied, notification is sent back to the person who submitted the original order. The term workflow refers to this larger process.

191. Steps involved in Workflow?

1. Designing a Workflow Application
– Analyze and document business requirements.
– Diagram the process flow.
– Document the workflow object attributes for business processes, activities, steps, events, and email and worklist routings.

2. Build Supporting Definitions

3. Create Workflow Maps
– Create the workflow maps comprising the steps, activities, and business processes required for your workflow as determined in step one.

4. Define Roles and Role Users
– Define the roles and the role users, including any Query roles, required for your workflow.

5. Define Worklist Records
– Create a record definition that will be used to store all of the application-specific information for the worklist.

6. Define the Workflow Objects
– This is the step in which you define the workflow application. You enter each of the objects onto a business process definition in Application Designer as determined in step one.

7. Define Event Triggers
– Define the business rule in PeopleCode on the triggering application record definition. Workflow programs are defined on a record definition for one of the tables that the component accesses. They contain the business rules used to decide whether to trigger the business event. The PeopleCode detects when a business rule has been triggered and determines the appropriate action.

8. Test
– Test your workflow, or use the workflow monitoring tools in Workflow Administrator to validate worklist routing results.

192. Rules, Roles, Routings?

A) – Rules determine which activities are required to process your business data. For example, you might implement a rule that says department managers must approve all requests for external classes.

You implement rules through workflow events, such as PeopleCode that evaluates a condition and triggers a notification (a routing) when appropriate.

– Roles describe how people fit into the workflow. A role is a class of users who perform the same type of work, such as clerks or managers.

Your business rules typically specify which roles do which activities. For example, a rule can say that department managers (a role) must approve external course requests EX: User list roles, Query Roles.

– Routings specify where the information goes and what form it takes: email message or worklist entry. Routings make it possible to deploy applications throughout the enterprise.

They work through the levels and departments of an enterprise to bring together all of the roles that are necessary to complete complex tasks.

PeopleSoft Interview Questions And Answers

193. Events, Workflow Peoplecode, Approvals

A) Events are conditions that have associated routings. Define the condition in PeopleCode, which is attached to the record definition underlying a step in a step map. When a user saves the page, completing the step, the system runs the PeopleCode program to test the condition. If the condition is met, the system performs the routings.

To trigger a business event from a page, you add a PeopleCode program to the workflow event in the record definition for one of the tables to which the page writes.

Approval processes are a common form of business process. The approval steps that you place on the approval rule set map represent the approval levels that are required for the activity.

PeopleSoft Payroll Interview Questions And Answers

194. North American Payroll?

A) Payroll for North America provides the tools to calculate earnings, taxes, and deductions efficiently, maintain balances, and report payroll data.

Payroll for North America supports the following business processes:

– Set Up and Maintain Core Payroll Tables: Core payroll tables are the tables that are required to implement the Payroll for North America application, including organization tables, compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables, general ledger interface, tax tables, retroactive processing, and tip allocation.

– Set Up and Maintain Employee Pay Data: Employee pay data includes personal data, job data, benefits data, federal, state/provincial, and local tax information, general and benefit deductions, additional pay, garnishments, savings bonds, and direct deposits.

– Process the Payroll: basic steps of payroll processing are: create paysheets, pay calculation, pay confirmation, and generate checks and direct deposits. You can employ audit reports and data review pages to verify and correct the results of each step before moving on. You can also review and adjust employee balances.

– Post to General Ledger: Use the integration with PeopleSoft Enterprise General Ledger and EnterpriseOne General Ledger to transfer the expenses and liabilities incurred from a pay run to the General Ledger application.

– Pay Taxes: Use the integration with PeopleSoft Enterprise Payables to transmit tax data to the Payables application for automatic payment to tax authorities.

– Pay Third Parties: Use the integration with Payables to transmit employee and employer deductions such as garnishments and benefit deductions to the Payables application for automatic payment to third parties.

– Produce Reports Payroll for North America provides dozens of reports to help you monitor payroll processing and comply with regulatory and tax reporting requirements. You can view reports online or print hard copies. You can also tailor the reports to fit the special needs of your organization.

195. What are six steps of payroll processing?

A)

– Setting up tables

  • – Setting up employees
  • – Paysheets
  • – Pay calculations
  • – Pay confirmation
  • – Print reports, checks, advices

PeopleSoft Interview Questions And Answers

196. Define the Deduction table?

A)

  • – Defines how the deduction will be processed.
  • – Identifies tax classification (for example, before- or after-tax deductions).
  • – Indicates whether arrears are allowed.
  • – Indicates whether partial deductions are allowed.
  • – Indicates when the deduction is withheld.

197. The Four Steps to Defining Deductions

A) To define how you want the system to process a deduction, follow these four general steps:

Use the Deduction Table component (DEDUCTION_TABLE) to select a plan type, enter a deduction code, and specify the deduction processing rules, including the priority of the deduction, how the deduction affects taxes, related general ledger account codes, and other special payroll process indicators, such as how arrears should be handled.

Use the General Deduction Table component (GENL_DEDUCTION_TBL) to define the rules for the actual calculation of general deductions such as parking or union dues.

Use the Company General Deductions component (GDED_COM_TBL) to build a general deduction plan using the general deductions you have set up.

Use the Benefit Program Table component (BEN_PROG_DEFN) to define the rules for the actual calculation of benefit deductions such as health plans and dental plans.

198. General Questions on Payroll?

A) Paysheets: Before you run payroll calculations, you must create paysheets. Paysheets contain the data required to calculate employee pay for each pay period.

Paycalculation: pay calculation is an iterative process. You can run and rerun calculations repeatedly until you’re confident that the payroll data is correct. Here are the basic steps:

  1.  Enter employee payroll information, create paysheets, and make updates and adjustments for the pay period.
  2.  Run the Pay Calculation COBOL SQL process (PSPPYRUN).
  3.  Review calculation results and check for errors.
  4. Check payroll error messages online or print the Payroll Error Messages report (PAY011).
  5. View the results of paycheck earnings, deductions, and taxes using the Paycheck pages and various standard reports that you can print to verify the results of the pay calculation.
  6.  Make adjustments on the paysheets.
  7.  Repeat these steps until you’re confident that the payroll data is correct, and then confirm pay.

Payconfirmation: After you verify that the payroll calculation is correct and you run the Pay Calculation COBOL SQL process (PSPPYRUN) in final mode, you can run the Pay Confirmation process.

Pay confirmation is the final step in running your payroll. Running the Pay Confirmation process indicates that you’ve reviewed and approved all payroll information for this pay run, and that you’re ready to produce paychecks.

PeopleSoft Interview Questions And Answers

199. Time and Labor?

A) It facilitates the management, planning, reporting, and approving of time, and calendar and schedule creation and usage, from one global web-based application, With this application, you can:

  • – Schedule time.
  • – Report time.
  • – Administer time.
  • – Distribute time.

Time and Labor provides these business processes:

  • – Report time.
  • – Create schedules.
  • – Organize employee groups.
  • – Approve time.
  • – Track compensatory time off.
  • – Manage security.
  • – Manage reported time.
  • – Track task data.
  • – Forecast payable time.
  • – Manage exceptions.
  • – Track attendance.
  • – Process payable time.
  • – Create rules for processing time.
  • – Distribute and dilute labor costs.

Data mapping is the process of integrating data by a method of mapping data between two distinct data models. Data mapping also refers to consolidation of multiple databases into a single database, thereby eliminating redundant data columns in the consolidation process.

Source: Scribd Document

RELATED INTERVIEW QUESTIONS

  1. 200 Blue Prism Interview Questions
  2. Visualforce Interview Questions
  3. Salesforce Interview Questions
  4. 300 SSIS Interview Questions
  5. PHP Interview Questions And Answers
  6. Alteryx Interview Questions
  7. AWS Cloud Support Interview Questions
  8. Google Kubernetes Engine Interview Questions
  9. AWS Devops Interview Questions
  10. Apigee Interview Questions
  11. Actimize Interview Questions
  12. Kibana Interview Questions
  13. Nagios Interview Questions
  14. Jenkins Interview Questions
  15. Chef Interview Questions
  16. Puppet Interview Questions
  17. DB2 Interview Questions
  18. AnthillPro Interview Questions
  19. Angular 2 Interview Questions
  20. Hibernate Interview Questions
  21. ASP.NET Interview Questions
  22. Kubernetes Interview Questions
  23. Docker Interview Questions
  24. CEH Interview Questions
  25. CyberArk Interview Questions
  26. Appian Interview Questions
  27. Drools Interview Questions
  28. Talend Interview Questions
  29. Selenium Interview Questions
  30. Ab Initio Interview Questions