{"id":54,"date":"2011-09-01T16:31:38","date_gmt":"2011-09-01T06:31:38","guid":{"rendered":"http:\/\/supportingelement.wordpress.com\/?p=54"},"modified":"2011-09-01T16:31:38","modified_gmt":"2011-09-01T06:31:38","slug":"calendar-view-ps_sch_clnd_vw","status":"publish","type":"post","link":"https:\/\/supportingelement.com\/index.php\/2011\/09\/01\/calendar-view-ps_sch_clnd_vw\/","title":{"rendered":"Calendar View: PS_SCH_CLND_VW"},"content":{"rendered":"

The \u201cPS_SCH_CLND_VW\u201d view shows Schedule Details by calendar day, including Shift ID, Workday day and Scheduled Hours.<\/p>\n

This is very useful for Arrays that require schedule details. \u00a0It is equally useful for analysis of payroll\/absence results (e.g. Forecasting validation)<\/p>\n

The following SQL shows an example of its use:<\/p>\n\n\n\n
SELECT DUR,<\/p>\n

SCHED_HRS<\/p>\n

FROM PS_SCH_CLND_VW<\/p>\n

WHERE SCHEDULE_ID = \u2018KA8HRDAY\u2019<\/p>\n

AND DUR >= \u201801-SEP-2011\u2019<\/p>\n

AND DUR <= \u201930-SEP-2011\u2019<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Update, 2 Nov 2017: The “PS_TL_DATES_TBL” is also useful to derive schedule related information.<\/p>\n","protected":false},"excerpt":{"rendered":"

The \u201cPS_SCH_CLND_VW\u201d view shows Schedule Details by calendar day, including Shift ID, Workday day and Scheduled Hours. This is very useful for Arrays that require schedule details. \u00a0It is equally useful for analysis of payroll\/absence results (e.g. Forecasting validation) The following SQL shows an example of its use: SELECT DUR, SCHED_HRS FROM PS_SCH_CLND_VW WHERE SCHEDULE_ID\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,1],"tags":[25,29,33,35],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-all-posts","category-uncategorized","tag-calendar","tag-peoplesoft","tag-schedule","tag-view"],"_links":{"self":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":0,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"wp:attachment":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}