CONSTRAINT_ATTR

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