SCC_RULE_RGCTVW (SQL View)	Index Back
Rule Group Category View This view is used for selecting a valid rule category from the valid list for the rule group.

SCC_RULE_RGCTVW

(SQL View)

Rule Group Category View

This view is used for selecting a valid rule category from the valid list for the rule group.

SELECT A.SCC_RULE_GROUP_ID , A.SCC_RULE_CATEGORY , B.SCC_RULE_CAT_NAME FROM PS_SCC_RULE_CAT_RG A , PS_SCC_RULE_CAT B WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY

Related Language Record: SCC_RULE_RGCTVL

# 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_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine

3 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine

#	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_CATEGORY	Character(40)	VARCHAR2(40) NOT NULL	Rule Category for the Rules Engine
3	SCC_RULE_CAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Rule Name for the Rules Engine