PSQASRUN

index back

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
QASINSTANCEID Character(36) VARCHAR2(36) NOT NULL Instance ID
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
QASISPUBLIC Number(1,0) SMALLINT NOT NULL Is Public Query
QASSTATUS Character(1) VARCHAR2(1) NOT NULL Status of Execution
QASBLOCKSIZE Number(10,0) DECIMAL(10) NOT NULL Block Size
QASMAXROWS Number(10,0) DECIMAL(10) NOT NULL Max Rows to Return
QASNUMCOLS Number(10,0) DECIMAL(10) NOT NULL Number of Columns
QASTOTALROWS Number(12,0) DECIMAL(12) NOT NULL Total Number of Rows
QASTOTALBLOCKS Number(12,0) DECIMAL(12) NOT NULL Total Number of Blocks
QASTOTALBYTES Number(12,0) DECIMAL(12) NOT NULL Total Number of bytes
QASERRORMSG Character(254) VARCHAR2(254) NOT NULL Error Message
QASDATAPATH Character(254) VARCHAR2(254) NOT NULL Directory Name
CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19