SOB_AW_ACTN_VW(SQL View) |
Index Back |
|---|---|
Approval ViewApproval Action View Date Initials Reference 07/22/2008 SM F-WYIN-P6X75 AWE required PTAF rename to EOAW. |
| SELECT A.EOAWDEFN_ID , A.EOAWPRCS_ID , A.EOAWTHREAD_ID , A.EOAWPARENT_THREAD , C.OPRID , A.EOAWTHREAD_STATUS , C.EOAWSTEP_STATUS , C.DTTM_CREATED , A.SETID , A.SUP_OB_REG_ID FROM PS_SUP_OB_APR_XREF A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C WHERE A.EOAWDEFN_ID = B.EOAWDEFN_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE AND C.EOAWSTEP_STATUS <> 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 2 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 3 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 4 | EOAWPARENT_THREAD | Number(15,0) | DECIMAL(15) NOT NULL | Parent Thread ID |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | EOAWTHREAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Thread Status
A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial |
| 7 | 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 |
| 8 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |
| 9 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 10 | SUP_OB_REG_ID | Character(10) | VARCHAR2(10) NOT NULL | * Registration ID |