---
category: [Administration & Integrations, Platform and Product Extensions, Platform and Product Extensions/Integration, Administration & Integrations/Custom Integrations & Apps, Platform and Product Extensions/Workday Extend]
keyword: [Extend, monitor, troubleshoot]
nav: wcp_docs
parent_url: /wcp_docs/
title: >- 
  Reference: WQL Performance Log Fields
layout: subsection
---

## <a id="section_report_summary"></a>Report Summary

<table><thead><tr><th>Log Field</th><th>Description</th></tr></thead><tbody><tr><td><b>Log</b></td><td>The tenant in which you executed the WQL query.</td></tr><tr><td><b>Report Type</b></td><td>A 3-letter abbreviation for the type of report logged. <p>Possible values:</p> <ul><li>ADV - Advanced
</li><li>FAC - Faceted Search
</li><li>MTX - Matrix
</li><li>TRD - Trending
</li><li>NBX - nBox
</li><li>SIM - Simple
</li><li>TPS - Transposed
</li></ul></td></tr><tr><td><b>Executed by User</b></td><td>The user who ran the report.</td></tr><tr><td><b>Data Source</b></td><td>Data source of the logged report.</td></tr><tr><td><b>Execution Status</b></td><td>Displays if the report ran successfully. <p>If you select the <b>Notify me later</b> check box when you run the report, the original report log displays a status of Failed and creates another report log for the report when it runs in the background.</p></td></tr><tr><td><b>Data Source Processing Mode</b></td><td>Displays how the report processed the data source: as standard, indexed, or hybrid. This field doesn’t display for composite reports. <p>Possible values:</p> <ul><li>Object Graph - The report processed the data source as a standard data source.
</li><li>Indexed - The report processed the data source as an indexed data source.
</li><li>Hybrid - The report processed the data source as an indexed data source with additional functions.
</li></ul></td></tr><tr><td><b>Filter Processing Mode</b></td><td>Displays how the report processed the fields used for filtering: as standard, indexed, or hybrid. <p>Possible values:</p> <ul><li>Object Graph - The report evaluates the fields selected for filtering outside of an indexed data source.
</li><li>Indexed - The report evaluates the fields selected for filtering inside of an indexed data source.
</li><li>Hybrid - The report evaluates the fields selected for filtering both inside and outside of an indexed data source.
</li></ul></td></tr><tr><td><b>Grouping Processing Mode</b></td><td>Displays how the report processed the fields used for grouping: as standard, indexed, or hybrid. <p>Possible values:</p> <ul><li>Object Graph - The report evaluates group by fields outside of an indexed data source.
</li><li>Indexed - The report evaluates group by fields inside of an indexed data source.
</li><li>Hybrid - The report evaluates group by fields both inside and outside of an indexed data source.
</li></ul></td></tr><tr><td><b>Report Execution Date and Time</b></td><td>Date and time when the report finished running.</td></tr><tr><td><b>Maximum Report Processing Time (s)</b></td><td>Maximum time a report runs before timing out. <p>By default, a report run by a user runs for 30 minutes. A report that ran in the background runs for 6 hours. A report that ran as a worklet runs for 30 seconds. Your tenant administrator can change these default values for your tenant.</p></td></tr><tr><td><b>Data Source Instance Count</b></td><td>Number of business object instances the data source returns. <p>This field displays a count of zero if the:</p> <ul><li>Data source returns zero instances.
</li><li>Report is a matrix report that's <b>Optimized for Performance</b>.
</li><li>Data source is a hybrid of standard and indexed data sources.
</li></ul></td></tr><tr><td><b>Data Source Instance Count (Post Security Processing)</b></td><td>Number of business object instances remaining after security processing. <p>This field displays a count of zero if the:</p> <ul><li>Report runs contextual security on the data source.
</li><li>Report runs contextual security and eliminates all instances from displaying.
</li><li>Report is a matrix report that's <b>Optimized for Performance</b>.
</li></ul></td></tr><tr><td><b>Report Instance Count</b></td><td>Number of business object instances the report returns after security, filter, and other processing. <p>This field displays a count of zero if the:</p> <ul><li>Report is a matrix report that's <b>Optimized for Performance</b>.
</li><li>Report is a matrix report and the data source is a hybrid of standard and indexed data sources.
</li></ul> <p>If the report is a matrix report that's <b>Optimized for Performance</b>, a unique instance count of all groups displays in the <b>Matrix Summarization</b> section of the:</p><ul><li><b>Development Report Performance Log</b>.
</li><li><b>Support Report Performance Log</b>.
</li></ul></td></tr></tbody></table><br/>

## <a id="section_vt5_kwf_rfb"></a>Report Performance Metrics

