EONC_NOT_USR(SQL Table) |
Index Back |
---|---|
Notification setup tableUsed to store the SQL ID for EONC. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
2 | EOAWLEVEL | Number(1,0) | SMALLINT NOT NULL |
Level e.g. Header = 0, Line = 1.
0=Header 1=Line |
3 | EOAWEVENT | Character(3) | VARCHAR2(3) NOT NULL |
Approval Workflow Events for Notification
A=On Final Approval AD=Ad Hoc Delete AH=Ad Hoc Insert B=Push Back D=On Final Denial E=On Error ES=On Escalate H=Hold Step L=Locked Out NAN=No Approver Necessary PC=Processing Complete PL=On Process Launch R=On Reactivate RA=Route for Approval RI=Request Information RIA=Request Information Added RR=Route for Review RS=On Reassign SC=On Step Complete T=On Terminate W=On Cancel |
4 | EOAWPARTICIPANT | Character(3) | VARCHAR2(3) NOT NULL |
Approval Workflow Events for Notification
A=Approvers D=Dynamic DA=Delegate Approver DR=Delegate Requester E=External PA=Proxy Approver PR=Proxy Requester R=Requester S=Administrator U=User List V=Reviewers |
5 | EOAWUSER_LIST_ID | Character(30) | VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the approval process.
Prompt Table: EOAWUSER_LIST |
6 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE Prompt Table: EOAW_SQLID_VW |
7 | EOAW_SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier
Prompt Table: EOAW_SQLID_VW |