OPRIDTRW_DATASRC_IDPrompt Table: GB_GROUP_SEC_VW
Prompt Table: PERSON_PROMPT
Prompt Table: EMPLMT_SRCH_GBL
Prompt Table: TRW_RW_ITEM_VW
TRW_DATASRC_TPM(SQL Table) |
Index Back |
|---|---|
TRW Data Src Test ParametersThis record stores the test parameters used to test the reward data source. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | TRW_DATASRC_ID |
Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - Reward Data Source ID |
| 3 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SEC_VW |
| 4 | FROMDATE | Date(10) | DATE | From Date |
| 5 | THRUDATE | Date(10) | DATE | End Date |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_PROMPT |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EMPLMT_SRCH_GBL |
| 8 | TRW_RW_ITEM_ID | Character(15) | VARCHAR2(15) NOT NULL |
Total rewards statement - reward item ID
Prompt Table: TRW_RW_ITEM_VW |
| 9 | TRW_STMT_ID | Character(15) | VARCHAR2(15) NOT NULL | Reward Statement ID |
| 10 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |