CONSTRAINT_HDR

(SQL Table)
 Index Back

Sourcing Constraints Header

Header Table for Strategic Sourcing Policies and Constraints

  • Related Language Record: CONSTR_HDR_LG

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Default Value: E

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_DEFN_TBL

    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 CONST_OBJECTIVE Character(1) VARCHAR2(1) NOT NULL Constraint Objective
    M=Mandatory Goal
    T=Target Goal

    Default Value: T

    10 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

    11 CONST_SUMMARY Long Character CLOB Constraint Summary
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL