OPRIDA=Approved
B=Pushback
P=Pending Approval
R=Rejected
SUPOB_USR_ADT_V(SQL View) |
Index Back |
|---|
| SELECT A.OPRID ,A.DESCR , A.SUP_USR_APR_STATUS , A.EMAILID , A.CREATE_DTTM , C.NAME1 , C.SETID , C.VENDOR_ID FROM PS_SUP_OB_USR_REG A ,PS_SUP_OB_USR_ATR B ,PS_VENDOR C WHERE A.OPRID=B.OPRID AND B.SUP_OB_VENDOR_ID=C.VENDOR_ID AND C.VENDOR_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SUP_USR_APR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved B=Pushback P=Pending Approval R=Rejected |
| 4 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 5 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |