NDAR Data Dictionary Data Structure Definition: Creating a Mapping File

1. NDAR Data DictionaryData Structure Definition:Creating a Mapping File Create a mapping file if your local data structurehas already been defined and published in theNDAR Data Dictionary. For help, contact NDARhelp@mail.nih.gov

2. Before we begin, let’s define some terms… • Data Element – A “variable” or “field” with documented attributes that establish a consistent format for recording research data • NDAR Data Dictionary – A compendium of data elements • NDAR Data Structure – A group of data elements published by name in the NDAR Data Dictionary • e.g., the ADI-R is published in the NDAR Data Dictionary as “Autism Diagnostic Interview-Revised - (ADI-R) - (2003)” and contains 406 associated data elements • Local Data Structure – A group of data elements defined at the research site

3. Let’s start with a typical scenario… • A small research team has been using the ADI-R for two years. The team records and maintains data in a spreadsheet for all of the 406 assessment items. • As a data capture system, the spreadsheet meets the needs of this small team. They’ve never needed to develop a codebook, which would have required them to define and document the format and attributes for the research data. • Eight new participants have consented to share data with NDAR. The data submission cycle is fast approaching. • What does the research team do?

4. What does the research team do? • Create a mapping file to specify the relationship between their local data structure for the ADI-R and the NDAR data structure for the ADI-R. • The mapping file provides a direct link from the localdata element name to the NDAR data element name. • This allows NDAR to understand that the two data elements are the same even though they may have different names. • When the researchers submit their data, NDAR will use the value ranges that have already been defined in the NDAR data structure to validate their data. • This process only needs to be completed one time.

5. How do I create a mapping file? • Locate the desired NDAR data structure on the NDAR Web site. • The NDAR Web site provides a current list of data structures published to the NDAR Data Dictionary. • View and download the list of data elements contained in the NDAR data structure. • Copy only the NDAR data element names and paste them into a new spreadsheet. • Enter each of your local data element names next to its corresponding NDAR data element name. • Save the mapping relationship to an XML file.

6. Can you show me an example? • In this example, we’ll generate a mapping file for 4 data elements contained in the NDAR ADI-R. • These 4 data elements are required in every data submission to NDAR. Let’s begin.

7. Example • Locate the desired NDAR data structure on the NDAR Web site. • Go to http://ndar.nih.gov. Click on the “Tools” tab in the menu.

8. Example • Locate the desired NDAR data structure on the NDAR Web site. • Click on the “NDAR Data Structures” link.

9. Example • View and download the list of data elements contained in the NDAR data structure. • Click on the desired data structure (in our example, the ADI-R).

10. Example • View and download the list of data elements contained in the NDAR data structure. • Download the CSV file.

11. Example • Copy only the NDAR data element names and paste them into a new spreadsheet.

12. Example • Enter each of your local data element names next to its corresponding NDAR data element name. Your Local Data StructureElementName NDAR Data StructureElementName

13. Example • Save the mapping relationship to an XML file. • Ensure that the file follows this format: <?xml version="1.0" ?> <map_file> <map_structure name="adi_200301"> <map_element alias="NDAR_GUID"ndar="subjectkey" /> <map_element alias="ID"ndar="src_subject_id" /> <map_element alias="test_date"ndar="interview_date" /> <map_element alias="subject_age"ndar="interview_age" /> </map_structure> </map_file>

14. Example • Save the mapping relationship to an XML file • Ensure that the file follows this format: How do I derive themap_structure name? <?xml version="1.0" ?> <map_file> <map_structure name="adi_200301"> <map_element alias="NDAR_GUID"ndar="subjectkey" /> <map_element alias="ID"ndar="src_subject_id" /> <map_element alias="test_date"ndar="interview_date" /> <map_element alias="subject_age"ndar="interview_age" /> </map_structure> </map_file>

15. Example • Save the mapping relationship to an XML file • Ensure that the file follows this format. • Use the NDAR Data Structure Short Name and Version. <?xml version="1.0" ?> <map_file> <map_structure name="adi_200301"> <map_element alias="NDAR_GUID"ndar="subjectkey" /> <map_element alias="ID"ndar="src_subject_id" /> <map_element alias="test_date"ndar="interview_date" /> <map_element alias="subject_age"ndar="interview_age" /> </map_structure> </map_file>

16. Example • Save the mapping relationship to an XML file. • Find the Short Name and Version on the NDAR Web site.

17. Questions & Answers • What do I do with my completed XML mapping files? • Send your mapping files to NDARhelp@mail.nih.gov with a request to publish them to the NDAR Data Dictionary. • What if I have multiple clinical assessments? • Generate a mapping file for each clinical assessment. • What if I can’t find a matching data structure in the NDAR Data Dictionary? • Use the NDAR Data Structure Definition Template to define a data structure for your data submission. http://ndar.nih.gov/ndarpublicweb/Documents/NDAR_Data_Structure_Definition_Template.xls

18. NDAR Technical Assistance • E-mail: ndarhelp@mail.nih.gov • Web site: http//:ndar.nih.gov • Standard Operating Procedures (Policy & Procedures page) • Webinars (Training page) • Online Tutorials (Training page, Spring 2010) • Listservs: http://ndar.nih.gov/ndarpublicweb/Listserv.go • NDAR General: System enhancements, Web updates, training schedules, meetings and special events • NDAR Data: Timely technical updates, system releases, new data structures, data management-related tools and trainings • Demonstration Environment: http://ndardemo.nih.gov • Request an Account • Practice setting up data structures and submitting test data