RC_ST_RSLT_DTL(SQL Table) |
Index Back |
|---|---|
Search Tool Result Details |
| # | 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 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | KEY_CHAR_1 | Character(25) | VARCHAR2(25) NOT NULL | Key Character 1 |
| 4 | KEY_CHAR_2 | Character(25) | VARCHAR2(25) NOT NULL | Key Character 2 |
| 5 | KEY_CHAR_3 | Character(25) | VARCHAR2(25) NOT NULL | Key Character 3 |
| 6 | KEY_NUM_1 | Number(18,0) | DECIMAL(18) NOT NULL | Key Numeric 1 |
| 7 | KEY_NUM_2 | Number(18,0) | DECIMAL(18) NOT NULL | Key Numeric 2 |
| 8 | KEY_NUM_3 | Number(18,0) | DECIMAL(18) NOT NULL | Key Numeric 3 |
| 9 | RESULT_1 | Character(50) | VARCHAR2(50) NOT NULL | Result Field |
| 10 | RESULT_2 | Character(50) | VARCHAR2(50) NOT NULL | Result Field |
| 11 | RESULT_3 | Character(50) | VARCHAR2(50) NOT NULL | Result Field |
| 12 | RESULT_4 | Character(50) | VARCHAR2(50) NOT NULL | Result Field |
| 13 | RESULT_5 | Character(50) | VARCHAR2(50) NOT NULL | Result Field |