SUPOB_S_APPR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT C.setid ,C.bidder_id ,c.SUP_OB_REG_ID , c.auc_company_name , c.supob_reg_opt_type , c.sup_ob_apr_status , c.create_dttm , c.last_update_dttm , b.eoawprcs_id , a.oprid FROM ps_EOAW_WL_OPRVW A ,PS_SUP_OB_APR_XREF B ,PS_SUPOB_APRLST_VW C WHERE A.EOAWPRCS_ID = b.eoawprcs_id AND a.eoawthread_id = b.eoawthread_id AND B.eoawthread_status='P' AND b.setid=C.setid AND b.sup_ob_reg_id= c.sup_ob_reg_id AND c.sup_ob_apr_status='P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | BIDDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 3 | SUP_OB_REG_ID | Character(10) | VARCHAR2(10) NOT NULL | * Registration ID |
| 4 | AUC_COMPANY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Company ID - Company Tax ID |
| 5 | SUPOB_REG_OPT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
On boarding manage invite options
AD=Ad-hoc Tasks NB=Register New Bidders NS=Register New Suppliers NU=Register New User Accounts PC=Profile Change Request RB=Request Change for Bidder RS=Request Supplier Change |
| 6 | SUP_OB_APR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
0=OFAC Checked A=Approved B=Request Editor More Info.. C=Dup supplier checked D=Draft E=Pending Editor Review F=Failed Dup supplier checking I=Request More Information P=Pending Approval R=Rejected W=Withdrawn X=Failed OFAC Checking |
| 7 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |
| 8 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |