Viewing Delivered Elements

This chapter provides an overview of how to view delivered elements using the GP_ELEMENTS query and discusses how to:

Access the GP_ELEMENTS query.
Run the GP_ELEMENTS query.

Understanding How to View Delivered Elements

Use the GP_ELEMENTS query to view a list of elements that are defined for your system. You can view elements defined for all countries or a specific country, view elements by category or name, or a combination of these criteria. If you are using the query to view system elements, the query retrieves information about the purpose of each system element and how and when it is resolved.

Page Used to Access and Run the GP_ELEMENTS Query

Page Name	Object Name	Navigation	Usage
Query Manager	QRY_SELECT	Reporting Tools, Query, Query Manager To access the GP_ELEMENTS query, enter GP_ELEMENTS in the Search By Query Name field on the Query Manager page and click the Search button.	Access the GP_ELEMENTS query.
GP_ELEMENTS – Global Payroll Elements	QRY_SELECT	Click the HTML link under Run to HTML on the Query Manager page, or click the Excel link under Run to Excel on the Query Manager page for the GP_ELEMENTS query.	Generate query results using the GP_ELEMENTS query.

Page Name

Object Name

Navigation

Usage

Query Manager

QRY_SELECT

Reporting Tools, Query, Query Manager

To access the GP_ELEMENTS query, enter GP_ELEMENTS in the Search By Query Name field on the Query Manager page and click the Search button.

Access the GP_ELEMENTS query.

GP_ELEMENTS – Global Payroll Elements

QRY_SELECT

Click the HTML link under Run to HTML on the Query Manager page, or click the Excel link under Run to Excel on the Query Manager page for the GP_ELEMENTS query.

Generate query results using the GP_ELEMENTS query.

Accessing the GP_ELEMENTS Query

Access the Query Manager page.

Edit

Click to edit field properties and sort order for your query.

Run to HTML

Click to run the query and generate an online view of the delivered elements. Once you've defined your search criteria for the GP_ELEMENTS query, in addition to viewing results online, you also have the option of downloading the results into a Microsoft Excel spreadsheet or a CSV text file.

Run to Excel

Click to run the query and send the results in a Microsoft Excel spreadsheet.

Note. If you cannot see the comment field for an element in Excel, change the format of the field, or view the output in html.

Schedule

Click to define criteria for scheduling a query.

Running the GP_ELEMENTS Query

Access the GP_ELEMENTS – Global Payroll Elements page.

To run the query, enter your search criteria and click the View Results button. Modify the query results by using the criteria described below.

Used By	Identify whether you want to view elements for All Countries or a Specific Country.
Country	If you select All Countries in the Used By field, enter ALL in the Country field. If you select Specific Country in the Used By field, enter the country code for which you want to view elements.
Category and Element Name	To narrow your results, you can enter a functional category code, such as ABS, for absences. You can also enter part of or all of an element name. Note. For information about category and element naming conventions, see the country extension PeopleBooks.
View Results	Click to view the results online or download the results to a Microsoft Excel file.

Edit	Click to edit field properties and sort order for your query.
Run to HTML	Click to run the query and generate an online view of the delivered elements. Once you've defined your search criteria for the GP_ELEMENTS query, in addition to viewing results online, you also have the option of downloading the results into a Microsoft Excel spreadsheet or a CSV text file.
Run to Excel	Click to run the query and send the results in a Microsoft Excel spreadsheet. Note. If you cannot see the comment field for an element in Excel, change the format of the field, or view the output in html.
Schedule	Click to define criteria for scheduling a query.