AUC_SSO_HDCN_AT

(SQL View)
 Index Back

SELECT C.BUSINESS_UNIT , C.AUC_ID , C.AUC_ROUND , C.AUC_VERSION , A.CONST_NBR , A.CONST_ATTR_NBR , C.CONSTRAINT_CD , C.AUC_CONST_APPLY , C.CONST_TYPE , C.CONST_OBJECTIVE , C.CONST_PRIORITY , A.CONST_ATTR_BASE , 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_AWARD , A.AWARD_OPERAND , A.AWARD_VAL1 , A.AWARD_VAL2 , A.AWARD_BASIS , A.CONST_APPLY , A.CONST_EXPRESSION FROM PS_AUC_CONSTRAINTS C , PS_AUC_CONST_ATTR A 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 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 CONST_NBR Number(2,0) SMALLINT NOT NULL Constraint Number
6 CONST_ATTR_NBR Number(2,0) SMALLINT NOT NULL Constraint Attribute
7 CONSTRAINT_CD Character(18) VARCHAR2(18) NOT NULL Constraint Code
8 AUC_CONST_APPLY Character(1) VARCHAR2(1) NOT NULL Constraints
A=Apply
I=Ignore

Default Value: A

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

Default Value: E

10 CONST_OBJECTIVE Character(1) VARCHAR2(1) NOT NULL Constraint Objective
M=Mandatory Goal
T=Target Goal
11 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

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_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
14 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
15 BID_FCTR_OPERAND Character(2) VARCHAR2(2) NOT NULL Bid Factor Operand
BT=Between
EQ==
GE=>=
LE=<=
NE=<>
16 BF_VAL_YN Character(1) VARCHAR2(1) NOT NULL Bid Factor Value
N=No
Y=Yes

Y/N Table Edit

17 BF_VAL_DT1 Date(10) DATE Bid Factor Value
18 BF_VAL_DT2 Date(10) DATE Bid Value Date
19 BF_VAL_NBR1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Value
20 BF_VAL_NBR2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Bid Factor Value
21 CONST_AWARD Character(3) VARCHAR2(3) NOT NULL Constraint Award
AMT=Price
QTY=Quantity
22 AWARD_OPERAND Character(2) VARCHAR2(2) NOT NULL Award Operand
BT=Between
GE=>=
LE=<=
23 AWARD_VAL1 Number(15,2) DECIMAL(14,2) NOT NULL Award Value
24 AWARD_VAL2 Number(15,2) DECIMAL(14,2) NOT NULL Award Value
25 AWARD_BASIS Character(1) VARCHAR2(1) NOT NULL Award Basis
A=Amount
P=Percent
26 CONST_APPLY Character(1) VARCHAR2(1) NOT NULL Constraint Apply
A=Across Bidders
B=Per Bidder
27 CONST_EXPRESSION Character(1) VARCHAR2(1) NOT NULL Constraint Expression
A=And
O=Or