PeopleSoft Query 2: Intermediate Query HCM
Current Status
Not Enrolled
Price
$2,354.00
Get Started
This course is currently closed
Advanced Query Topics
Adhoc analysis, data sources, and reporting
- Manual joins
- Expressions
- Subqueries
- Outer joins
- Unions
- Connected queries
- Composite query
- Pivot Grids
- Security
PeopleSoft Query is the data source for many PeopleTools features, such as Pivot Grids, BI Publisher, and Elastic Search
Live-Virtual
Two days
$2,354 USD
Topics Covered
- Automatic joins
- Manual joins
- Expressions
- Criteria expressions
- Prompts in expressions
- Aggregates in expressions
- Concatenation expressions
- Drilling URLs
- List-of-values subqueries
- Exists subqueries
- Outer joins
- Unions
- Connected queries
- Composite queries
- Pivot grids
- Query security trees
Who Should Attend?
- Functional analysts
- Functional users
- PeopleSoft Developers
- Administrators
Recommended Prerequisites
Course Content
Lesson Content
0% Complete
0/3 Steps
Lesson Content
0% Complete
0/11 Steps
Lesson Content
0% Complete
0/15 Steps
Lesson Content
0% Complete
0/4 Steps
Lesson Content
0% Complete
0/6 Steps
Lesson Content
0% Complete
0/6 Steps
Lesson Content
0% Complete
0/12 Steps
Lesson Content
0% Complete
0/1 Steps