Files-Specifications.md

@@ -14,6 +14,23 @@ The **modified** schema of the **Table Schema** JSON object can be found [HERE](
 
 # CDE Dictionary Excel file
 
+## CDE Dictionary Excel columns
+
+The spreadsheet **MUST** have the following columns with the same order:
+1. mipname: The name of the variable.
+2. mip_code: The variable’s code.
+3. mip_type: The variable’s type.
+4. mip_values: The variable’s values. It may have an enumeration or a range of values. For enumerations, for every value please provide code and label in brackets.
+Example (for ADNI category): {“AD”,”Alzheimer’s Disease”},{”MCI”,”Mild Cognitive Impairment”},{”CN”,”Cognitively Normal”}
+For range of values simply state the min and max values with '-' in between. Example (for MMSE Total scores): 0-30.
+5. unit: The variable’s measurement unit.
+6. description: The variable’s description.
+7. comments: Comments about the variable’s nature.
+8. conceptPath: The variable’s concept path. Example (for ApoE4): /root/genetic/polymorphism/apoe4.
+9. variable_lookup
+10. enum_lookup
+11. domain:
+
 # Data Catalogue Excel file
 
 ## Necessary Conventions