SCC_RULE_CAT6VL

(SQL View)
 Index Back

Rules Engine Category View

This related language view is used to retrieve the data used in the rule category cross reference page for system variables.

SELECT A.SCC_RULE_CATEGORY , A.SCC_RULE_SYSVAR_ID , L.LANGUAGE_CD , L.SCC_RULE_SYSVAR_NM FROM PS_SCC_RULE_SYSVAR A , PS_SCC_RULE_SYSVLN L WHERE A.SCC_RULE_SYSVAR_ID = L.SCC_RULE_SYSVAR_ID

  • Related Language Record for SCC_RULE_CAT6VW

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

    Prompt Table: SCC_RULE_CAT

    2 SCC_RULE_SYSVAR_ID Character(40) VARCHAR2(40) NOT NULL System Variable id for the Rules Engine

    Prompt Table: SCC_RULE_SYSVAR

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_RULE_SYSVAR_NM Character(30) VARCHAR2(30) NOT NULL System Variable Name for the Rules Engine