Jump to content

Extended Diagnosis File

Column Name Type Format / Value Checks Additional Comments
ind_id string

Checks:

Must match exactly with Subject Code submitted to RUCDR.

Field is a required field and cannot be left empty.

Definition: The unique individual id submitted to RUCDR with the biosample.

Comments: IMPORTANT-- This id is used to verify subject \ RUID pairs at RUCDR. Therefore, the id you submit here should match exactly the subject-code submitted to RUCDR.

dx_rank integer

Valid Values:

Integer 1 or greater.

Checks:

Field is a required field and cannot be left empty.

Definition: Since an individual may have several rows with diagnostic codes, this column ranks the diagnosis by order of importance. The most important diagnosis should have the value 1, the second most important the value 2, and so on in order of decreasing importance. Several diagnosis at the same rank are allowed.

Sample value:  1

dx_study string

Valid Values:

A diagnostic code values from the DSM or an approved diagnostic system.

Checks:

Field is a required field and cannot be left empty.

Definition: Investigator-provided specific diagnosis in a given diagnostic system.

Sample value: 295.70

Comments: dx codes in this file should use a standard dx_system [text or excel], specified in the Notice of Grant Award. Typically this system is DSM.

If you want to use a diagnostic codes in a system other than DSM, please submit a diagnosis data dictionary file (in Investigator-Defined Main Diagnosis (_dx) File format) to help@nrgr.on.spiceworks.com for approval.

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 specific diagnosis

Sample value: SS

Comments: dx codes in this file should use a standard dx_system [text or excel], specified in the Notice of Grant Award. Typically this system is DSM.

If you want to use a diagnostic codes in a system other than DSM, please submit a diagnosis data dictionary file (in Investigator-Defined Main Diagnosis (_dx) File format) to help@nrgr.on.spiceworks.com for approval.

dx_confidence integer

Valid Values:

1=Unknown; diagnosis asserted but completeness of diagnosis and status of supporting information is unknown

2=Low; only some diagnostic criteria met

3=Medium; all criteria met, no supporting information

4=High; all criteria met and has supporting information

NULL=Not Applicable

Definition: Confidence on the diagnosis in dx field

Sample value: 4

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

dx_external_support string(1)

Valid Values:

E=Diagnosis supported by external information

I=Diagnosis supported by data submitted to repository

NULL=Missing or not applicable or unknown


Definition: Diagnosis based on information that is not (or cannot be) submitted to the Center. This missing information overrules some information that was submitted to the Center. For example, medical records, interviews with family members, etc.

Sample value: I

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

Submissions for Autism

age_onset_months integer(4)

Format:

Age of Onset (months).

Checks:

Age should be between 0 and 1560.

Definition: Age of individual in months at time of onset of specific diagnosis

Sample value: 200

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

Submissions for Other Disorders

age_onset_years integer(3)

Format:

Age of Onset (years).

Checks:

Age should be between 0 and 130.

Definition: Age of individual in years at time of onset of specific diagnosis

Sample value: 20

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL