SCC_RULE_CRT3VL

(SQL View)
 Index Back

Rules Engine Criteria View

This related language view contains the criteria used to define a rule in the Rules Engine

SELECT A.SCC_RULE_ID , A.SCC_RULE_VERSION , A.SCC_RULE_SEQNUM , BL.LANGUAGE_CD , XXL.XLATLONGNAME , XXXL.XLATLONGNAME FROM PS_SCC_RULE_CRIT A ,PS_SCC_RULE_HDR B ,PS_SCC_RULE_HDR_LN BL ,PSXLATITEM XX ,PSXLATITEMLANG XXL ,PSXLATITEM XXX ,PSXLATITEMLANG XXXL WHERE A.SCC_RULE_ID = B.SCC_RULE_ID AND A.SCC_RULE_VERSION = B.SCC_RULE_VERSION AND B.SCC_RULE_ID = BL.SCC_RULE_ID AND B.SCC_RULE_VERSION = BL.SCC_RULE_VERSION AND XX.FIELDNAME = 'SCC_RULE_OPERATOR' AND XX.FIELDVALUE = A.SCC_RULE_OPERATOR AND XX.EFFDT = ( SELECT MAX(XX1.EFFDT) FROM PSXLATITEM XX1 WHERE XX1.FIELDNAME = XX.FIELDNAME AND XX1.FIELDVALUE = XX.FIELDVALUE AND XX1.EFFDT <= %CurrentDateIn AND XX1.EFF_STATUS = 'A') AND XXX.FIELDNAME = 'SCC_RULE_FLEX_TYP1' AND XXX.FIELDVALUE = A.SCC_RULE_FLEX_TYP1 AND XXX.EFFDT = ( SELECT MAX(XXX1.EFFDT) FROM PSXLATITEM XXX1 WHERE XXX1.FIELDNAME = XXX.FIELDNAME AND XXX1.FIELDVALUE = XXX.FIELDVALUE AND XXX1.EFFDT <= %CurrentDateIn AND XXX1.EFF_STATUS = 'A') AND XX.FIELDNAME = XXL.FIELDNAME AND XX.FIELDVALUE = XXL.FIELDVALUE AND XX.EFFDT = XXL.EFFDT AND XXL.LANGUAGE_CD = BL.LANGUAGE_CD AND XXX.FIELDNAME = XXXL.FIELDNAME AND XXX.FIELDVALUE = XXXL.FIELDVALUE AND XXX.EFFDT = XXXL.EFFDT AND XXXL.LANGUAGE_CD = BL.LANGUAGE_CD

  • Related Language Record for SCC_RULE_CRT3VW

  • Parent record: SCC_RULE_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_RULE_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule ID for rules used in the Rules Engine
    2 SCC_RULE_VERSION Number(3,0) SMALLINT NOT NULL This field is the version of a rule or rule group in the rules engine.

    Default Value: 1

    3 SCC_RULE_SEQNUM Number(4,0) SMALLINT NOT NULL This field is a sequence number used to create a unqiue key in the Rules Engine setup
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SCC_RULE_OPR_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the operator description
    6 SCC_RULE_FL1_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the rule flex type description