TRW_DATASRC_IDFIELDNAMEPrompt Table: TRW_RIF_FLD_VW
N=No
Y=Yes
Default Value: N
1=No Table Edit
2=Prompt Table
3=Translate Table
4=Yes/No
Prompt Table: TRW_RECDEFN_VW
TRW_DATASRC_RIF(SQL Table) |
Index Back |
|---|---|
TRW Data Source Reward FilterThis record stores the Reward Item 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 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: TRW_RIF_FLD_VW |
| 3 | TRW_REQ_FILTER | Character(1) | VARCHAR2(1) NOT NULL |
Total Rewards Statement - Required Filter
N=No Y=Yes Default Value: N |
| 4 | PROMPT_EDITTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Edit Type
1=No Table Edit 2=Prompt Table 3=Translate Table 4=Yes/No |
| 5 | PROMPT_TABLE | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
Prompt Table: TRW_RECDEFN_VW |