NDA Help Center

Login Dialog

Frequently Asked Questions

Glossary

Contact NDA Help Desk

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).

When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

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.

    When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

  • 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. 

Contact NDA Help Desk

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: %,_,!,@,#,$,-,%,&,+,=,),(,*,^,:,;
Update Password

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
NIMH Data Archive
Filter Cart
No filters selected
Description
Value Range
Notes
Data Structures with shared data
No filters have been selected
Switch User

Alcohol and Drug Use Disorders Identification Test

7,693 Shared Subjects

N/A
Clinical Assessments
Substance Use
06/26/2015
audit01
09/08/2020
View Change History
01
Definition
Submission Template
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* pseduo_guids, pseudo_guids
src_subject_id String 20 Required Subject ID how it's defined in lab/project aid, id, record_id
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY audit_date, date_of_interview_contact, interview_dt_t1, interview_dt_t2, interview_dt_t3, interview_dt_t4, lab_interview_date, visit_date
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. age, age_months, age_t1_mos, age_t2_mos, age_t3_mos, age_t4_mos, dema1, lab_interview_age
sex String 20 Required Sex of the subject
M;F; O; NR
M = Male; F = Female; O=Other; NR = Not reported demo_1, gender, gender_t1, gender_t2, gender_t3, gender_t4, sex
Query site String 101 Recommended Site Study Site asite
Query clinicid Integer Recommended Clinic ID aclinic
Query ran002 Integer Recommended Was the subject randomized? 0::3; -9 0=No; 1=Yes; -9=unknown; 2=No meds; 3=No community care rand
Query audit1 Integer Recommended How often do you have a drink containing alcohol? 0::6 0= Never; 1= Monthly; 2= 2-4 times a month; 3= 2-3 times a week; 4= 4 or more times a week; 5= NA; 6=Monthly or less alcohol_1audit, audit1_t1, audit1_t2, audit1_t3, audit1_t4, audit_02_1, audit_1, audit_1_1month, audit_1_bl, audit_1_fu, audit_oftendrink, how_often_do_you_have_a_dr, oftndrink
Query audit2 Float Recommended How many drinks containing alcohol do you have on a typical day when you are drinking?
0::6; 9999
Decimals: answered between two values - 0= 0 to 2; 1= 3 to 4; 2= 5 to 6; 3= 7 to 9; 4= 10 or more; 5= N/A; 9999= no data; 6= 1 or 2 alcohol_2audit, audit2_t1, audit2_t2, audit2_t3, audit2_t4, audit_02_2, audit_2, audit_2_1month, audit_2_bl, audit_2_fu, audit_howmany, how_many_drinks_containing, numdrinks
Query audit3 Integer Recommended How often do you have six(for male, 4-female) or more drinks on one occasion?
0::5; 9999
0= Never; 1= Less than monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 5= N/A; 9999= no data alcohol_3audit, audit3_t1, audit3_t2, audit3_t3, audit3_t4, audit_02_3, audit_3, audit_3_1month, audit_3_bl, audit_3_fu, audit_sixdrinks, fiveormore, how_often_do_you_have_six
Query audit4 Integer Recommended How often during the last year have you been unable to remember what happened the night before because you had been drinking?
0::5
0 = Never; 1 = Less than monthly; 2 = Monthly; 3 = Weekly; 4 = Daily or almost daily; 5=N/A alcohol_8audit, audit12_08a, audit6_t1, audit6_t2, audit6_t3, audit6_t4, audit_02_8, audit_8, audit_8_1month, audit_8_fu, memloss, unable_to_remember
Query audit5 Integer Recommended How often during the last year have you found that you were not able to stop drinking once you had started?
0::5
0 = Never; 1 = Less than monthly; 2 = Monthly; 3 = Weekly; 4 = Daily or almost daily; 5=N/A alcohol_4audit, audit12_04a, audit4_t1, audit4_t2, audit4_t3, audit4_t4, audit_02_4, audit_4, audit_4_1month, audit_4_fu, cantstop, how_often_during_the_last
Query audit7 Integer Recommended Have you or someone else been injured as a result of your drinking?
0::10
0 = No; 1 = Yes, but not in the time range given in version_form; 2 = Yes, but not in last year; 3 = Yes, in the time range given in version_form; 4 = Yes, during last year;5 = Yes, but not in the 4 months before jail ; 6 = Yes, in the 4 months before jail; 7=N/A; 8=Yes, but not in the last month; 10=Yes, during the last month alcohol_9audit, audit9_t1, audit9_t2, audit9_t3, audit9_t4, audit_02_9, audit_9, audit_9_1month, audit_9_bl, audit_9_fu, audit_injury, have_you_or_someone_else_b, injured
Query audit6 Integer Recommended How often during the last year have you failed to do what was normally expected from you because of drinking (e.g., missed deadlines, poor classroom or work attendance, failed committee responsibilities, inconsistent work patterns)?
0::5
0 = Never; 1 = Less than monthly; 2 = Monthly; 3 = Weekly; 4 = Daily or almost daily; 5=N/A alcohol_5audit, audit12_05a, audit5_t1, audit5_t2, audit5_t3, audit5_t4, audit_02_5, audit_5, audit_5_1month, audit_5_fu, failed, failed_expectations
Query audit8 Integer Recommended Has a relative or friend or a doctor or other health worker been concerned about your drinking or suggested you cut down?
0::10
0 = No; 1 = Yes, but not in the time range given in version_form; 2 = Yes, but not in last year; 3 = Yes, in the time range given in version_form; 4 = Yes, during last year;5 = Yes, but not in the 4 months before jail ; 6 = Yes, in the 4 months before jail; 7=N/A; 8=Yes, but not in the last month; 10=Yes, during the last month alcohol_10audit, audit10_t1, audit10_t2, audit10_t3, audit10_t4, audit_10, audit_10_1month, audit_10_bl, audit_10_fu, audit_suggeststop, has_a_relative_or_friend_o, sggtstcutdn
Query audit9 Integer Recommended How often in the last year have you needed a first drink in the morning to get yourself going after a heavy drinking session?
0::5
0 = Never; 1 = Less than monthly; 2 = Monthly; 3 = Weekly; 4 = Daily or almost daily; 5=N/A alcohol_6audit, audit12_06a, audit7_t1, audit7_t2, audit7_t3, audit7_t4, audit_02_6, audit_6, audit_6_1month, audit_6_fu, first_drink_in_the_morning, morngdrink
Query audit10 Integer Recommended How often during the past year have you had feeling of guilt or remorse after drinking?
0::5
0 = Never; 1 = Less than monthly; 2 = Monthly; 3 = Weekly; 4 = Daily or almost daily; 5=N/A alcohol_7audit, audit12_07a, audit8_t1, audit8_t2, audit8_t3, audit8_t4, audit_02_7, audit_7, audit_7_1month, audit_7_fu, guilt_or_remorse, guiltdrnk
Query au1 Integer Recommended Thinking about the past 6 months, how often do you have a drink containing alcohol? 0::4 0 = never; 1 = monthly or less; 2 = 2 to 4 times a month; 3 = 2 or 3 times a week; 4 = 4 or more times a week
Query au2 Integer Recommended How many drinks containing alcohol do you have on a typical day when you are drinking? By "a drink," I mean a can of beer, a glass of wine, or a shot of hard liquor.
Query au3 Integer Recommended Thinking about the last 6 months, how often do you have six or more drinks on one occasion? 0::4 0 = never; 1 = less than monthly; 2 = monthly; 3 = weekly; 4 = daily or almost daily audit_3
Query visit String 60 Recommended Visit name audit12_date, pax_timepoint, wave
Query days_baseline Integer Recommended Days since baseline lof
Query interv Integer Recommended Intervention Status 0;1 1=ITV, intervention; 0=TAU, treatment as usual
Query alcq Integer Recommended Sum of Alcohol Use Items audit_score, audit_sum, audit_sum_score, audit_total, audittot_t1, audittot_t2, audittot_t3, audittot_t4, record_the_total_of_spe, record_the_total_of_specif
version_form String 121 Recommended Form used/assessment name
Query audit12_01a Integer Recommended How often do you have a drink containing alcohol or use other drugs (e.g., marijuana, cocaine, narcotics)? 1;2 1=Never; 2=Less than monthly
Query audit12_01b Integer Recommended If more than once a month: Alcohol 1::3 1= Monthly;2= Weekly;3= Daily or almost daily
Query audit12_01c Integer Recommended If more than once a month: Cocaine 1::3 1= Monthly;2= Weekly;3= Daily or almost daily
Query audit12_01d Integer Recommended If more than once a month: Marijuana 1::3 1= Monthly;2= Weekly;3= Daily or almost daily
Query audit12_01e Integer Recommended If more than once a month: Tranquilizers 1::3 1= Monthly;2= Weekly;3= Daily or almost daily
other_specify_mdhx String 50 Recommended Other= specify audit12_01f
Query audit12_01g Integer Recommended If more than once a month: Other 1::3 1= Monthly;2= Weekly;3= Daily or almost daily
Query audit12_02a Integer Recommended On a day when you drink alcohol or use other drugs, how many drinks (alcohol) do you have? 1::6 1= None; 2= 1 or 2; 3= 3 or 4; 4= 5 or 6; 5= 7 or 9; 6= 10 or more
Query audit12_02b Integer Recommended On a day when you drink alcohol or use other drugs, how many lines (cocaine) do you use? 1::6 1= None; 2= 1 or 2; 3= 3 or 4; 4= 5 or 6; 5= 7 or 9; 6= 10 or more
Query audit12_02c Integer Recommended On a day when you drink alcohol or use other drugs, how many joints (marijuana) do you use? 1::6 1= None; 2= 1 or 2; 3= 3 or 4; 4= 5 or 6; 5= 7 or 9; 6= 10 or more
Query audit12_02d Integer Recommended On a day when you drink alcohol or use other drugs, how many tranquilizer pills do you use? 1::6 1= None; 2= 1 or 2; 3= 3 or 4; 4= 5 or 6; 5= 7 or 9; 6= 10 or more
Query audit12_02e Integer Recommended On a day when you drink alcohol or use other drugs, how many other drugs do you use? 1::6 1= None; 2= 1 or 2; 3= 3 or 4; 4= 5 or 6; 5= 7 or 9; 6= 10 or more
Query audit12_03a Integer Recommended How often do you have 6 or more drinks, 1 or more joints, 10 or more lines, or 3 or more tranquilizer pills on one occasion? Alcohol 1::5 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily
Query audit12_03b Integer Recommended How often do you have 6 or more drinks, 1 or more joints, 10 or more lines, or 3 or more tranquilizer pills on one occasion? Other drugs 1::5 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily
Query audit12_04b Integer Recommended How often during the last year have you found that you were unable to stop using other drugs once you had started?
1::6
1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily; 6=NA dudit_6, dudit_6_1month, dudit_6_bl, dudit_6_fu
Query audit12_05b Integer Recommended How often during the last year have you failed to do what was normally expected from you because of using other drugs? 1::5 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily dudit_7_1month, dudit_7_bl, dudit_7_fu
Query audit12_06b Integer Recommended How often during the last year have you needed a drug in the morning to get yourself going after a drug using session?
1::6
1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily; 6=NA dudit8, dudit_8, dudit_8_1month, dudit_8_bl, dudit_8_fu
Query audit12_07b Integer Recommended How often during the last year have you had a feeling of guilt or remorse after using other drugs?
1::6
1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily; 6=NA dudit_9, dudit_9_1month, dudit_9_bl, dudit_9_fu
Query audit12_08b Integer Recommended How often during the last year have you been unable to remember what happened the night before because you had been using other drugs? 1::5 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily
Query audit12_09a Integer Recommended Have you or someone else been injured as the result of your drinking or drug use? Alcohol 1::5 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily
Query audit12_09b Integer Recommended Have you or someone else been injured as the result of your drinking or drug use? Other Drugs 1::10 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily; 6 = Yes, but not over the 4 months before jail (baseline)/past 4 months (follow-up)/month since leaving jail (1-month); 7 = Yes, over the 4 months before jail (baseline)/past 4 months (follow-up)/month since leaving jail (1-month); 8=Yes, but not in the last month; 10=Yes, during the last month dudit_10_1month, dudit_10_bl, dudit_10_fu
Query audit12_10a Integer Recommended Has a relative, friend, doctor or other health worker been concerned about your drinking or drug use or suggested you cut down? Alcohol 1::5 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily
Query audit12_10b Integer Recommended Has a relative, friend, doctor or other health worker been concerned about your drinking or drug use or suggested you cut down? Other Drugs 1::7 1= Never;2= Less than monthly;3= Monthly;4= Weekly;5= Daily or almost daily; 6 = Yes, but not over the 4 months before jail (baseline)/past 4 months (follow-up)/month since leaving jail (1-month); 7 = Yes, over the 4 months before jail (baseline)/past 4 months (follow-up)/month since leaving jail (1-month) dudit_11_1month, dudit_11_bl, dudit_11_fu
Query audit_4_bl Integer Recommended How often during the 4 months before coming to jail have you found that you were unable to stop drinking once you had started? 0::4 0 = Never ; 1 = Less than Monthly ; 2 = Monthly ; 3 = Weekly ; 4 = Daily or almost daily audit_4, audit_4_1month, audit_4_fu
Query audit_5_bl Integer Recommended How often during the 4 months before coming to jail have you failed to do what was normally expected of you because of drinking? 0::4 0 = Never ; 1 = Less than Monthly ; 2 = Monthly ; 3 = Weekly ; 4 = Daily or almost daily audit_5, audit_5_1month, audit_5_fu
Query audit_6_bl Integer Recommended How often during the 4 months before coming to jail have you needed a first drink in the morning to get yourself going after a heavy drinking session? 0::4 0 = Never ; 1 = Less than Monthly ; 2 = Monthly ; 3 = Weekly ; 4 = Daily or almost daily audit_6, audit_6_1month, audit_6_fu
Query audit_7_bl Integer Recommended How often during 4 months before coming to jail have you had a feeling of guilt or remorse after drinking? 0::4 0 = Never ; 1 = Less than Monthly ; 2 = Monthly ; 3 = Weekly ; 4 = Daily or almost daily audit_7, audit_7_1month, audit_7_fu
Query audit_8_bl Integer Recommended How often during the 4 months before coming to jail have you been unable to remember what happened the night before because you had been drinking? 0::4 0 = Never ; 1 = Less than Monthly ; 2 = Monthly ; 3 = Weekly ; 4 = Daily or almost daily audit_8, audit_8_1month, audit_8_fu
Query audit_02_2b Integer Recommended During the year when you drank the most, how many drinks did you have on a typical day? 0::5; 9999 0= 0 to 2; 1= 3 to 4; 2= 5 to 6; 3= 7 to 9; 4= 10 or more; 5= N/A; 9999= no data
Query audit_02_3b Integer Recommended During the year when you drank the most, how often did you have six or more drinks on one occasion? 0::5; 9999 0= Never; 1= Less than monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 5= N/A; 9999= no data
Query audit_02_4b Integer Recommended During the year you drank the most, how often did you find that you were unable to stop drinking once you started? 0::5; 9999 0= Never; 1= Less than monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 5= N/A; 9999= no data
Query audit_02_5b Integer Recommended During the year you drank the most, how often have you failed to do what was normally expected of you because of drinking? 0::5; 9999 0= Never; 1= Less than monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 5= N/A; 9999= no data
Query audit_02_6b Integer Recommended During the year you drank the most, how often did you need a first drink in the morning to get yourself going after heaving drinking? 0::5; 9999 0= Never; 1= Less than monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 5= N/A; 9999= no data
Query audit_02_7b Integer Recommended During the year you drank the most, how often did you feel guilt or remorse after drinking? 0::5; 9999 0= Never; 1= Less than monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 5= N/A; 9999= no data
Query audit_02_8b Integer Recommended During the year you drank the most, how often were you unable to remember what happened the night before because of drinking? 0::5; 9999 0= Never; 1= Less than monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 5= N/A; 9999= no data
Query audit_03_1 Integer Recommended Since your last visit for the study, how often have you had a drink containing alcohol? 0::4; 9999 0= Never; 1= Monthly or less; 2= 2-4 Times a month; 3= 2-3 Times a week; 4= 4 or More Times a Week; 9999= no data
Query audit_03_2 Integer Recommended Since your last visit for the study, how many standard drinks containing alcohol do you have on a typical day? 0::5; 9999 0= 1 or 2; 1= 3 or 4; 2= 5 or 6; 3= 7 or 9; 4= 10 or more; 9999 = no data; 5=none
Query audit_03_3 Integer Recommended Since your last visit for the study, how often have you had six or more drinks on one occasion? 0::4; 9999 0= Never; 1= Less than Monthly; 2= Monthly; 3= Weekly; 4= Daily or almost daily; 9999= no data
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 visit_number
mini_subuse3 String 100 Recommended Substance Use Disorder: Which drug(s) cause the biggest problems? dudit_12a, dudit_12a_1month, dudit_12a_bl, dudit_12a_fu
dusib String 100 Recommended The drug that you PREFER MOST. Please choose only one. dudit_12b, dudit_12b_1month, dudit_12b_bl, dudit_12b_fu
Query mini_j1a1 Integer Recommended J1a1. Check each drug taken 0::12; 999 0=Stimulants; 1=Cocaine; 2=Narcotics; 3=Hallucinogens; 4=Inhalants; 5=Marijuana; 6=Tranquilizers; 7=Miscellaneous; 8 = Sedative/hypnotic/anxiolytic; 9 = Opioids; 10 = PCP; 11 = Other; 12 = No drug of choice; 999 = Unknown dudit_12c, dudit_12c_1month, dudit_12c_bl, dudit_12c_fu
Query dudit_1_bl Integer Recommended How often do you use drugs other than alcohol? 0::4 0 = Never ; 1 = Once a month or less often ; 2 = 2-4 times a month ; 3 = 2-3 times a week ; 4 = 4 times a week or more often dudit1, dudit_1, dudit_1_1month, dudit_1_fu
Query dudit_2_bl Integer Recommended Do you use more than one type of drug on the same occasion?
0::5
0 = Never ; 1 = Once a month or less often ; 2 = 2-4 times a month ; 3 = 2-3 times a week ; 4 = 4 times a week or more often; 5=NA dudit2, dudit_2, dudit_2_1month, dudit_2_fu
Query dudit_3_bl Integer Recommended How many times do you take drugs on a typical day when you use drugs?
0::5
0 = 0 ; 1 = 1-2 ; 2 = 3-4 ; 3 = 5-6 ; 4 = 7 or more; 5=NA dudit3, dudit_3, dudit_3_1month, dudit_3_fu
Query dudit_4_bl Integer Recommended How often are you influenced heavily by drugs?
0::5
0 = Never ; 1 = Less often than once a month ; 2 = Every month ; 3 = Every week ; 4 = Daily or almost every day; 5=NA dudit4, dudit_4, dudit_4_1month, dudit_4_fu
Query dudit_5_bl Integer Recommended Have you felt that your longing for drugs was so strong that you could not resist it?
0::5
0 = Never ; 1 = Less often than once a month ; 2 = Every month ; 3 = Every week ; 4 = Daily or almost every day; 5=NA dudit5, dudit_5, dudit_5_1month, dudit_5_fu
Query audit1_2 Float Recommended During the year when you drank the most, how often did you have a drink containing alcohol? 0::6 0=Never; 2=Monthly or less; 3=2-4 times a month; 4=4 or more times a week; 5 = NA; 6=2-3 times a week
Query aescode Integer Recommended Staff code number of person completing this form audit_interviewer
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data audit_comments
Query dode String 10 Recommended Date of Data Entry audit_entered
Query audit_tot Integer Recommended Sum of AUDIT1, AUDIT2, and AUDIT3
Query dudit_7 Integer Recommended How often over the past year have you taken drugs and then neglected to do something you should have done?
0::5
0 = Never ; 1 = Less often than once a month ; 2 = Every month ; 3 = Every week ; 4 = Daily or almost every day; 5 = Not Applicable dudit7, dudit_7_1month, dudit_7_bl, dudit_7_fu
Query dudit_10 Integer Recommended Have you or anyone else been hurt (mentally or physically) because you used drugs?
0::5
0 = no; 1=Yes, but not in the time range specified in version_form; 2 = yes, but not over the past year; 3=Yes, during the time range specified in version_form; 4 = yes, over the past year; 5 = not applicable dudit10, dudit_10_1month, dudit_10_bl, dudit_10_fu
Query dudit_11 Integer Recommended Has a relative or a friend, a doctor or a nurse, or anyone else, been worried about your drug use or said to you that you should stop using drugs?
0::8
0 = no; 1=Yes, but not in the time range specified in version_form; 2 = yes, but not over the past year; 3=Yes, during the time range specified in version_form; 4 = yes, over the past year; 5 = not applicable; 6=Yes, but not in the last month; 8=Yes, during the last month dudit11, dudit_11_1month, dudit_11_bl, dudit_11_fu
Query audit_m4 Integer Recommended How often during the last month have you found that you were not able to stop drinking once you had started 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily
Query audit_m5 Integer Recommended How often during the last month have you failed to do what was normally expected of you because of drinking 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily
Query audit_m6 Integer Recommended How often during the last month have you needed a first drink in the morning to get yourself going after a heavy drinking session 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily
Query audit_m7 Integer Recommended How often during the last month have you had a feeling of guilt or remorse after drinking 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily
Query audit_m8 Integer Recommended How often during the last month have you been unable to remember what happened the night before because of your drinking 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily
Query dudit_m3 Integer Recommended How often during the last month have you failed to do what was normally expected of you because of drug use 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily
Query dudit_m4 Integer Recommended How often during the last month have you had a feeling of guilt or remorse after using drugs 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily dudit9, dudit_9
Query dudit_m1 Integer Recommended How often do you use illegal drugs or use prescription drugs in a different way than prescribed 0::4 0= Never; 1= Once per month; 2= 2-4 times per month; 3= 2-3 times per week; 4=4 or more times per week
Query dudit_m2 Integer Recommended How often during the last month have you found that you were not able to stop using drugs once you had started 0::4 0= Never; 1= Less than once per month; 2= Once per month; 3= Weekly; 4= Daily or almost daily dudit6, dudit_6, dudit_6_1month, dudit_6_bl, dudit_6_fu
Query au3_1 Integer Recommended In the last year, how often do you have six or more drinks on one occasion? 0::4 0 = never; 1 = less than monthly; 2 = monthly; 3 = weekly; 4 = daily or almost daily
Query missingsum_obvq Integer Recommended total number of missing items auditmiss_t1, auditmiss_t2, auditmiss_t3, auditmiss_t4
Query auditdx_t1 Integer Recommended Problematic alcohol use diagnosis based of cutoff of a total score of 8 0;1 0= No; 1= Yes audit_cutoff, auditdx_t2, auditdx_t3, auditdx_t4
timepoint_label String 15 Recommended Timepoint/visit label assessment.c
condition_c Integer Recommended Patient Condition 0::2 0 = Control; 1 = Self-Affirmation; 2 = Expressive Writing condition.c
sample Integer Recommended Training or randomized case 1::5 1 = randomized; 2 = training; 3=randomized-control; 4=randomized-intervention; 5=concurrent cohort-intervention
audit12_12 Integer Recommended How many drinks have you ever drunk in a 24 hour period? Specify
alc_first_use_agecoded Integer Recommended The next question is about drinking alcohol. This includes coolers, beer, wine, champagne, liquor such as whiskey, rum, gin, vodka, scotch, or liqueurs, and also any other type of alcohol. About how old were you when you first started drinking, not counting small tastes or sips of alcohol? PX030201_Alcohol_First_Use_Age_Coded 96;97;99 96=Never drank; 97=Refused; 99=Don't know
audit_stopdrink Integer Required How often during the last 3 months have you found that you were not able to stop drinking once you had started? 0::4; 9999 0= Never; 1= Less than Monthly; 2= Monthly; 3= Weekly; 4= Daily or Almost Daily; 9999= no data
audit_failedtodo Integer Required How often during the last 3 months have you failed to do what was normally expected from you because of drinking? 0::4; 9999 0= Never; 1= Less than Monthly; 2= Monthly; 3= Weekly; 4= Daily or Almost Daily; 9999= no data
audit_firstdrink Integer Required How often during the last 3 months have you needed a first drink in the morning to get yourself going after a heavy drinking session? 0::4; 9999 0= Never; 1= Less than Monthly; 2= Monthly; 3= Weekly; 4= Daily or Almost Daily; 9999= no data
audit_guilt Integer Required How often during the last 3 months have you had a feeling of guilt or remorse after drinking? 0::4; 9999 0= Never; 1= Less than Monthly; 2= Monthly; 3= Weekly; 4= Daily or Almost Daily; 9999= no data
audit_remember Integer Required How often during the last 3 months have you been unable to remember what happened the night before because you had been drinking? 0::4; 9999 0= Never; 1= Less than Monthly; 2= Monthly; 3= Weekly; 4= Daily or Almost Daily; 9999= no data
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.