AUC_RESP_HDR_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.AUC_BID_STATUS , A.RESP_DTTM_FIRST , A.RESP_DTTM_SAVE , A.RESP_DTTM_POST , A.OPRID_ENTERED_BY , A.OPRID_LAST_UPDT , COUNT(*) FROM PS_RESP_HDR A , PS_RESP_LN B WHERE A.AUC_ID = B.AUC_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.BIDNUM = B.BIDNUM AND A.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID AND A.BIDDER_TYPE = B.BIDDER_TYPE AND A.BIDDER_LOC = B.BIDDER_LOC AND A.AUC_BID_STATUS = 'P' GROUP BY A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND, A.AUC_VERSION, A.BIDNUM , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.AUC_BID_STATUS , A.RESP_DTTM_FIRST , A.RESP_DTTM_SAVE , A.RESP_DTTM_POST , A.OPRID_ENTERED_BY , A.OPRID_LAST_UPDT

# 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

Default Value: 1

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

Default Value: 1

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_BID_STATUS Character(1) VARCHAR2(1) NOT NULL Bid Status
D=Disqualified
P=Posted
S=Saved
W=Disallowed
X=Cancelled
11 RESP_DTTM_FIRST DateTime(26) TIMESTAMP First Entry Date Time
12 RESP_DTTM_SAVE DateTime(26) TIMESTAMP Date Time Last Saved
13 RESP_DTTM_POST DateTime(26) TIMESTAMP Response Date Time
14 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
15 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update
16 AUC_NUM_LINES Number(6,0) INTEGER NOT NULL Number of Lines