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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19