SCC_RULE_CATLNR

(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 C.ROLEUSER , A.SCC_RULE_CATEGORY , BL.LANGUAGE_CD , BL.SCC_RULE_CAT_NAME , BL.SCC_DESCRLONG , DL.SCC_ENT_PRFL_NAME FROM PS_SCC_RULE_CAT_RL A , PS_SCC_RULE_CAT B , PS_SCC_RULE_CAT_LN BL , PSROLEUSER C , PS_SCC_ENT_PRFL_LN DL WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND B.SCC_RULE_CATEGORY = BL.SCC_RULE_CATEGORY AND C.ROLENAME = A.ROLENAME AND DL.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID AND DL.LANGUAGE_CD = BL.LANGUAGE_CD UNION SELECT C.ROLEUSER , A.SCC_RULE_CATEGORY , BL.LANGUAGE_CD , BL.SCC_RULE_CAT_NAME , BL.SCC_DESCRLONG , ' ' FROM PS_SCC_RULE_CAT_RL A , PS_SCC_RULE_CAT B , PS_SCC_RULE_CAT_LN BL , PSROLEUSER C WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND B.SCC_RULE_CATEGORY = BL.SCC_RULE_CATEGORY AND C.ROLENAME = A.ROLENAME AND NOT EXISTS( SELECT 'X' FROM PS_SCC_ENT_PRFL_LN DL WHERE DL.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID AND DL.LANGUAGE_CD = BL.LANGUAGE_CD) UNION SELECT A.OPRID , A.SCC_RULE_CATEGORY , BL.LANGUAGE_CD , BL.SCC_RULE_CAT_NAME , BL.SCC_DESCRLONG , DL.SCC_ENT_PRFL_NAME FROM PS_SCC_RULE_CAT_OP A , PS_SCC_RULE_CAT B , PS_SCC_RULE_CAT_LN BL , PS_SCC_ENT_PRFL_LN DL WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND B.SCC_RULE_CATEGORY = BL.SCC_RULE_CATEGORY AND DL.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID AND DL.LANGUAGE_CD = BL.LANGUAGE_CD UNION SELECT A.OPRID , A.SCC_RULE_CATEGORY , BL.LANGUAGE_CD , BL.SCC_RULE_CAT_NAME , BL.SCC_DESCRLONG , ' ' FROM PS_SCC_RULE_CAT_OP A , PS_SCC_RULE_CAT B , PS_SCC_RULE_CAT_LN BL WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND B.SCC_RULE_CATEGORY = BL.SCC_RULE_CATEGORY AND NOT EXISTS ( SELECT 'X' FROM PS_SCC_ENT_PRFL_LN DL WHERE DL.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID AND DL.LANGUAGE_CD = BL.LANGUAGE_CD)

  • Related Language Record for SCC_RULE_CATSCR

    • # 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