PSPTQRYDEFS_VW

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 NameField TypeColumn TypeDescription
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
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
SELCOUNTNumber(2,0)SMALLINT NOT NULLSelect Count
EXPCOUNTNumber(3,0)SMALLINT NOT NULLExpression Count
BNDCOUNTNumber(3,0)SMALLINT NOT NULLBind Count
QRYVALIDNumber(1,0)SMALLINT NOT NULLValid Query
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.
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.
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