SCC_RULEGR_HDR (SQL Table)	Index Back
Rules Engine Header This table contains the header record information for rules used in the Rules Engine

SCC_RULEGR_HDR

(SQL Table)

Rules Engine Header

This table contains the header record information for rules used in the Rules Engine

Related Language Record: SCC_RULEGR_HDRL

Parent Record Of SCC_RLGR_VAR_VW SCC_RULEGR_VARS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_RULE_GROUP_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule Group ID for rule groups 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_STATUS Character(1) VARCHAR2(1) NOT NULL This field contains the status of a rule in the rules engine.
1=In Progress
2=Active
3=Inactive
Default Value: 1

4 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine

5 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
Prompt Table: SCC_ENTITY_PT

6 SCC_RULE_TYPE Character(2) VARCHAR2(2) NOT NULL This field holds the value of the rule type used in the setup of rules in the Rules Engine
10=Function
20=Rule
30=Trigger
Default Value: 20

7 SCC_RULE_AVAILABLE Character(1) VARCHAR2(1) NOT NULL This field is used to assign a status to a rule in the Rules Engine. It will be a Y/N flag to states if the rule is available to used by another rule.
Y/N Table Edit
Default Value: N

8 SCC_RULE_ALLOWSAVE Character(1) VARCHAR2(1) NOT NULL This field is a Y/N flag used to identify if a rule is ready to save data. If the value is N, the results will be output either to a popup window or dumped to an XML file.
Y/N Table Edit
Default Value: N

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

10 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

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

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

13 SCC_RULE_LONGNAME Long Character CLOB NOT NULL This field is used for the long description used to describe a rule.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_RULE_GROUP_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule Group ID for rule groups 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_STATUS	Character(1)	VARCHAR2(1) NOT NULL	This field contains the status of a rule in the rules engine. 1=In Progress 2=Active 3=Inactive Default Value: 1
4	SCC_RULE_GROUP_NM	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine
5	SCC_ENTITY_ID	Character(40)	VARCHAR2(40) NOT NULL	Entitiy ID Prompt Table: SCC_ENTITY_PT
6	SCC_RULE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field holds the value of the rule type used in the setup of rules in the Rules Engine 10=Function 20=Rule 30=Trigger Default Value: 20
7	SCC_RULE_AVAILABLE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to assign a status to a rule in the Rules Engine. It will be a Y/N flag to states if the rule is available to used by another rule. Y/N Table Edit Default Value: N
8	SCC_RULE_ALLOWSAVE	Character(1)	VARCHAR2(1) NOT NULL	This field is a Y/N flag used to identify if a rule is ready to save data. If the value is N, the results will be output either to a popup window or dumped to an XML file. Y/N Table Edit Default Value: N
9	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
10	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
11	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
12	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time
13	SCC_RULE_LONGNAME	Long Character	CLOB NOT NULL	This field is used for the long description used to describe a rule.