OPRIDQRYNAMEInternal PeopleTools version for controlling caching of object.
Y=Yes
N=No
Y=Yes
N=No
PSQRYDEFN |
PS/Query Definition
| PeopleSoft Field Name | Description |
|---|---|
| OPRID | Operator ID of Owner. Blank for Public Queries |
| QRYNAME | Query Name |
| DESCR | Description |
| VERSION | Version Number (OBJECTTYPE = 'QDM', also on PSLOCK) Internal PeopleTools version for controlling caching of object. |
| QRYTYPE | Query type field with translates for Query |
| SELCOUNT | Select Count |
| EXPCOUNT | Expression Count |
| BNDCOUNT | Bind Count |
| QRYVALID | Valid Query |
| LASTUPDDTTM | 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. |
| LASTUPDOPRID | 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. |
| DESCRLONG | Long Description of Query. |
| QRYAPPROVED | Approved |
| CREATEOPRID | A user's ID |
| CREATEDTTM | Date/Time of Query Creation |
| APPROVEOPRID | Approver's Operator ID |
| APPROVEDTTM | Date/Time of Query Approval |
| EXECLOGGING | Flag for Logging Query Execution to table PSQRYEXECLOG Y=Yes N=No |
| QRYDISABLED | Query Disabled Y=Yes N=No |
| QRYFOLDER | Query Folder |
Author: David Kurtz | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 26 July 2010 |