| # |
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 |
QASINSTANCEID |
Character(36) |
VARCHAR2(36) NOT NULL |
Instance ID
|
| 3 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
|
| 4 |
QASISPUBLIC |
Number(1,0) |
SMALLINT NOT NULL |
Is Public Query
|
| 5 |
QASSTATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status of Execution
|
| 6 |
QASBLOCKSIZE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Block Size
|
| 7 |
QASMAXROWS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Max Rows to Return
|
| 8 |
QASNUMCOLS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number of Columns
|
| 9 |
QASTOTALROWS |
Number(12,0) |
DECIMAL(12) NOT NULL |
Total Number of Rows
|
| 10 |
QASTOTALBLOCKS |
Number(12,0) |
DECIMAL(12) NOT NULL |
Total Number of Blocks
|
| 11 |
QASTOTALBYTES |
Number(12,0) |
DECIMAL(12) NOT NULL |
Total Number of bytes
|
| 12 |
QASERRORMSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Error Message
|
| 13 |
QASDATAPATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Directory Name
|
| 14 |
CREATEDTTM |
DateTime(26) |
TIMESTAMP |
DateTime of Query Creation
|