PV_SAC_DCSN_VW(SQL View) |
Index Back |
|---|---|
Mass approvals PendingMass approvals Pending Date Initials Reference 07/22/2008 SM F-WYIN-P6X75 AWE required PTAF rename to EOAW. |
| SELECT A.BUSINESS_UNIT , A.REQ_ID , B.EOAWAPPROVER_OPRID FROM PS_PV_AW_ACTION_VW A , PS_EOAW_DECISION B WHERE A.EOAWDEFN_ID = B.EOAWDEFN_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.EOAWDONE_FLAG = 'N' AND A.OPRID = B.EOAWAPPROVER_OPRID |
| # | 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 | APPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver Oprid |