Select Variables & Participant Fields

Home / DatStat Connect / Population Management / Data / Create a New Query / Select Variables & Participant Fields

The third step in building a query is to select which Variables and/or Participant Fields are to be included in the results. These data points are selected in the Variables & Participant Fields sections of the New Query page.

2017-02-09 10_20_33-POPULATION NAME

The Variables tab displays the variables within the Activity Variables are organized by Collection.  Each collection can be collapsed or expanded using the icon appearing next to the collection name.

The Participant Fields tab displays the participant fields configured for the population. The ability to include Participant Fields in a query is controlled by user permissions.  A user must have “participant view” permissions to include this type of data.  Participant fields are displayed by group. Each field group can be collapsed or expanded using the icon appearing next to the group name.

  1. Click on the Variables tab.

2017-02-08 14_00_35-POPULATION NAME

  1. Check the checkboxes next to the individual variables that are to be included in the query results. If an entire collection of variables is required, check the checkbox next to the collection name to select all of the variables within that collection.

2017-02-08 14_00_55-POPULATION NAME

  1. Search for a particular variable by typing into the Search Box and pressing Enter. The list will update so that only variables whose names contain the text typed into the search box will be shown.

2017-02-09 10_17_38-POPULATION NAME

  1. Filter the list of variables by using the quick filter button group options. By default, All is selected and all variables are shown

2017-02-09 10_16_21-POPULATION NAME

  • Structured Data:  Quantitative, non-verbatim data.
  • Unstructured Data: Qualitative verbatim data.
  1. Click on the Participant Fields tab.

2017-02-08 14_02_20-POPULATION NAME

  1. Check the checkboxes next to the individual participant fields that are to be included in the query results. If an entire group of fields is required, check the checkbox next to the group name to select all of the participant fields within that group.

2017-02-08 14_02_08-POPULATION NAME

  1. Search for a particular participant field by typing into the Search Box and pressing Enter. The list will update so that only fields whose names contain the text typed into the search box will be shown.

2017-02-09 10_17_05-POPULATION NAME

  1. Filter the list of participant fields by using the quick filter button group options. By default, All is selected and all fields are shown

2017-02-09 10_16_35-POPULATION NAME

  • PHI: Participant fields designated as PHI (Protected Health Information).
  • PII:  Participant fields designated as PII (Personally Identifiable Information).