SCC_RULE_TRCATV (SQL View)	Index Back
Rule Engine Category Security This view is used to search for valid rule categories for a specific user in the rules engine.

SCC_RULE_TRCATV

(SQL View)

Rule Engine Category Security

This view is used to search for valid rule categories for a specific user in the rules engine.

SELECT A.OPRID , A.SCC_RULE_CATEGORY , B.SCC_RULE_CAT_NAME , A.SCC_DESCRLONG , A.SCC_ENT_PRFL_NAME FROM PS_SCC_RULE_CATSCR A , PS_SCC_RULE_CAT B WHERE A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY AND B.SCC_RULE_ALW_TRGRS = 'Y'

Related Language Record: SCC_RULE_TRCATL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

5 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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
4	SCC_DESCRLONG	Character(254)	VARCHAR2(254) NOT NULL	This field is a long description field used in Campus Community
5	SCC_ENT_PRFL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Entity Profile Name