SCRTY_QUERY(SQL Table) |
Index Back |
|---|---|
PS/Query Profile |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CLASSID |
Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 2 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 3 | QRY_RUN_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Only Allowed to run Queries
Y/N Table Edit Default Value: N |
| 4 | QRY_CREATE_PUBLIC | Character(1) | VARCHAR2(1) NOT NULL |
Allow create of Public Queries
Y/N Table Edit Default Value: N |
| 5 | QRY_CREATE_WFLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow create of Workflow Query
Y/N Table Edit Default Value: N |
| 6 | QRY_MAX_FETCH | Number(5,0) | INTEGER NOT NULL | Maximum Rows Fetched |
| 7 | QRY_MAX_RUN | Number(4,0) | SMALLINT NOT NULL | Maximum Run Time in Minutes |
| 8 | QRY_ADV_DISTINCT | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Distinct
Y/N Table Edit Default Value: N |
| 9 | QRY_ADV_ANY_JOIN | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of 'Any Join'
Y/N Table Edit Default Value: N |
| 10 | QRY_ADV_SUBQUERY | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Subquery/Exists
Y/N Table Edit Default Value: N |
| 11 | QRY_ADV_UNION | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Union
Y/N Table Edit Default Value: N |
| 12 | QRY_ADV_EXPR | Character(1) | VARCHAR2(1) NOT NULL |
Allow use of Expressions
Y/N Table Edit Default Value: N |
| 13 | QRY_MAX_JOINS | Number(1,0) | SMALLINT NOT NULL | Maximum Joins Allowed |
| 14 | QRY_MAX_IN_TREE | Number(1,0) | SMALLINT NOT NULL | Maximum 'In Tree' Criteria |
| 15 | QRY_OUT_LISTBOX | Character(1) | VARCHAR2(1) NOT NULL |
Run
Y/N Table Edit Default Value: N |
| 16 | QRY_OUT_NVISION | Character(1) | VARCHAR2(1) NOT NULL |
Run to Excel
Y/N Table Edit Default Value: N |
| 17 | QRY_OUT_CRYSTAL | Character(1) | VARCHAR2(1) NOT NULL |
Run to Crystal
Y/N Table Edit Default Value: N |
| 18 | QRY_ADM_AUTOPUBLIC | Character(1) | VARCHAR2(1) NOT NULL | Flag to approve public queries |
| 19 | QRY_ADM_AUTOPRIV | Character(1) | VARCHAR2(1) NOT NULL | Auto-approve Private Queries |
| 20 | QRY_ADM_LIMUNAPPRV | Character(1) | VARCHAR2(1) NOT NULL | Limit number of rows for U Qry |
| 21 | QRY_ADM_UNAPP_ROWS | Number(4,0) | SMALLINT NOT NULL | Maximum Run Time in Seconds |