The Data Questions command lets you create a client-friendly Excel workbook from the errors logged in the current database, with each error displayed on a separate worksheet (tab). The Excel workbook can be sent to your client or colleague to provide data corrections. These corrections can then be merged back in using Import Corrections.

You can customize the questions to suit your client, including selecting which errors will be sent to your client, wording the error/question in a client-friendly way, selecting which fields will be displayed, providing client-friendly column titles, and more.

To generate data questions, open the database, click ​Screen > Data Questions​, and follow the step-by-step wizard. Here are some specific tips:

• Step 1: Errors & warnings to ask client about.

  • Deselect (i.e., uncheck) any errors you don't want to ask your client about, e.g., because you'll apply a data default. If there are specific records (as opposed to errors) that you don't want to ask your client about, approve the errors for those records first -- see Approve data errors. 

  • To reuse previous settings or manage saved Data Questions styles, click the Style link.

• Step 2: Error & warning descriptions. For each error, provide a client-friendly question or description. To combine errors, specify the same description for them. For example, you might combine missing birth date and invalid age errors under the single description "Birth date issues".

• Step 3: Fields to display.

• You must specify at least one field to identify records. These fields are shown for all errors. They are intended to help the client identify the records. They are also used along with RecID as a key when importing corrections to match records between the workbook and ProVal. Since RecID is part of the key, there is no need for the values in the identifier fields to be unique.

• For each error, specify additional fields to be included in the worksheet. This may included prior year fields (prefixed with "py.") if the error test involves prior year data. By default, all fields involved in the test are included.

• Step 4: Column titles and coded field labels.

• For each field that will be included, provided a client-friendly column title. For example, such as "Date of hire" instead of "DOH". Use "^" to start a new line, as in "Date^of hire".

• Similarly, click Coded Field Labels link to specify client-friendly labels for each coded field that will be included. For example, such as "Retired" instead of "R".

• Step 5: Headings. Specify two lines of headings that will appear at the top of each worksheet (tab) in the Excel workbook. For example, plan name on line 1 and "Actuarial Valuation Data Review" on line.

Click Finish to generate the Excel workbook. (ProVal will also prompt you to save your customizations in the Data Questions style library for reuse in the future.) This workbook can be sent to your client to make corrections. Please ensure that Personally Identifiable Information (PII) is transmitted securely. Any transmission of PII is your responsibility.

Once corrections have been made to the workbook, use Import Corrections to merge them back into the database. 

​

The Excel workbook is based on the Excel template "Data Questions - Template.xltx", which can be found in the ProVal installation folder. You can customize this template in minor ways, such as changing fonts and colors.