Tool Name: Data Dictionaries



Tool Description: 

The data dictionary is a system-generated blueprint of the forms and their properties. These are especially valuable when performing validation of the various behaviors that have been built on a form. The data dictionary covers all the elements (described in detail below), across three main categories:

  • Form properties and form level conditional actions (web only) 
  • Field properties (web only) 
  • Field  conditional actions (web only) 


Tool Use: 


Select which study version or another form type, followed by the export button for the type of details needed:



The exported file name will contain the date exported and the study name.

Each export will contain the following details:


Form Properties 

  • Form_ID
  • Form_Name
  • Sequence
  • Omit Review 1
  • Omit Review 2
  • Omit Review 3
  • Omit Review 4
  • Omit Review 5
  • Record Relation
  • Log Form
  • Suppress VOW
  • Omit Error Msg
  • ePRO form
  • Lab form
  • CA id
  • Conditional Action Type
  • Conditional Action Name
  • Message (only for validations)
  • Condition(s)
  • Email Message (Subject: Body)
  • Email distribution (roles)
  • Date_Last_save
  • User_save
  • Query Override - applicable roles
  • View Roles (delimited)
  • Edit roles (delimited)
  • Sub form details - IDs and names
  • Preserve deleted


Field Conditional Actions

  • Field_ID
  • Field_Name
  • Field_Label
  • Field_Type 
  • CA Id
  • Conditional Action Type
  • Conditional Action Name
  • Message (only for validations)
  • Condition(s)
  • Email Message (Subject: Body)
  • Email distribution (roles)
  • Query Override - applicable roles
  • Sub Form - ID and Name


Field Properties

  • Field_ID - These include any normalized table fields on the form as well
  • Field_Name
  • Field_Label
  • Field_Type
  • Norm_table_ID (if applicable) 
  • Text_label - For labels that have a related field
  • Hidden (true/false)
  • Blinded roles (delimited)
  • FLSV (true/false)
  • Required (true/false)
  • Valid range (numbers)
  • Decimal places (numbers)
  • Max length (text/memo)
  • Field mask (text)
  • Single Select codes (choice fields)    
  • Date_time_type (date/time fields)


For a summarized data dictionary focused only on the field conditional actions and primary field components, use the quick link here:


The following details are provided in the summarized data dictionary:

  • Form Name
  • Form ID
  • Field Name
  • Field Label
  • Field ID
  • Field Type
  • Field Choices - select/dropdown fields only
  • Conditional Actions (concatenated)


The summarized data dictionary is exportable to Excel or ODM.



Need more help?

Please visit the Datatrak Contact Information page.