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

SCC_RULE_RGCTVL

(SQL View)

Rule Group Category View

This related langauge 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 , L.LANGUAGE_CD , L.SCC_RULE_CAT_NAME FROM PS_SCC_RULE_CAT_RG A , PS_SCC_RULE_CAT B , PS_SCC_RULE_CAT_LN L WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND B.SCC_RULE_CATEGORY = L.SCC_RULE_CATEGORY

Related Language Record for SCC_RULE_RGCTVW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	SCC_RULE_CAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Rule Name for the Rules Engine