SCC_RULE_RC_ARG (SQL Table)	Index Back
Rules Engine Batch Processing This run control record is used to define arguments to run rules in batch.

SCC_RULE_RC_ARG

(SQL Table)

Rules Engine Batch Processing

This run control record is used to define arguments to run rules in batch.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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_FLEX_OBJ1 Character(91) VARCHAR2(91) NOT NULL This field is the value of the used in the processing of rules for the Rules Engine

10 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

11 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

12 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

13 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

14 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

15 SCC_RULE_DFLT_VAL Character(91) VARCHAR2(91) NOT NULL This field is the default value of a variable used in the rules engine.

16 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

17 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
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_FLEX_OBJ1	Character(91)	VARCHAR2(91) NOT NULL	This field is the value of the used in the processing of rules for the Rules Engine
10	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
11	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
12	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
13	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
14	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
15	SCC_RULE_DFLT_VAL	Character(91)	VARCHAR2(91) NOT NULL	This field is the default value of a variable used in the rules engine.
16	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
17	SCC_LOV_UID	Character(40)	VARCHAR2(40) NOT NULL	LOV Unique ID