SCC_RULE_CATSCR

(SQL View)
 Index Back

Rule Engine Category Security

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

SELECT C.ROLEUSER , A.SCC_RULE_CATEGORY , B.SCC_RULE_CAT_NAME , B.SCC_DESCRLONG , D.SCC_ENT_PRFL_NAME FROM PS_SCC_RULE_CAT_RL A , PS_SCC_RULE_CAT B LEFT OUTER JOIN PS_SCC_ENTITY_PRFL D ON D.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID , PSROLEUSER C WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND C.ROLENAME = A.ROLENAME UNION SELECT A.OPRID , A.SCC_RULE_CATEGORY , B.SCC_RULE_CAT_NAME , B.SCC_DESCRLONG , D.SCC_ENT_PRFL_NAME FROM PS_SCC_RULE_CAT_OP A , PS_SCC_RULE_CAT B LEFT OUTER JOIN PS_SCC_ENTITY_PRFL D ON D.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY

  • Related Language Record: SCC_RULE_CATLNR

    • # 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 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine
    4 SCC_DESCRLONG Character(254) VARCHAR2(254) NOT NULL This field is a long description field used in Campus Community
    5 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name