{"id":55,"date":"2010-12-02T16:31:55","date_gmt":"2010-12-02T06:31:55","guid":{"rendered":"http:\/\/supportingelement.wordpress.com\/?p=55"},"modified":"2010-12-02T16:31:55","modified_gmt":"2010-12-02T06:31:55","slug":"running-an-element-resolution-chain-on-the-forecasting-process","status":"publish","type":"post","link":"https:\/\/supportingelement.com\/index.php\/2010\/12\/02\/running-an-element-resolution-chain-on-the-forecasting-process\/","title":{"rendered":"Running an Element Resolution Chain on the Forecasting Process"},"content":{"rendered":"

Warning:<\/strong> This is an advanced trick. It is not for the faint hearted and I would definitely not do this in a production environment (i.e. \u201cdon\u2019t try this at home\u2026\u201d).<\/em><\/p>\n

The Element Resolution Chain is an invaluable tool for debugging Global Payroll rules. However, it is not possible to generate an Element Resolution Chain when forecasting\u2026 or is it?<\/p>\n

Here\u2019s a trick learned from the Godfather of PeopleSoft Global Payroll, Hubert Naim. You will need access to App Designer and a stiff drink.<\/p>\n

1. Goto the Field Formula of the “DERIVED_GP > FCST_PB” field.<\/p>\n

\"\"<\/a><\/p>\n

2. Change the “RUN_TRACE_OPTN” from “N” to “A”.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

3. Go and run the forecast process online and \u201chey presto\u201d you have an Element Resolution Chain.<\/p>\n

4. Don\u2019t forget to undo the PeopleCode change when you\u2019re done.<\/p>\n

5. Use the following SQL to view the results:<\/p>\n

SELECT\u00a0A.EMPLID,<\/em>
\n A.EMPL_RCD,<\/em>
\n A.GP_PAYGROUP,<\/em>
\n A.CAL_RUN_ID,<\/em>
\n C.RUN_TYPE,<\/em>
\n A.ORIG_CAL_RUN_ID,<\/em>
\n A.CAL_ID,<\/em>
\n A.RSLT_SEG_NUM,<\/em>
\n B.PIN_NM,<\/em>
\n B.PIN_TYPE,<\/em>
\n A.AUDIT_SORT_KEY,<\/em>
\n A.PIN_CHAIN_SEQ_NUM,<\/em>
\n A.INSTANCE_NUM,<\/em>
\n TO_CHAR(A.SLICE_BGN_DT,’YYYY-MM-DD’),<\/em>
\n TO_CHAR(A.SLICE_END_DT,’YYYY-MM-DD’),<\/em>
\n A.CALC_RSLT_VAL,<\/em>
\n A.CALC_ADJ_VAL,<\/em>
\n A.CALC_RAW_VAL,<\/em>
\n TO_CHAR(A.DATE_PIN_VAL,’YYYY-MM-DD’),<\/em>
\n A.CHR_PIN_VAL<\/em>
\nFROM PS_GP_AUDIT_TBL A,<\/em>
\n PS_GP_PIN B,<\/em>
\n PS_GP_CALENDAR C<\/em>
\n WHERE A.PIN_NUM = B.PIN_NUM<\/em>
\n AND A.GP_PAYGROUP = C.GP_PAYGROUP<\/em>
\n AND A.CAL_ID = C.CAL_ID<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Warning: This is an advanced trick. It is not for the faint hearted and I would definitely not do this in a production environment (i.e. \u201cdon\u2019t try this at home\u2026\u201d). The Element Resolution Chain is an invaluable tool for debugging Global Payroll rules. However, it is not possible to generate an Element Resolution Chain when\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,8,21],"tags":[],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-all-posts","category-global-payroll","category-peoplesoft"],"_links":{"self":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/55","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=55"}],"version-history":[{"count":0,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"wp:attachment":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}