DFW_EPRO_WF_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT C.BUSINESS_UNIT , C.REQ_ID , C.LINE_NBR , C.EOAWDEFN_ID , C.EOAWPRCS_ID , C.EOAWTHREAD_ID , D.EOAWREQUESTOR_ID , C.OPRID , A.EOAWUSER_TYPE , A.EOAWSTEP_STATUS , A.DTTM_CREATED , A.EOAWDTTM_MODIFIED , A.EOAWDTTM_COMPLETE FROM PS_EOAW_USERINST A , PS_EOAW_STEPINST B , PS_PV_AW_ACTION_VW C , PS_PV_REQ_AW D WHERE B.EOAWDEFN_ID = C.EOAWDEFN_ID AND B.EOAWPRCS_ID = C.EOAWPRCS_ID AND B.EOAWTHREAD_ID = C.EOAWTHREAD_ID AND A.EOAWSTEP_INSTANCE = B.EOAWSTEP_INSTANCE AND A.EOAWSTEP_STATUS = B.EOAWSTEP_STATUS AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.REQ_ID = D.REQ_ID AND C.LINE_NBR = D.LINE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 5 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 6 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 7 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | EOAWUSER_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Approval Workflow Events for Notification
A=Approver Q=Requester R=Reviewer |
| 10 | 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 |
| 11 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |
| 12 | EOAWDTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |
| 13 | EOAWDTTM_COMPLETE | DateTime(26) | TIMESTAMP | Date/Time Completed |