SCC_RULE_CRT_VW(SQL View) |
Index Back |
---|---|
Rules Engine Criteria ViewThis view contains the criteria used to define a rule in the Rules Engine |
SELECT SCC_RULE_ID , SCC_RULE_VERSION , SCC_RULE_SEQNUM , SCC_RULE_ORDER , SCC_RULE_CONNECTOR , SCC_PROP_NAME , SCC_RULE_OPERATOR , SCC_RULE_FLEX_TYP1 , SCC_RULE_FLEX_OBJ , SCC_RULE_PARENS FROM PS_SCC_RULE_CRIT |
# | 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_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_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 |
6 | SCC_PROP_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Property Name
Prompt Table: SCC_ENT_PROP_VW |
7 | 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: = |
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_OBJ | 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_PARENS | Character(5) | VARCHAR2(5) NOT NULL | This field is used to hold the parenthesis values used in processing rules for the Rules Engine |