EOPM_QRYPRFL(SQL Table) |
Index Back |
|---|---|
Query Profile MetadataStores metadata to update Query Profile settings (PUM Update Automation) This record is used to specify query profile permissions like allowed to run queries, create public queries, role process archive queries, max rows, max time (timeout) etc. |
| # | 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 | PTIASPRPTNO |
Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
| 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 |