SCC_RULE_ST_LVW (SQL View)	Index Back
Rules Engine Statements This table contains the definition and attributes of statements used in the rules engine.

SCC_RULE_ST_LVW

(SQL View)

Rules Engine Statements

This table contains the definition and attributes of statements used in the rules engine.

SELECT L.SCC_RULE_STMT_NAME , L.LANGUAGE_CD , L.SCC_DESCR , A.SCC_RULE_STATEMENT FROM PS_SCC_RULE_ST_LNG L , PS_SCC_RULE_ST_TBL A WHERE A.SCC_RULE_STATEMENT = L.SCC_RULE_STATEMENT

Related Language Record for SCC_RULE_ST_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_STMT_NAME Character(30) VARCHAR2(30) NOT NULL This field is the name of the statement used in the rule engine.

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

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

4 SCC_RULE_STATEMENT Character(40) VARCHAR2(40) NOT NULL This field is used to identify the type of statement used in the rules calculation for the Rules Engine

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_STMT_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name of the statement used in the rule engine.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	SCC_DESCR	Character(254)	VARCHAR2(254) NOT NULL	This field is a long description field used in Campus Community
4	SCC_RULE_STATEMENT	Character(40)	VARCHAR2(40) NOT NULL	This field is used to identify the type of statement used in the rules calculation for the Rules Engine