RESP_CNTR_HD_VW

(SQL View)
 Index Back

SELECT BUSINESS_UNIT ,AUC_ID ,AUC_ROUND ,AUC_VERSION ,BIDNUM ,BIDDER_SETID ,BIDDER_ID ,BIDDER_TYPE ,BIDDER_LOC ,AUC_FORMAT ,AUC_TYPE ,AUC_NAME ,AUC_STATUS ,AUC_DTTM_PREVIEW ,AUC_DTTM_START ,AUC_DTTM_FINISH FROM PS_RESP_CNTR_LN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
6 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
7 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
8 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
9 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
10 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service
11 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx
12 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
13 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

14 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
15 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
16 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish