By taking the PeopleSoft Human Resource Management System (HRMS)  functional training from Tekslate, you”ll be able to develop skills required to manage global employees on a single intelligent system. In this course, you”ll learn how to setup administration, methods to use HCM applications to manage talent for your global workforce, benefits, and payroll, etc. Our curriculum is designed by industry experts based on real-time scenarios.

Key Features

  • 30 hours of Instructor Led PeopleSoft HRMS Functional Training
  • Lifetime Access to Recorded Sessions
  • Practical Approach
  • 24/7 Support
  • Expert & Certified Trainers
  • Real World use cases and Scenarios
Trusted By Companies Worldwide

Course Overview

By the end of the PeopleSoft Human Resource Management System functional training, you will be able to:

  • Set up core foundation tables related to table set sharing and business units
  • Set up core foundation tables related to compensation

  • Set up core foundation tables related to locations, establishments, and departments

  • Add people in the PeopleSoft System

  • Maintain person and job data

  • Describe the human resource foundation table sequence

  • Define PeopleSoft enterprise HRMS products and business processes

  • There is a huge requirement for skilled PeopleSoft Human resource managers around the globe.

  • Top multinational companies are hiring certified PeopleSoft Human resource managers worldwide.

  • The average salary of a certified PeopleSoft Human resource manager is around $80,075 USD per annum.

  • Candidates working as functional implementers

  • System analysts

  • Report developers

  • Aspirants who are willing to build their career in the administrative field.

The following are the prerequisites for learning PeopleSoft HRMS functional course:

  • basic knowledge of tables.

The following job roles will get benefited by taking up this course:

  • System analysts

  • Report developers

The tutor will take care of handling the projects. We will provide two real-time projects with a highly-skilled guide who can assist you throughout the project.

Course Curriculum

  • Dissecting a PeopleSoft Table
  • Using the Application Designer to find Table Definitions

    • Querying Tables

    • Cross-Referencing Fields

    • Cross-Referencing Panels and Tables

  • PeopleSoft Processes

  • The core tables

  • Types of tables

    • PS_PERSONAL_DATA, PS_JOB (Base Table)

    • PS_EARNINGS_TBL (Control Table)

    • PS_BENEFITS_VW (Views)

    • PS_EMPLOYEES (Reporting Tables)

    • PS_TREENODE (Application Tables)

    • SUB-RECORDS (Non-Tables)

  • Effective dating

    • Concepts Underlying Effective Dating

    • Basic Effective Date Sub-Query

    • Additional Criteria with a Sub-Query

  • Understanding Control Tables

    • Structure of a Control Tables

    • Adding a Control Table to a Query

    • Using Effective Status

  • Reporting tables

    • Reporting Tables Overview

    • The Employee Table

    • Benefits Plan data table

    • Benefits Personal Data Table

    • Enrollments

  • Personal Information
    • Compensation History

    • Status

      • Employee Status Field

      • The Status Date

      • Long Term Disability Issue

    • The Job Tables

      • Identifying Jobs On PS_JOB

      • Storing History: Effective Sequence

        • Tracking Actions

      • Actions and Action Reasons

      • Linking Employees to Common Data

      • Human Resource Settings

      • Payroll Settings

        • Company and Paygroup

        • Tracking Hourly Employees and FTE

        • Other Payroll Identifiers

        • Compensations

      • Benefit Settings

        • Benefits Status

        • Benefits Base Rate

        • Custom Fields

        • FLSA Status

    • Personal Data for Other Countries

    • Citizenship Status

    • Referrals

    • Educational Status

    • Birth Information

    • Original Hire Date

    • Non-Employees on Personal Data

    • Resident Address and Phone

    • PeopleSoft Name Format

    • Identifying Employees

    • Personal Data

    • Understanding Effective Dated Personal Data

      • Name Differences

    • Using Social Security Numbers

      • The NID Table and Identifiers

      • National Ids

      • Querying the National ID

  • Position/Job History
  • Corporate Hierarchy
  • Employment Information
    • Background Information

    • Position Management Fields

    • Payroll Settings

    • Benefits administration flag


  • Working with Payroll
    • Batch Processing Payroll Data

    • The Payroll Process

      • Paysheets

      • Payroll Calculations

      • Payroll Confirmation

      • Identifying Payroll Process Achievements

    • General Ledger

    • Looking at a Specific Payroll Run

      • Paycheck table with Payroll Queries

      • Payroll Keys

      • Current Payroll

      • Pay Run Id

      • Payroll Dates

      • Multiple Jobs

      • Taking Deductions

    • Payroll Tables

    • The Paycheck

      • How are Paychecks Created

      • The Paycheck tables

        • Payroll keys

        • Alternate Keys

        • Paycheck Accounting

      • Different Kinds of Paychecks

    • Earnings

      • Defining Earnings

        • Earn Codes

        • Defining an Earnings

      • Retrieving Earnings for an Employee

        • Pay Earnings Table

      • Feeding PeopleSoft

    • Deductions

      • Getting to know Deductions

        • Deduction Code and Class

        • Defining Deduction

      • Enrolling Employees In Deductions

        • General Deductions Tables

        • Verifying Eligibility

      • Retrieving Deductions

        • The Pay Deduction Table

    • Taxes

      • Tax Location

        • State and Locality

        • The Other States

        • Tax Location Code

      • Defining A Tax

        • Local Taxes

        • State and Federal Taxes

        • Tax Types/Rates

      • Employee Tax Elections

        • Special Withholding/Allowances

        • FICA and EIC

        • W-2 Settings

        • State Settings

        • Local Settings

      • Retrieving Taxes

    • Garnishments

      • Setting up Garnishments

        • Employee Garnishment Specifications

      • Retrieving Garnishments

        • The Pay Garnish table

      • An Accounts Payable Interface

    • Year End Processing

      • The W-2 Design

        • W-2 Parameters

        • Adding Data Using Delivered Reports

        • Multiple W-2s

      • Using W-2 Tables


  • Navigating Benefits
  • Introductions To Benefits
  • Understanding Benefits Administration

