Extended Diagnosis File

Back to Submission Requirements

Column Name

Type

Format / Value Checks

Additional Comments

ind_id

string

Format:

<study_id>-<site_id>-<fam_id>-<subject_id>

Checks:

Field is a required field and cannot be left empty.

Definition: A unique id for each individual in the specified format

Sample value: 22-101-00132-00001

If your study does not include families, please submit <study_id>-<site_id>-<subject_id>-<subject_id>

Comments: IMPORTANT-- This id is used to verify subject \ cell_id pairs at RUCDR. Therefore, the id you submit here should match exactly the subject-code submitted to RUCDR. If IDs submitted to RUCDR do not match this format, NRGR will re-format and record the ID updates prior to release.

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(6)

Valid Values:

DSM3R=DSM III revised

DSM4=DSM IV

DSM4TR=DSM IV Text Revision

Checks:

Field is a required field and cannot be left empty.

Definition: diagnostic system for specific diagnosis

Sample value: DSM4TR

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.

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