SCC_RULE_CATSL2

(SQL View)
 Index Back

Rule Engine Category Security

This related language view is used to search for valid rule categories for a specific user in the rules engine.

SELECT L.OPRID , B.SCC_RULE_CAT_NAME , L.SCC_RULE_CATEGORY , L.LANGUAGE_CD , L.SCC_DESCRLONG , L.SCC_ENT_PRFL_NAME FROM PS_SCC_RULE_CATLNR L , PS_SCC_RULE_CAT B WHERE L.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY

  • Related Language Record for SCC_RULE_CATSC2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine
    3 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SCC_DESCRLONG Character(254) VARCHAR2(254) NOT NULL This field is a long description field used in Campus Community
    6 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name