RULE_IDRULE_SET_NUMA=Attribute
S=SQL
Prompt Table: IT_RULE_ATT1
<=<
<==<=
<>=<>
===
>=>
>==>=
LK=Like
NLK=Not Like
A=Attribute
V=Value
Prompt Table: IT_RULE_ATT2
IT_RULE_SET(SQL Table) |
Index Back |
|---|---|
Rule Set Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Rule ID |
| 2 | RULE_SET_NUM |
Number(3,0) | SMALLINT NOT NULL | Rule Set Number |
| 3 | ATTRIBUTE1_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attribute1 Type
A=Attribute S=SQL |
| 4 | ATTRIBUTE_ID1 | Character(20) | VARCHAR2(20) NOT NULL |
Attribute ID
Prompt Table: IT_RULE_ATT1 |
| 5 | RULE_OPERATOR | Character(3) | VARCHAR2(3) NOT NULL |
Rule Operator
<=< <==<= <>=<> === >=> >==>= LK=Like NLK=Not Like |
| 6 | ATTRIBUTE2_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attribute2 Type
A=Attribute V=Value |
| 7 | ATTRIBUTE_ID2 | Character(20) | VARCHAR2(20) NOT NULL |
Attribute ID
Prompt Table: IT_RULE_ATT2 |
| 8 | FIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 9 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |