AUC_OPT_HDR_CST

(SQL Table)
Index Back

  • Parent record: AUC_OPT_HDR
  • # 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 CONST_NBR Number(2,0) SMALLINT NOT NULL Constraint Number
    8 CONSTRAINT_CD Character(18) VARCHAR2(18) NOT NULL Constraint Code
    9 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    10 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_DEFN_TBL

    11 AUC_CONST_APPLY Character(1) VARCHAR2(1) NOT NULL Constraints
    A=Apply
    I=Ignore
    12 CONST_TYPE Character(1) VARCHAR2(1) NOT NULL Constraint Type
    B=Bus Unit
    E=Event
    G=Global
    13 CONST_OBJECTIVE Character(1) VARCHAR2(1) NOT NULL Constraint Objective
    M=Mandatory Goal
    T=Target Goal
    14 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
    15 CONST_ORIGIN Character(1) VARCHAR2(1) NOT NULL Constraint Origin
    D=Defaulted
    O=Operator Created\Added
    16 CONST_SUMMARY Long Character CLOB Constraint Summary
    17 AUC_OPT_CNST_COST Signed Number(16,2) DECIMAL(14,2) NOT NULL Cost of Constraint