BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//JSMPROS - ECPv6.18.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:JSMPROS
X-ORIGINAL-URL:https://www.jsmpros.com
X-WR-CALDESC:Events for JSMPROS
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Los_Angeles
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20250309T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20251102T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20260308T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20261101T090000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20270314T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20271107T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20260520T080000
DTEND;TZID=America/Los_Angeles:20260521T160000
DTSTAMP:20260427T134823Z
CREATED:20260427T134657Z
LAST-MODIFIED:20260427T134823Z
UID:10000392-1779264000-1779379200@www.jsmpros.com
SUMMARY:PeopleSoft Query 1 (Campus Solutions)
DESCRIPTION:Learn PeopleSoft QuerySQL basicsQuery ManagerSelecting dataFiltering dataPromptsJoinsAggregate functions\n\n\n\n\n\nEnroll\n\n\n\n\n\n\n\n\n\nPeopleSoft Query is more than just an ad-hoc reporting tool. PeopleSoft Query is a foundational development tool for search indexes\, integration points\, security role rules\, reports\, pivot grids\, user lists\, and much more! \n\n\n\nPeopleSoft Query 1 is part one of our two-part Query series and includes the following topics: \n\n\n\nIntroduction to QueryCreating queriesModifying queriesSelecting fieldsDuplicate rowsFiltering results with criteriaGrouping criteriaEffective datingRuntime promptsMulti-table queriesAggregate functionsFinding your data\n\n\n\nOur PeopleTools expert\, Jim Marion\, facilitates this two-day training course. We provide comprehensive activity guides and access to training servers. \n\n\n\n\n\nWho Should Attend\n\n\n\nFunctional Business AnalystsDevelopers\n\n\n\n\n\nOn-Demand\n\n\n\nPrefer to learn at your own pace? Get this same training on demand! \n\n\n\nQuery 1All-access Pass\n\n\n\n\n\nEnroll
URL:https://www.jsmpros.com/event/q1-202605/
LOCATION:Live Virtual
CATEGORIES:Functional,Technical,Training
ATTACH;FMTTYPE=image/jpeg:https://www.jsmpros.com/wp-content/uploads/2021/06/Query-1-OpenGraph-2.jpg
END:VEVENT
END:VCALENDAR