SCC_RULE_HDR3VW

(SQL View)
 Index Back

Rules Engine Header

This table contains the header record information for rules used in the Rules Engine

SELECT A.SCC_RULE_ID , A.SCC_RULE_VERSION , A.SCC_RULE_STATUS , X.XLATLONGNAME , A.SCC_RULE_NAME , A.SCC_RULE_CATEGORY , B.SCC_RULE_CAT_NAME , A.SCC_RULE_GROUP_ID , D.SCC_RULE_GROUP_NM , A.SCC_ENTITY_ID , C.SCC_ENTITY_NAME , A.SCC_RULE_AVAILABLE , A.SCC_RULE_TYPE , XX.XLATLONGNAME , A.SCC_RULE_USER_MODE , XXX.XLATLONGNAME , A.SCC_RULE_ALLOWSAVE , A.SCC_RULE_LOG_LEVEL , XXXX.XLATLONGNAME , A.SCC_RULE_APCLASS , A.SCC_RULE_ROWNBR , A.SCC_ROW_ADD_OPRID , A.SCC_ROW_ADD_DTTM , A.SCC_ROW_UPD_OPRID , A.SCC_ROW_UPD_DTTM , A.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_CAT B ,PSXLATITEM X ,PSXLATITEM XX ,PSXLATITEM XXX ,PSXLATITEM XXXX WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY 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')

  • Related Language Record: SCC_RULE_HDR3VL

  • Parent Record Of SCC_RULE_CRT3VW SCC_RULE_STM3VW SCC_RULE_VAR3VL SCC_RULE_VAR3VW

    • # 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_STATUS Character(1) VARCHAR2(1) NOT NULL This field contains the status of a rule in the rules engine.
    1=In Progress
    2=Active
    3=Inactive

    Default Value: 1

    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_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine

    Prompt Table: SCC_RULE_CAT

    7 SCC_RULE_CAT_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the category description
    8 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
    9 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
    10 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

    Prompt Table: SCC_ENTITY_PT

    11 ENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Entity Name
    12 SCC_RULE_AVAILABLE Character(1) VARCHAR2(1) NOT NULL This field is used to assign a status to a rule in the Rules Engine. It will be a Y/N flag to states if the rule is available to used by another rule.

    Y/N Table Edit

    Default Value: N

    13 SCC_RULE_TYPE Character(2) VARCHAR2(2) NOT NULL This field holds the value of the rule type used in the setup of rules in the Rules Engine
    10=Function
    20=Rule
    30=Trigger
    14 SCC_RULE_TYP_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the rule type description
    15 SCC_RULE_USER_MODE Character(2) VARCHAR2(2) NOT NULL This field hold the skill level of the user who will be creating the rule.
    20=Novice
    40=Expert
    60=Developer
    16 SCC_RULE_MOD_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the user mode description
    17 SCC_RULE_ALLOWSAVE Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag used to identify if a rule is ready to save data. If the value is N, the results will be output either to a popup window or dumped to an XML file.

    Y/N Table Edit

    Default Value: N

    18 SCC_RULE_LOG_LEVEL Character(2) VARCHAR2(2) NOT NULL This field will contain a value that controls the logging level when processing rules in the rules engine.
    05=Trace Logging
    10=Informational Messages
    20=Warning Messages
    30=Error Messages
    40=Write To Log Only
    99=No Message Logging

    Default Value: 99

    19 SCC_RULE_LOG_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the log level description
    20 SCC_RULE_APCLASS Character(190) VARCHAR2(190) NOT NULL This field holds the value of the application class used to contain the code used for the rule in the Rules Engine

    Prompt Table: SCC_APPCLASS_PT

    21 SCC_RULE_ROWNBR Number(3,0) SMALLINT NOT NULL This field is the current row number where a encompassing row was added and new blank row needs to be added after.
    22 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    23 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    24 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    25 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    26 SCC_RULE_LONGNAME Long Character CLOB NOT NULL This field is used for the long description used to describe a rule.