A new workflow custom function called P2K_CF_GET_DAPR_COMMENT was created for use in the workflow products such as WF_AAL, WF_SPA, etc. to look for any approval records that are tied to the subject record being changed and return the comment column.
Currently of the 23 approval areas only 12 have workflow products available. See chart below.
Approval Areas and Workflow Product Cross Reference
Value | Displayed | WF Product | WF Product Description |
---|---|---|---|
01 | Disabled | ||
02 | Pay Trans Batches | WF_PBT | Workflow – Batches |
03 | Pay Header Batches | WF_PBT | Workflow – Batches |
04 | Performance Reviews | WF_SRV | Workflow – Reviews |
05 | Personnel Actions | WF_SPA | Workflow – Personnel Actions |
07 | Job Requisitions | WF_RPO | Workflow – Postings |
08 | Applicant Hires | WF_RAP | Workflow – Applications |
09 | Development Programs | ||
10 | Development Activity | ||
11 | Courses | ||
12 | Class Schedules | ||
13 | Training Resources | ||
14 | Benefit Elections | WF_BEL | Workflow – BE Elections |
15 | Assessments | ||
16 | Class Registration | WF_CRSE | Workflow – Class Registrations |
17 | Time Sheets | WF_PTS | Workflow – Time Sheets |
19 | Leave Lines | WF_AAL | Workflow – Leave Lines |
20 | Clock Entries ((Authorize) | WF_TCE | Workflow – Clock Entries |
21 | Education | ||
22 | References | ||
23 | Work History | ||
24 | Open Enrollment EEs | WF_BOEE | Workflow – Open Enrollment EE |
25 | Positions | ||
26 | Time Sheet Entries (Authorize) |
There could be multiple approval records out there for a subject record at any point in time, so records with the following approval statuses will be bypassed:
- 01 – Approval Cancelled
- 20 – Future Approval
- 80 – Approval Historic
- 95 – Declined Historic
From there we will sort the records by the change date descending to ensure that the most recent change will be the one that triggered this.
Implementation#
1. To use this custom function an entry needs to be made to the X_UC_FUNCTIONS lexicon as below2. When using this custom function the value needs to be returned to a character variable like:
3. A sample Workflow Action may look like this:
4. A sample Workflow Usercalc may look like this:
In the example above, there is a check to see if the PA status has changed before anything is done.
Then in this example, we are only dealing with Declined/Not Approved PA’s so we want to ensure that the status is for that.
The actual custom function is called and the value of the found comment field is returned into the variable dapr_comment created.
If the comment is left blank, an email is not sent. In this case, you may want to have one action line (email content) for when a comment is supplied and a different one for when a comment is not supplied.