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 Prompt Table: SCC_RULEGR_HDR
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_ORDER	Number(4,0)	SMALLINT NOT NULL	This field is used to identify the order of the rows in the rules engine setup for the Rules Engine
5	SCC_RULE_EARG_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name displayed external to the users of the Rules Engine
6	SCC_RULE_IARG_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name displayed internal to the rules engine for the Rules Engine
7	SCC_DESCRLONG	Character(254)	VARCHAR2(254) NOT NULL	This field is a long description field used in Campus Community
8	SCC_RULE_FLEX_TYP1	Character(2)	VARCHAR2(2) NOT NULL	This field is used to identify the type of object for the following value in the rules engine 10=Text 20=Number 30=Datetime 40=Date 50=Time 55=True/False 60=Entity 65=Data Set 70=Property 75=Data Set Property 80=Variable Default Value: 10
9	SCC_RULE_ARGUMENT	Character(1)	VARCHAR2(1) NOT NULL	This is a Y/N field used to identify if a variable in the rules engine is also used as an argument for the rule. Y/N Table Edit Default Value: N
10	SCC_RULE_RETURN	Character(1)	VARCHAR2(1) NOT NULL	This field is a Y/N field used to identify if a variable in the rules engine is also going to be returned to the calling rule. Y/N Table Edit Default Value: N
11	SCC_RULE_FLD_RQD	Character(1)	VARCHAR2(1) NOT NULL	This field is a Y/N field used to identify if an argument is required in the rules engine. Y/N Table Edit Default Value: N
12	SCC_RULE_LIST_VAR	Character(1)	VARCHAR2(1) NOT NULL	This field is a Y/N variable used to define when a variable in the rules engine is a list variable Y/N Table Edit Default Value: N
13	SCC_RULE_SYS_VAR	Character(1)	VARCHAR2(1) NOT NULL	This field is a Y/N variable used to define when a variable in the rules engine is a system variable Y/N Table Edit Default Value: N
14	SCC_RULE_DFLT_VAL	Character(91)	VARCHAR2(91) NOT NULL	This field is the default value of a variable used in the rules engine.
15	SCC_RULE_REF_CNT	Number(3,0)	SMALLINT NOT NULL	This field identified how many times the argument or variable in question is references in the current rule. Default Value: 0
16	SCC_LOV_UID	Character(40)	VARCHAR2(40) NOT NULL	LOV Unique ID
17	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
18	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
19	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
20	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time