BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//JSMPROS - ECPv6.16.5//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/Chicago
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20240310T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20241103T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20250309T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20251102T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20260308T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20261101T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20250805T090000
DTEND;TZID=America/Chicago:20250806T170000
DTSTAMP:20250226T231933Z
CREATED:20250226T231419Z
LAST-MODIFIED:20250226T231933Z
UID:10000341-1754384400-1754499600@www.jsmpros.com
SUMMARY:PeopleSoft Query 1
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 1\n\n\n\n\n\nEnroll
URL:https://www.jsmpros.com/event/q1-202508/
CATEGORIES:Functional,Technical,Training
ATTACH;FMTTYPE=image/jpeg:https://www.jsmpros.com/wp-content/uploads/2021/06/Query-1-OpenGraph-1.jpg
END:VEVENT
END:VCALENDAR