PSPTQRYDEFN_VW

index back

Query Definitions

Definition Security view.
SELECT QRYNAME , OPRID , VERSION , QRYTYPE , QRYVALID , LASTUPDOPRID , LASTUPDDTTM , QRYAPPROVED , CREATEOPRID , CREATEDTTM , APPROVEOPRID , APPROVEDTTM , EXECLOGGING , QRYDISABLED , QRYFOLDER , QRYJOINOPTIMIZE FROM %Table(PSQRYDEFN)

PeopleSoft Field Name Field Type Column Type Description
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
QRYTYPE Number(1,0) SMALLINT NOT NULL Query type field with translates for Query
QRYVALID Number(1,0) SMALLINT NOT NULL Valid Query
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
QRYAPPROVED Character(1) VARCHAR2(1) NOT NULL Approved
CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
APPROVEOPRID Character(30) VARCHAR2(30) NOT NULL Approver's Oper ID
APPROVEDTTM DateTime(26) TIMESTAMP DateTime of Query Approval
EXECLOGGING Character(1) VARCHAR2(1) NOT NULL Flag for Logging Qry Execution
QRYDISABLED Character(1) VARCHAR2(1) NOT NULL Query Disabled
N=No
Y=Yes
QRYFOLDER Character(18) VARCHAR2(18) NOT NULL Query Folder
QRYJOINOPTIMIZE Number(1,0) SMALLINT NOT NULL Security Join Optimizer

Default: 0

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19