SCC_RULE_VR_VLN (SQL View)	Index Back
Rules Engine Reason Search This view is the search record for the rules engine version reason component search record.

SCC_RULE_VR_VLN

(SQL View)

Rules Engine Reason Search

This view is the search record for the rules engine version reason component search record.

SELECT L.SCC_RULE_VRSN_NAME , L.LANGUAGE_CD , L.SCC_RULE_VRSN_DSCR , L.SCC_RULE_VERS_RSN FROM PS_SCC_RULE_VR_LNG L

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_VRSN_NAME Character(30) VARCHAR2(30) NOT NULL This field is the name of the reason version used in the rule engine.

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

3 SCC_RULE_VRSN_DSCR Character(254) VARCHAR2(254) NOT NULL Version reason description used in the Rules Engine

4 SCC_RULE_VERS_RSN Character(40) VARCHAR2(40) NOT NULL This field is the reason code used for versioning a rule in the Rules Engine

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_VRSN_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name of the reason version used in the rule engine.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	SCC_RULE_VRSN_DSCR	Character(254)	VARCHAR2(254) NOT NULL	Version reason description used in the Rules Engine
4	SCC_RULE_VERS_RSN	Character(40)	VARCHAR2(40) NOT NULL	This field is the reason code used for versioning a rule in the Rules Engine