SETIDRULE_IDEMP=is empty
EQL=equals
INLS=is in list
NEMP=is not empty
NEQL=not equals
NINL=not in list
EMP=is empty
EQL=equals
INLS=is in list
NEMP=is not empty
NEQL=not equals
NINL=not in list
RB_RULE_ER_TBL(SQL Table) |
Index Back |
|---|---|
Eligibility rule defn rec.Record used for storing Eligibility Rule Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | RULE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Field used for storing rule id information |
| 3 | SOURCE_OPR | Character(4) | VARCHAR2(4) NOT NULL |
Field used for storing Source Operator information
EMP=is empty EQL=equals INLS=is in list NEMP=is not empty NEQL=not equals NINL=not in list |
| 4 | SOURCE_VALUE | Character(128) | VARCHAR2(128) NOT NULL | Field used for storing source value information |
| 5 | SUBSOURCE_OPR | Character(4) | VARCHAR2(4) NOT NULL |
Field used for storing sub source operator information
EMP=is empty EQL=equals INLS=is in list NEMP=is not empty NEQL=not equals NINL=not in list |
| 6 | SUBSOURCE_VALUE | Character(128) | VARCHAR2(128) NOT NULL | Field used for storing sub source value information |