PSQASRUN

index back

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
QASINSTANCEIDCharacter(36)VARCHAR2(36) NOT NULLInstance ID
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
QASISPUBLICNumber(1,0)SMALLINT NOT NULLIs Public Query
QASSTATUSCharacter(1)VARCHAR2(1) NOT NULLStatus of Execution
QASBLOCKSIZENumber(10,0)DECIMAL(10) NOT NULLBlock Size
QASMAXROWSNumber(10,0)DECIMAL(10) NOT NULLMax Rows to Return
QASNUMCOLSNumber(10,0)DECIMAL(10) NOT NULLNumber of Columns
QASTOTALROWSNumber(12,0)DECIMAL(12) NOT NULLTotal Number of Rows
QASTOTALBLOCKSNumber(12,0)DECIMAL(12) NOT NULLTotal Number of Blocks
QASTOTALBYTESNumber(12,0)DECIMAL(12) NOT NULLTotal Number of bytes
QASERRORMSGCharacter(254)VARCHAR2(254) NOT NULLError Message
QASDATAPATHCharacter(254)VARCHAR2(254) NOT NULLDirectory Name
CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19