SCC_RULEGR9LV

(SQL View)
 Index Back

Rules Group Header View

This related language view is used to pick up data sets used by rule groups in the rules engine.

SELECT DISTINCT A.SCC_LOV_UID , A.SCC_RULE_GROUP_ID , A.SCC_RULE_VERSION , AL.SCC_RULE_EARG_NAME , AL.LANGUAGE_CD , BL.SCC_RULE_GROUP_NM FROM PS_SCC_RULEGR_VARS A , PS_SCC_RULEGR_VARL AL , PS_SCC_RULEGR_HDR B , PS_SCC_RULEGR_HDRL BL , PS_SCC_RULE_CAT_RG C , PS_SCC_RULE_CAT D WHERE A.SCC_RULE_GROUP_ID = B.SCC_RULE_GROUP_ID AND A.SCC_RULE_VERSION = B.SCC_RULE_VERSION AND B.SCC_RULE_GROUP_ID = C.SCC_RULE_GROUP_ID AND C.SCC_RULE_CATEGORY = D.SCC_RULE_CATEGORY AND A.SCC_RULE_GROUP_ID = AL.SCC_RULE_GROUP_ID AND A.SCC_RULE_VERSION = AL.SCC_RULE_VERSION AND A.SCC_RULE_SEQNUM = AL.SCC_RULE_SEQNUM AND B.SCC_RULE_GROUP_ID = BL.SCC_RULE_GROUP_ID AND B.SCC_RULE_VERSION = BL.SCC_RULE_VERSION AND BL.LANGUAGE_CD = AL.LANGUAGE_CD

  • Related Language Record for SCC_RULEGR9VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID
    2 SCC_RULE_GROUP_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule Group ID for rule groups used in the Rules Engine

    Prompt Table: SCC_RULEGR_HDR

    3 SCC_RULE_VERSION Number(3,0) SMALLINT NOT NULL This field is the version of a rule or rule group in the rules engine.
    4 SCC_RULE_EARG_NAME Character(30) VARCHAR2(30) NOT NULL This field is the name displayed external to the users of the Rules Engine
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine