PSPTQRYDEFN_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
4 QRYTYPE Number(1,0) SMALLINT NOT NULL Query type field with translates for Query
5 QRYVALID Number(1,0) SMALLINT NOT NULL Valid Query
6 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.
7 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.
8 QRYAPPROVED Character(1) VARCHAR2(1) NOT NULL Approved
9 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
10 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
11 APPROVEOPRID Character(30) VARCHAR2(30) NOT NULL Approver's Oper ID
12 APPROVEDTTM DateTime(26) TIMESTAMP DateTime of Query Approval
13 EXECLOGGING Character(1) VARCHAR2(1) NOT NULL Flag for Logging Qry Execution
14 QRYDISABLED Character(1) VARCHAR2(1) NOT NULL Query Disabled
N=No
Y=Yes
15 QRYFOLDER Character(18) VARCHAR2(18) NOT NULL Query Folder
16 QRYJOINOPTIMIZE Number(1,0) SMALLINT NOT NULL Security Join Optimizer

Default Value: 0