SCC_RULEGR5VW (SQL View)	Index Back
Rules Engine Header View This table is a view of the header record information for rules groups used in the Rules Engine

SCC_RULEGR5VW

(SQL View)

Rules Engine Header View

This table is a view of the header record information for rules groups used in the Rules Engine

SELECT A.SCC_RULE_GROUP_ID ,A.SCC_RULE_VERSION ,A.SCC_RULE_STATUS ,A.SCC_RULE_GROUP_NM ,B.SCC_RULE_CATEGORY ,A.SCC_ENTITY_ID ,A.SCC_RULE_TYPE ,A.SCC_RULE_AVAILABLE ,A.SCC_RULE_ALLOWSAVE ,A.SCC_RULE_LONGNAME FROM PS_SCC_RULEGR_HDR A LEFT OUTER JOIN PS_SCC_RULE_CAT_RG B ON A.SCC_RULE_GROUP_ID = B.SCC_RULE_GROUP_ID

Related Language Record: SCC_RULEGR5LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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_GROUP_NM 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_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
Prompt Table: SCC_ENTITY_PT

7 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

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_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

10 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_GROUP_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule Group ID for rule groups 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_GROUP_NM	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_ENTITY_ID	Character(40)	VARCHAR2(40) NOT NULL	Entitiy ID Prompt Table: SCC_ENTITY_PT
7	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
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_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
10	SCC_RULE_LONGNAME	Long Character	CLOB NOT NULL	This field is used for the long description used to describe a rule.