Basic Benefits Terminology

  • Benefit Plans and Plan Type
  • Benefit Program Costs

  • Specifying Benefit Plan Settings

  • Linking Plans

  • Defining Plan and Plan Type Setting for a Program

  • Defining a Benefit Program

  • Benefits Program

Benefits Control Tables

  • Base Benefits Control Tables
  • Benefits Administration Control Tables

The Benefits Administration Process

  • BAS Activity / Manual Entry
  • On-Demand Event Maintenance

Tracking PeopleSoft Benefits

  • Benefits Interfaces
  • Benefits Reports

Health and life plan Elections

  • Elections
  • Dates
  • Determining the Current Enrollments
  • Locating a Terminations
  • Life Plans

Dependents And Beneficiaries

  • How are Dependents and Beneficiaries Stored
  • Locating all dependents for a Participant
  • Determining Dependent Coverage


  • Rate tables
  • Calculation rates



PeopleSoft Query

  • Query Basics
  • Advanced Query Topics

Using SQR with PeopleSoft

  • Why SQR
  • Using SQR with PeopleSoft
  • Types Of SQR
  • Basic SQR Nested Query
  • Understanding Delivered SQR Programs
  • Understanding PeopleSoft Security Architecture
  • Security Administration
  • Application Security
  • Reporting Security PS Query/ PS n-Vision
  • Batch Process Security
  • Developer Security
  • Security In The Implementation Cycle
  • Security Design
  • Understanding PeopleCode and Events
  • PeopleCode and PeopleSoft Internet Architecture
  • PeopleCode and Component Processor
  • Using Methods and Built-In Functions
  • Understanding Objects and Classes in PeopleCode
  • PeopleCode Language
  • Using PeopleCode Editor


  • Relational Database Basics In PeopleSoft
  • Data Validation
  • PeopleSoft Application Design
    • Review Create An Application

    • Test the Application

    • Enable the Menu Security

    • Create the Menu Definition

    • Define the Component

    • Create the Page Definition

    • Build the SQL Table

    • Create the Record Definition

    • Define New Fields

    • Designing the Application


Our trainers are well experienced professionals and certified in working with front-end development technologies.

We will record all the Live sessions you go through, and we will send the recording of the class you missed.

For practical execution, our trainer will provide server access to the student. 

All our training classes are live. This is to solve all the student queries directly with the trainer.

Live online training means, our trainer will be in online with you to solve your issues.
Pre-recorded training means, there will be no trainer available to solve your issues.

You can contact our Tekslate support team, or you can send an email to info@tekslate.com for your queries.

Yes, you can access the course material after completing course by the recorded training videos we shared with you during training.

To avail all discounts offered by Tekslate, you need to visit the website regularly. However, there will be a group discount for 2 or more participants.

Yes, you will get your refund by cancelling some administration fee from the course. But, you should cancel your enrolment within 48 hours of registration, and then the refund will be retained within 30 days of a request.


Certification is a matter of demonstrating your skills and establishing your credibility. Having a PeopleSoft HRMS functional Certification proves that the candidate has a strong foundation and expertise in implementing asset management techniques using PeopleSoft HRMS functional, and also helps to land in a better job in your career.

Tekslate will provide you with a course completion certificate after you complete the course. After the course completion, you will be in a position to clear the certification exam conducted by Oracle with ease. We advise you to take up the following certification exam.

  • PeopleSoft 9.2 Human Resources Certified Implementation Specialist

Click here to get certified.