ERC Online Benchmarking Query Tool

What is the Query Tool?
What does the Query Tool allow me to do?
How can I use the Query Tool to view data?

What is the Query Tool?

ERC's surveys measure several interrelated components of an ethics and compliance program, including: expected program outcomes, ethical culture and formal program elements. Your subscription to ERC Online allows you to use the benchmarking query tool to sort selected data by those components (primary metric groups) and generate cross-tabs by management level.

You have limited access to ERC's benchmarks through the demo query tool. Clients who conduct surveys with ERC can use the tool to compare their own survey data to ERC's benchmarks. Organizations who donate their data to ERC can also purchase a subscription to obtain more comprehensive access to our benchmarks.

The data in the query tool are subsets of ERC's 2005 National Business Ethics Survey® (NBES), a household telephone survey of a random sample of employees across the United States. In 2005, ERC sampled 3,015 employees over the age of 18 who worked more than 20 hours per week in the 48 contiguous United States. To learn more about the data used in the query tool, click here.

What does the Query Tool allow me to do?

The demo query tool allows you to:

• View data and cross-tabs of the data by management level in table form
• Create bar graphs with the queries you run
• View the library site where subscribers can store queries and graphs

How can I use the Query Tool to view data?

1. Select the datasets you want to benchmark.
2. Select a primary metric group (outcomes, ethical culture, or formal programs).
3. This primary metric group will lead you to a subgroup that includes one specific metric.
4. If you click on the drop-down box under "Select Demographic (Optional):" you will have the option to view the data by management level.
5. Click "submit".
6. You will see your data in table form, and will be able to create charts.
7. You can print your tables and charts.

What Datasets are in the Query Tool?

The datasets you can view in this query tool are as follows:

• US 2005 (Programs) — This is a subset of the NBES designed to represent organizations who have ethics and compliance programs. The subset is defined by respondents who were aware that their organization had 6 elements of an ethics and compliance program, as defined by the U.S. Sentencing Commission's Federal Sentencing Guidelines for Organizations(FSGO): 1) written standards of conduct; 2) training on standards of conduct; 3) mechanism to seek advice about ethical issues; 4) mechanism to report misconduct anonymously; 5) supervisor disciplines employees who violate ethical standards; and 6) supervisor assesses ethical conduct in performance appraisals. If your organization already has an ethics and compliance program in place, this is the subset you should use as a benchmark.
• US 2005 (Partial or No Program) — This is a subset of the NBES consisting of employees who said their organization had at least one, but not all, of the six elements of an ethics and compliance program measured in the survey. This subset provides useful benchmarks for organizations that have a brand new ethics and compliance program, or that have not yet fully implemented a program.
• US 2005 — This dataset represents the averages of the entire NBES dataset. This subset provides useful benchmarks for organizations that do not have an ethics and compliance program.