SCC_RULE_CAT3VW (SQL View)	Index Back
Rules Engine Categories This view contains the setup the category data in reports for the rules engine.

SCC_RULE_CAT3VW

(SQL View)

Rules Engine Categories

This view contains the setup the category data in reports for the rules engine.

SELECT A.SCC_RULE_CATEGORY , A.SCC_RULE_CAT_NAME , A.SCC_DESCRLONG , A.SCC_BASE_APPACKAGE , A.SCC_RULE_ALW_FNCTN , A.SCC_RULE_ALW_RULES , A.SCC_RULE_ALW_TRGRS , A.SCC_RULE_ALW_DVLPR , A.SCC_RULE_CATRG_RQD , A.SCC_RULE_AVAIL_ALL , A.SCC_ENT_PRFL_ID , B.SCC_ENT_PRFL_NAME FROM PS_SCC_RULE_CAT A LEFT OUTER JOIN PS_SCC_ENTITY_PRFL B ON B.SCC_ENT_PRFL_ID = A.SCC_ENT_PRFL_ID

Related Language Record: SCC_RULE_CAT3VL

# 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_DESCRLONG Character(254) VARCHAR2(254) NOT NULL This field is a long description field used in Campus Community

4 SCC_BASE_APPACKAGE Character(190) VARCHAR2(190) NOT NULL Base Application Package used by the Rules Engine

5 SCC_RULE_ALW_FNCTN Character(1) VARCHAR2(1) NOT NULL This field is a Y/N field used to identify if the rule in the Rules Engines allows functions.
Y/N Table Edit
Default Value: N

6 SCC_RULE_ALW_RULES Character(1) VARCHAR2(1) NOT NULL This field identifies is a rule in the Rules Engine allows Rules
Y/N Table Edit
Default Value: N

7 SCC_RULE_ALW_TRGRS Character(1) VARCHAR2(1) NOT NULL This field identifies if a rule in the Rules Engine allows triggers
Y/N Table Edit
Default Value: N

8 SCC_RULE_ALW_DVLPR Character(1) VARCHAR2(1) NOT NULL This field is a Y/N field used to identify if the rule in the Rules Engines allows developer mode.
Y/N Table Edit
Default Value: N

9 SCC_RULE_CATRG_RQD Character(1) VARCHAR2(1) NOT NULL This field is a yes/no flag on the rule category setup that is used to identify when a rule category must have rule groups attached to the rules.

10 SCC_RULE_AVAIL_ALL Character(1) VARCHAR2(1) NOT NULL This field is a Yes/No field used to identify if a rule category is a generic category that should be available to all other categories in the Rules Engine.

11 SCC_ENT_PRFL_ID Character(40) VARCHAR2(40) NOT NULL Entity Profile ID

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

#	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_DESCRLONG	Character(254)	VARCHAR2(254) NOT NULL	This field is a long description field used in Campus Community
4	SCC_BASE_APPACKAGE	Character(190)	VARCHAR2(190) NOT NULL	Base Application Package used by the Rules Engine
5	SCC_RULE_ALW_FNCTN	Character(1)	VARCHAR2(1) NOT NULL	This field is a Y/N field used to identify if the rule in the Rules Engines allows functions. Y/N Table Edit Default Value: N
6	SCC_RULE_ALW_RULES	Character(1)	VARCHAR2(1) NOT NULL	This field identifies is a rule in the Rules Engine allows Rules Y/N Table Edit Default Value: N
7	SCC_RULE_ALW_TRGRS	Character(1)	VARCHAR2(1) NOT NULL	This field identifies if a rule in the Rules Engine allows triggers Y/N Table Edit Default Value: N
8	SCC_RULE_ALW_DVLPR	Character(1)	VARCHAR2(1) NOT NULL	This field is a Y/N field used to identify if the rule in the Rules Engines allows developer mode. Y/N Table Edit Default Value: N
9	SCC_RULE_CATRG_RQD	Character(1)	VARCHAR2(1) NOT NULL	This field is a yes/no flag on the rule category setup that is used to identify when a rule category must have rule groups attached to the rules.
10	SCC_RULE_AVAIL_ALL	Character(1)	VARCHAR2(1) NOT NULL	This field is a Yes/No field used to identify if a rule category is a generic category that should be available to all other categories in the Rules Engine.
11	SCC_ENT_PRFL_ID	Character(40)	VARCHAR2(40) NOT NULL	Entity Profile ID
12	SCC_ENT_PRFL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Entity Profile Name