SCC_RULE_BT_AET

(SQL Table)
 Index Back

Rules Engine Batch Processing

This record is the state record used for processing rules in batch.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 SCC_RULE_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule ID for rules used in the Rules Engine
5 SCC_RULE_VERSION Number(3,0) SMALLINT NOT NULL This field is the version of a rule or rule group in the rules engine.
6 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
7 SCC_RULE_NAME Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
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_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
10 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.
11 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
12 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
13 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.
14 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
15 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
16 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine
17 SCC_DATE Date(10) DATE The date the file was created
18 SCC_TIME Time(15) TIMESTAMP This field is used as a date field for the rules engine in Campus Community
19 SCC_RULE_EXEC_TIME Character(15) VARCHAR2(15) NOT NULL This field is used to report the amount of time it takes to execute a rule.
20 SCC_RULE_LONGNAME Long Character CLOB This field is used for the long description used to describe a rule.