SCRTY_QUERY |
index back |
|---|---|
PS/Query Profile |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 CLASSID |
Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| QRY_RUN_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Only Allowed to run Queries
Y/N Table Edit Default: N |
| QRY_CREATE_PUBLIC | Character(1) | VARCHAR2(1) NOT NULL |
Allow create of Public Queries
Y/N Table Edit Default: N |
| QRY_CREATE_WFLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow create of Workflow Query
Y/N Table Edit Default: N |
| QRY_MAX_FETCH | Number(5,0) | INTEGER NOT NULL | Maximum Rows Fetched |
| QRY_MAX_RUN | Number(4,0) | SMALLINT NOT NULL | Maximum Run Time in Minutes |
| QRY_ADV_DISTINCT | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Distinct
Y/N Table Edit Default: N |
| QRY_ADV_ANY_JOIN | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of 'Any Join'
Y/N Table Edit Default: N |
| QRY_ADV_SUBQUERY | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Subquery/Exists
Y/N Table Edit Default: N |
| QRY_ADV_UNION | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Union
Y/N Table Edit Default: N |
| QRY_ADV_EXPR | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Expressions
Y/N Table Edit Default: N |
| QRY_MAX_JOINS | Number(1,0) | SMALLINT NOT NULL | Maximum Joins Allowed |
| QRY_MAX_IN_TREE | Number(1,0) | SMALLINT NOT NULL | Maximum 'In Tree' Criteria |
| QRY_OUT_LISTBOX | Character(1) | VARCHAR2(1) NOT NULL |
Run
Y/N Table Edit Default: N |
| QRY_OUT_NVISION | Character(1) | VARCHAR2(1) NOT NULL |
Run to Excel
Y/N Table Edit Default: N |
| QRY_OUT_CRYSTAL | Character(1) | VARCHAR2(1) NOT NULL |
Run to Crystal
Y/N Table Edit Default: N |
| QRY_ADM_AUTOPUBLIC | Character(1) | VARCHAR2(1) NOT NULL | Flag to approve public queries |
| QRY_ADM_AUTOPRIV | Character(1) | VARCHAR2(1) NOT NULL | Auto-approve Private Queries |
| QRY_ADM_LIMUNAPPRV | Character(1) | VARCHAR2(1) NOT NULL | Limit number of rows for U Qry |
| QRY_ADM_UNAPP_ROWS | Number(4,0) | SMALLINT NOT NULL | Maximum Run Time in Seconds |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |