SCRTY_QUERY

index back

PS/Query Profile


PeopleSoft Field NameField TypeColumn TypeDescription
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
QRY_RUN_ONLYCharacter(1)VARCHAR2(1) NOT NULLOnly Allowed to run Queries

Y/N Table Edit

Default: N

QRY_CREATE_PUBLICCharacter(1)VARCHAR2(1) NOT NULLAllow create of Public Queries

Y/N Table Edit

Default: N

QRY_CREATE_WFLOWCharacter(1)VARCHAR2(1) NOT NULLAllow create of Workflow Query

Y/N Table Edit

Default: N

QRY_MAX_FETCHNumber(5,0)INTEGER NOT NULLMaximum Rows Fetched
QRY_MAX_RUNNumber(4,0)SMALLINT NOT NULLMaximum Run Time in Minutes
QRY_ADV_DISTINCTCharacter(1)VARCHAR2(1) NOT NULLAllow use of Distinct

Y/N Table Edit

Default: N

QRY_ADV_ANY_JOINCharacter(1)VARCHAR2(1) NOT NULLAllow use of 'Any Join'

Y/N Table Edit

Default: N

QRY_ADV_SUBQUERYCharacter(1)VARCHAR2(1) NOT NULLAllow use of Subquery/Exists

Y/N Table Edit

Default: N

QRY_ADV_UNIONCharacter(1)VARCHAR2(1) NOT NULLAllow use of Union

Y/N Table Edit

Default: N

QRY_ADV_EXPRCharacter(1)VARCHAR2(1) NOT NULLAllow use of Expressions

Y/N Table Edit

Default: N

QRY_MAX_JOINSNumber(1,0)SMALLINT NOT NULLMaximum Joins Allowed
QRY_MAX_IN_TREENumber(1,0)SMALLINT NOT NULLMaximum 'In Tree' Criteria
QRY_OUT_LISTBOXCharacter(1)VARCHAR2(1) NOT NULLRun

Y/N Table Edit

Default: N

QRY_OUT_NVISIONCharacter(1)VARCHAR2(1) NOT NULLRun to Excel

Y/N Table Edit

Default: N

QRY_OUT_CRYSTALCharacter(1)VARCHAR2(1) NOT NULLRun to Crystal

Y/N Table Edit

Default: N

QRY_ADM_AUTOPUBLICCharacter(1)VARCHAR2(1) NOT NULLFlag to approve public queries
QRY_ADM_AUTOPRIVCharacter(1)VARCHAR2(1) NOT NULLAuto-approve Private Queries
QRY_ADM_LIMUNAPPRVCharacter(1)VARCHAR2(1) NOT NULLLimit number of rows for U Qry
QRY_ADM_UNAPP_ROWSNumber(4,0)SMALLINT NOT NULLMaximum Run Time in Seconds
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19