SCC_GE_RULE_VW3 (SQL View)	Index Back
EMS Rules Engine Header View3 Evaluation Management System Rules Engine Header View 3.

SCC_GE_RULE_VW3

(SQL View)

EMS Rules Engine Header View3

Evaluation Management System Rules Engine Header View 3.

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_20140514151404'

Related Language Record: SCC_GE_RULELVW3

# 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.

#	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.