TRW_RW_ITEM_IDEFFDTDefault Value: %date
FIELDNAME01=In List
02=Not In List
03=Equal to Blank
04=Not Equal to Blank
05=Equal to 0
06=Not Equal to 0
07=Equal to Null
08=Not Equal to Null
Default Value: 01
TRW_ITEM_FLTR(SQL Table) |
Index Back |
|---|---|
Reward Item FilterDefine total rewards item filters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRW_RW_ITEM_ID |
Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - reward item ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | TRW_OPERATOR | Character(2) | VARCHAR2(2) NOT NULL |
Total Reward Statement - Rewad Item Filter Operator
01=In List 02=Not In List 03=Equal to Blank 04=Not Equal to Blank 05=Equal to 0 06=Not Equal to 0 07=Equal to Null 08=Not Equal to Null Default Value: 01 |