SCC_RULE_STM_LN (SQL Table)	Index Back
Rules Engine Statements This related language table contains the defintion of statements used in the rules engine.

SCC_RULE_STM_LN

(SQL Table)

Rules Engine Statements

This related language table contains the defintion of statements used in the rules engine.

Related Language Record for SCC_RULE_STMT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule ID for rules used in the Rules Engine

2 SCC_RULE_VERSION Number(3,0) SMALLINT NOT NULL This field is the version of a rule or rule group in the rules engine.
Default Value: 1

3 SCC_RULE_SEQNUM Number(4,0) SMALLINT NOT NULL This field is a sequence number used to create a unqiue key in the Rules Engine setup

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

5 SCC_RULE_STMTDESCR Long Character(2000) VARCHAR2(2000) This field contains the description of the statement to show to user on the rules engine main page.

6 SCC_RULE_DESCRHTML Long Character CLOB This field contains the description of the statement to show to user on the rules engine main page.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule ID for rules used in the Rules Engine
2	SCC_RULE_VERSION	Number(3,0)	SMALLINT NOT NULL	This field is the version of a rule or rule group in the rules engine. Default Value: 1
3	SCC_RULE_SEQNUM	Number(4,0)	SMALLINT NOT NULL	This field is a sequence number used to create a unqiue key in the Rules Engine setup
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	SCC_RULE_STMTDESCR	Long Character(2000)	VARCHAR2(2000)	This field contains the description of the statement to show to user on the rules engine main page.
6	SCC_RULE_DESCRHTML	Long Character	CLOB	This field contains the description of the statement to show to user on the rules engine main page.