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

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

Workflow triggers are initiated when a record is inserted, updated or deleted from the database.

  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.
  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.