SCC_RULE_ST_LV2 (SQL View)	Index Back
Rules Engine Statements This related language view contains the definition and attributes of statements used in the rules engine.

SCC_RULE_ST_LV2

(SQL View)

Rules Engine Statements

This related language view contains the definition and attributes of statements used in the rules engine.

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

Related Language Record for SCC_RULE_ST_VW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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

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

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

5 SCC_RULE_SEC_TITLE Character(50) VARCHAR2(50) NOT NULL This page contains the title used for the secondary search pages for statements used in the rules engine.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	SCC_RULE_STMT_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name of the statement used in the rule engine.
4	SCC_DESCR	Character(254)	VARCHAR2(254) NOT NULL	This field is a long description field used in Campus Community
5	SCC_RULE_SEC_TITLE	Character(50)	VARCHAR2(50) NOT NULL	This page contains the title used for the secondary search pages for statements used in the rules engine.