IT_RULE_DEFN

(SQL Table)
 Index Back

Rule Header Definition

  • Related Language Record: IT_RULE_DEFN_LG

  • Parent Record Of IT_RULE_ACTN IT_RULE_SET IT_RULE_STYPE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID
    2 RULE_DESCR Character(30) VARCHAR2(30) NOT NULL Rule Description
    3 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
    A=Active
    I=Inactive
    4 RULE_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    5 ATTRIBUTE_ID Character(20) VARCHAR2(20) NOT NULL Attribute ID

    Prompt Table: IT_RULE_ATT0

    6 SYSTEM_MAINTAINED Character(1) VARCHAR2(1) NOT NULL System Maintained

    Y/N Table Edit

    7 FOUND_IN_SYSTEM Character(1) VARCHAR2(1) NOT NULL Found in System
    A=Repository Only
    D=Discovery Only
    8 ASSET_SUBTYPE_ALL Character(1) VARCHAR2(1) NOT NULL All Subtypes

    Y/N Table Edit

    9 COMMENTS Long Character CLOB Comment
    10 FIN_IMPACT_FLG Character(1) VARCHAR2(1) NOT NULL Financial Impact Flag

    Y/N Table Edit

    Default Value: N

    11 TREND_FLG Character(1) VARCHAR2(1) NOT NULL Trend Analysis

    Y/N Table Edit

    Default Value: N