SCC_RULEGR6VW (SQL View)	Index Back
Rule Grp Header Lookup View This view is used to search for rule groups based on the category values.

SCC_RULEGR6VW

(SQL View)

Rule Grp Header Lookup View

This view is used to search for rule groups based on the category values.

SELECT A.SCC_RULE_GROUP_ID , A.SCC_RULE_GROUP_NM FROM PS_SCC_RULEGR_HDR A WHERE A.SCC_RULE_VERSION = ( SELECT MAX(A1.SCC_RULE_VERSION) FROM PS_SCC_RULEGR_HDR A1 WHERE A1.SCC_RULE_GROUP_ID = A.SCC_RULE_GROUP_ID)

Related Language Record: SCC_RULEGR6LV

# 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_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine

#	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_GROUP_NM	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine