SCRTY_QUERY

Return to Index

PeopleSoft Field NameField TypeDescription
CLASSIDVARCHAR2(30) NOT NULLThe name of the class
VERSIONDECIMAL(10) NOT NULLVersion
QRY_RUN_ONLYVARCHAR2(1) NOT NULLOnly Allowed to run Queries

Y/N Table Edit

Default: N

QRY_CREATE_PUBLICVARCHAR2(1) NOT NULLAllow create of Public Queries

Y/N Table Edit

Default: N

QRY_CREATE_WFLOWVARCHAR2(1) NOT NULLAllow create of Workflow Query

Y/N Table Edit

Default: N

QRY_MAX_FETCHINTEGER NOT NULLMaximum Rows Fetched
QRY_MAX_RUNSMALLINT NOT NULLMaximum Run Time in Minutes
QRY_ADV_DISTINCTVARCHAR2(1) NOT NULLAllow use of Distinct

Y/N Table Edit

Default: N

QRY_ADV_ANY_JOINVARCHAR2(1) NOT NULLAllow use of 'Any Join'

Y/N Table Edit

Default: N

QRY_ADV_SUBQUERYVARCHAR2(1) NOT NULLAllow use of Subquery/Exists

Y/N Table Edit

Default: N

QRY_ADV_UNIONVARCHAR2(1) NOT NULLAllow use of Union

Y/N Table Edit

Default: N

QRY_ADV_EXPRVARCHAR2(1) NOT NULLAllow use of Expressions

Y/N Table Edit

Default: N

QRY_MAX_JOINSSMALLINT NOT NULLMaximum Joins Allowed
QRY_MAX_IN_TREESMALLINT NOT NULLMaximum 'In Tree' Criteria
QRY_OUT_LISTBOXVARCHAR2(1) NOT NULLRun

Y/N Table Edit

Default: N

QRY_OUT_NVISIONVARCHAR2(1) NOT NULLRun to Excel

Y/N Table Edit

Default: N

QRY_OUT_CRYSTALVARCHAR2(1) NOT NULLRun to Crystal

Y/N Table Edit

Default: N

QRY_ADM_AUTOPUBLICVARCHAR2(1) NOT NULLFlag to approve public queries
QRY_ADM_AUTOPRIVVARCHAR2(1) NOT NULLAuto-approve Private Queries
QRY_ADM_LIMUNAPPRVVARCHAR2(1) NOT NULLLimit number of rows for U Qry
QRY_ADM_UNAPP_ROWSSMALLINT NOT NULLMaximum Run Time in Seconds

Author: PeopleTools 8.52

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 04 January 2014