AUC_HDR_RND_VW

(SQL View)
 Index Back

Event Rounds


SELECT DISTINCT business_unit , auc_format , auc_type , auc_id , auc_round , auc_name , auc_status FROM PS_AUC_HDR

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

Default Value: AUC_COPY_WRK.BUSINESS_UNIT

Prompt Table: AUC_BU_ASSGN_VW

2 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
F=Sell
I=RFI
R=Buy
S=Service

Default Value: AUC_COPY_WRK.AUC_FORMAT

3 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
E=Auction
S=RFx

Default Value: AUC_COPY_WRK.AUC_TYPE

4 COPY_FROM_EVENT Character(10) VARCHAR2(10) NOT NULL Copy from Event

Default Value: AUC_COPY_WRK.COPY_FROM_EVENT

5 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
6 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
7 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