EOAW_ADT_USRINS(SQL View) |
Index Back |
|---|---|
AWE Audit ReportUsed to collect and display User Instance level information in the AWE Audit report gnerated by XMLP. Note: PTAFDTTM_COMPLETE isnt populated for header level transactions so we use PTAFDTTM_MODIFIED in the COMPLETE field to simulate the the timestamp of the participants action |
| SELECT A.EOAWPRCS_ID , A.EOAWDEFN_ID , A.EOAWTHREAD_ID , A.EOAWSTAGE_NBR , A.EOAWPATH_ID , A.EOAWSTEP_NBR , B.EOAWSTEP_INSTANCE , B.EOAWUSTEP_INST_ID , B.EOAWUSER_TYPE , C.XLATLONGNAME , B.OPRID , B.EOAWORIG_OPRID , B.EOAWSTEP_STATUS , D.XLATLONGNAME , B.DTTM_CREATED , B.EOAWDTTM_MODIFIED , B.EOAWDTTM_MODIFIED FROM PS_EOAW_STEPINST A , PS_EOAW_USERINST B , PSXLATITEM C , PSXLATITEM D WHERE B.EOAWSTEP_INSTANCE = A.EOAWSTEP_INSTANCE AND C.FIELDNAME = 'EOAWUSER_TYPE' AND C.FIELDVALUE = B.EOAWUSER_TYPE AND %EffdtCheck(PSXLATITEM,C,%CURRENTDATEIN) AND D.FIELDNAME = 'EOAWSTEP_STATUS' AND D.FIELDVALUE = B.EOAWSTEP_STATUS AND %EffdtCheck(PSXLATITEM,D,%CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOAWPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 2 | EOAWDEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 3 | EOAWTHREAD_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 4 | EOAWSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Approval Framework Stage Number |
| 5 | EOAWPATH_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Path ID |
| 6 | EOAWSTEP_NBR |
Number(6,2) | DECIMAL(5,2) NOT NULL | Sequence number of step in its path |
| 7 | EOAWSTEP_INSTANCE |
Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
| 8 | EOAWUSTEP_INST_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
| 9 | EOAWUSER_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Approval Workflow Events for Notification
A=Approver Q=Requester R=Reviewer |
| 10 | EOAWUSERTYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | User Type Description |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 12 | EOAWORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 13 | EOAWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial |
| 14 | EOAWSTEPSTAT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Step Status Description |
| 15 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |
| 16 | EOAWDTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |
| 17 | EOAWDTTM_COMPLETE | DateTime(26) | TIMESTAMP | Date/Time Completed |