Len Krukowski

Table of Contents: (click on "SHOW MORE" and click on the time links to advance to that topic)

Query Basics

What is a query? @0:19

How is data stored? @0:42

A Query @2:35

Create & Run the query @3:20

PeopleSoft Queries @3:49

What is PeopleSoft query @4:05

PeopleSoft Query Structure @5:24

Database Elements: Records @6:31

Database Elements: Fields @7:49

Database Elements: Row @9:02

Database Elements: Keys @9:26

Joining Records @10:15

Joining: without using a key @11:25

Joining: using a key field @11:55

Join: Table Relationships @12:27

Join: Hierarchical & Related Record Relationship @13:08

Query Properties: Criterion @13:56

Effective-Dated Tables @14:54

Using Prompts in queries @16:50

PeopleSoft Security @17:28

PeopleSoft Query Options @18:55