{"id":522,"date":"2014-08-08T15:03:37","date_gmt":"2014-08-08T20:03:37","guid":{"rendered":"https:\/\/www.wisconsin.edu\/sfs\/?page_id=522"},"modified":"2020-10-21T10:45:29","modified_gmt":"2020-10-21T15:45:29","slug":"ps-query","status":"publish","type":"page","link":"https:\/\/www.wisconsin.edu\/sfs\/reporting\/ps-query\/","title":{"rendered":"PS Query"},"content":{"rendered":"\n\t\t\t\t\t<div id=\"cfct-build-522\" class=\"cfct-build grid\">\n\t\t\t\t\t\t<div class=\"row\"><div class=\"col-md-12 cfct-block\">\n\t\t\t<div class=\"cfct-module uwsa-rich-text\">\n\t\t\t\t<div class=\"cfct-mod-content copy\"><p>PeopleSoft Query (PS Query) is a delivered reporting tool inside of SFS that allows users the appropriate access to build or run their own queries against real-time data in SFS.<\/p>\n<\/div>\n\t\t\t<\/div><\/div><\/div><div class=\"row\"><div class=\"col-md-6 cfct-block\">\n\t\t\t<div class=\"cfct-module uwsa-doc-list\">\n\t\t\t\t<h2>Training Materials and Resources<\/h2>\n\n<div class=\"doc-list\">\r\n<ul class=\"list-unstyled\"><li><span class=\"doc-icon\"><a class=\"doc-type xlsx\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/TableListingForQueryUse.xlsx\" target=\"_blank\">Frequently Used Tables\/Records<span class=\"sr-only\"> xlsx<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/Query-Manager.pdf\" target=\"_blank\">How to Use Query Manager<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/PS-Query-Viewer-.pdf\" target=\"_blank\">RPT.1.02.01 PeopleSoft-Query-Viewer<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/Query-Basics(2).pdf\" target=\"_blank\">RPT.1.02.02 \u2013 Basic PeopleSoft Query<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/PS-Query-Intermediate-Skills-.pdf\" target=\"_blank\">RPT.1.02.03 \u2013 Intermediate PeopleSoft Query<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/RPT.1.02.04-\u2013-Advanced-PeopleSoft-Query-for-Developers.pdf\" target=\"_blank\">RPT.1.02.04 \u2013 Advanced PeopleSoft Query For Developers<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/RPT.1.02.05--Advanced-PeopleSoft-Query-----Creating-Hyperlinked-Query-Drills.pdf\" target=\"_blank\">RPT.1.02.05- Advanced PeopleSoft Query: Creating Hyperlinked Query Drills<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<li><span class=\"doc-icon\"><a class=\"doc-type pdf\" href=\"https:\/\/www.wisconsin.edu\/sfs\/download\/reporting\/query\/Scheduling-Queries-And-NVision-Reports.pdf\" target=\"_blank\">Scheduling Queries And NVision Reports<span class=\"sr-only\"> pdf<\/span><\/a><\/span><\/li>\r\n<\/div>\n\t\t\t<\/div><\/div><div class=\"col-md-6 cfct-block\">\n\t\t\t<div class=\"cfct-module cfct-module-image\">\n\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"896\" height=\"591\" src=\"https:\/\/www.wisconsin.edu\/sfs\/wp-content\/uploads\/sites\/40\/2015\/05\/psquery.jpg\" class=\"cfct-mod-image cfct-module-image-mod-image\" alt=\"PS Query\" srcset=\"https:\/\/www.wisconsin.edu\/sfs\/wp-content\/uploads\/sites\/40\/2015\/05\/psquery.jpg 896w, https:\/\/www.wisconsin.edu\/sfs\/wp-content\/uploads\/sites\/40\/2015\/05\/psquery-300x198.jpg 300w\" sizes=\"auto, (max-width: 896px) 100vw, 896px\" \/>\n\t\t\t<\/div><\/div><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t","protected":false},"excerpt":{"rendered":"","protected":false},"author":18,"featured_media":0,"parent":363,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-522","page","type-page","status-publish","hentry","cfct-can-haz-build"],"_links":{"self":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/comments?post=522"}],"version-history":[{"count":5,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/522\/revisions"}],"predecessor-version":[{"id":9658,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/522\/revisions\/9658"}],"up":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/pages\/363"}],"wp:attachment":[{"href":"https:\/\/www.wisconsin.edu\/sfs\/wp-json\/wp\/v2\/media?parent=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}