SCC_RULE_EDSHDV (SQL View)	Index Back
Rules Engine EDS View This view is created to show all the properties for a data set to be used in the rules engine tester.

SCC_RULE_EDSHDV

(SQL View)

Rules Engine EDS View

This view is created to show all the properties for a data set to be used in the rules engine tester.

SELECT ' ' , 0 , 0 FROM PS_SCC_RULE_HDR

# 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_SEQNUM Number(4,0) SMALLINT NOT NULL This field is a sequence number used to create a unqiue key in the Rules Engine setup

#	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_SEQNUM	Number(4,0)	SMALLINT NOT NULL	This field is a sequence number used to create a unqiue key in the Rules Engine setup