OPRIDPSSYSCREATEDTTMPACKAGEIDAPPCLASSIDKEYVALUE0=False
1=True
PSDIAGQRY2 |
index back |
|---|---|
Diagnostic Framework Query 2 |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| PSSYSCREATEDTTM |
DateTime(26) | TIMESTAMP | Create Date Time |
| PACKAGEID |
Character(30) | VARCHAR2(30) NOT NULL | Plug-in Name (see PSDIAGREG). |
| APPCLASSID |
Character(30) | VARCHAR2(30) NOT NULL | Class Name |
| KEYVALUE |
Character(30) | VARCHAR2(30) NOT NULL | Key Value |
| ROW_NUM | Number(3,0) | SMALLINT NOT NULL | Row Number |
| DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| FIELD_DATE | Date(10) | DATE | Field Date |
| FIELD_CHAR | Character(200) | VARCHAR2(200) NOT NULL | Field Char |
| FIELD_BOOL | Character(1) | VARCHAR2(1) NOT NULL |
Field Bool
0=False 1=True |
| FLDFORMAT | Number(5,0) | INTEGER NOT NULL | Field Format |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |