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 NameField TypeColumn TypeDescription
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
QRYTYPENumber(1,0)SMALLINT NOT NULLQuery type field with translates for Query
QRYVALIDNumber(1,0)SMALLINT NOT NULLValid Query
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
QRYAPPROVEDCharacter(1)VARCHAR2(1) NOT NULLApproved
CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
APPROVEOPRIDCharacter(30)VARCHAR2(30) NOT NULLApprover's Oper ID
APPROVEDTTMDateTime(26)TIMESTAMPDateTime of Query Approval
EXECLOGGINGCharacter(1)VARCHAR2(1) NOT NULLFlag for Logging Qry Execution
QRYDISABLEDCharacter(1)VARCHAR2(1) NOT NULLQuery Disabled
N=No
Y=Yes
QRYFOLDERCharacter(18)VARCHAR2(18) NOT NULLQuery Folder
QRYJOINOPTIMIZENumber(1,0)SMALLINT NOT NULLSecurity Join Optimizer

Default: 0

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