PSQRYTRANS

index back

PeopleSoft Field NameField TypeColumn TypeDescription
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
QRYMACHINENAMECharacter(32)VARCHAR2(32) NOT NULLMachine Name
QRYDOMAINIDCharacter(32)VARCHAR2(32) NOT NULLDomain ID
PROCESSIDSigned Number(11,0)DECIMAL(10) NOT NULLProcess Identifier
HOSTNAMECharacter(254)VARCHAR2(254) NOT NULLHost
STATUSCharacter(1)VARCHAR2(1) NOT NULLStatus Indicator
A=Active
I=Inactive
QRYSTARTTIMEDateTime(26)TIMESTAMPStart Time
QRYENDTIMEDateTime(26)TIMESTAMPTimeout End Time
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19