How to Use Metadata Tables

Metadata tables guide implementation of the CDISC CDASH model to develop CRFs and the underlying database or other data collection structure. Metadata tables for the TIG are provided in the following sections:

Individual Health Metadata

Metadata tables are structured to present one row for each collection field with columns to describe expectations for the CRF and data management system design, mapping of collected data in tabulation datasets, as well as guidance for individuals involved in data collection. Columns describing CRF and data management system design are intended to assist the designers CRF(s) and the underlying database structures in remaining in conformance with the standard. When multiple options are contained in a single cell, the options are separated by a semicolon.

The columns in a metadata table are:

Column	For	Purpose
Observation Class	Tabulation Dataset Mapping	Specifies the SDTM class for the domain.
Domain	Tabulation Dataset Mapping	Specifies the 2-letter domain code.
Data Collection Scenario	Collection Guidance	Identifies the different data collection options in CDASH for the same domain and is best used for filtering the table. The information in this column provides the context for the CDASHIG Core Designations (e.g., denoting which fields should be present on the CRF). When only 1 data collection scenario is provided for the domain, the column contains N/A.
Implementation Options	Collection Guidance	When this column contains "Horizontal-Generic," a sampling of the CDASHIG metadata is provided as a template for the metadata of the CRF in a denormalized structure.
Order Number	Collection Guidance	Provides a suggested order of variables to be displayed on a CRF.
CDASHIG Variable	Tabulation Dataset Mapping	Provides the variable names.
CDASHIG Variable Label		Provides the CDASHIG variable label.
DRAFT CDASHIG Definition	CRF and System Design	Provides a draft definition of the CDASHIG variable to support understanding and ensures proper usage
Question Text	CRF and System Design	Provides full sentence/question forms to prompt for data. Values in this column are: Without text in brackets or parentheses to be used as-is. With text in brackets to be replaced with protocol-specified verbiage. With text in parentheses indicating optional text. With text separated with a forward slash indicating optional wording.
Prompt	CRF and System Design	Provides short phrases to prompt for data. Values in this column are: Suitable as column headers. Without text in brackets or parentheses to be used as-is With text in brackets to be replaced with protocol-specified verbiage. With text in parentheses indicating optional text. With text with NULL indicating the prompt is not required on a CRF screen/page if not needed.
Data Type	Tabulation Dataset Mapping	Specifies the data type of the variable. Values for in this column are: Num for numeric data Char for character or alphanumeric data Date Time
CDASHIG Core	CRF and System Design	Specifies expectations for inclusion of fields on a CRF. Values in this column are: HR for fields which are Highly Recommended and for which a data collection field should always be on the CRF. R/C for fields which are Recommended/Conditional and for which a data collection field that should be on a CRF based on certain conditions. O for fields which are Optional and for which a data collection field is available for use.
Case Report Form Completion Instructions	Collection Guidance	Provides recommended example instructions to support authoring of study-level documentation for instructing sites how to complete CRF fields.
Tabulation Target	Tabulation Dataset Mapping	This column provides the suggested mapping to the tabulation dataset variable. Values in this column are: N/A for when no direct mapping to a tabulation dataset variable is available. SUPP–.QNAM for when a value represented in the field will be mapped to as a Supplemental Qualifier.
Mapping Instructions	Tabulation Dataset Mapping	Provides information on the suggested mapping of the collection variable to the tabulation variable.
Controlled Terminology Codelist Name	CRF and System Design	Specifies controlled terminology applicable to the field. Values in this column are: In cases where a CDASH/CDASHIG variable has associated CT, the codelist is referenced in the Controlled Terminology column in the CDASH Model and CDASHIG metadata table in this format: (codelist name). A single, required controlled term for the variable represented by the controlled term in double quotes. This value indicates the controlled term must be populated in the variable for all records in the resulting dataset. Names of controlled terminology codelists with allowable terms to populate the variable. Codelist names are specified in paratheses. Multiple codelist names indicate the variable is subject to one or more of the codelists. Names of formats to be applied to values in the variable.
Subset Controlled Terminology/CDASH Codelist Name:	CRF and System Design	This column contains the CDISC CT or CDASH subset codelist name that may be used for that specific variable (e.g., EXDOSFRM).
Implementation Notes	CRF and System Design	Provides additional context for implementation of CRF data collection fields and mapping to tabulation datasets content may include: Rationale Implementation instructions For any R/C fields, the "condition" is described in the Implementation Notes column of the CDASHIG metadata table.

Page tree

How to Use Metadata Tables