SCC_RULE_VAR2VW (SQL View)	Index Back
Rules Engine Arguments This table contains the arguments used in the setup for rules used in the Rules Engine

SCC_RULE_VAR2VW

(SQL View)

Rules Engine Arguments

This table contains the arguments used in the setup for rules used in the Rules Engine

SELECT SCC_RULE_ID , SCC_RULE_VERSION , SCC_RULE_SEQNUM , SCC_RULE_EARG_NAME , SCC_RULE_IARG_NAME , SCC_DESCRLONG , SCC_RULE_ORDER , SCC_RULE_FLEX_TYP1 , SCC_RULE_ARGUMENT , SCC_RULE_RETURN , SCC_RULE_FLD_RQD , SCC_RULE_LIST_VAR , SCC_RULE_SYS_VAR , SCC_RULE_DFLT_VAL , SCC_RULE_REF_CNT , SCC_LOV_UID FROM PS_SCC_RULE_VARS

Related Language Record: SCC_RULE_VAR_VL

Parent record: 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

4 SCC_RULE_EARG_NAME Character(30) VARCHAR2(30) NOT NULL This field is the name displayed external to the users of the Rules Engine

5 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

6 SCC_DESCRLONG Character(254) VARCHAR2(254) NOT NULL This field is a long description field used in Campus Community

7 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

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

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.

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

#	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
4	SCC_RULE_EARG_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name displayed external to the users of the Rules Engine
5	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
6	SCC_DESCRLONG	Character(254)	VARCHAR2(254) NOT NULL	This field is a long description field used in Campus Community
7	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
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
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.
16	SCC_LOV_UID	Character(40)	VARCHAR2(40) NOT NULL	LOV Unique ID