SCC_RULE_FNCLVW (SQL View)	Index Back
Rules Engine Categories This related language view contains the setup the category data used for the rules in the Rules Engine

SCC_RULE_FNCLVW

(SQL View)

Rules Engine Categories

This related language view contains the setup the category data used for the rules in the Rules Engine

SELECT A.SCC_RULE_CATEGORY , L.LANGUAGE_CD , L.SCC_RULE_CAT_NAME , L.SCC_DESCRLONG FROM PS_SCC_RULE_CAT A , PS_SCC_RULE_CAT_LN L WHERE A.SCC_RULE_CATEGORY = L.SCC_RULE_CATEGORY

Related Language Record for SCC_RULE_FNC_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_FUNC_CAT Character(40) VARCHAR2(40) NOT NULL This field is used to identify functional Rule Category to be tied to a Rule Category in the Rules Engine

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

4 SCC_DESCRLONG Character(254) VARCHAR2(254) NOT NULL This field is a long description field used in Campus Community

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_FUNC_CAT	Character(40)	VARCHAR2(40) NOT NULL	This field is used to identify functional Rule Category to be tied to a Rule Category in the Rules Engine
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	SCC_RULE_CAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Rule Name for the Rules Engine
4	SCC_DESCRLONG	Character(254)	VARCHAR2(254) NOT NULL	This field is a long description field used in Campus Community