PSQRYTRANS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 2 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | QRYMACHINENAME | Character(32) | VARCHAR2(32) NOT NULL | Machine Name |
| 5 | QRYDOMAINID | Character(32) | VARCHAR2(32) NOT NULL | Domain ID |
| 6 | PROCESSID | Signed Number(11,0) | DECIMAL(10) NOT NULL | Process Identifier |
| 7 | HOSTNAME | Character(254) | VARCHAR2(254) NOT NULL | Host |
| 8 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 9 | QRYSTARTTIME | DateTime(26) | TIMESTAMP | Start Time |
| 10 | QRYENDTIME | DateTime(26) | TIMESTAMP | Timeout End Time |