AUC_SSO_HDCN_BF

(SQL View)
 Index Back

SELECT C.BUSINESS_UNIT , C.AUC_ID , C.AUC_ROUND , C.AUC_VERSION , C.CONSTRAINT_CD , C.AUC_CONST_APPLY , C.CONST_TYPE , C.CONST_OBJECTIVE , C.CONST_PRIORITY , A.CONST_NBR , A.CONST_ATTR_NBR , A.CONST_ATTR_BASE , B.BID_FACTOR_NBR , A.BID_FACTOR_CD , A.BID_FACTOR_TYPE , A.BID_FCTR_OPERAND , A.BF_VAL_YN , A.BF_VAL_DT1 , A.BF_VAL_DT2 , A.BF_VAL_NBR1 , A.BF_VAL_NBR2 , A.CONST_EXPRESSION , B.BIDDER_SETID , B.BIDDER_ID , B.BIDDER_TYPE , B.BIDDER_LOC , B.BIDNUM , B.BID_RESP_QTY , B.BID_RESP_DT , B.BID_RESP_YN FROM PS_AUC_CONSTRAINTS C , PS_AUC_CONST_ATTR A , PS_RESP_HDR_FACTOR B WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.AUC_ID = C.AUC_ID AND A.AUC_ROUND = C.AUC_ROUND AND A.AUC_VERSION = C.AUC_VERSION AND A.CONST_NBR = C.CONST_NBR AND 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 AND A.BID_FACTOR_CD = B.BID_FACTOR_CD AND A.BID_FACTOR_TYPE = B.BID_FACTOR_TYPE AND C.AUC_CONST_APPLY = 'A'

# 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 CONSTRAINT_CD Character(18) VARCHAR2(18) NOT NULL Constraint Code
6 AUC_CONST_APPLY Character(1) VARCHAR2(1) NOT NULL Constraints
A=Apply
I=Ignore

Default Value: A

7 CONST_TYPE Character(1) VARCHAR2(1) NOT NULL Constraint Type
B=Bus Unit
E=Event
G=Global

Default Value: E

8 CONST_OBJECTIVE Character(1) VARCHAR2(1) NOT NULL Constraint Objective
M=Mandatory Goal
T=Target Goal
9 CONST_PRIORITY Character(1) VARCHAR2(1) NOT NULL Constraint Priority
1=1 - Not Important
2=2 - Less Important
3=3 - Important
4=4 - Very Important
5=5 - Critical

Default Value: 3

10 CONST_NBR Number(2,0) SMALLINT NOT NULL Constraint Number
11 CONST_ATTR_NBR Number(2,0) SMALLINT NOT NULL Constraint Attribute
12 CONST_ATTR_BASE Character(3) VARCHAR2(3) NOT NULL Constraint Attribute Base
AMT=Awarded Amount
BFR=Bid Factor
BID=Awarded Bidders
QTY=Awarded Quantity
13 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
14 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
15 BID_FACTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment
C=Monetary
D=Date
L=List
N=Numeric
S=Separator
T=Text
Y=Yes/No
16 BID_FCTR_OPERAND Character(2) VARCHAR2(2) NOT NULL Bid Factor Operand
BT=Between
EQ==
GE=>=
LE=<=
NE=<>
17 BF_VAL_YN Character(1) VARCHAR2(1) NOT NULL Bid Factor Value
N=No
Y=Yes

Y/N Table Edit

18 BF_VAL_DT1 Date(10) DATE Bid Factor Value
19 BF_VAL_DT2 Date(10) DATE Bid Value Date
20 BF_VAL_NBR1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Value
21 BF_VAL_NBR2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Bid Factor Value
22 CONST_EXPRESSION Character(1) VARCHAR2(1) NOT NULL Constraint Expression
A=And
O=Or
23 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
24 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
25 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
26 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
27 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
28 BID_RESP_QTY Number(19,6) DECIMAL(18,6) NOT NULL Bid Response Quantity
29 BID_RESP_DT Date(10) DATE Bid Response Date
30 BID_RESP_YN Character(1) VARCHAR2(1) NOT NULL Bid Response Yes/No
N=No
Y=Yes