SCC_RULE_CAT

(SQL Table)
Index Back

Rules Engine Categories

This table contains the setup the category data used for the rules in the Rules Engine

  • Related Language Record: SCC_RULE_CAT_LN
  • Parent Record Of SCC_RULE_CAT_RG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine
    2 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine
    3 SCC_DESCRLONG Character(254) VARCHAR2(254) NOT NULL This field is a long description field used in Campus Community
    4 SCC_BASE_APPACKAGE Character(190) VARCHAR2(190) NOT NULL Base Application Package used by the Rules Engine
    5 SCC_RULE_ALW_FNCTN Character(1) VARCHAR2(1) NOT NULL This field is a Y/N field used to identify if the rule in the Rules Engines allows functions.

    Y/N Table Edit

    Default Value: N

    6 SCC_RULE_ALW_RULES Character(1) VARCHAR2(1) NOT NULL This field identifies is a rule in the Rules Engine allows Rules

    Y/N Table Edit

    Default Value: N

    7 SCC_RULE_ALW_TRGRS Character(1) VARCHAR2(1) NOT NULL This field identifies if a rule in the Rules Engine allows triggers

    Y/N Table Edit

    Default Value: N

    8 SCC_RULE_ALW_DVLPR Character(1) VARCHAR2(1) NOT NULL This field is a Y/N field used to identify if the rule in the Rules Engines allows developer mode.

    Y/N Table Edit

    Default Value: N

    9 SCC_RULE_CATRG_RQD Character(1) VARCHAR2(1) NOT NULL This field is a yes/no flag on the rule category setup that is used to identify when a rule category must have rule groups attached to the rules.

    Y/N Table Edit

    Default Value: N

    10 SCC_RULE_AVAIL_ALL Character(1) VARCHAR2(1) NOT NULL This field is a Yes/No field used to identify if a rule category is a generic category that should be available to all other categories in the Rules Engine.

    Y/N Table Edit

    Default Value: N

    11 SCC_ENT_PRFL_ID Character(40) VARCHAR2(40) NOT NULL Entity Profile ID

    Prompt Table: SCC_ENTPR_RL_VW

    12 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    13 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    14 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    15 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time