PSDIAGQRY1

index back

Diagnostic Framework Query 1

Diagnostic Framework Query 1

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).
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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19