SCC_RTR_CAT_LVW (SQL View)	Index Back
Rule Trigger Category Search This related language view is used to search for valid rule categories used in the rules engine where triggers are defined as valid.

SCC_RTR_CAT_LVW

(SQL View)

Rule Trigger Category Search

This related language view is used to search for valid rule categories used in the rules engine where triggers are defined as valid.

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_ALW_TRGRS = 'Y' AND A.SCC_RULE_CATEGORY = L.SCC_RULE_CATEGORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for 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_RULE_CAT_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the category description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_CATEGORY	Character(40)	VARCHAR2(40) NOT NULL	Rule Category for 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_RULE_CAT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used for the rules engine report for the category description