OPRIDPSSYSCREATEDTTMPACKAGEIDAPPCLASSIDKEYVALUE0=False
1=True
PSDIAGQRY2(SQL Table) |
Index Back |
|---|---|
Diagnostic Framework Query 2Diagnostic Framework Query 2 |
| # | 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 | PSSYSCREATEDTTM |
DateTime(26) | TIMESTAMP | Create Date Time |
| 3 | PACKAGEID |
Character(30) | VARCHAR2(30) NOT NULL | Plug-in Name (see PSDIAGREG). |
| 4 | APPCLASSID |
Character(30) | VARCHAR2(30) NOT NULL | Class Name |
| 5 | KEYVALUE |
Character(30) | VARCHAR2(30) NOT NULL | Key Value |
| 6 | ROW_NUM | Number(3,0) | SMALLINT NOT NULL | Row Number |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | FIELD_DATE | Date(10) | DATE | Field Date |
| 9 | FIELD_CHAR | Character(200) | VARCHAR2(200) NOT NULL | Field Char |
| 10 | FIELD_BOOL | Character(1) | VARCHAR2(1) NOT NULL |
Field Bool
0=False 1=True |
| 11 | FLDFORMAT | Number(5,0) | INTEGER NOT NULL | Field Format |