SUPOB_U_APPR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT d.sup_ob_vendor_id , c.sup_usr_apr_status ,c.descr ,c.emailid , a.oprid , c.oprid ,c.create_dttm FROM ps_EOAW_WL_OPRVW A , ps_sup_ob_usr_XREF B ,PS_SUP_OB_USR_REG C ,PS_SUP_OB_USR_ATR D WHERE a.EOAWPRCS_ID = b.eoawprcs_id AND a.eoawthread_id = b.eoawthread_id AND b.eoawthread_status='P' AND b.oprid=c.oprid AND c.oprid=d.oprid AND c.sup_usr_apr_status ='P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 2 | SUP_USR_APR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved B=Pushback P=Pending Approval R=Rejected |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 7 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |