Queries

Queries are used with the Search Framework to extract data from the database for component and global searches. Queries must be assigned to an access group and a related security tree.

This section describes the Expenses record in the associated query structure, which can be viewed using the Query Access Manager page (Reporting Tools, Query, Query Manager).

Query Tree Definition

The security information for the Expenses tree definition is:

Query Tree Name	Access Group	Permission List
SEARCH_TREE_EX	EX_ACCESS_GROUP	EPEX9500

Types of Queries

PeopleSoft Expenses uses these types of queries for the PeopleSoft Search Framework:

• Primary Query

• Connected Query

• Related Query

• Delete Query

• Document level Security Query

For additional information about queries as they relate to the PeopleSoft Search Framework, see PeopleTools: PeopleSoft Search Technology.

The predefined queries for PeopleSoft Expense are:

Query Name	Description	Additional Information
EX_SRCH_BASE	Top level Search Framework Query for Expense Reports.	This is a primary query and uses SEARCH_TREE_EX as its security tree.
EX_SRCH_DIST	Expense Report distribution lines.	This is a related query.
EX_SRCH_HDR_ATTRIB	Expense Report Risk Level.	This is a related query.
EX_SRCH_SECURITY_SES_REPORT	Document security for Expense Reports. Displays all operator IDs that have access to the Expense Report.	This is a related query.
EX_SRCH_APPROVER	Expense Report Approver.	This is a related query.
EX_SRCH_LINE_DELETE	Expense Search Framework Line Delete.	This is a delete query.
EX_SRCH_HDR_LINE_CQ	Expense Component Search.	This is a connected query, and its parent query name is EX_SRCH_HDR_LINE.
EX_SRCH_SECURITY_SES_REPORT	Expense Report SHEET_ID Security.	This is a document-level security query.