SCC_RULE_TRCATL

(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 , L.SCC_RULE_CATEGORY , L.LANGUAGE_CD , L.SCC_RULE_CAT_NAME , 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 AND B.SCC_RULE_ALW_TRGRS = 'Y'

  • Related Language Record for SCC_RULE_TRCATV

    • # 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_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine
    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