<table><thead><tr><th>Log Field</th><th>Description</th></tr></thead><tbody><tr><td><b>Total Execution Time (ms)</b></td><td>Time spent running the report.</td></tr><tr><td><b>Total CPU Execution Time (ms)</b></td><td>Total time of each concurrent thread for each time bucket. This value doesn’t contribute to <b>Total Execution Time (ms)</b>. This field is only available if you enable <b>Parallel Processing</b>. <p>For composite reports, this field always displays zero.</p></td></tr><tr><td><b>Initialization Time (ms)</b></td><td>Time spent building the report definition model. During this time, the report evaluates parameter processing and static filters.</td></tr><tr><td><b>Data Source Time (ms)</b></td><td>Time spent identifying the data source and retrieving the business object instances that the report uses.</td></tr><tr><td><b>Data Source Security Time (ms)</b></td><td>Time spent evaluating security access to the data source. <p>This field displays zero if the data source contains no security.</p> <p>If the data source is secured to an unconstrained security group while some instances of the business object are secured to a constrained security group, this field displays the time spent evaluating security access for the constrained security group.</p></td></tr><tr><td><b>Top Level Filter Time (ms)</b></td><td>Time spent applying all filters in the report definition, including filters at the data source, field, and subfilter levels. <p>This field displays zero if there's no filtering on the data source.</p></td></tr><tr><td><b>Top Level Sort Time (ms)</b></td><td>Time spent applying all sort options in the report definition. <p>This field displays zero if the report:</p> <ul><li>Is a search report based on a Syman data source.
</li><li>Is a facet selection.
</li><li>Has paginated results.
</li></ul></td></tr><tr><td><b>Processing Time (ms)</b></td><td>Time spent processing all calculations and fields and delivering all business object instances in the report results. Includes time for generating data for fields and columns. <p>This field displays zero if the report ran for the first time and contains paginated results.</p></td></tr><tr><td><b>Filter Tree Time (ms)</b></td><td>Time spent building the filter tree while initializing the report definition. <p>This field displays zero if:</p> <ul><li>There are no filters on the report.
</li><li>The report execution is an interaction. Example: Drill down, paginated report results, outlining, facet search.
</li></ul></td></tr><tr><td><b>Report Parameters Evaluation Time (ms)</b></td><td>Time spent evaluating all user-entered prompt values while initializing the report. <p>This field displays zero when:</p> <ul><li>There are no prompts on the report.
</li><li>The report execution is an interaction and reuses the initial prompt values from the initial report execution. Example: Drill down, paginated report results, outlining, facet search.
</li></ul></td></tr></tbody></table><br/>

## <a id="section_qjk_yxf_rfb"></a>WQL Information

<table><thead><tr><th>Log Field</th><th>Description</th></tr></thead><tbody><tr><td><b>WQL Query String</b></td><td>The WQL query that you executed.</td></tr><tr><td><b>WQL Obfuscated Query String</b></td><td>The WQL query that you executed with the data source and fields names replaced by their instance IDs. Not available on the Customer Report Performance Log.</td></tr></tbody></table><br/>

## <a id="section_ymt_yxf_rfb"></a>Report Prompts

The report prompts in this section can come from the data source and data source filters.

<table><thead><tr><th>Log Field</th><th>Description</th></tr></thead><tbody><tr><td><b>Prompt Field</b></td><td>Prompt fields that the report evaluates.</td></tr><tr><td><b>Prompt Value(s)</b></td><td>Values for the prompt field.</td></tr><tr><td><b>Count</b></td><td>(Workday Support only) Count of how many instance prompt values are selected. <p>Possible values:</p> <ul><li>Blank - The value for the prompt isn’t an instance value.
</li><li>Zero - No instances were selected for the prompt.
</li><li>Greater than zero - The number of instance values selected for the prompt.
</li></ul></td></tr><tr><td><b>Hash Code</b></td><td>(Workday Support only) Hash code used to recreate the instance prompt selected values.</td></tr></tbody></table><br/>

## <a id="section_n25_myf_rfb"></a>Field Performance Metrics

<table><thead><tr><th>Log Field</th><th>Description</th></tr></thead><tbody><tr><td><b>Field</b></td><td>Name of the field in the report, data source, or data source filter.</td></tr><tr><td><b>Field Type</b></td><td>Type of field in the report. <p>Possible values:</p> <ul><li>Calculated
</li><li>Calculated - Report Specific
</li><li>Computed
</li><li>Custom Field
</li><li>Workday-delivered
</li></ul></td></tr><tr><td><b>Total Field Security (ms)</b></td><td>Time spent evaluating the security for the field.</td></tr><tr><td><b>Total (ms)</b></td><td>Time spent processing this field, not including <b>Total Field Security</b> time. <p>The total time is the sum of the <b>Data Source Processing</b> time and the <b>Report Processing</b> time.</p></td></tr><tr><td><b>Initialization (ms)</b></td><td>Time spent initializing static values. Example: Effective moment.</td></tr><tr><td><b>Data Source (ms)</b></td><td>Time spent evaluating the field in the data source. <p>This field displays zero when:</p> <ul><li>The data source is indexed and Workday doesn't evaluate the field outside of the data source.
</li><li>The data source doesn't use the field.
</li></ul></td></tr><tr><td><b>Data Source Security (ms)</b></td><td>Time spent evaluating the field security in the data source. <p>This field displays zero when Workday doesn't evaluate the field for data source security.</p></td></tr><tr><td><b>Contextual Security Filter (ms)</b></td><td>Time spent filtering logic for the data source that calls this field during execution. <p>This field displays zero when there’s no contextual security.</p></td></tr><tr><td><b>Report Processing (ms)</b></td><td>Time spent filtering, sorting, processing, and so on. <p>This field displays zero when the report field is only in the data source.</p></td></tr><tr><td><b>Times Executed</b></td><td>Number of times the field executes, including when the field nests under other fields.</td></tr></tbody></table><br/>

## <a id="section_int_kx1_sfb"></a>Advanced Metrics

This section is for Workday Support use only.