1 / 18

NDAR Data Dictionary Data Structure Definition: Creating a Mapping File

NDAR Data Dictionary Data Structure Definition: Creating a Mapping File Create a mapping file if your local data structure has already been defined and published in the NDAR Data Dictionary. For help, contact NDARhelp@mail.nih.gov. Before we begin, let’s define some terms….

hoshi
Download Presentation

NDAR Data Dictionary Data Structure Definition: Creating a Mapping File

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related