NDA Help Center

Login Dialog

Frequently Asked Questions

Glossary

NDA Help Center

Filter Cart

Viewable at the top right of NDA pages, the Filter Cart is a temporary holder for filters and data they select. Filters are added to the Workspace first, before being submitted to The Filter Cart. Data selected by filters in the Filter Cart can be added to a Data Package or an NDA Study from the Data Packaging Page, by clicking the 'Create Data Package / Add Data to Study' button.

The filter cart supports combining multiple filters together, and depending on filter type will use "AND" or "OR"  when combining filters.

Multiple selections from the same filter type will result in those selections being applied with an ‘OR’ condition. For example, if you add an NDA Collection Filter with selections for both collections 2112 and 2563 to an empty Workspace, the subjects from NDA Collection 2112 ‘OR’ NDA Collection 2563 will be added to your Workspace even if a subject is in both NDA Collections. You can then add other NDA Collections to your Workspace which further extends the ‘OR’ condition.

If a different filter type is added to your Workspace, or a filter has already been submitted to the Filter Cart, the operation then performs a logical ‘AND’ operation. This means that given the subjects returned from the first filter, only those subjects that matched the first filter are returned by the second filter (i.e., subjects that satisfied both filters). Note that only the subjects specific to your filter will be added to your Filter Cart and only on data shared with the research community. Other data for those same subjects may exist (i.e., within another NDA Collection, associated with a data structure that was not requested in the query, etc.). So, users should select ‘Find all Subjects Data’ to identify all data for those specific subjects. 

Additional Tips:

  • You may query the data without an account, but to gain access you will need to create an NDA user account and apply for access.  Most data access requires that you or your lab are sponsored by an NIH recognized institution with Federal Wide Assurance (FWA).  Without access, you will not be able to obtain individual-level data. 

    Once you have selected data of interest you can:
  • Create a data package - This allows you to specify format for access/download
  • Assign to Study Cohort - Associate the data to an NDA Study allowing for a DOI to be generated and the data to be linked directly to a finding, publication, or data release. 
  • Find All Subject Data - Depending on filter types being used, not all data associated with a subject will be selected.  Data may be restricted by data structure, NDA Collection, or outcome variables (e.g., NDA Study). ‘Find All Data’ expands the fliter criteria by replacing all filters in your Filter Cart with a single Query by GUID filter for all subjects selected by those filters.

    Please Note:
  • When running a query, it may take a moment to populate the Filter Cart. Queries happen in the background so you can define other queries during this time. 
  • When you add your first filter, all data associated with your query will be added to the Filter Cart (e.g., a Concept, an NDA Collection, a Data Structure/Element, etc.). As you add additional filters, they will also display in the Filter Cart. Only the name of filter will be shown in the Filter Cart, not the underlying structures. 
  • Information about the contents of the Filter Cart can be seen by clicking "Edit”.
  • Once your results appear in the Filter Cart, you can create a data package or assign subjects to a study by selecting the 'Package/Assign to Study' option. You can also 'Edit' or 'Clear' filters.
     

Frequently Asked Questions

  • The Filter Cart currently employs basic AND/OR Boolean logic. A single filter may contain multiple selections for that filter type, e.g., a single NDA Study filter might contain NDA Study 1 and NDA Study 2. A subject that is in EITHER 1 OR 2 will be returned.  Adding multiple filters to the cart, regardless of type, will AND the result of each filter.  If NDA Study 1 and NDA Study 2 are added as individual filters, data for a subject will only be selected if the subject is included in  BOTH 1 AND 2.

  • Viewable at the top right of NDA pages, the Filter Cart is a temporary holder of data identified by the user, through querying or browsing, as being of some potential interest. The Filter Cart is where you send the data from your Workspace after it has been filtered.

  • After filters are added to the Filter Cart, users have options to ‘Create a Package’ for download, ‘Associate to Study Cohort’, or ‘Find All Subject Data’. Selecting ‘Find All Subject Data’ identifies and pulls all data for the subjects into the Filter Cart. Choosing ‘Create a Package’ allows users to package and name their query information for download. Choosing ‘Associate to Study Cohort’ gives users the opportunity to choose the Study Cohort they wish to associate this data.

