AUC_CONST_ATTR

#	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	CONST_ATTR_BASE	Character(3)	VARCHAR2(3) NOT NULL	Constraint Attribute Base AMT=Awarded Amount BFR=Bid Factor BID=Awarded Bidders QTY=Awarded Quantity
8	BID_FACTOR_CD	Character(18)	VARCHAR2(18) NOT NULL	Bid Factor Code Prompt Table: BID_FCTR_CNS_VW
9	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
10	BID_FCTR_OPERAND	Character(2)	VARCHAR2(2) NOT NULL	Bid Factor Operand BT=Between EQ== GE=>= LE=<= NE=<>
11	BF_VAL_YN	Character(1)	VARCHAR2(1) NOT NULL	Bid Factor Value N=No Y=Yes
12	BF_VAL_DT1	Date(10)	DATE	Bid Factor Value
13	BF_VAL_DT2	Date(10)	DATE	Bid Value Date
14	BF_VAL_NBR1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Value
15	BF_VAL_NBR2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bid Factor Value
16	CONST_AWARD	Character(3)	VARCHAR2(3) NOT NULL	Constraint Award AMT=Price QTY=Quantity
17	AWARD_OPERAND	Character(2)	VARCHAR2(2) NOT NULL	Award Operand BT=Between GE=>= LE=<=
18	AWARD_VAL1	Number(15,2)	DECIMAL(14,2) NOT NULL	Award Value
19	AWARD_VAL2	Number(15,2)	DECIMAL(14,2) NOT NULL	Award Value
20	AWARD_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Award Basis A=Amount P=Percent
21	CONST_APPLY	Character(1)	VARCHAR2(1) NOT NULL	Constraint Apply A=Across Bidders B=Per Bidder
22	CONST_EXPRESSION	Character(1)	VARCHAR2(1) NOT NULL	Constraint Expression A=And O=Or