Contributions Benchmarking Distribution Report

Group Results By *

Select Group Size, Coverage Type, Account Location, Account Industry, or By Renewal Years to determine how the data is grouped on the report.

Account Location is based on the Main Address entered for the account.  Account Industry is based on the Primary Industry selected for the account. By Renewal Years is based on the year the plan renews.

Line of Coverage *

Select Medical, Dental, Vision, Life and AD&D, Short Term Disability, or Long Term Disability to include that line of coverage in the report.

In Force Date *

Use this parameter to select plans that were in force on the specified date for inclusion on the report.

• Enter the date in MM/DD/YYYY format, or

• Click the calendar icon and select a date, or

• Click Relative Date to specify a variable date that is relative to the date the report is run. For help with this tool, see  Specifying Relative Dates or click the Help icon in the upper right corner of the relative date popup box.

Plan Type(s) *

Select one or more Plan Types to filter data returned on the report. Values in this list depend on the Line of Coverage selected above. Click the arrows to move your select(s) between the Available and Selected lists.

Tier Schedule(s) *

Select one or more Tier Schedules. Use Ctrl-click to select multiple items in the list. Contributions with contribution schedules with those tier schedules are included in the results.  

Report on defined contribution/flex credit arrangement *

Select Yes to include only defined contribution/flex credit arrangement contribution schedules in the results. If No, defined contribution/flex credit arrangement schedules are excluded from the benchmarking.

Select a field to by which you want to show the contribution distribution within each group selected in Group By above. For example, if you choose to group by Account State, and distribution by Plan Type, the report displays a separate row for each Account State/Plan Type combination.

NY

Medical HMO

4

NY

Medical PPO

3

NJ

Medical HMO

6

Select Union/Non-union Plans

Select Union Plans or Non-Union Plans, or use Ctrl-click to select both.

Group Size

Select one or more items to limit the data to the selected Group Size(s). Click the arrows to move your selections between the Available and Selected lists.

Primary Industry(s)

Select one or more items to limit the data to the selected Industry(s). Click the arrows to move your selections between the Available and Selected lists.

SIC Code From

SIC Code To

Enter a two- to four-digit number. The report results are limited to accounts with SIC Codes starting with the numbers you input.  

Example:
Account 1: SIC Code 1521
Account 2: SIC Code 1531
Account 3: SIC Code 152
Account 4: SIC Code 251

You enter SIC Code From: 15 and SIC Code To: 16.

The report includes Accounts 1, 2, and 3.

Business Type

Select one or more Business Types to limit report to accounts with those Business Types.  Click the arrows to move your selection(s) between the Available and Selected lists.

Main Address State

Select one or more State(s) to limit the data on the report to accounts with the selected state as the main address. Click the arrows to move your selections between the Available and Selected lists.

Main Address CBSA

Select one or more CBSAs to limit the accounts on the report to the selected CBSAs. CBSAs available depend on the state selected above.

Click the arrows to move your selections between the Available and Selected lists.

Report Results Title

Use this field to enter your own title for the report.

Show Parameters

If selected, the report will list the parameters used to create the report.

To get Report Results in

The following output options are available for this report:

• Excel

Save Report Parameters

If you run this report with this set of parameter selections frequently, enter a title to save the set of parameters you just entered. You can run the report again at any time by selecting the saved parameter set on the My Reports tab.

Save Report Results

To save the report with the results, so that you can easily view the report again later, enter a title and click Save.  You can view the report again at any time by selecting the report on the My Reports tab.