Glossary

  • Once your filter cart contains the subjects of interest, select Create Data Package/Assign to Data Study which will provide options for accessing item level data and/or assigning to a study.  

  • Once queries have been added to your workspace, the next step is to Submit the Filters in the workspace to the Filter Cart.  This process runs the queries selected, saving the results within a filter cart attached to your account.  

  • The Workspace within the General Query Tool is a holding area where you can review your pending filters prior to adding them to Filter Cart. Therefore, the first step in accessing data is to select one or more items and move it into the Workspace. 

Loading...

Login
Reset Password

NDA provides a single access to de-identified autism research data. For permission to download data, you will need an NDA account with approved access to NDA or a connected repository (AGRE, IAN, or the ATP). For NDA access, you need to be a research investigator sponsored by an NIH recognized institution with federal wide assurance. See Request Access for more information.

Warning Notice

This is a U.S. Government computer system, which may be accessed and used only for authorized Government business by authorized personnel. Unauthorized access or use of this computer system may subject violators to criminal, civil, and/or administrative action. All information on this computer system may be intercepted, recorded, read, copied, and disclosed by and to authorized personnel for official purposes, including criminal investigations. Such information includes sensitive data encrypted to comply with confidentiality and privacy requirements. Access or use of this computer system by any person, whether authorized or unauthorized, constitutes consent to these terms. There is no right of privacy in this system.

Update Password

You have logged in with a temporary password. Please update your password. Passwords must contain 8 or more characters and must contain at least 3 of the following types of characters:

  • Uppercase
  • Lowercase
  • Numbers
  • Special Characters limited to: %,_,!,@,#,$,-,%,&,+,=,),(,*,^,:,;

Subscribe to our mailing list

Mailing List(s)
Email Format

You are now leaving the NIMH Data Archive (NDA) web site to go to:

Click on the address above if the page does not change within 10 seconds.

Disclaimer

NDA is not responsible for the content of this external site and does not monitor other web sites for accuracy.

Accept Terms
Filter Cart
No filters selected
Description
Value Range
Notes
Data Structures with shared data
No filters have been selected
Switch User

End of Treatment Form

901 Shared Subjects

