SUPOB_APRSCH_VW

(SQL View)

SELECT DISTINCT A.SETID , A.BIDDER_ID , C.CATEGORY_CD , A.SUP_OB_REG_ID , A.AUC_COMPANY_NAME , B.SUPOB_REG_OPT_TYPE , B.SUP_OB_APR_STATUS , A.CREATE_DTTM , A.LAST_UPDATE_DTTM , B.SUP_INITIATED_BY , E.OPRID FROM PS_AUC_BIDDER_HDR A ,PS_SUP_OB_REG_DEF B , PS_AUC_BID_SLF_CAT C , PS_AUC_BIDDER_XREF D , PS_SOB_AW_ACTN_VW E WHERE A.SETID=B.SETID AND A.SUP_OB_REG_ID=B.SUP_OB_REG_ID AND A.BIDDER_ID=B.BIDDER_ID AND A.SETID=C.SETID AND A.BIDDER_ID=C.BIDDER_ID AND B.SETID=E.SETID AND B.SUP_OB_REG_ID=E.SUP_OB_REG_ID

# 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 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

4 SUP_OB_REG_ID Character(10) VARCHAR2(10) NOT NULL * Registration ID

5 AUC_COMPANY_NAME Character(40) VARCHAR2(40) NOT NULL Company ID - Company Tax ID

6 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

7 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

8 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime

9 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.

10 SUP_INITIATED_BY Character(2) VARCHAR2(2) NOT NULL Ordered by
BU=Buyer
EX=External
IN=Internal

11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	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	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
4	SUP_OB_REG_ID	Character(10)	VARCHAR2(10) NOT NULL	* Registration ID
5	AUC_COMPANY_NAME	Character(40)	VARCHAR2(40) NOT NULL	Company ID - Company Tax ID
6	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
7	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
8	CREATE_DTTM	DateTime(26)	TIMESTAMP	Creation Datetime
9	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.
10	SUP_INITIATED_BY	Character(2)	VARCHAR2(2) NOT NULL	Ordered by BU=Buyer EX=External IN=Internal
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).