TRW_DATASRC_IDTRW_EX_FILTER_TYPE001=Group ID
002=From Date
003=Thru Date
004=From and Thru Dates
005=Employee ID
006=Employee Record
TRW_DATASRC_EXF(SQL Table) |
Index Back |
|---|---|
TRW Data Source Extract FilterThis record stores the Extract Filters for the Reward Data Source. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRW_DATASRC_ID |
Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - Reward Data Source ID |
| 2 | TRW_EX_FILTER_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Total Rewards Statement - Extract Filter Type
001=Group ID 002=From Date 003=Thru Date 004=From and Thru Dates 005=Employee ID 006=Employee Record |
| 3 | TRW_EX_FILTER_TEXT | Long Character | CLOB NOT NULL | Total Rewards Statement - Extract Filter Text |