Clinical Trials: End of Treatment Form
Clinical Assessments
Exit Form
06/25/2014
etf01
06/25/2014
View Change History
01
Query Element Name Data Type Size Required Description Value Range Notes Aliases
subjectkey GUID Required The NDAR Global Unique Identifier (GUID) for research subject NDAR*
src_subject_id String 20 Required Subject ID how it's defined in lab/project SUBJECT, bid, stepid
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY Required field ETFDate
interview_age Integer Required Age in months at the time of the interview/test/sampling/imaging. 0 :: 1260 Age is rounded to chronological month. If the research participant is 15-days-old at time of interview, the appropriate value would be 0 months. If the participant is 16-days-old, the value would be 1 month. dema1
sex String 20 Required Sex of the subject M;F; O; NR M = Male; F = Female; O=Other; NR = Not reported dema2, gender
Query aescode Integer Recommended Staff code number of person completing this form ETFCODE
Query visit String 60 Recommended Visit name
Query bafinfo Integer Recommended Check if the Assessment was not done. 0::2 0=No; 1=Yes; 2=Unverified ETFINFO
Query etfrsn Integer Recommended Reason for End of Treatment Form 1;2 1=Patient completed 40 hours of study treatment; 2=Patient did not complete 40 hours of study treatment, but has reached 12 weeks since randomization
tcdate Date Recommended Date of study treatment completion
Query erlrsn String 1 Recommended Patient ended study early for which reason A;B;C;D; E; F A= Withdrew consent; B=Medical reason; C= Non-compliance with protocol or treatment; D=Terminatin of study by sponsor; E= Subject terminated at discretion of the investigator or sponsor; F= Other
Query erlrsmds String 255 Recommended Describe reason for early termination rtd
Query daysrz Integer Recommended days since randomization exitrz
Query certcode Integer Recommended stepbd certification code
Query exitreas Integer Recommended omega3 exit reason 1::16 1=Completion of 52 week protocol; 2=Consent withdrawn; 3=Recurrence of mania; 4=Recurrence of hypomania; 5=Recurrence of depression; 6=Recurrence of mixed episode; 7=Emerging or worsening of subsyndromal mood or neurovegetative symptoms; 8=Intolerable adverse effects; 9=Significant non compliance with protocol; 10=Emergence of significant suicidal ideation; 11=Emergence of significant homicidal ideation; 12=Medical or surgical conditions; 13=Suicide; 14=Homicide; 15=Death (all other causes); 16=Other
Query unmasked Integer Recommended randomization unmasking 0;1;-7 0=No; 1=Yes; -7=Refused
Query site String 101 Recommended Site Study Site site_id, siteid
Query deprexit Integer Recommended depression rand care path exit 0::8 0=Treatment responder; 1=Nonresponder 1; 2=Nonresponder 2; 3=Nonresponder 3; 4=Nonresponder 4; 5=Significant non compliance with study protocol; 6=Ineligible; 7=Other; 8=Clinically contra indicated to continue tx
Query ncmed Integer Recommended NC: has GMC contra level 1 or 2 tx 0;1 0=Not checked; 1=Checked
Query nctx Integer Recommended noncompliance psych treatment 0;1;-7 0=No; 1=Yes;-7=Refused
Query nceval Integer Recommended noncompliance evaluations 0;1;-7 0=No; 1=Yes;-7=Refused
Query ncdose Integer Recommended noncompliance incorrect dose 0;1;-7 0=No; 1=Yes;-7=Refused
Query ncoth Integer Recommended NC: other reason 0;1 0=Not checked; 1=Checked
Query rtda1 Integer Recommended What date was the assigned study treatment stopped? 0::999 timest
Query rtda2 Integer Recommended Did patient successfully complete the protocol on the assigned treatment? 0;1 1=Yes; 0=No
Query rtda3 Integer Recommended Was study treatment discontinued for administrative reasons? 0;1 1=Yes; 0=No;Note: This implies that both the patient and the clinical staff judge the assigned antipsychotic treatment to be a success (i.e. adequately effective, with tolerable or no side effects), and that treatment would have continued if not for the administrative reason independent of the study procedures.
Query rtda4 Integer Recommended Was study treatment discontinued based on a clinical decision of inadequate therapeutic effect 0;1 1=Yes; 0=No
Query rtda5 Integer Recommended What was the problematic psychopathology? 1;2;3 1=Postitive Psychopathology; 2=Negative Psychopathology; 3=Affective Psychopathology
Query rtda6 Integer Recommended Was study treatment discontinued based on a clinical decision of unacceptable side effects? 0;1 1=Yes; 0=No
Query rtda7 Integer Recommended Indicate the most problematic side effect 1;2;3;4;5;6;7;8;9;10;11 1=Weight Gain; 2=Lipids; 3=Glucose; 4=EPS; 5=TD; 6=Akathisia/activation; 7=Sexual Dysfunction; 8=Breast changes/galactorrhea; 9=Menstrual irregularities; 10=Hypersensitivity during oral antipsychotic trial; 11=other
Query rtda8 Integer Recommended Was study treatment discontinued based on patient decision, refusal/failure to take the assigned antipsychotic? 0;1 1=Yes; 0=No;Note: This implies that clinical staff believes the patient should continue on the assigned LAI antipsychotic, but the patient, through words and/or actions, refuses to do so.
Query rtda9 Integer Recommended Indicate patients reason for study medication discontinuation: 1;2;3;4;5 1=Patient lost to follow-up, no information available; 2=Patient believes he/she does not need any antipsychotic medication; 3=Patient willing to take antipsychotic medication, but not the assigned LAI antipsychotic medication; 4=Patient no longer willing to do study procedures such as blood draws or ratings; 5= Other
version_form String 121 Recommended Form used/assessment name vers
Query visday Integer Recommended Number of days from study baseline to date of visit
Query fseqno Integer Recommended Sequence Number 0::999 The FSEQNO variable in the ADJ form has a special interpretation compared to other forms. For example, ADJ FSEQNO of '1' can be thought of as being '001', FSEQNO of '2' can be thought of as being '002', and FSEQNO of '3' can be thought of as being '003'. The first digit of FSEQNO relates to the corresponding ENF sequence number at that visit and the third digit relates to the specific adjudicator who completed the adjudication form.
Query istatus Integer Recommended ISTATUS: 1 =discontinued trt/protocol early, 0 =otherwise (indicator variable for variable STATUS) 0;1 0=Otherwise; 1=Discontinued treatment/protocol early trtdscon
Query tstdymed Integer Recommended Taking Study Meds Up To Time Of Visit 0;1 0=No; 1=Yes
Query timeall Integer Recommended Time To All-Cause Treatment Discontinuation in Days 0::365
Query discont_status String 2 Recommended Detailed status of subject in terms of early discontinuation/violation or completing the study A=Lack of efficacy; B=Unacceptable side effects; C=Participant refusal; D=Lost to Follow-up; E=Disallowed Med; F=Never took study meds; G=Completer
Query rtdvis String 50 Recommended Visit on when participant had RTDA form
Query week Float Recommended Week in level/study 99=week 10-week 14
Query compprot Integer Recommended Completed treatment protocol 0;1;-7 0=No; 1=Yes; -7=Refused
Query er_who_inv Integer Recommended investigator initiated termination 1;0 1=yes; 0=no
Query er_who_sub Integer Recommended subject initiated termination 1;0 1=yes; 0=no
Query er_who_fam Integer Recommended family initiated termination 1;0 1=yes; 0=no
Query pr_protcomp Integer Recommended Primary reason for termination: Protocal Complete 1;0 1=yes; 0=no
Query pr_admin Integer Recommended Primary reason for termination: Administrative 1;0 1=yes; 0=no
Query pr_cinadeff Integer Recommended Primary reason for termination: Inadequate Theraeutic effect 1;0 1=yes; 0=no
Query pr_ciaprob String 3 Recommended Primary reason for termination: Problematic Psychopathology P;N;A;O;N P=positive;N=negative;A=affective;O = other;N = not applicable
Query pr_ciaprobs String 20 Recommended Primary reason for termination: Problematic Psychopathology Specify Actual value
Query pr_csideeff Integer Recommended Primary reason for termination: Unacceptable Side Effects 1;0 1=yes; 0=no
Query pr_cseepse Integer Recommended Primary reason for termination: Unacceptable Side Effect was EPSE 1;0 1=yes; 0=no
Query pr_csewt Integer Recommended Primary reason for termination: Unacceptable Side Effect was Weight 1;0 1=yes; 0=no
Query pr_csesex Integer Recommended Primary reason for termination: Unacceptable Side Effect was Sexual 1;0 1=yes; 0=no
Query pr_cseinsom Integer Recommended Primary reason for termination: Unacceptable Side Effect was Insomnia 1;0 1=yes; 0=no
Query pr_csemania Integer Recommended Primary reason for termination: Unacceptable Side Effect was Mania 1;0 1=yes; 0=no
Query pr_cseirrit Integer Recommended Primary reason for termination: Unacceptable Side Effect was Irritability 1;0 1=yes; 0=no
Query pr_cseoth Integer Recommended Primary reason for termination: Unacceptable Side Effect was Other 1;0 1=yes; 0=no
Query pr_cseoths String 20 Recommended Primary reason for termination: Unacceptable Side Effect was Other Specify Actual value
Query pr_pnottake Integer Recommended Primary reason for termination: Noncompliance 1;0 1=yes; 0=no
Query er_secreas Integer Recommended Other Reasons for Terminating 1;0 1=yes; 0=no
Query sr_admin Integer Recommended Secondary reason for termination: Administrative 1;0 1=yes; 0=no
Query sr_cinadeff Integer Recommended Secondary reason for termination: Inadequate Theraeutic effect 1;0 1=yes; 0=no
Query sr_ciaprob Integer Recommended Secondary reason for termination: Problematic Psychopathology 1::4 1=positive;2=negative;3=affective;4 = other
Query sr_ciaprobs String 20 Recommended Secondary reason for termination: Problematic Psychopathology Specify Actual value
Query sr_csideeff Integer Recommended Secondary reason for termination: Unacceptable Side Effects 1;0 1=yes; 0=no
Query sr_cseepse Integer Recommended Secondary reason for termination: Unacceptable Side Effect was EPSE 1;0 1=yes; 0=no
Query sr_csewt Integer Recommended Secondary reason for termination: Unacceptable Side Effect was Weight 1;0 1=yes; 0=no
Query sr_csesex Integer Recommended Secondary reason for termination: Unacceptable Side Effect was Sexual 1;0 1=yes; 0=no
Query sr_cseinsom Integer Recommended Secondary reason for termination: Unacceptable Side Effect was Insomnia 1;0 1=yes; 0=no
Query sr_csemania Integer Recommended Secondary reason for termination: Unacceptable Side Effect was Mania 1;0 1=yes; 0=no
Query sr_cseirrit Integer Recommended Secondary reason for termination: Unacceptable Side Effect was Irritability 1;0 1=yes; 0=no
Query sr_cseoth Integer Recommended Secondary reason for termination: Unacceptable Side Effect was Other 1;0 1=yes; 0=no
Query sr_cseoths String 20 Recommended Secondary reason for termination: Unacceptable Side Effect was Other Specify
Query sr_pnottake Integer Recommended Secondary reason for termination: Noncompliance 1;0 1=yes; 0=no
Query er_conttreat Integer Recommended subject continuing antipsychotic treatment 0::3 0=No; 1=rerandomized; 2=Ziprasidone;3=Community Care
Query er_guesstrt String 3 Recommended best guess of treatment received Z;C;M;R;O;N;MO; MP Z =Ziprasidone; C =Community Care; M =Molindone; R =Risperidone; O =Olanzapine;N=Not Applicable;MO=Medication Only;MP=Medication+PMT
Query er_certtrt String 3 Recommended how certain of best guess CS;FS;TG;CU;N CS =Completely Sure; FS =Fairly Sure; TG=Tentative Guess; CU=Completely Uncertain; N= Not Applicable
Query ptleff Integer Recommended Is Lack of Efficacy the type of information on which your guess is based 0;1 0 = Not indicated;1 = Yes
Query ptpeff Integer Recommended Is Presence of efficacy the type of information on which your guess is based 0;1 0 = Not indicated;1 = Yes
Query ptase Integer Recommended Is Absence of side effects the type of information on which your guess is based 0;1 0 = Not indicated;1 = Yes
Query ptpse Integer Recommended Is Presence of side effects the type of information on which your guess is based 0;1 0 = Not indicated;1 = Yes
Query er_info_na Integer Recommended guess basis: Not applicable 1;0 1=yes; 0=no
Query ptoth Integer Recommended Is Other Types of Information the type of information on which your guess is based 0;1 0 = Not indicated;1 = Yes
Query pt3oth String 60 Recommended If Other Types of Information the type of information on which your guess is based, explain
Query sa_any_allwk Integer Recommended Suicide attempt reported during any of the study weeks 0;1; -888; -999 0=No; 1=Yes; -888=Not Applicable; -999=Missing;
Query er_assaults Integer Recommended assaults on others during study 1;0 1=yes; 0=no
Query er_arrests Integer Recommended arrests during study 1;0 1=yes; 0=no
Query er_liveifam Integer Recommended current living situation: immediate family 1;0 1=yes; 0=no
Query er_liveefam Integer Recommended current living situation: extended family 1;0 1=yes; 0=no
Query er_liveghome Integer Recommended current living situation: group home 1;0 1=yes; 0=no
Query er_liveres Integer Recommended current living situation: residential 1;0 1=yes; 0=no
Query er_livephosp Integer Recommended current living situation: psychiatric hospital 1;0 1=yes; 0=no
Query er_livemhoss Integer Recommended current living situation: mental hospital study complication 1;0 1=yes; 0=no
Query er_livemhosu Integer Recommended current living situation: mental hospital unrelated problem 1;0 1=yes; 0=no
Query er_liveshelt Integer Recommended current living situation: shelter 1;0 1=yes; 0=no
Query er_liveoth Integer Recommended current living situation: other 1;0 1=yes; 0=no
Query er_termdx String 6 Recommended subject's diagnosis at termination 3-5 digit code (XXX.XX)
Query er_dxchange Integer Recommended diagnosis changed from enrollment 1;0 1=yes; 0=no
Query er_secdx Integer Recommended Secondary Diagnosis? (Y or N) 1;0 1=yes; 0=no
Query encounter1_020 String 100 Recommended Secondary ICD Diagnosis Code
Query er_secdx2 String 6 Recommended Secondary Diagnosis #2 XXX.XX
Query er_secdx3 String 6 Recommended Secondary Diagnosis #3 XXX.XX
er_secdx4 String 6 Recommended Secondary Diagnosis #4 XXX.XX
er_secdx5 String 6 Recommended Secondary Diagnosis #5 XXX.XX
Query treat String 1 Recommended Treatment for Randomization X;Y;Z
Query trm_q3 Integer Recommended Date of study termination in days from the randomization/enrollment date (TRM_Q3 = Date of study termination - randomization/enrollment date)
Query compdt Integer Recommended Study completion date, since randomization Offset from randomization
Query rand_num Integer Recommended Randomization Number 0::2
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data
Query sigp1 Integer Recommended Physician signature present 0;1 0 = No; 1 = Yes
Query sigd1 Integer Recommended Physician/PI signature date (days since randomization)
Query visnum Float Recommended Numeric Visit Number -1.5 = Pre-Screening; -1 = Screening; 0 = Baseline; ## = Visit ## (from 1 to 10); Whole numbers = standard monthly visits; #.001 - #.009 = Unscheduled; #.1 = End of Phase 1; #.2 = End of Phase 2; #.3 = End of Phase 3; #.4 = End of Open Choice Phase; #.5 = End of Study; #.6 = Genetic Analysis; 1000=all visits
Data Structure

This page displays the data structure defined for the measure identified in the title and structure short name. The table below displays a list of data elements in this structure (also called variables) and the following information:

  • Element Name: This is the standard element name
  • Data Type: Which type of data this element is, e.g. String, Float, File location.
  • Size: If applicable, the character limit of this element
  • Required: This column displays whether the element is Required for valid submissions, Recommended for valid submissions, Conditional on other elements, or Optional
  • Description: A basic description
  • Value Range: Which values can appear validly in this element (case sensitive for strings)
  • Notes: Expanded description or notes on coding of values
  • Aliases: A list of currently supported Aliases (alternate element names)
  • For valid elements with shared data, on the far left is a Filter button you can use to view a summary of shared data for that element and apply a query filter to your Cart based on selected value ranges

At the top of this page you can also:

  • Use the search bar to filter the elements displayed. This will not filter on the Size of Required columns
  • Download a copy of this definition in CSV format
  • Download a blank CSV submission template prepopulated with the correct structure header rows ready to fill with subject records and upload

Please email the The NDA Help Desk with any questions.