SCC_GE_RULE_VW2(SQL View) |
Index Back |
---|---|
EMS Rules Engine Header View2Evaluation Management System Rules Engine Header View 2. |
SELECT A.SCC_RULE_ID , A.SCC_RULE_VERSION , A.SCC_RULE_STATUS , A.SCC_RULE_NAME , A.SCC_RULE_CATEGORY , A.SCC_RULE_GROUP_ID , A.SCC_ENTITY_ID , A.SCC_RULE_AVAILABLE , A.SCC_RULE_TYPE , A.SCC_RULE_USER_MODE , A.SCC_RULE_ALLOWSAVE , A.SCC_RULE_LOG_LEVEL , A.SCC_RULE_APCLASS , A.SCC_RULE_ROWNBR , A.SCC_RULE_LONGNAME FROM PS_SCC_RULE_HDR A WHERE A.SCC_RULE_VERSION = ( SELECT MAX (A1.SCC_RULE_VERSION) FROM PS_SCC_RULE_HDR A1 WHERE A1.SCC_RULE_ID = A.SCC_RULE_ID) AND A.SCC_RULE_STATUS IN ('2') AND A.SCC_RULE_GROUP_ID = 'SCC_RULEGR_ID_20140226154255' |
# | 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 |
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_LONGNAME | Long Character | CLOB NOT NULL | This field is used for the long description used to describe a rule. |