SCC_RULE_HDR2VW (SQL View)	Index Back
Rule Header Lookup View This view is used to search for rules based on the category values.

SCC_RULE_HDR2VW

(SQL View)

Rule Header Lookup View

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

SELECT A.SCC_RULE_ID , A.SCC_RULE_VERSION , A.SCC_RULE_CATEGORY , B.SCC_RULE_CAT_NAME , A.SCC_RULE_NAME FROM PS_SCC_RULE_HDR A , PS_SCC_RULE_CAT B WHERE A.SCC_RULE_VERSION = ( SELECT MAX (A1.SCC_RULE_VERSION) FROM PS_SCC_RULE_HDR A1 WHERE A1.SCC_RULE_ID = A.SCC_RULE_ID) AND A.SCC_RULE_CATEGORY = B.SCC_RULE_CATEGORY

Related Language Record: SCC_RULE_HDR2LV

# 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.

3 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine
Prompt Table: SCC_RULE_CAT

4 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine

5 SCC_RULE_NAME 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_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.
3	SCC_RULE_CATEGORY	Character(40)	VARCHAR2(40) NOT NULL	Rule Category for the Rules Engine Prompt Table: SCC_RULE_CAT
4	SCC_RULE_CAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Rule Name for the Rules Engine
5	SCC_RULE_NAME	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine