SCC_RULEGR5LV (SQL View)	Index Back
Rules Engine Header View This table is a related language view of the header record information for rules groups used in the Rules Engine

SCC_RULEGR5LV

(SQL View)

Rules Engine Header View

This table is a related language view of the header record information for rules groups used in the Rules Engine

SELECT A.SCC_RULE_GROUP_ID ,A.SCC_RULE_VERSION ,L.LANGUAGE_CD ,L.SCC_RULE_GROUP_NM ,L.SCC_RULE_LONGNAME FROM PS_SCC_RULEGR_HDR A , PS_SCC_RULEGR_HDRL L WHERE A.SCC_RULE_GROUP_ID = L.SCC_RULE_GROUP_ID AND A.SCC_RULE_VERSION = L.SCC_RULE_VERSION

Related Language Record for SCC_RULEGR5VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_GROUP_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule Group ID for rule groups 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine

5 SCC_RULE_LONGNAME Long Character CLOB NOT NULL This field is used for the long description used to describe a rule.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_GROUP_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule Group ID for rule groups 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	SCC_RULE_GROUP_NM	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine
5	SCC_RULE_LONGNAME	Long Character	CLOB NOT NULL	This field is used for the long description used to describe a rule.