This page (revision-31) was last changed on 26-Nov-2021 10:22 by jaiken

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
31 26-Nov-2021 10:22 2 KB jaiken to previous
30 26-Nov-2021 10:22 2 KB jaiken to previous | to last
29 26-Nov-2021 10:22 2 KB jaiken to previous | to last
28 26-Nov-2021 10:22 2 KB jaiken to previous | to last
27 26-Nov-2021 10:22 2 KB jaiken to previous | to last
26 26-Nov-2021 10:22 2 KB jaiken to previous | to last
25 26-Nov-2021 10:22 2 KB jaiken to previous | to last
24 26-Nov-2021 10:22 2 KB JMyers to previous | to last
23 26-Nov-2021 10:22 2 KB JMyers to previous | to last
22 26-Nov-2021 10:22 2 KB RForbes to previous | to last
21 26-Nov-2021 10:22 2 KB RForbes to previous | to last

Page References

Incoming links Outgoing links
WORKFLOW PRODUCTS
WORKFLOW PRODUCTS

Version management

Difference between version and

At line 1 changed one line
Currently, workflow triggers have been implemented on the following tables. Also noted here is whether you currently can access the Identity pointed to on an employee's prime assignment
Currently, workflow triggers have been implemented on the following tables. Also noted here is whether you currently can access the Identity pointed to on an Employee's Prime Assignment
At line 3 changed 46 lines
||Product || Table || Access to Employee Supervisor||Clean Link to Department
| [WF_AAL] | P2K_AT_LEAVE_LINES | Yes|Yes
| [WF_BBR] | P2K_BE_BENEFIT_RECIPIENTS | Yes|Yes
| [WF_BEL] | P2K_BE_ELECTIONS | Yes|Yes
| [WF_BOEE] | P2K_BE_OPEN_ENROLLMENT_EES | Yes|Yes
| [WF_BEV] | P2K_BE_EVENTS | Yes|Yes
| [WF_CCCU] | P2K_CP_COMPETENCE_USAGES | Yes|Yes
| [WF_CRSC] | P2K_CP_CLASS_SCHEDULES | N/A|N/A
| [WF_CRSE] | P2K_CP_CLASS_REGISTRATIONS | Yes|Yes
| [WF_DAPR] | P2K_CM_APPROVAL_RECORDS | Yes|N/A
| [WF_DPD] | P2K_CM_POSITION_DETAILS | N/A|Yes
| [WF_EAS] | P2K_HR_ASSIGNMENTS | Yes|Yes
| [WF_EASD] | P2K_HR_ASSIGNMENT_DETAILS | Yes|Yes
| [WF_ECT] | P2K_HR_CONTACTS | N/A|Yes
| [WF_EEM] | P2K_HR_EMPLOYMENTS | Yes|Yes
| [WF_EID] | P2K_HR_IDENTITIES | Yes|Yes
| [WF_EPS] | P2K_HR_PERSONALS | Yes|Yes
| [WF_EST] | P2K_HR_STATISTICS | Yes|Yes
| [WF_HIN] | P2K_SH_INCIDENTS | Yes|Yes
| [WF_LCM] | P2K_LR_COMPLAINTS | Yes|Yes
| [WF_LDA] | P2K_LR_DISCIPLINARY_ACTIVITIES | Yes|Yes
| [WF_LDI] | P2K_LR_DISCIPLINARY_ISSUES | Yes|Yes
| [WF_LGA] | P2K_LR_GRIEVANCE_ACTIVITIES | Yes|Yes
| [WF_LGV] | P2K_LR_GRIEVANCES | Yes|Yes
| [WF_MEX] | P2K_AM_EXECUTIONS | N/A|N/A
| [WF_MRE] | P2K_AM_REQUESTS | N/A|N/A
| [WF_MSO] | P2K_AM_SIGN_OFFS | Yes|Yes
| [WF_PBT] | P2K_PR_BATCHES | N/A|Yes
| [WF_PDS] | P2K_PR_DISBURSEMENTS | Yes|Yes
| [WF_PPRC] | P2K_PR_CDN_PAY_RULES | No|Yes
| [WF_PPRD] | P2K_PR_PAYMENT_RULE_DETAILS | No|Yes
| [WF_PPRU] | P2K_PR_US_PAY_RULES | No|Yes
| [WF_PRN] | P2K_PR_PAY_RUNS | N/A|N/A
| [WF_PTS] | P2K_PR_TIME_SHEETS | Yes|Yes
| [WF_PTSE] | P2K_PR_TIME_SHEET_ENTRIES | Yes|Yes
| [WF_RAP] | P2K_RE_APPLICATIONS | N/A|Yes
| [WF_RASE] | P2K_RE_ASSESSMENT_EVENTS | N/A|N/A
| [WF_RCA] | P2K_RE_CANDIDATES | N/A|N/A
| [WF_RPO] | P2K_RE_POSTINGS | N/A|Yes
| [WF_RQL] | P2K_RE_QUALIFICATIONS | N/A|N/A
| [WF_SPA] | P2K_SA_PERSONNEL_ACTIONS | Yes|Yes
| [WF_SRV] | P2K_SA_REVIEWS | Yes|Yes
| [WF_SRVR] | P2K_SA_REVIEW_RATINGS | Yes|Yes
| [WF_TCE] | P2K_TS_CLOCK_ENTRIES | Yes|Yes
| [WF_TRE] | P2K_TS_WORK_RESTRICTIONS | No|Yes
| [WF_TTX] | P2K_TS_TIME_EXCEPTIONS | Yes|Yes
||Product || Table ||Access to Employee Supervisor
| WF_AAL | [P2K_AT_LEAVE_LINES] | Yes
| WF_BEL | [P2K_BE_ELECTIONS] | Yes
| WF_CCCU | [P2K_CP_COMPETENCE_USAGES] | Yes
| WF_CRSE | [P2K_CP_CLASS_REGISTRATIONS] | Yes
| WF_DAP | [P2K_CM_APPROVAL_LOGS] | No
| WF_DAPR | [P2K_CM_APPROVAL_RECORDS] | No
| WF_EAS | [P2K_HR_ASSIGNMENTS] | Yes
| WF_EASD | [P2K_HR_ASSIGNMENT_DETAILS] | Yes
| WF_EEM | [P2K_HR_EMPLOYMENTS] | Yes
| WF_EID | [P2K_HR_IDENTITIES] | Yes
| WF_EPS | [P2K_HR_PERSONALS] | Yes
| WF_HIN | [P2K_SH_INCIDENTS] | Yes
| WF_LDA | [P2K_LR_DISCIPLINARY_ACTIVITIES] | Yes [1]
| WF_LDI | [P2K_LR_DISCIPLINARY_ISSUES] | Yes
| WF_MEX | [P2K_AM_EXECUTIONS] | No
| WF_MRE | [P2K_AM_REQUESTS] | No [2]
| WF_PPRC | [P2K_PR_CDN_PAY_RULES] | No
| WF_PPRD | [P2K_PR_PAYMENT_RULE_DETAILS] | No
| WF_PPRU | [P2K_PR_US_PAY_RULES] | No
| WF_PTS | [P2K_PR_TIME_SHEETS] | Yes
| WF_RAP | [P2K_RE_APPLICATIONS] | No
| WF_RASE | [P2K_RE_ASSESSMENT_EVENTS] | No
| WF_RCA | [P2K_RE_CANDIDATES] | No
| WF_RPO | [P2K_RE_POSTINGS] | No
| WF_RQL | [P2K_RE_QUALIFICATIONS] | No
| WF_SPA | [P2K_SA_PERSONNEL_ACTIONS] | Yes
| WF_TCE | [P2K_TS_CLOCK_ENTRIES] | Yes
| WF_TRE | [P2K_TS_WORK_RESTRICTIONS] | No
| WF_TTX | [P2K_TS_TIME_EXCEPTIONS] | Yes
At line 50 removed one line
Workflow triggers are initiated when a record is inserted, updated or deleted from the database.
At line 35 added one line
[#1] P2K_LR_DISCIPLINARY_ACTIVITIES uses the Employee linked through the Disciplinary Issue for ALL Employee related information rather than the "Reviewer" of the Activity.
At line 53 changed 3 lines
----
![Notes|Edit:Internal.WORKFLOW+PRODUCTS]
[{InsertPage page='Internal.WORKFLOW+PRODUCTS' default='Click to create a new notes page'}]
[#2] P2K_AM_REQUESTS uses the EID table to access the information on the person the request is coming from and the EID_SUP table to access the information on the person the request is going to.
This page (revision-31) was last changed on 26-Nov-2021 10:22 by jaikenTop