AUC_BIDR_HDR_VW (SQL View)	Index Back
Strat Sourcing Bidder Header Used to store Strat Sourcing Bidder Header info

AUC_BIDR_HDR_VW

(SQL View)

Strat Sourcing Bidder Header

Used to store Strat Sourcing Bidder Header info

SELECT A.SETID , A.BIDDER_ID , A.SUP_OB_REG_ID , A.EFF_STATUS , A.APPROVAL_STATUS , A.REASON_CD , A.EMAIL_FLG , A.EMAILID , A.BID_CONTACT_TYPE , A.AUC_COMPANY_NAME , A.ADDL_COMP_LBL , A.URL , A.MAIN_ADDR_SEQ_NUM , A.BILL_ADDR_SEQ_NUM , A.SHIP_ADDR_SEQ_NUM , A.INV_ADDR_SEQ_NUM , A.CREATEOPRID , A.CREATE_DTTM , A.LASTUPDOPRID , A.LAST_UPDATE_DTTM FROM PS_AUC_BIDDER_HDR A ,PS_SUP_OB_REG_DEF B WHERE A.SETID = B.SETID AND A.BIDDER_ID=B.BIDDER_ID AND B.SUPOB_REG_OPT_TYPE='NB' UNION SELECT A.SETID , A.BIDDER_ID , A.SUP_OB_REG_ID , A.EFF_STATUS , A.APPROVAL_STATUS , A.REASON_CD , A.EMAIL_FLG , A.EMAILID , A.BID_CONTACT_TYPE , A.AUC_COMPANY_NAME , A.ADDL_COMP_LBL , A.URL , A.MAIN_ADDR_SEQ_NUM , A.BILL_ADDR_SEQ_NUM , A.SHIP_ADDR_SEQ_NUM , A.INV_ADDR_SEQ_NUM , A.CREATEOPRID , A.CREATE_DTTM , A.LASTUPDOPRID , A.LAST_UPDATE_DTTM FROM ps_auc_bidder_hdr a WHERE 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 SUP_OB_REG_ID Character(10) VARCHAR2(10) NOT NULL * Registration ID

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
D=Denied
E=Sent Back for Revision
H=On Hold
I=Initial
M=Resubmitted
P=In Process
R=Rerouted
S=Submitted

6 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

7 EMAIL_FLG Character(1) VARCHAR2(1) NOT NULL When the email flag is checked, the user will notified a specific user regarding an activity.
N=No
Y=Yes

8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

9 BID_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Business
I=Individual

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

11 ADDL_COMP_LBL Character(40) VARCHAR2(40) NOT NULL Additional Name

12 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

13 MAIN_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

14 BILL_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

15 SHIP_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

16 INV_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

17 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

18 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime

19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

#	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	APPROVAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved D=Denied E=Sent Back for Revision H=On Hold I=Initial M=Resubmitted P=In Process R=Rerouted S=Submitted
6	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
7	EMAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	When the email flag is checked, the user will notified a specific user regarding an activity. N=No Y=Yes
8	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
9	BID_CONTACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Business I=Individual
10	AUC_COMPANY_NAME	Character(40)	VARCHAR2(40) NOT NULL	Company ID - Company Tax ID
11	ADDL_COMP_LBL	Character(40)	VARCHAR2(40) NOT NULL	Additional Name
12	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
13	MAIN_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
14	BILL_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
15	SHIP_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
16	INV_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
17	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
18	CREATE_DTTM	DateTime(26)	TIMESTAMP	Creation Datetime
19	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	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.