The table below contains the basic elements of the Studytrax data definition and the defaults used if the Studytrax team assists with setup.
Attribute | What’s Needed | Default Used if no information provided |
---|---|---|
Variable Name | Descriptive Name | |
Unique code (no spaces/special characters [underscore ok]) | ||
Variable Type | Numeric – What is the range (min / max)? Units? | No range, no unit |
Calculation - How calculated? What if missing some values? | All values required for a calculation | |
Text - How many characters needed?
| Unlimited for questions like "Describe", "Comments" | |
Date – What is acceptable range? | Any valid date can be entered | |
Document – How many files and how large? | ||
Picklist (Coded list of value/label pairs, such as 0 = Male, 1 = Female). - What are the values and labels for all options? - do you want values displayed for data entry? - Can more than one option be selected? | 0=No, 1=Yes Other lists would start with 0 and increment by 1 Values are not displayed Only one option can be selected | |
Other | Exportable – Can values be exported in dataset? | Exportable |
Missing Values – Will value/label pairs are defined as “Missing” (e.g., Missing = -9)? | No missing value definition set up if not specified | |
Required - Must a value be entered? | Yes |
A good data definition provides ALL the characteristics forms (questionnaires, CRFs) and associated variables. What is needed is good old "TLV".
Stands For.. | Overview | |
---|---|---|
T | Type of Variable | The most common types are dates, number, coded variables (e.g., 0 = No, 1 = Yes; Tell us if more than one option can be selected). |
L | Layout and Logic | Indicate the look and feel of the variable, and when it should be displayed (e.g., only show if subject is a male). |
V | Validation | Indicate the rules that govern the acceptable variable values (acceptable range, units) |
...
Communicating
Use A Spreadsheet
Document your data definition using the spreadsheet here.
...
Example Marked Up Form
L - Layout and Logic
Keep
...
It Simple
One row per variable (other Forms should use the cleanest, simplest layout possible. Standard practice is to use one-row-per-variable (examples here) is standard practice.
Leverage Visual Validation
A form's spatial and visual layout can be it's most important validation (see examples here).
...
Form | Skip logic / condition |
Pregnancy Test | Hide form for males |
Demographic Data | Show text box if ‘other’ is selected for Race |
Variable Standards and Defaults
...
Attribute
...
What’s Needed
...
Our Default
...
Variable Name
...
Descriptive Name
...
Unique code (no spaces/special characters [underscore ok])
...
Variable Type
Numeric – What is the range (min / max)? Units?
...
No range, no unit
Calculation - How calculated? What if missing some values?
...
All values required for a calculation
...
Text - How many characters needed?
- Text variables require a limit (can range from 1 to 255 characters)
- Memo variables do not have a limit
Unlimited for questions like Describe, Comments
...
Date – What is acceptable range?
...
Any valid date can be entered
...
Document – How many files and how large?
Coded list (e.g., 0 = Male…)
· What are the values and labels for all options?
- do you want values displayed for data entry?
· Can more than one option be selected?
...
0=No, 1=Yes
Other lists would start with 0 and increment by 1
Values are not displayed
Only one option can be selected
...
Definition
...
Export – Can values be exported in dataset?
...
Exportable
...
Missing Values – Will values be assigned as “Missing” (e.g., Missing = -9)?
...
No missing value definition set up if not specified
...
Required
...
Must a value be entered?
...
Example: Data Collection Forms Schedule
...