AUC_OPT_LN_CS1

(SQL Table)
 Index Back

Line Const Attributes at Opt

Stores off the Line Constraint Attributes for the event at the time Optimization was ran.

  • Parent record: AUC_OPT_LN_CST

    • # 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 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
    6 AUC_OPT_RUN_ID Number(3,0) SMALLINT NOT NULL Optimization Run ID
    7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    8 CONST_NBR Number(2,0) SMALLINT NOT NULL Constraint Number
    9 CONST_ATTR_NBR Number(2,0) SMALLINT NOT NULL Constraint Attribute
    10 CONST_ATTR_BASE Character(3) VARCHAR2(3) NOT NULL Constraint Attribute Base
    AMT=Awarded Amount
    BFR=Bid Factor
    BID=Awarded Bidders
    QTY=Awarded Quantity
    11 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code
    12 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
    13 BID_FCTR_OPERAND Character(2) VARCHAR2(2) NOT NULL Bid Factor Operand
    BT=Between
    EQ==
    GE=>=
    LE=<=
    NE=<>
    14 BF_VAL_YN Character(1) VARCHAR2(1) NOT NULL Bid Factor Value
    N=No
    Y=Yes
    15 BF_VAL_DT1 Date(10) DATE Bid Factor Value
    16 BF_VAL_DT2 Date(10) DATE Bid Value Date
    17 BF_VAL_NBR1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Value
    18 BF_VAL_NBR2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Bid Factor Value
    19 CONST_AWARD Character(3) VARCHAR2(3) NOT NULL Constraint Award
    AMT=Price
    QTY=Quantity
    20 AWARD_OPERAND Character(2) VARCHAR2(2) NOT NULL Award Operand
    BT=Between
    GE=>=
    LE=<=
    21 AWARD_VAL1 Number(15,2) DECIMAL(14,2) NOT NULL Award Value
    22 AWARD_VAL2 Number(15,2) DECIMAL(14,2) NOT NULL Award Value
    23 AWARD_BASIS Character(1) VARCHAR2(1) NOT NULL Award Basis
    A=Amount
    P=Percent
    24 CONST_APPLY Character(1) VARCHAR2(1) NOT NULL Constraint Apply
    A=Across Bidders
    B=Per Bidder
    25 CONST_EXPRESSION Character(1) VARCHAR2(1) NOT NULL Constraint Expression
    A=And
    O=Or
    26 SSO_BOUND_INDEX Number(10,0) DECIMAL(10) NOT NULL Bound constraint idx
    27 SSO_BND_OVER Number(17,6) DECIMAL(16,6) NOT NULL amount over policy upper bound
    28 SSO_BND_UNDER Number(17,6) DECIMAL(16,6) NOT NULL amount under policy lower bnd