SCC_RULEGR5LN (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. This view is used to display searches in the related languages and does not need a related language record.

SCC_RULEGR5LN

(SQL View)

Rules Engine Header View

This table is a view of the header record information for rules groups used in the Rules Engine. This view is used to display searches in the related languages and does not need a related language record.

SELECT A.SCC_RULE_GROUP_ID ,A.SCC_RULE_VERSION ,L.LANGUAGE_CD ,A.SCC_RULE_STATUS ,L.SCC_RULE_GROUP_NM ,B.SCC_RULE_CATEGORY ,A.SCC_ENTITY_ID ,A.SCC_RULE_TYPE ,A.SCC_RULE_AVAILABLE ,A.SCC_RULE_ALLOWSAVE ,L.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 , PS_SCC_RULEGR_HDRL L WHERE A.SCC_RULE_GROUP_ID = L.SCC_RULE_GROUP_ID AND A.SCC_RULE_VERSION = L.SCC_RULE_VERSION

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

8 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

9 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

10 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

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