PSPTQRYDEFS_VW

(SQL View)
Index Back

Query Definition Securtiy View


SELECT A.QRYNAME , A.VERSION , A.QRYTYPE , A.SELCOUNT , A.EXPCOUNT , A.BNDCOUNT , A.QRYVALID , A.LASTUPDDTTM , A.LASTUPDOPRID , A.QRYAPPROVED , A.CREATEOPRID , A.CREATEDTTM , A.APPROVEOPRID , A.APPROVEDTTM , A.EXECLOGGING , A.QRYDISABLED , A.QRYFOLDER , A.QRYJOINOPTIMIZE FROM PSQRYDEFN A WHERE A.QRYTYPE=1 AND A.OPRID = ' '

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

Default Value: 0