OPRIDTRW_DATASRC_IDSEQNUMF=Fail
N=New
S=Success
TRW_DATASRC_TSQ(SQL Table) |
Index Back |
|---|---|
TRW Data Src Test SQLThis record stores the SQL generated when testing a 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 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | TRW_SQL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
TRW SQL Status
F=Fail N=New S=Success |
| 7 | ROWS_RETRIEVED | Number(9,0) | DECIMAL(9) NOT NULL | Number of Rows Retrieved |