Jump to content

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

Values in the field should be unique.

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.

cell_id string(14)

Checks:

Values in the field should be unique.

Definition: RUCDR sample id, "RUID"

Sample value:  03C19340

For subjects with multiple samples at RUCDR, please include the blood sample in the main submission file. Additional sample IDs can be submitted in the Alternate ID (_id) file. For timepoint studies where multiple blood draws were used in analysis, please contact the help desk (help@nrgr.on.spiceworks.com) for further guidance.

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

site_id integer(5)

Checks:

site_id should be between 10 and 99999.

Definition: Submitting site within a study.

Sample value: 101

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

study_id integer(3)

Checks:

study_id should be between 0 and 999.

Definition: Study number assigned by the NIMH RGR

Sample value: 22

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

 

father_id string

Format:

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

Definition: Id for the father of this individual in the specified format

in Sample value: 22-101-00132-90000

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

mother_id string

Format:

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

Definition: Id for the mother of this individual in the specified format

Sample value: 22-101-00132-90001

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

fam_id string

Format:

<unique number>

Definition: Family id of this individual in the specified format

Sample value: 00132

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

subject_type string(2)

Valid Values:

P=Proband or Affected

NP=Not Proband; Unaffected relative of a proband

C=Control; unaffected, non-relative

D=Dummy; subject used for linking pedigrees, no additional data submitted

Definition: Subject type, including proband and dummy individuals.

Sample value: P

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

Comments: The value P is used to represent the Proband in the context of family studies, or an affected individual in other study designs. The value D represents a Dummy record, which is used to fill out a pedigree when family relations are known, but important linking individuals did not participate in the study. If you have subjects that do not fit any of these subject types (for example, informants in family history interviews) please ask the helpdesk for assistance help@nrgr.on.spiceworks.com

zygosity string(2)

Valid Values:

MZ=Monozygotic

DZ=Dizygotic

TZ=Trizygotic

UZ=Multiple birth, but unknown zygosity

NULL=Missing or not applicable or unknown

Definition: Zygosity of this individual

Sample value: MZ

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

sex string(1)

Valid Values:

M=Male

F=Female

NULL=Missing or not applicable or unknown

Definition: Sex

Sample value: F

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

 
race string(1)

Valid Values:

W=White

I=American Indian

A=Asian

B=Black

P=Pacific Islander

M=More than one

NULL=Missing or not applicable or unknown

Definition: Race according to the NIH Policy on Reporting Race and Ethnicity Data for Subjects In Clinical Research

Sample value: P

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

ethnicity string(1)

Valid Values:

H=Hispanic

N=Not-hispanic

NULL=Missing or not applicable or unknown

Definition: Ethnicity according to the NIH Policy on Reporting Race and Ethnicity Data for Subjects In Clinical Research

Sample value: H

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

Submissions for Autism

age_months integer(4)

Format:

Age (months).

Checks:

Age should be between 0 and 1560.

Definition: Age of individual in months at time of first study assessment

Sample value: 240

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

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 disorder

Sample value: 200

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

Submissions for Other Disorders

age_years integer(3)

Format:

Age (years).

Checks:

Age should be between 0 and 130.

Definition: Age of individual in years at time of first study assessment

Sample value: 24

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

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 disorder

Sample value: 20

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL


yob integer(4)

Checks:

Year of Birth should be between 1800 and <current_year>.

 

Definition: Year of birth

Sample value: 1999

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

deceased string(1)

Valid Values:

Y=Yes

N=No

NULL=Missing or not applicable or unknown

Definition: Whether individual is deceased

Sample value: N

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

yod integer(4)

Year of Death should be between 1800 and <current_year>.

 

Definition: Year of Death

Sample value: 2005

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

dx_study string

Valid Values:

Only values specified in the 'code' column of the are allowed here.

Definition: Investigator-provided overall primary diagnosis.

Sample value: SADD

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

Comments: The dx provided in the column is meant to allow future investigators to match the dx's described in corresponding publications with the data stored in the repository. For example, if in your paper you describe 4 dx groups: Schizophrenia, Schizophrenia-spectrum, Bipolar, Bipolar-spectrum, this is where you would indicate how subjects in your study were grouped into those 4 categories. (In this case, the dx_system would be "Other" and a corresponding _dx dictionary would describe what criteria were used in grouping)

dx_system string(6)

Valid Values:

DSM3R=DSM III revised

DSM4=DSM IV

DSM4TR=DSM IV Text Revision

Other=User defined or non-standard diagnostic system

NULL=Missing or not applicable or unknown

Definition: diagnostic system for overall diagnosis including version

Sample value: Other

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

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

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

Note: a dx_confidence vale of "4" IS compatible with a dx_external_support value of "E"

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 (information not submitted to the repository)

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

Note: dx based on any source or instrument, even one administered by the study itself, should be coded E=external, if not deposited.  

Empty string is considered an invalid value.

Empty strings should be represented with the value NULL

consent string(3)

A value is required if and only if subject_type is not a dummy.

Valid Values:

GRU=General Research Use

REL=Disorder and Related Disorders

DIS=Specific Disorder Only

Definition:  The type of consent granted by the subjects on the use of their data.

Sample value: REL

Detailed definition of "REL": Related Mental Health Conditions - Use of the data must be related to mental health research only. This includes methods development provided there is sufficient evidence that it will contribute to methodology that will further mental health research.