SCRTY_QUERY | |
Table: PS_SCRTY_QUERY |
| PeopleSoft Field Name | Description |
|---|---|
 CLASSID | The name of the class |
| VERSION | Internal PeopleTools version to control reloading of objects in cache. |
| QRY_RUN_ONLY | Only Allowed to run Queries Y/N Table Edit Default: N |
| QRY_CREATE_PUBLIC | Allow create of Public Queries Y/N Table Edit Default: N |
| QRY_CREATE_WFLOW | Allow create of Workflow Query Y/N Table Edit Default: N |
| QRY_MAX_FETCH | Maximum Rows Fetched |
| QRY_MAX_RUN | Maximum Run Time in Minutes |
| QRY_ADV_DISTINCT | Allow use of Distinct Y/N Table Edit Default: N |
| QRY_ADV_ANY_JOIN | Allow use of 'Any Join' Y/N Table Edit Default: N |
| QRY_ADV_SUBQUERY | Allow use of Subquery/Exists Y/N Table Edit Default: N |
| QRY_ADV_UNION | Allow use of Union Y/N Table Edit Default: N |
| QRY_ADV_EXPR | Allow use of Expressions Y/N Table Edit Default: N |
| QRY_MAX_JOINS | Maximum Joins Allowed |
| QRY_MAX_IN_TREE | Maximum 'In Tree' Criteria |
| QRY_OUT_LISTBOX | Run Y/N Table Edit Default: N |
| QRY_OUT_NVISION | Run to Excel Y/N Table Edit Default: N |
| QRY_OUT_CRYSTAL | Run to Crystal Y/N Table Edit Default: N |
| QRY_ADM_AUTOPUBLIC | Flag to approve public queries |
| QRY_ADM_AUTOPRIV | Auto-approve Private Queries |
| QRY_ADM_LIMUNAPPRV | Limit number of rows for U Qry |
| QRY_ADM_UNAPP_ROWS | Maximum Run Time in Seconds |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |