Data Guidelines

The Query Overview accepts JSON data of the format returned by d3.csv(). The renderer visualizes clinical query data with one row per query plus the required variables specified below.

Data structure

one record per query

Data specification

required and optional variables:

Setting	Default	Data Type	Description	Required?
site_col	sitename	character	site variable name	Yes
id_col	subjectnameoridentifier	character	participant ID variable name
visit_col	folderoid	character	visit/folder variable name	Yes
visitDescription_col	folderinstancename	character	visit/folder description variable name
form_col	formoid	character	form variable name	Yes
formDescription_col	ecrfpagename	character	form description variable name
field_col	fieldname	character	field variable name	Yes
fieldDescription_col	fieldlabel	character	field description variable name
marking_group_col	markinggroup	character	query origin variable name	Yes
open_by_col	queryopenby	character	entity opening query variable name
query_col	querytext	character	query text variable name
query_response_col	queryresponsetext	character	query response text variable name
status_col	querystatus	character	query status variable name	Yes
open_date_col	queryopendate	character	query open date variable name
response_date_col	queryresponsedate	character	query response date variable name
resolved_date_col	queryresolveddate	character	query resolution date variable name
recency_col	odays	numeric	query recency variable measured in days between query open date and data snapshot date, regardless of query status
recency_category_col	open_time	character	query recency category variable name; overrides recency_col
age_col	qdays	numeric	query age variable measured in days between query open date and data snapshot date, query response date, or query resolution date for open, answered, and resolved queries, respectively	Yes
groups[]		either	an array of variables by which to count queries; each value of the variable is plotted on the y-axis
status_groups[]		either	an array of variables with which to stratify each group-by value, each value of which plots as a component of a stacked bar when Bar Arrangement is set to Stacked or as individual bars when Bar Arrangement is set to grouped
filters[]		either	an array of variables with which to filter the data
details[]		either	an array of variables which will print in the listing; if unspecified all variables in data will appear in listing