SCC_RULE_VRSN (SQL Table)	Index Back
Rules Engine Rule Versions This table is used to track rules engine version reason for rules in the rules engine.

SCC_RULE_VRSN

(SQL Table)

Rules Engine Rule Versions

This table is used to track rules engine version reason for rules in the rules engine.

Related Language Record: SCC_RULE_VRS_LN

# 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.
Default Value: 1

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

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
Prompt Table: SCC_RULE_VR2VW

5 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

6 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

7 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By

8 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time

9 SCC_RULE_VRSN_CMNT Long Character CLOB This field is used as a free-form field to allow customers to explain what a rule was versioned 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. Default Value: 1
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
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 Prompt Table: SCC_RULE_VR2VW
5	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
6	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
7	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
8	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time
9	SCC_RULE_VRSN_CMNT	Long Character	CLOB	This field is used as a free-form field to allow customers to explain what a rule was versioned in the Rules Engine.