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

SCC_RTR_CAT_VW

(SQL View)

Rule Trigger Category Search

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

SELECT SCC_RULE_CATEGORY , SCC_RULE_CAT_NAME , SCC_DESCRLONG , SCC_RULE_ALW_TRGRS FROM PS_SCC_RULE_CAT WHERE SCC_RULE_ALW_TRGRS = 'Y'

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

3 SCC_RULE_CAT_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the category description

4 SCC_RULE_ALW_TRGRS Character(1) VARCHAR2(1) NOT NULL This field identifies if a rule in the Rules Engine allows triggers

#	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	SCC_RULE_CAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Rule Name for the Rules Engine
3	SCC_RULE_CAT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used for the rules engine report for the category description
4	SCC_RULE_ALW_TRGRS	Character(1)	VARCHAR2(1) NOT NULL	This field identifies if a rule in the Rules Engine allows triggers