IT_RULE_ACTV

(SQL View)
 Index Back

Rule Header Definition


SELECT RULE_ID , RULE_DESCR , RULE_SEQ_NUM , ATTRIBUTE_ID , SYSTEM_MAINTAINED , FOUND_IN_SYSTEM , ASSET_SUBTYPE_ALL , COMMENTS FROM PS_IT_RULE_DEFN WHERE ACTIVE_STATUS = 'A'

  • Related Language Record: IT_RULE_ACTV_LG

    • # 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 RULE_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 ATTRIBUTE_ID Character(20) VARCHAR2(20) NOT NULL Attribute ID

    Prompt Table: IT_RULE_ATT0

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

    Y/N Table Edit

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

    Y/N Table Edit

    8 COMMENTS Long Character CLOB Comment