SCC_RULE_CALC(SQL Table) |
Index Back |
---|---|
Rules Engine CalculationsThis table contains the calculations used by rules 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_STMT_SEQ | Number(3,0) | SMALLINT NOT NULL | This field is used as a unique key for unique statement ids for the rules engine. |
5 | 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 |
6 | SCC_RULE_STATEMENT | Character(40) | VARCHAR2(40) NOT NULL | This field is used to identify the type of statement used in the rules calculation for the Rules Engine |
7 | SCC_RULE_CONNECTOR | Character(3) | VARCHAR2(3) NOT NULL |
This field is the connector value used in defining rules in the Rules Engine
AND=And OR=Or |
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_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_OPERATOR | Character(2) | VARCHAR2(2) NOT NULL |
This field is the operator used in the defintion of rules in the Rules Engine
<=Less Than <==Less Than or Equal To <>=Not Equal ==Equal >=Greater Than >==Greater Than or Equal To AD=As Of Date EX=Exists IN=In LI=Like NE=Not Exists NI=Not In NL=Not Like SF=First Effective Sequence SL=Last Effective Sequence Default Value: = |
11 | SCC_RULE_FLEX_TYP2 | 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 |
12 | SCC_RULE_FLEX_OBJ2 | Character(91) | VARCHAR2(91) NOT NULL | This field is the value of the used in the processing of rules for the Rules Engine |
13 | SCC_RULE_PARENS | Character(5) | VARCHAR2(5) NOT NULL | This field is used to hold the parenthesis values used in processing rules for the Rules Engine |
14 | 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 |
15 | 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 |
16 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
17 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
18 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
19 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |