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

SCC_RTRIG_RI_LV

(SQL View)

Rule Header Lookup View

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

SELECT S.OPRID , A.SCC_RULE_CATEGORY , A.SCC_RULE_ID , AL.LANGUAGE_CD , AL.SCC_RULE_NAME FROM PS_SCC_RULE_CATSCR S , PS_SCC_RULE_HDR A , PS_SCC_RULE_HDR_LN AL WHERE S.SCC_RULE_CATEGORY = A.SCC_RULE_CATEGORY AND A.SCC_RULE_ID = AL.SCC_RULE_ID AND A.SCC_RULE_VERSION = AL.SCC_RULE_VERSION

Related Language Record for SCC_RTRIG_RI_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine

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

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

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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SCC_RULE_CATEGORY	Character(40)	VARCHAR2(40) NOT NULL	Rule Category for the Rules Engine
3	SCC_RULE_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule ID for rules used in the Rules Engine
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	SCC_RULE_NAME	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine