SCC_RULE_HDR

(SQL Table)
 Index Back

Rules Engine Header

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

  • Related Language Record: SCC_RULE_HDR_LN

  • Parent Record Of SCC_RLGR_VAR_VL SCC_RULEGR_VARL SCC_RULE_BUILD SCC_RULE_CAL2VW SCC_RULE_CAL_VW SCC_RULE_CRIT SCC_RULE_CRT3VL SCC_RULE_CRT_VW SCC_RULE_STMT SCC_RULE_STM_LN SCC_RULE_TP_HDR SCC_RULE_VAR2VW SCC_RULE_VARS SCC_RULE_VAR_LN SCC_RULE_VAR_VL SCC_RULE_VAR_VW

    • # 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_NAME Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
    5 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine

    Prompt Table: SCC_RULE_CATSC2

    6 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_VW

    7 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

    Prompt Table: SCC_ENTITY_PT

    8 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

    9 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
    10 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
    11 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

    12 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

    13 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

    14 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.
    15 SCC_RULE_BLD_DTTM DateTime(26) TIMESTAMP Status Last Date/Time
    16 SCC_RULE_ENTLD_OPT Character(1) VARCHAR2(1) NOT NULL This field contains the entity data load option for rules in the Rules Engine.
    1=Retrieve Data By Criteria
    2=Retrieve No Data
    3=Retrieve All Data

    Default Value: 1

    17 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    18 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    19 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    20 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    21 SCC_RULE_LONGNAME Long Character CLOB NOT NULL This field is used for the long description used to describe a rule.