PSDIAGQRY2

index back

Diagnostic Framework Query 2

Diagnostic Framework Query 2

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PSSYSCREATEDTTMDateTime(26)TIMESTAMPCreate Date Time
PACKAGEIDCharacter(30)VARCHAR2(30) NOT NULLPlug-in Name (see PSDIAGREG).
APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLClass Name
KEYVALUECharacter(30)VARCHAR2(30) NOT NULLKey Value
ROW_NUMNumber(3,0)SMALLINT NOT NULLRow Number
DESCR50Character(50)VARCHAR2(50) NOT NULLDescription of length 50
FIELD_DATEDate(10)DATEField Date
FIELD_CHARCharacter(200)VARCHAR2(200) NOT NULLField Char
FIELD_BOOLCharacter(1)VARCHAR2(1) NOT NULLField Bool
0=False
1=True
FLDFORMATNumber(5,0)INTEGER NOT NULLField Format
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19