SCC_RULE_HDR5LN(SQL View) |
Index Back |
|---|---|
Rules Engine HeaderThis table contains the header record information for rules used in the Rules Engine. This view is used to combine a view and a related language view for searching, it should not have another related language record created for it. |
| SELECT A.SCC_RULE_ID , A.SCC_RULE_VERSION , B.LANGUAGE_CD , A.SCC_RULE_STATUS , B.SCC_RULE_NAME , A.SCC_RULE_CATEGORY , A.SCC_RULE_GROUP_ID , B.SCC_RULE_GROUP_NM , 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 , B.SCC_RULE_LONGNAME FROM PS_SCC_RULE_HDR5VW A , PS_SCC_RULE_HDR5VL B WHERE A.SCC_RULE_ID = B.SCC_RULE_ID AND A.SCC_RULE_VERSION = B.SCC_RULE_VERSION |
| # | 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_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 |
| 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_CATSC2 |
| 7 | 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 |
| 8 | SCC_RULE_GROUP_NM | Character(80) | VARCHAR2(80) NOT NULL | This field contains the name of the rule used in the Rules Engine |
| 9 | SCC_ENTITY_ID | Character(40) | VARCHAR2(40) NOT NULL |
Entitiy ID
Prompt Table: SCC_ENTITY_PT |
| 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.
Y/N Table Edit Default Value: N |
| 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.
Y/N Table Edit Default Value: N |
| 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 Default Value: 99 |
| 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
Prompt Table: SCC_APPCLASS_PT |
| 16 | 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. |
| 17 | SCC_RULE_LONGNAME | Long Character | CLOB NOT NULL | This field is used for the long description used to describe a rule. |