--- table: _subjects maps: subject_table cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: subjectID like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: name dtype: str maps: name hide: yes - name: phone dtype: str(10) maps: phone like: "[0-9]{10}" hide: yes - name: gender dtype: str(6) maps: gender case: lower like: "(male|female)" - name: date_of_birth dtype: date maps: subjectID like: "^\\d{4}-\\d{2}-\\d{2}$" replace: value: subjectID to: DOB file: "" - name: city dtype: str maps: city case: lower like: "[a-z A-Z]+" hide: yes - name: update_timestamp dtype: datetime maps: date --- table: _assessments maps: mainassessment_table cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: subjectID like: "D[0-9]{4}" refs: "_subjects.subject" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: appointment_date dtype: datetime maps: deep_date - name: update_timestamp dtype: datetime maps: Tdate --- table: _clinical_global_impression maps: cgitable refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: severity_of_illness dtype: integer maps: ans1 between: [0,7] - name: global_improvement dtype: integer maps: ans2 between: [0,7] - name: efficacy_index dtype: integer maps: ans3 between: [0,15] - name: score dtype: integer maps: Stotal between: [0,29] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _hindi_mental_state_examination maps: hindi__mental__state__examinationtable refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: time_of_day dtype: boolean maps: ans1 - name: day_of_week dtype: boolean maps: ans2 - name: date_of_month dtype: boolean maps: ans3 - name: month_of_year dtype: boolean maps: ans4 - name: season_of_year dtype: boolean maps: ans5 - name: village_post_office dtype: boolean maps: ans6 - name: village_district dtype: boolean maps: ans7 - name: village_name dtype: boolean maps: ans8 - name: area_number dtype: boolean maps: ans9 - name: place_name dtype: boolean maps: ans10 - name: object_registration dtype: integer maps: ans11 betweeen: [0,3] - name: world_backwards dtype: integer maps: ans12 betweeen: [0,5] - name: object_recall dtype: integer maps: ans13_14_15 betweeen: [0,5] - name: name_watch dtype: boolean maps: ans17 - name: name_pen dtype: boolean maps: ans18 - name: repeat_phrase dtype: boolean maps: ans19 - name: follow_command dtype: boolean maps: ans20 - name: three_step_task dtype: integer maps: ans21 betweeen: [0,3] - name: score dtype: integer maps: total - name: attempted dtype: integer maps: attended_ques - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _adult_adhd_self_report_scale maps: adult_adhd_self_report_scaletable refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: trouble_wrapping_final_details dtype: str(10) maps: ans1 in: [Never, Rarely, Sometimes, Often, Very Often] - name: difficulty_in_organization dtype: str(10) maps: ans2 in: [Never, Rarely, Sometimes, Often, Very Often] - name: problem_remembering_appointments dtype: str(10) maps: ans1 in: [Never, Rarely, Sometimes, Often, Very Often] - name: avoid_challenging_tasks dtype: str(10) maps: ans4 in: [Never, Rarely, Sometimes, Often, Very Often] - name: fidget_while_seated dtype: str(10) maps: ans5 in: [Never, Rarely, Sometimes, Often, Very Often] - name: overly_active dtype: str(10) maps: ans6 in: [Never, Rarely, Sometimes, Often, Very Often] - name: careless_mistakes_on_boring_tasks dtype: str(10) maps: ans7 in: [Never, Rarely, Sometimes, Often, Very Often] - name: difficulty_focusing_on_boring_tasks dtype: str(10) maps: ans8 in: [Never, Rarely, Sometimes, Often, Very Often] - name: difficulty_focusing_on_people_speaking dtype: str(10) maps: ans9 in: [Never, Rarely, Sometimes, Often, Very Often] - name: difficulty_finding_things dtype: str(10) maps: ans10 in: [Never, Rarely, Sometimes, Often, Very Often] - name: easily_distracted_by_noise dtype: str(10) maps: ans11 in: [Never, Rarely, Sometimes, Often, Very Often] - name: difficulty_remaining_seated dtype: str(10) maps: ans12 in: [Never, Rarely, Sometimes, Often, Very Often] - name: feel_restless dtype: str(10) maps: ans13 in: [Never, Rarely, Sometimes, Often, Very Often] - name: difficulty_unwinding_in_seclusion dtype: str(10) maps: ans14 in: [Never, Rarely, Sometimes, Often, Very Often] - name: talkative_in_social_situations dtype: str(10) maps: ans15 in: [Never, Rarely, Sometimes, Often, Very Often] - name: finish_sentences_for_others dtype: str(10) maps: ans16 in: [Never, Rarely, Sometimes, Often, Very Often] - name: difficulty_waiting_for_turn dtype: str(10) maps: ans17 in: [Never, Rarely, Sometimes, Often, Very Often] - name: integererrupt_others_when_busy dtype: str(10) maps: ans18 in: [Never, Rarely, Sometimes, Often, Very Often] - name: age_during_first_occurence_of_problem dtype: integer maps: problm like: "[0-9]+" between: [1,100] - name: symptoms_not_consistent_with_adhd dtype: integer maps: A_White between: [0,6] - name: additional_cues_not_consistent_with_adhd dtype: integer maps: B_White between: [0,12] - name: symptoms_highly_consistent_with_adhd dtype: integer maps: A_Dark between: [0,6] - name: additional_cues_consistent_with_adhd dtype: integer maps: B_Dark between: [0,12] - name: not_consistent_with_adhd_score dtype: integer maps: AB_White between: [0,18] - name: consistent_with_adhd_score dtype: integer maps: AB_Dark between: [0,18] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _modified_kuppuswamy_socioeconomic_scale maps: modified_kuppuswamy_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: education_level dtype: integer maps: education between: [1,7] - name: occupation_level dtype: integer maps: occupation between: [1,10] - name: income_level dtype: integer maps: Income between: [1,12] - name: score dtype: integer maps: stotal between: [1,29] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _work_and_social_adjustment_scale maps: workandsocial_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: unrelated_retirement dtype: boolean maps: retired - name: work_ability_impaired dtype: integer maps: be between: [0,8] - name: home_management_impaired dtype: integer maps: bec between: [0,8] - name: social_activities_impaired dtype: integer maps: beca between: [0,8] - name: private_activities_impaired dtype: integer maps: becau between: [0,8] - name: relationships_impaired dtype: integer maps: becaus between: [0,8] - name: score dtype: integer maps: total between: [0,40] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _global_assessment_of_functioning maps: globalassessmentoffunctioningscale_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: score dtype: integer maps: Persistent like: "[0-9]{1,3}" betweeen: [0,100] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _adverse_childhood_experiences maps: adversechildhoodexperiencesinternational_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: age dtype: integer maps: How like: "[0-9]{1,3}" between: [1,100] - name: ethnic_background dtype: str maps: Whatis case: lower - name: level_of_education dtype: str maps: Whatisthe like: "(No formal schooling|Less than primary school|Primary school completed|Secondary\/High school completed|College\/University completed|Post graduate degree|Refused)" - name: work_status dtype: str maps: Whichof like: "(Government employee|Non-government employee|Self-employed|Non-paid|Student|Homemaker|Retired|Unemployed but able to work|Unemployed as unable to work|Refused)" replace: - value: "Unemploed (able to work)" to: "Unemployed but able to work" - value: "Unemployed (unable to work" to: "Unemployed as unable to work" - name: civic_status dtype: str maps: Whatisyour like: "(Married|Living as couple|Divorced or separated|Single|Widowed|Other|Refused)" replace: - value: "Married (Go to Q.M2)" to: "Married" - value: "Widowed (Go to Q.M2)" to: "Widowed" - name: been_married dtype: boolean maps: Have replace: - value: "No (Go to Q.M5)" to: "No" - name: age_of_marriage dtype: integer maps: Atwhat like: "[0-9]{1,2}" between: [1,99] - name: freedom_of_choice_to_marry dtype: str maps: Atthetime like: "(Yes|No|Not sure|Refused)" replace: - value: "Yes (Go to Q.M5)" to: "Yes" - value: "Don't know / Not sure" to: "Not sure" - name: consent_for_marriage dtype: str maps: Atthetimeof like: "(Yes|No|Refused)" - name: age_during_first_baby dtype: str maps: Ifyouare like: "(1[5-9]|[2-6][0-9]|Not Applicable|Refused)" - name: parents_understood_problems dtype: str maps: Didyour like: "(Always|Most of the time|Sometimes|Rarely|Never|Refused)" - name: parents_knew_hobbies dtype: str maps: Didyourparents like: "(Always|Most of the time|Sometimes|Rarely|Never|Refused)" - name: parents_starved_subject dtype: str maps: Howoften like: "(Many times|A few times|Once|Never|Refused)" - name: neglect_due_to_drugs dtype: str maps: Wereyour like: "(Many times|A few times|Once|Never|Refused)" - name: parents_deprived_education dtype: str maps: Howoftendidyour like: "(Many times|A few times|Once|Never|Refused)" - name: drug_addict_in_household dtype: str maps: Didyoulivewith like: "(Yes|No|Refused)" - name: mentally_disturbed_in_household dtype: str maps: Didyoulivewitha like: "(Yes|No|Refused)" - name: prisoner_in_household dtype: str maps: Didyoulivewithahousehold like: "(Yes|No|Refused)" - name: parents_separated dtype: str maps: Wereyourparentseve like: "(Yes|No|Not Applicable|Refused)" - name: parent_died dtype: str maps: Didyourmother like: "(Yes|No|Not sure|Refused)" replace: - value: "Don't know / Not sure" to: "Not sure" - name: verbal_abuse_in_household dtype: str maps: Didyouseeor like: "(Many times|A few times|Once|Never|Refused)" - name: mild_physical_abuse_in_household dtype: str maps: Didyouseeorhear like: "(Many times|A few times|Once|Never|Refused)" - name: severe_physical_abuse_in_household dtype: str maps: Didyouseeorhearaparent like: "(Many times|A few times|Once|Never|Refused)" - name: verbal_abuse_on_subject dtype: str maps: Didaparentguardian like: "(Many times|A few times|Once|Never|Refused)" - name: abandon_threat_on_subject dtype: str maps: Didaparentguardianor like: "(Many times|A few times|Once|Never|Refused)" - name: mild_physical_abuse_on_subject dtype: str maps: Didaparentguardianorotherhouseholdmember like: "(Many times|A few times|Once|Never|Refused)" - name: severe_physical_abuse_on_subject dtype: str maps: Didaparentguardianorotherhouseholdmemberhit like: "(Many times|A few times|Once|Never|Refused)" - name: sexual_harassment_on_subject dtype: str maps: Didsomeonetouch like: "(Many times|A few times|Once|Never|Refused)" - name: subject_forced_into_sexual_activities dtype: str maps: Didsomeonemake like: "(Many times|A few times|Once|Never|Refused)" - name: forced_sexual_attempt_on_subject dtype: str maps: Didsomeoneattemptoral like: "(Many times|A few times|Once|Never|Refused)" - name: forced_sex_with_subject dtype: str maps: Didsomeoneactuallyhaveoralanal like: "(Many times|A few times|Once|Never|Refused)" - name: subject_bullied dtype: str maps: Howoftenwereyou like: "(Many times|A few times|Once|Never|Refused)" replace: - value: "Never (Go to Q.V3)" to: "Never" - name: bullied_method_or_cause dtype: str maps: Howwereyoubulliedmost like: "(I was hit, kicked, pushed, shoved around, or locked indoors|I was made fun of because of my race, nationality or colour|I was made fun of because of my religion|I was made fun of with sexual jokes, comments, or gestures|I was left out of activities on purpose or completely ignored|I was made fun of because of how my body or face looked|I was bullied in some other way|Refused)" - name: subject_involved_in_fight dtype: str maps: Howoftenwereyouin like: "(Many times|A few times|Once|Never|Refused)" - name: witnessed_physical_violence dtype: str maps: Didyouseeor1 like: "(Many times|A few times|Once|Never|Refused)" - name: witnessed_murder dtype: str maps: Didyouseeorhear1 like: "(Many times|A few times|Once|Never|Refused)" - name: witnessed_murder_threat dtype: str maps: Didyouseeorhearsomeonebeing like: "(Many times|A few times|Once|Never|Refused)" - name: forced_migration dtype: str maps: Wereyouforced like: "(Many times|A few times|Once|Never|Refused)" - name: home_destroyed_in_violence dtype: str maps: Didyouexperience like: "(Many times|A few times|Once|Never|Refused)" - name: physical_abuse_by_police dtype: str maps: Wereyoubeaten like: "(Many times|A few times|Once|Never|Refused)" - name: relative_murdered_or_beaten_by_police dtype: str maps: Wasafamily like: "(Many times|A few times|Once|Never|Refused)" - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _adult_temperament maps: adulttemperamentquestionnaire_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: frightened_easily dtype: integer maps: Ibecome between: [0,7] - name: late_for_appointments dtype: integer maps: Iam between: [0,7] - name: happiness_due_to_mild_events dtype: integer maps: Sometimes between: [0,7] - name: irritated_by_loud_noises dtype: integer maps: Ifindloud between: [0,7] - name: hard_to_alternate_between_tasks dtype: integer maps: Its between: [0,7] - name: not_annoyed_with_slow_lines dtype: integer maps: Irarelybecome between: [0,7] - name: not_enjoy_loud_music_with_laser dtype: integer maps: Iwould between: [0,7] - name: not_follow_plans dtype: integer maps: Ioften between: [0,7] - name: departure_of_relatives_not_saddening dtype: integer maps: Irarelyfeel between: [0,7] - name: attention_not_captured_by_minor_visuals dtype: integer maps: Barely between: [0,7] - name: sit_still_even_when_energized dtype: integer maps: Even between: [0,7] - name: uneasiness_at_high_places dtype: integer maps: Looking between: [0,7] - name: subtle_tone_aswareness_in_music dtype: integer maps: when_1 between: [0,7] - name: dislike_socalizing_job dtype: integer maps: Iwouldnot between: [0,7] - name: keep_performing_task_even_if_dont_want dtype: integer maps: Ican between: [0,7] - name: unable_to_enjoy_joyful_activities dtype: integer maps: Isometimes between: [0,7] - name: annoyance_when_item_not_in_store dtype: integer maps: Ifind between: [0,7] - name: notice_emotional_aspects_in_pictures dtype: integer maps: Itend between: [0,7] - name: like_to_talk_a_lot dtype: integer maps: Iusually between: [0,7] - name: not_sad_watching_sad_movie dtype: integer maps: Iseldombecome between: [0,7] - name: aware_of_bird_sounds_in_vicinity dtype: integer maps: Im between: [0,7] - name: uneasy_in_small_places dtype: integer maps: WhenIam between: [0,7] - name: listen_to_music_at_high_volume dtype: integer maps: Whenlistening between: [0,7] - name: understand_things_intuitively dtype: integer maps: Isometimesseem between: [0,7] - name: sad_due_to_minor_events dtype: integer maps: Sometimesminor between: [0,7] - name: easy_hold_laugh_when_appropriate dtype: integer maps: Itis between: [0,7] - name: work_difficult_task_when_not_feel_like_trying dtype: integer maps: Icanmake between: [0,7] - name: frequently_experience_brief_intense_happiness dtype: integer maps: Irarelyever between: [0,7] - name: easily_distracted_when_trying_to_focus dtype: integer maps: WhenIamtrying between: [0,7] - name: enjoy_playing_fast_noisy_game dtype: integer maps: Iwouldprobably between: [0,7] - name: become_agitated_while_waiting dtype: integer maps: Whenever between: [0,7] - name: bothered_by_bright_light dtype: integer maps: Imoften between: [0,7] - name: not_notice_people_eye_color dtype: integer maps: Irarely between: [0,7] - name: not_sad_on_hearing_sad_event dtype: integer maps: Iseldom between: [0,7] - name: focus_back_when_interrupted dtype: integer maps: Wheninterrupted between: [0,7] - name: scratchy_sounds_irritating dtype: integer maps: Ifindcertain between: [0,7] - name: like_many_people_conversations dtype: integer maps: Ilike between: [0,7] - name: patient_person dtype: integer maps: Iamusually between: [0,7] - name: see_visual_images_when_eyes_closed dtype: integer maps: WhenIamresting between: [0,7] - name: difficult_to_focus_when_distressed dtype: integer maps: Itisveryhard between: [0,7] - name: mind_has_diverse_thoughts_sometimes dtype: integer maps: Sometimesmymind between: [0,7] - name: bothered_by_bright_colors dtype: integer maps: Very between: [0,7] - name: resist_talking_out_of_turn dtype: integer maps: Icaneasily between: [0,7] - name: not_enjoy_wild_carnival_ride dtype: integer maps: Iwouldprobablynot between: [0,7] - name: sad_for_more_than_an_hour dtype: integer maps: Isometimesfeel between: [0,7] - name: rarely_enjoy_socializing dtype: integer maps: Irarelyenjoy between: [0,7] - name: get_right_to_work_on_things dtype: integer maps: IfI between: [0,7] - name: easily_frustrated dtype: integer maps: Itdoesnttake between: [0,7] - name: easily_made_happy dtype: integer maps: Itdoesnttakemuch between: [0,7] - name: hard_focusing_due_to_upcoming_event dtype: integer maps: WhenIamhappy between: [0,7] - name: panic_for_no_reason dtype: integer maps: SometimesIfeel between: [0,7] - name: notice_mild_odours dtype: integer maps: Ioftennotice between: [0,7] - name: trouble_resisting_cravings dtype: integer maps: Ioftenhave between: [0,7] - name: bothered_by_flashing_lights dtype: integer maps: Colorful between: [0,7] - name: finish_things_before_due_date dtype: integer maps: Iusuallyfinishdoing between: [0,7] - name: often_feel_sad dtype: integer maps: Ioftenfeelsad between: [0,7] - name: aware_of_color_affecting_mood dtype: integer maps: Iamoftenaware between: [0,7] - name: remain_calm_when_things_not_smooth dtype: integer maps: Iusuallyremain between: [0,7] - name: loud_music_unpleasant dtype: integer maps: Loud between: [0,7] - name: jump_right_in_when_excited dtype: integer maps: WhenImexcitedabout between: [0,7] - name: scared_by_loud_noises dtype: integer maps: Loudnoises between: [0,7] - name: have_vivid_dreams dtype: integer maps: Isometimesdream between: [0,7] - name: hard_resisting_attractive_items dtype: integer maps: WhenIsee between: [0,7] - name: enjoy_laser_show dtype: integer maps: Iwouldenjoywatching between: [0,7] - name: sad_on_hearing_sad_event dtype: integer maps: WhenIhear between: [0,7] - name: do_not_notice_setting_in_movie dtype: integer maps: WhenIwatchamovie between: [0,7] - name: spend_free_time_with_people dtype: integer maps: Iusuallyliketospend between: [0,7] - name: not_frightened_by_people_suddenly dtype: integer maps: Itdoesnot between: [0,7] - name: aware_of_weather_affecting_mood dtype: integer maps: Iamoftenconsciously between: [0,7] - name: takes_lot_make_me_happy dtype: integer maps: Ittakesalot between: [0,7] - name: rarely_aware_of_texture dtype: integer maps: Iamrarelyaware between: [0,7] - name: avoid_dealing_with_unexpected_situations dtype: integer maps: WhenIamafraidofhow between: [0,7] - name: enjoy_talk_without_thinking dtype: integer maps: Iespecially between: [0,7] - name: creative_ideas_without_effort dtype: integer maps: Withoutapplying between: [0,7] - name: not_concerned_about_failing dtype: integer maps: WhenItry between: [0,7] - name: easily_inhibit_fun_but_inappropriate_acts dtype: integer maps: Itiseasy between: [0,7] - name: not_enjoy_yelling dtype: integer maps: Iwouldnotenjoy between: [0,7] - name: score dtype: integer maps: total_score between: [0,539] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _mini_ipip_scale maps: theminiipipscale_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: life_of_party dtype: boolean maps: e1 - name: sympathize_with_others dtype: boolean maps: a1 - name: complete_chores_immediately dtype: boolean maps: c1 - name: frequent_mood_swings dtype: boolean maps: n1 - name: vivid_imagination dtype: boolean maps: i1 - name: talk_less dtype: boolean maps: e2 - name: not_interested_in_others_problems dtype: boolean maps: a2 - name: forget_to_put_things_back dtype: boolean maps: c2 - name: mostly_relaxed dtype: boolean maps: n2 - name: not_interested_in_abstract_ideas dtype: boolean maps: i2 - name: talk_to_different_people dtype: boolean maps: e3 - name: feel_others_emotions dtype: boolean maps: a3 - name: like_order dtype: boolean maps: c3 - name: easily_upset dtype: boolean maps: n3 - name: difficulty_understanding_abstract_ideas dtype: boolean maps: i3 - name: keep_in_background dtype: boolean maps: e4 - name: not_interested_in_others dtype: boolean maps: a4 - name: mess_up_things dtype: boolean maps: c4 - name: seldom_feel_blue dtype: boolean maps: n4 - name: not_good_imagination dtype: boolean maps: i4 - name: extraversion_score dtype: integer maps: total_e between: [0,4] - name: agreeableness_score dtype: integer maps: total_a between: [0,4] - name: conscientiousness_score dtype: integer maps: total_c between: [0,4] - name: neuroticism_score dtype: integer maps: total_n between: [0,4] - name: imagination_score dtype: integer maps: total_i between: [0,4] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _hamilton_anxiety_rating maps: hamiltonanxietyratingscale_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: anxiety dtype: integer maps: Anxiousmood between: [0,4] - name: tension dtype: integer maps: Tension between: [0,4] - name: fears dtype: integer maps: Fears between: [0,4] - name: insomnia dtype: integer maps: Insomnia between: [0,4] - name: intellectuality dtype: integer maps: Intellectual between: [0,4] - name: depressed_mood dtype: integer maps: Depressed between: [0,4] - name: somatic_muscular dtype: integer maps: Somatic between: [0,4] - name: somatic_sensory dtype: integer maps: Somaticsensory between: [0,4] - name: cardiovascular_symptoms dtype: integer maps: Cardiovascular between: [0,4] - name: respiratory_symptoms dtype: integer maps: Respiratory between: [0,4] - name: gastrointestinal_symptoms dtype: integer maps: Gastrointestinal between: [0,4] - name: genitourinary_symptoms dtype: integer maps: Genitourinary between: [0,4] - name: autonomic_symptoms dtype: integer maps: Autonomic between: [0,4] - name: behavior dtype: integer maps: Behavior between: [0,4] - name: score dtype: integer maps: total betweeen: [0,56] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _hamilton_depression_rating maps: hamiltonratingscalefordepression_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: depression dtype: integer maps: Depressed between: [0,4] - name: guilty_feeling dtype: integer maps: Feelings between: [0,4] - name: suicidal_feeling dtype: integer maps: Suicide between: [0,4] - name: early_insomnia dtype: integer maps: Insomnia between: [0,2] - name: middle_insomnia dtype: integer maps: InsomniaMiddle between: [0,2] - name: late_insomnia dtype: integer maps: InsomniaLate between: [0,2] - name: work_and_activities dtype: integer maps: Work between: [0,4] - name: retardation dtype: integer maps: Retardation between: [0,4] - name: agitation dtype: integer maps: Agitation between: [0,2] - name: psychic_anxiety dtype: integer maps: Anxiety between: [0,4] - name: somatic_anxiety dtype: integer maps: AnxietySomatic between: [0,4] - name: gastrointestinal_symptoms dtype: integer maps: Somatic between: [0,2] - name: general_somatic_symptoms dtype: integer maps: SomaticSymptoms between: [0,2] - name: genital_symptoms dtype: integer maps: Genita between: [0,2] - name: hypochondriasis dtype: integer maps: Hypochondriasis between: [0,4] - name: loss_of_weight_by_history dtype: integer maps: Loss_a between: [0,2] - name: loss_of_weight_by_weekly dtype: integer maps: Loss_b between: [0,2] - name: insight dtype: integer maps: Insight between: [0,2] - name: score dtype: integer maps: total between: [0,52] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _negative_symptoms_assessment maps: sans_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: facial_expression_unchanged dtype: integer maps: Unchanged between: [0,5] - name: decreased_spontaneous_movements dtype: integer maps: Decreased between: [0,5] - name: expressive_gestures_paucity dtype: integer maps: Paucity between: [0,5] - name: poor_eye_contact dtype: integer maps: Poor between: [0,5] - name: affective_nonresponsiveness dtype: integer maps: Affective between: [0,5] - name: inappropriate_effect dtype: integer maps: Inappropriate between: [0,5] - name: vocal_inflections_absence dtype: integer maps: Lack between: [0,5] - name: affective_flattening_global_response dtype: integer maps: Global1 between: [0,5] - name: poverty_of_speech dtype: integer maps: Poverty between: [0,5] - name: speech_content_poverty dtype: integer maps: Povertyof between: [0,5] - name: thoughts_interrupted dtype: integer maps: Blocking between: [0,5] - name: response_latency_increase dtype: integer maps: Increased between: [0,5] - name: alogia_global_rating dtype: integer maps: GlobalRating between: [0,5] - name: grooming_rating dtype: integer maps: Grooming between: [0,5] - name: work_impersistence dtype: integer maps: Impersistence between: [0,5] - name: physical_anergia dtype: integer maps: Physical between: [0,5] - name: avolition_apathy_global_rating dtype: integer maps: GlobalRatingof between: [0,5] - name: recreational_interests dtype: integer maps: Recreational between: [0,5] - name: sexual_activity dtype: integer maps: Sexual between: [0,5] - name: closeness_feel_ability dtype: integer maps: Ability between: [0,5] - name: relationship_with_friends dtype: integer maps: Relationships between: [0,5] - name: anhedonia_asociality_global_rating dtype: integer maps: GlobalRatingofAnhedonia between: [0,5] - name: social_inattentiveness dtype: integer maps: Social1 between: [0,5] - name: mental_status_testing_inattentiveness dtype: integer maps: Inattentiveness between: [0,5] - name: attention_global_rating dtype: integer maps: GlobalRatingofAttention between: [0,5] - name: affective_score dtype: integer maps: affective_total between: [0,40] - name: alogia_score dtype: integer maps: alogia_total between: [0,25] - name: avolition_score dtype: integer maps: avolition_total between: [0,20] - name: anhedonia_score dtype: integer maps: anhedonia_total between: [0,25] - name: attention_score dtype: integer maps: attention_total between: [0,15] - name: score dtype: integer maps: total between: [0,125] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _positive_symptoms_assessment maps: saps_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: auditory_hallucinations dtype: integer maps: Auditory between: [0,5] - name: voices_commenting dtype: integer maps: Voices between: [0,5] - name: voices_conversing dtype: integer maps: VoicesConversing between: [0,5] - name: somatic_hallucinations dtype: integer maps: Somaticor between: [0,5] - name: olfactory_hallucinations dtype: integer maps: Olfactory between: [0,5] - name: visual_hallucinations dtype: integer maps: Visual between: [0,5] - name: hallucinations_global_rating dtype: integer maps: GlobalRatingofHallucinations between: [0,5] - name: persecutary_delusions dtype: integer maps: Persecutory between: [0,5] - name: delusions_of_jealousy dtype: integer maps: Delusions between: [0,5] - name: delusions_of_guilt dtype: integer maps: Delusionsof between: [0,5] - name: grandiose_delusions dtype: integer maps: Grandiose between: [0,5] - name: religious_delusions dtype: integer maps: Religious between: [0,5] - name: somatic_delusions dtype: integer maps: Somatic between: [0,5] - name: delusions_of_reference dtype: integer maps: DelusionsofReference between: [0,5] - name: delusions_of_being_controlled dtype: integer maps: DelusionsofBeing between: [0,5] - name: delusion_of_mind_reading dtype: integer maps: DelusionsofMind between: [0,5] - name: thought_broadcasting dtype: integer maps: Thought between: [0,5] - name: thought_insertion dtype: integer maps: ThoughtInsertion between: [0,5] - name: thought_withdrawal dtype: integer maps: ThoughtWithdrawal between: [0,5] - name: delusion_global_rating dtype: integer maps: GlobalRatingofDelusions between: [0,5] - name: clothing_and_appearance dtype: integer maps: Clothing between: [0,5] - name: social_behavior dtype: integer maps: Social between: [0,5] - name: aggressive_behavior dtype: integer maps: Aggressive between: [0,5] - name: repeptitive_behavior dtype: integer maps: Repetitiveor between: [0,5] - name: bizarre_behavior_global_rating dtype: integer maps: GlobalRatingofBizarre between: [0,5] - name: derailment dtype: integer maps: Derailment between: [0,5] - name: tangentiality dtype: integer maps: Tangentiality between: [0,5] - name: incoherance dtype: integer maps: Incoherence between: [0,5] - name: illogicality dtype: integer maps: Illogicality between: [0,5] - name: circumstantiality dtype: integer maps: Circumstantiality between: [0,5] - name: pressure_of_speech dtype: integer maps: Pressure between: [0,5] - name: distractable_speech dtype: integer maps: Distractible between: [0,5] - name: clanging dtype: integer maps: Changing between: [0,5] - name: positive_formal_thought_disorder_global_rating dtype: integer maps: Global between: [0,5] - name: hallucinations_rating dtype: integer maps: hallucinations_total betweeen: [0,30] - name: delusions_rating dtype: integer maps: delusions_total betweeen: [0,30] - name: bizzarre_rating dtype: integer maps: bizzarre_total betweeen: [0,20] - name: positive_rating dtype: integer maps: positive_total betweeen: [0,40] - name: score dtype: integer maps: total betweeen: [0,120] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _young_mania_rating_scale maps: young_mania_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: elevated_mood dtype: integer maps: Elevated between: [0,4] - name: increased_motor_activity dtype: integer maps: Increased between: [0,4] - name: sexual_interest dtype: integer maps: Sexual between: [0,4] - name: sleep dtype: integer maps: Sleep between: [0,4] - name: irritability dtype: integer maps: Irritability like: "[02468]" between: [0,8] - name: speech dtype: integer maps: Speech1 like: "[02468]" between: [0,8] - name: language_disorder dtype: integer maps: Language between: [0,4] - name: thought_content dtype: integer maps: Thought like: "[02468]" between: [0,8] - name: disruptive_behavior dtype: integer maps: Disruptive like: "[02468]" between: [0,8] - name: appearance dtype: integer maps: Appearance between: [0,4] - name: insight dtype: integer maps: Insight between: [0,4] - name: score dtype: integer maps: total between: [0,60] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _severity_of_alcohol_dependence maps: sadq_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: month_of_heavy_drinking dtype: str maps: month_year extract: "(\\w+) - \\d+" like: "(jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec)" case: lower - name: year_of_heavy_drinking dtype: integer maps: month_year extract: "\\w+ - (\\d+)" between: [2000, 2050] - name: next_day_wake_up_feeling_sweaty dtype: integer maps: ans1 between: [0,3] - name: next_day_shaking_hands_in_morning dtype: integer maps: ans2 between: [0,3] - name: next_day_body_shakes_violently_in_morning dtype: integer maps: ans3 between: [0,3] - name: next_day_drenched_in_sweat_in_morning dtype: integer maps: ans4 between: [0,3] - name: next_day_dread_waking_up dtype: integer maps: ans5 between: [0,3] - name: next_day_frightened_of_meeting_people dtype: integer maps: ans6 between: [0,3] - name: next_day_felt_at_edge_of_despair dtype: integer maps: ans7 between: [0,3] - name: next_day_felt_frightened_in_morning dtype: integer maps: ans8 between: [0,3] - name: next_day_like_drinking_again_in_morning dtype: integer maps: ans9 between: [0,3] - name: next_day_gulp_first_few_drinks dtype: integer maps: ans10 between: [0,3] - name: next_day_drank_alcohol_to_rid_shakes dtype: integer maps: ans11 between: [0,3] - name: next_day_strong_craving_for_drink_in_morning dtype: integer maps: ans12 between: [0,3] - name: drank_more_than_quarter_per_day dtype: integer maps: ans13 between: [0,3] - name: drank_more_than_half_per_day dtype: integer maps: ans14 between: [0,3] - name: drank_more_than_one_per_day dtype: integer maps: ans15 between: [0,3] - name: drank_more_than_two_per_day dtype: integer maps: ans16 between: [0,3] - name: relapse_drinking_morning_sweating dtype: integer maps: ans17 between: [0,3] - name: relapse_drinking_hands_shaking dtype: integer maps: ans18 between: [0,3] - name: relapse_drinking_body_shaking dtype: integer maps: ans19 between: [0,3] - name: relapse_drinking_alcohol_craving dtype: integer maps: ans20 between: [0,3] - name: physical_withdrawal_score dtype: integer maps: score_1_4 like: ^[0-1]?\d$ between: [0,12] - name: affective_withdrawal_score dtype: integer maps: score_5_8 between: [0,12] - name: withdrawal_relief_drinking_score dtype: integer maps: score_9_12 between: [0,12] - name: alcohol_consumption_score dtype: integer maps: score_13_16 between: [0,12] - name: rapidity_of_reinstatement_score dtype: integer maps: score_17_20 between: [0,12] - name: score dtype: integer maps: total between: [0,60] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _yale_brown_obsessive_compulsive_scale maps: ocdybocschecklistandseverityassessments_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: time_spent_on_obsessive_thoughts dtype: integer maps: How between: [0,4] - name: interference_by_obsessive_thoughts dtype: integer maps: Howmuch between: [0,4] - name: distress_caused_by_obsessive_thoughts dtype: integer maps: Howmuchdistress between: [0,4] - name: resistance_against_obsessions dtype: integer maps: Howmuchofan between: [0,4] - name: control_over_obsessive_thoughts dtype: integer maps: Howmuchcontrol between: [0,4] - name: time_spent_performing_compulsive_behaviors dtype: integer maps: Howmuchtime between: [0,4] - name: interference_by_compulsive_behaviors dtype: integer maps: Howmuchdo between: [0,4] - name: distress_caused_by_compulsive_behaviors dtype: integer maps: Howwould between: [0,4] - name: effort_to_resist_compulsive_behaviors dtype: integer maps: Howmuchof between: [0,4] - name: control_over_compulsive_behaviors dtype: integer maps: Howstrong between: [0,4] - name: insight_rating dtype: integer maps: insight_score between: [0,4] - name: avoidance_rating dtype: integer maps: avoidance_score between: [0,4] - name: obsession_score dtype: integer maps: obsessive_total between: [0,25] - name: compulsion_score dtype: integer maps: compulsive_total between: [0,25] - name: score dtype: integer maps: ybocs_total between: [0,50] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _yale_brown_obsessive_compulsive_symptoms maps: ocdybocschecklistandseverityassessments_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: fear_of_self_harm dtype: integer maps: etFear between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_harming_others dtype: integer maps: etFearmight between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: violent_images dtype: integer maps: etViolent between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_blurting_insults dtype: integer maps: etFearof between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_doing_embarrassing_things dtype: integer maps: etFearofdoing between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_acting_on_impulses dtype: integer maps: etFearwillact between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_stealing dtype: integer maps: etFearwill between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_will_harm_other_if_careless dtype: integer maps: etFearwillharm between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_responsibility_for_terrible dtype: integer maps: etFearwillbe between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: disgust_with_bodily_secretions dtype: integer maps: etConcern between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concern_with_germs dtype: integer maps: etConcerned between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concern_with_environmental_contaminants dtype: integer maps: etExcessive between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concern_with_household_items dtype: integer maps: etExcessiveconcern between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: bothered_by_sticky_residues dtype: integer maps: etExcessivebothered between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concerned_will_get_ill dtype: integer maps: etConcernedwill between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concerned_will_spread_germs dtype: integer maps: etConcernedwillget between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: not_concerned_with_contamination_consequences dtype: integer maps: etNoconcern between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: other_contamination_obsessions dtype: integer maps: etOther1 between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: doubt_performing_activities dtype: integer maps: etAfter between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: unacceptable_sexual_thoughts dtype: integer maps: etPersonally between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: sexual_thoughts_of_children dtype: integer maps: etContents between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: sexual_thoughts_of_homosexuality dtype: integer maps: etContentinvolves between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: aggressive_sexual_behaviors dtype: integer maps: etSexualbehavior between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: other_sexual_obsessions dtype: integer maps: etOthers2 between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: collect_useless_items dtype: integer maps: etCollect between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concerned_with_losing_items dtype: integer maps: etConcernedwithlosing between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concerned_with_blasphemy dtype: integer maps: etConcernedwith between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: excess_concern_with_morality dtype: integer maps: etExcess between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: bothered_by_order dtype: integer maps: etBothered between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: symmetry_while_grooming dtype: integer maps: etExactness between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: magical_thinking dtype: integer maps: etAccompanied between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: no_magical_thinking dtype: integer maps: etNot between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: need_to_remember dtype: integer maps: etNeed between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_saying_things dtype: integer maps: etFearofsaying between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_not_saying_right_things dtype: integer maps: etFearofnotsaying between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: fear_of_losing_things dtype: integer maps: etFearoflosing between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: superstitious_fear dtype: integer maps: etSuperstitious between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: intrusive_meaningless_thoughts dtype: integer maps: etIntrusive between: [1,3] replace: replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: other_miscellaneous_obsessions dtype: integer maps: etOthers4 between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: concern_with_illness dtype: integer maps: etConcernwithillness between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: excessive_concern_with_body dtype: integer maps: etExcessiveconcernwithbody between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: other_somatic_obsessions dtype: integer maps: etOthers between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: ritualized_hand_washing dtype: integer maps: etExcessiveor between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: ritualized_grooming dtype: integer maps: etExcessiveorritualized between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: cleaning_household_items dtype: integer maps: etCleaningof between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: preventing_contaminant_contact dtype: integer maps: etOthermeasures between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: avoiding_contaminant_contact dtype: integer maps: etAvoidance between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: checking_for_harm dtype: integer maps: etCheckingthat between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: checkings_locks dtype: integer maps: etCheckinglocks between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: checking_for_mistakes dtype: integer maps: etCheckingthatdid between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: checking_for_terrible_things dtype: integer maps: etCheckingthatnothing between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: checking_tied_to_somatic dtype: integer maps: etCheckingtied between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: checking_personal_appearance dtype: integer maps: etCheckingforpersonal between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: rereading dtype: integer maps: etRereading between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: repeating_questions dtype: integer maps: etRepeatingsame between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: repeat_routine_activities dtype: integer maps: etNeedto between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: crossing_rituals dtype: integer maps: etRituals between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: inspecting_household_trash dtype: integer maps: etInspecting between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: line_up_clothes dtype: integer maps: etLines between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: need_for_symmetry dtype: integer maps: etNeedfor between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: activity_incomplete_till_right dtype: integer maps: etCant between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: accumulating_useless_objects dtype: integer maps: etInspectinghousehold between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: mental_rituals dtype: integer maps: etMental between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: pathological_slowness dtype: integer maps: etPathologicalslowness between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: compulsion_by_proxy dtype: integer maps: etCompulsion between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: need_to_touch dtype: integer maps: etNeedtotouch between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: excessive_list_making dtype: integer maps: etExcessivelist between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: need_to_tell dtype: integer maps: etNeedtotell between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: measures_to_prevent dtype: integer maps: etMeasures between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: ritualized_eating_behaviors dtype: integer maps: etRitualized between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: trichotillomania dtype: integer maps: etTrichotillomania between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: superstitions dtype: integer maps: etSuperstitions between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: repeated_reassurance_required dtype: integer maps: etAsking between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: self_damaging_behavior dtype: integer maps: etSelf between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: blinking_rituals dtype: integer maps: etRitualsinvolved between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: other_miscellaneous_compulsions dtype: integer maps: etOthers5 between: [1,3] replace: - value: "Current" to: "1" - value: "Current," to: "1" - value: ",Past" to: "2" - value: "Past" to: "2" - value: "Current,Past" to: "3" - name: aggressive_obsessions_are_principal dtype: boolean maps: etC - name: contamination_obsessions_are_principal dtype: boolean maps: etA - name: pathological_doubts_are_principal dtype: boolean maps: etG - name: sexual_obsessions_are_principal dtype: boolean maps: etD - name: saving_obsessions_are_principal dtype: boolean maps: etF - name: religious_obsessions_are_principal dtype: boolean maps: etE - name: symmetry_obsessions_are_principal dtype: boolean maps: etH - name: miscellaneous_obsessions_are_principal dtype: boolean maps: etI - name: somatic_obsessions_are_principal dtype: boolean maps: etB - name: cleaning_compulsions_are_principal dtype: boolean maps: etA1 - name: checking_compulsions_are_principal dtype: boolean maps: etB1 - name: repeating_rituals_are_principal dtype: boolean maps: etC1 - name: counting_compulsions_are_principal dtype: boolean maps: etD1 - name: arranging_compulsions_are_principal dtype: boolean maps: etE1 - name: hoarding_compulsions_are_principal dtype: boolean maps: etF1 - name: miscellaneous_compulsions_are_principal dtype: boolean maps: etG1 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _mental_status_assessment maps: mseotd_assessmenttable refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: description dtype: str(1000) maps: mseotd - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _physical_examination maps: physicalexamination_table1 refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: weight dtype: float maps: etWeight_ between: [20,150] - name: standing_height dtype: float maps: etStandingHeight1_ betweeen: [50,300] - name: sitting_height dtype: float maps: etSittingHeight1_ between: [45,270] - name: height_ratio dtype: float maps: HeightRatio between: [0,1] - name: head_circumference dtype: float maps: etHead1_ between: [35,70] - name: anemia dtype: boolean maps: Anemia_ - name: pedal_edema dtype: boolean maps: Pedal_ - name: cyanosis dtype: boolean maps: Cyanosis_ - name: clubbing dtype: boolean maps: Clubbing_ - name: iceterus dtype: boolean maps: Icterus_ - name: lymphadenopathy dtype: boolean maps: Lymphadenopathy_ - name: pulse_rate dtype: integer maps: etPulse_ between: [0,200] - name: systolic_blood_pressure_while_seated dtype: integer maps: etBloodPressureSitting1_ between: [60,200] - name: diastolic_blood_pressure_while_seated dtype: integer maps: etBloodPressureSitting2_ between: [50,100] - name: systolic_blood_pressure_while_standing dtype: integer maps: etBloodPressureStanding1_ between: [70,200] - name: diastolic_blood_pressure_while_standing dtype: integer maps: etBloodPressureStanding2_ between: [50,120] - name: pupil_bilateral_size dtype: str maps: Equal_ like: "(equal|unequal)" case: lower - name: pupil_reflexes dtype: str maps: Reactive_ like: "(reactive|sluggish)" case: lower - name: electric_hair dtype: integer maps: Hair_ like: "[012]" - name: hair_whorls dtype: integer maps: Hair2_ like: "[01]" - name: head_circumference dtype: integer maps: Hair3_ like: "[012]" - name: epicanthus dtype: integer maps: Epicanthus_ like: "[012]" - name: hypertelorism dtype: integer maps: Epicanthus2_ like: "[012]" - name: lowset_ears dtype: integer maps: Lowset_ like: "[012]" - name: adherent_ear_lobes dtype: integer maps: Adherent_ like: "[01]" - name: lower_edge_of_ears_extend dtype: integer maps: LowerEdge_ like: "[01]" - name: malformed_ears dtype: integer maps: Malformed_ like: "[01]" - name: asymmetrical_ears dtype: integer maps: Asymmetrical_ like: "[01]" - name: soft_and_pliable_ears dtype: integer maps: Softandpliable_ like: "[01]" - name: oral_cavity_palate dtype: integer maps: Palate_ like: "[012]" - name: furrowed_tongue dtype: integer maps: Tongue_ like: "[012]" - name: tongue_with_smooth_rough_spots dtype: integer maps: Tongue2_ like: "[01]" - name: curved_fifth_finger dtype: integer maps: Curved_ like: "[01]" - name: transverse_palmar_crease dtype: integer maps: Transverse like: "[01]" - name: third_toe dtype: integer maps: Third like: "[012]" - name: syndactylia dtype: integer maps: Syndactylia like: "[01]" - name: gap_between_first_second_toe dtype: integer maps: Gap like: "[01]" - name: waldrop_scale_comments dtype: str maps: etComments_ - name: respiratory_system dtype: str maps: ChRespiratory_ like: "WNL" - name: cardiovascular_system dtype: str maps: ChCardiovascular_ like: "WNL" - name: abdominal_system dtype: str maps: ChAbdomen_ like: "WNL" - name: respiratory_system_comment dtype: str maps: etRespiratory_ - name: cardiovascular_system_comment dtype: str maps: etCardiovascular_ - name: abdominal_system_comment dtype: str maps: etPerAbdomen_ - name: hepatocellular_failure dtype: str maps: Hepatocellular like: "(present|absent)" case: lower - name: cranial_nerves dtype: str maps: Cranial like: "(normal|abnormal)" case: lower - name: cranial_nerves_comment dtype: str maps: etCranial_ - name: power_in_limbs dtype: str maps: Power like: "(equal|unequal)" case: lower - name: tone_in_limbs dtype: str maps: Tone like: "(normal|abnormal)" case: lower - name: tone_condition dtype: str maps: Abnormal like: "(hypertonic|hypotonic)" case: lower - name: tone_condition_comment dtype: str maps: etAbnormal_ - name: deep_tendon_reflexes dtype: str maps: DeepTendon like: "(normal|brisk|absent|others)" case: lower - name: deep_tendon_reflexes_comment dtype: str maps: etDeepTendon_ - name: peripheral_neuropathy dtype: str maps: Peripheral like: "(present|absent)" case: lower - name: rombergs_sign dtype: str maps: Rombergs like: "(positive|negative)" case: lower - name: cerebellar_coordination dtype: str maps: Celebellar like: "(intact|lost)" case: lower - name: cerebellar_coordination_comment dtype: str maps: etCelebellar_ - name: gait dtype: str maps: Gait like: "(normal|broad based|antalgic|others)" case: lower - name: gait_comment dtype: str maps: etGait_ - name: plantars dtype: str maps: Plantars like: (normal|abnormal) case: lower - name: primitive_reflexes dtype: str maps: Primitive like: "(absent|present)" case: lower - name: primitive_reflexes_comment dtype: str maps: etPrimitive_ - name: within_normal dtype: boolean maps: Remarks - name: remarks dtype: str maps: etCoOrdination_ - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _post_traumatic_stress_disorder maps: posttraumaticstressdisorder_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: experienced_traumatic_event dtype: boolean maps: ans1 - name: responded_to_event_with_fear dtype: boolean maps: ans2 - name: reexperienced_event dtype: boolean maps: ans3 - name: avoided_thinking_about_event dtype: boolean maps: ans4 - name: avoided_activities_that_remind dtype: boolean maps: ans5 - name: trouble_recalling dtype: boolean maps: ans6 - name: become_less_interested_in_hobbies dtype: boolean maps: ans7 - name: felt_detached dtype: boolean maps: ans8 - name: feelings_are_numbed dtype: boolean maps: ans9 - name: felt_life_shortened dtype: boolean maps: ans10 - name: difficulty_sleeping dtype: boolean maps: ans12 - name: irritable dtype: boolean maps: ans13 - name: difficulty_concentrating dtype: boolean maps: ans14 - name: nervous dtype: boolean maps: ans15 - name: easily_startled dtype: boolean maps: ans16 - name: problems_interfered_with_work dtype: boolean maps: ans18 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _socialphobia maps: socialphobia_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: fear_of_humiliation dtype: boolean maps: G1 - name: unreasonable_fear dtype: boolean maps: G2 - name: avoid_social_situations_due_to_fear dtype: boolean maps: G3 - name: disrupts_work dtype: boolean maps: G4 - name: current dtype: boolean maps: ans3 - name: type dtype: str maps: Generalized like: "(generalized|non-generalized)" case: lower - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _suicidality maps: suicidality_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: suffered_accident dtype: boolean maps: ans1 - name: planned_to_hurt_self_in_accident dtype: boolean maps: ans2 - name: intended_to_die_in_accident dtype: boolean maps: ans3 - name: wish_you_were_dead dtype: boolean maps: ans4 - name: want_to_harm_self dtype: boolean maps: ans5 - name: think_about_suicide dtype: boolean maps: ans6 - name: suicidal_thoughts_frequency dtype: str maps: ans14 like: "(occasionally|often|very often)" case: lower - name: suicidal_thoughts_intensity dtype: str maps: ans15 like: "(mild|moderate|severe)" case: lower - name: control_these_impulses dtype: boolean maps: ans7 - name: have_suicide_plan dtype: boolean maps: ans8 - name: prepared_for_attempt dtype: boolean maps: ans9 - name: deliberately_injured_without_planning_death dtype: boolean maps: ans10 - name: attempt_possible dtype: boolean maps: ans11 - name: expected_outcome dtype: str maps: AttemptSuicideT like: "(survival|death)" replace: - value: "Hoped to be rescued / survive" to: "survival" - value: "Expected / intended to die" to: "death" - name: attempted_suicide_before dtype: boolean maps: ans12 - name: at_risk dtype: boolean maps: ans13 - name: score dtype: integer maps: sumtotal between: [0,50] - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _panic_disorder maps: panicdisorder_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: had_spells_of_anxiousness dtype: boolean maps: ans1 - name: spells_peaked_within_ten_minutes dtype: boolean maps: ans2 - name: unpredictable dtype: boolean maps: ans3 - name: significant_change_due_to_attack dtype: boolean maps: ans4 - name: pounding_heart dtype: boolean maps: ans5 - name: sweating_hand dtype: boolean maps: ans6 - name: trembling dtype: boolean maps: ans7 - name: shortness_of_breath dtype: boolean maps: ans8 - name: choking_sensation dtype: boolean maps: ans9 - name: chest_pain dtype: boolean maps: ans10 - name: nausea dtype: boolean maps: ans11 - name: felt_faint dtype: boolean maps: ans12 - name: felt_strange dtype: boolean maps: ans13 - name: lost_control dtype: boolean maps: ans14 - name: feared_death dtype: boolean maps: ans15 - name: numbness dtype: boolean maps: ans16 - name: chills dtype: boolean maps: ans17 - name: current dtype: boolean maps: ans20 replace: - value: "Yes (PANIC DISORDER CURRENT)" to: "Yes" - name: lifetime dtype: boolean maps: ans18 replace: - value: "Yes (PANIC DISORDER LIFETIME)" to: "Yes" - name: lifetime_limited_symptoms dtype: boolean maps: ans19 replace: - value: "Yes (LIMITED SYMPTOM ATTACKS LIFETIME)" to: "Yes" - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _obsessive_compulsive_disorder maps: obsessive_compulsivedisorder_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: bothered_by_recurrent_thoughts dtype: boolean maps: ans1 - name: thoughts_keep_coming_back dtype: boolean maps: ans2 - name: obsessions_product_of_own_mind dtype: boolean maps: ans3 replace: - value: "Yes(obsessions)" to: "Yes" - name: did_something_repeatedly dtype: boolean maps: ans4 replace: - value: "Yes (compulsions)" to: "Yes" - name: thoughts_were_unreasonable dtype: boolean maps: ans6 - name: current dtype: boolean maps: ans7 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _agoraphobia maps: agoraphobia_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: fear_of_places_that_cause_attack dtype: boolean maps: ans1 - name: avoidance_due_to_fear dtype: boolean maps: ans2 - name: panic_disorder_without_agoraphobia dtype: boolean maps: ans3 - name: panic_disorder_with_agoraphobia dtype: boolean maps: ans4 - name: agoraphobia_without_panic_disorder_history dtype: boolean maps: ans5 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _alchohol_dependence maps: alcoholabuseanddependence_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: history_of_alcohol_dependence dtype: boolean maps: ans1 - name: need_more_drink_to_get_same_effect dtype: boolean maps: ans2 - name: cutting_down_led_to_shakes dtype: boolean maps: ans3 - name: drank_more_than_you_planned dtype: boolean maps: ans4 - name: failed_attempt_to_stop dtype: boolean maps: ans5 - name: spent_substantial_time_drinking dtype: boolean maps: ans6 - name: spent_less_time_working dtype: boolean maps: ans7 - name: drinking_despite_knowing_health_problems dtype: boolean maps: ans8 - name: current dtype: boolean maps: ans9 replace: - value: "Yes*" to: "Yes" - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _alchohol_abuse maps: alcoholabuseanddependence_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: intoxication_caused_problems dtype: boolean maps: ans10 - name: intoxicated_while_physically_at_risk dtype: boolean maps: ans11 - name: legal_problems_due_to_drinking dtype: boolean maps: ans12 - name: drinking_despite_problems_with_family dtype: boolean maps: ans13 - name: current dtype: boolean maps: ans14 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _anorexia_nervosa maps: anorexianervosa_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: height dtype: float maps: heightInCm between: [10, 300] - name: lowest_weight_in_past_quarter dtype: float maps: weightInKg between: [10, 200] - name: weight_below_threshold dtype: boolean maps: ans1 - name: tried_not_to_gain_weight dtype: boolean maps: ans2 - name: feared_getting_fat dtype: boolean maps: ans3 - name: consider_yourself_fat dtype: boolean maps: ans4 - name: body_shape_influenced_self_esteem dtype: boolean maps: ans5 - name: think_current_weight_is_excessive dtype: boolean maps: ans6 - name: current dtype: boolean maps: ans9 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _anitisocial_personality_disorder maps: antisocialpersonalitydisorder_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: ran_away_from_home_or_school_when_young dtype: boolean maps: ans1 - name: repeatedly_con_or_steal_when_young dtype: boolean maps: ans2 - name: start_fights_or_bully_when_young dtype: boolean maps: ans3 - name: deliberately_destroy_things_when_young dtype: boolean maps: ans4 - name: deliberately_hurt_animals_when_young dtype: boolean maps: ans5 - name: forced_sex_with_others_when_young dtype: boolean maps: ans6 - name: behaved_irresponsibly_when_adult dtype: boolean maps: ans8 - name: done_illegal_things_when_adult dtype: boolean maps: ans9 - name: repeated_physical_fights_when_adult dtype: boolean maps: ans10 - name: lied_often_when_adult dtype: boolean maps: ans11 - name: exposed_others_to_danger_when_adult dtype: boolean maps: ans12 - name: felt_no_guilt_when_adult dtype: boolean maps: ans13 - name: lifetime dtype: boolean maps: ans14 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _bulimia_nervosa maps: bulimianervosa_table refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: eating_binges dtype: boolean maps: ans1 - name: eating_binges_often dtype: boolean maps: ans2 - name: eating_out_of_control dtype: boolean maps: ans3 - name: steps_to_prevent_weight_gain dtype: boolean maps: ans4 - name: body_shape_influences_self_esteem dtype: boolean maps: ans5 - name: anorexia_symptoms dtype: boolean maps: ans6 - name: underweight_triggers_binges dtype: boolean maps: ans7 - name: threshold_weight dtype: float maps: usedDrug between: [10, 150] - name: bulimia dtype: boolean maps: ans8 - name: binge_eating_type dtype: boolean maps: ans9 - name: update_timestamp dtype: datetime maps: date_of_last_update --- table: _recent_life_events maps: "cambridge_bereavement_table" refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: update_timestamp dtype: datetime maps: date_of_last_update attach: - name: timing primary: yes dtype: str - name: event primary: yes dtype: str - name: occurence dtype: integer - name: independence dtype: integer - name: impact dtype: integer detach: - name: recent-death_of_close_friend-occurence dtype: integer maps: m_recent_1 - name: recent-death_of_close_family-occurence dtype: integer maps: m_recent_2 - name: recent-death_of_child-occurence dtype: integer maps: m_recent_3 - name: recent-death_of_spouse-occurence dtype: integer maps: m_recent_4 - name: recent-lost_item_of_personal_value-occurence dtype: integer maps: m_recent_5 - name: recent-death_of_close_friend-independence dtype: integer maps: i_recent_1 - name: recent-death_of_close_family-independence dtype: integer maps: i_recent_2 - name: recent-death_of_child-independence dtype: integer maps: i_recent_3 - name: recent-death_of_spouse-independence dtype: integer maps: i_recent_4 - name: recent-lost_item_of_personal_value-independence dtype: integer maps: i_recent_5 - name: recent-death_of_close_friend-impact dtype: integer maps: n_recent_1 - name: recent-death_of_close_family-impact dtype: integer maps: n_recent_2 - name: recent-death_of_child-impact dtype: integer maps: n_recent_3 - name: recent-death_of_spouse-impact dtype: integer maps: n_recent_4 - name: recent-lost_item_of_personal_value-impact dtype: integer maps: n_recent_5 - name: onset-death_of_close_friend-occurence dtype: integer maps: m_onset_1 - name: onset-death_of_close_family-occurence dtype: integer maps: m_onset_2 - name: onset-death_of_child-occurence dtype: integer maps: m_onset_3 - name: onset-death_of_spouse-occurence dtype: integer maps: m_onset_4 - name: onset-lost_item_of_personal_value-occurence dtype: integer maps: m_onset_5 - name: onset-death_of_close_friend-independence dtype: integer maps: i_onset_1 - name: onset-death_of_close_family-independence dtype: integer maps: i_onset_2 - name: onset-death_of_child-independence dtype: integer maps: i_onset_3 - name: onset-death_of_spouse-independence dtype: integer maps: i_onset_4 - name: onset-lost_item_of_personal_value-independence dtype: integer maps: i_onset_5 - name: onset-death_of_close_friend-impact dtype: integer maps: n_onset_1 - name: onset-death_of_close_family-impact dtype: integer maps: n_onset_2 - name: onset-death_of_child-impact dtype: integer maps: n_onset_3 - name: onset-death_of_spouse-impact dtype: integer maps: n_onset_4 - name: onset-lost_item_of_personal_value-impact dtype: integer maps: n_onset_5 reshape: - add: name: category value: bereavement - melt: id_vars: [id, subject, session, category, update_timestamp] - split: name: variable pat: "-" rename: [timing, event, variable] - pivot: columns: variable values: value index: [subject, session, timing, event] --- table: _presenting_disorders maps: hopi_master refs: - cols: [subject, session] links: [_assessments.subject, _assessments.session] cols: - name: id dtype: integer maps: id - name: subject primary: yes dtype: str(6) maps: assessmentId extract: "[0-9]{3}([0-9]{6})" like: "D[0-9]{4}" replace: value: subjectID to: D_number file: "" - name: session primary: yes dtype: str(3) maps: assessmentId extract: "([0-9]{3})[0-9]{6}" like: "[0-9]{3}" - name: addiction dtype: boolean maps: Addiction - name: bipolar dtype: boolean maps: Bipolar - name: dementia dtype: boolean maps: Dementia - name: ocd dtype: boolean maps: ocd - name: schizophrenia dtype: boolean maps: Schizophrenia - name: update_timestamp dtype: datetime maps: date_of_last_update