SCC_RULE_HDR3VL

(SQL View)
 Index Back

Rules Engine Header

This related language view contains the header record information for rules used in the Rules Engine. NOTE: Since the view is used in the generation of the rule report, the related language data for the outer join records will need to be pulled from the app class code that generated the report xml file. This will simplify this view so it is not a 4 part unioned view.

SELECT A.SCC_RULE_ID , A.SCC_RULE_VERSION , AL.LANGUAGE_CD , X.XLATLONGNAME , AL.SCC_RULE_NAME , BL.SCC_RULE_CAT_NAME , D.SCC_RULE_GROUP_NM , C.SCC_ENTITY_NAME , XX.XLATLONGNAME , XXX.XLATLONGNAME , XXXX.XLATLONGNAME , AL.SCC_RULE_LONGNAME FROM PS_SCC_RULE_HDR A LEFT OUTER JOIN PS_SCC_ENTITY_REG C ON C.SCC_ENTITY_ID = A.SCC_ENTITY_ID LEFT OUTER JOIN PS_SCC_RULEGR_HDR D ON D.SCC_RULE_GROUP_ID = A.SCC_RULE_GROUP_ID ,PS_SCC_RULE_HDR_LN AL ,PS_SCC_RULE_CAT B ,PS_SCC_RULE_CAT_LN BL ,PSXLATITEM X ,PSXLATITEMLANG XL ,PSXLATITEM XX ,PSXLATITEMLANG XXL ,PSXLATITEM XXX ,PSXLATITEMLANG XXXL ,PSXLATITEM XXXX ,PSXLATITEMLANG XXXXL WHERE A.SCC_RULE_ID = AL.SCC_RULE_ID AND A.SCC_RULE_VERSION = AL.SCC_RULE_VERSION AND A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND BL.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND BL.LANGUAGE_CD = AL.LANGUAGE_CD AND X.FIELDNAME = 'SCC_RULE_STATUS' AND X.FIELDVALUE = A.SCC_RULE_STATUS AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn AND X1.EFF_STATUS = 'A') AND XX.FIELDNAME = 'SCC_RULE_TYPE' AND XX.FIELDVALUE = A.SCC_RULE_TYPE 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_USER_MODE' AND XXX.FIELDVALUE = A.SCC_RULE_USER_MODE 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 XXXX.FIELDNAME = 'SCC_RULE_LOG_LEVEL' AND XXXX.FIELDVALUE = A.SCC_RULE_LOG_LEVEL AND XXXX.EFFDT = ( SELECT MAX(XXXX1.EFFDT) FROM PSXLATITEM XXXX1 WHERE XXXX1.FIELDNAME = XXXX.FIELDNAME AND XXXX1.FIELDVALUE = XXXX.FIELDVALUE AND XXXX1.EFFDT <= %CurrentDateIn AND XXXX1.EFF_STATUS = 'A') AND X.FIELDNAME = XL.FIELDNAME AND X.FIELDVALUE = XL.FIELDVALUE AND X.EFFDT = XL.EFFDT AND XL.LANGUAGE_CD = AL.LANGUAGE_CD AND XX.FIELDNAME = XXL.FIELDNAME AND XX.FIELDVALUE = XXL.FIELDVALUE AND XX.EFFDT = XXL.EFFDT AND XXL.LANGUAGE_CD = AL.LANGUAGE_CD AND XXX.FIELDNAME = XXXL.FIELDNAME AND XXX.FIELDVALUE = XXXL.FIELDVALUE AND XXX.EFFDT = XXXL.EFFDT AND XXXL.LANGUAGE_CD = AL.LANGUAGE_CD AND XXXX.FIELDNAME = XXXXL.FIELDNAME AND XXXX.FIELDVALUE = XXXXL.FIELDVALUE AND XXXX.EFFDT = XXXXL.EFFDT AND XXXXL.LANGUAGE_CD = AL.LANGUAGE_CD

  • Related Language Record for SCC_RULE_HDR3VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_RULE_STS_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the status description
    5 SCC_RULE_NAME Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
    6 SCC_RULE_CAT_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the category description
    7 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
    8 ENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Entity Name
    9 SCC_RULE_TYP_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the rule type description
    10 SCC_RULE_MOD_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the user mode description
    11 SCC_RULE_LOG_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the log level description
    12 SCC_RULE_LONGNAME Long Character CLOB NOT NULL This field is used for the long description used to describe a rule.