AUC_RESP_ALL_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT ,A.AUC_ID ,A.BIDDER_SETID ,A.BIDDER_ID ,A.BIDDER_TYPE ,A.BIDDER_LOC ,B.AUC_FORMAT ,B.AUC_TYPE ,B.AUC_NAME ,B.AUC_STATUS ,B.AUC_DTTM_PREVIEW ,B.AUC_DTTM_START ,B.AUC_DTTM_FINISH FROM PS_RESP_HDR A , PS_AUC_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_A1

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
4 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
5 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
6 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
7 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
8 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
9 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
10 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
A=Awarded
C=Collaborating Event
D=Collaborating Bid Analysis
E=Evaluating
F=RFI Reviewed
I=Pending RFI Review
N=Not Awarded
O=Open
P=Posted
Q=Paused
R=Pending Scheduled Review
S=Pending Post Approval
T=Pending Award
U=Pending Award Approval
W=Post to Third Party Failed
X=Cancelled
Z=Inactive Version

Default Value: O

11 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
12 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
13 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish