Jump to content

Diagnosis File

Diagnosis File

Column Name Type Format / Value Checks Additional Comments
study_id integer(3)

Cannot be left empty

Values of the (study_id, dx_study) must be unique

Definition: Study ID assigned to your project by NRGR.

Sample value:  270

dx_study string

Cannot be left empty

Values of the (study_id, dx_study) must be unique

Definition: A unique, short code used to represent a diagnosis code contained in the dx_study column of the submission file.

Sample value:  SADD

dx_system string(15)

Valid Values:

DSM3R=Diagnostic and Statistical Manual of Mental Disorders, 3rd Edition, Revision (DSM-III-R)

NRGR_DSM3R=Supplemental codes for DSM3R, curated by NRGR

DSM4=Diagnostic and Statistical Manual of Mental Disorders, 4th Edition & 4th Edition, Text Revision

NRGR_DSM4=Supplemental codes for DSM4, curated by NRGR

DSM5_ICD9=Diagnostic and Statistical Manual of Mental Disorders, 5th Edition. International Statistical Classification of Diseases and Related Health Problems, 9th Revision

NRGR_DSM5_ICD9=Supplemental codes for DSM5-ICD9, curated by NRGR

DSM5_ICD10=Diagnostic and Statistical Manual of Mental Disorders, 5th Edition. International Statistical Classification of Disease and Related Health Problems, 10th Revision

NRGR_DSM5_ICD10=Supplemental codes for DSM5-ICD9, curated by NRGR

RDC=Research Diagnostic Criteria Codes

MRDC=Modified Research Diagnostic Criteria Codes

SS=Study Specific

Definition: diagnostic system for overall diagnosis including version

Sample value: SS

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

Comments: Most frequently, the dx_system will be "SS" to allow for study-specific categorization

definition string Cannot be left empty

Definition: A long value used to represent the diagnosis code contained in the dx_study column of the submission file.

Sample valueSchizoaffective disorder, depressive type

description string Cannot be left empty

Definition: Detailed description for the diagnosis code used in the dx_study column of the submission file.

Sample value: Schizoaffective disorder, depressive type, diagnosed using the Structured Clinical Instrument for DSM Disorders