CTRN Data Dictionary

ctrn derived integer

age_at_enrollment_years

Subject's age (in years) at study enrollment, computed from DOB and the date of the baseline visit.

Definition

EXTRACT(YEAR FROM age(enrollment_date::date, dob::date))::integer

Notes

Demo entry created 2026-05-22 to validate the Derived Variables feature end-to-end on prod. Replace with a real lab-view-backed definition once Pat's CTRN view is wired in.

ctrn external varchar

sample_pending_external_field

SAMPLE placeholder to preview the review queue UI

Definition

(external linkage; sample only)

Notes

Delete me. Created to demo the in-app peer-review UI.

cbt text

caps_administrator_2

DW variable: caps_administrator

Form

caps_ca5_2nd_data_entry

Label

Name of interviewer

cbt text

caps_administrator_other_2

DW variable: caps_administrator_other

Form

caps_ca5_2nd_data_entry

Label

Other, please specify

cbt calc

caps_b_subtotal_sev_2

DW variable: caps_b_subtotal_sev

Form

caps_ca5_2nd_data_entry

cbt calc

caps_b_subtotal_symptom_2

DW variable: caps_b_subtotal_symptom

Form

caps_ca5_2nd_data_entry

cbt calc

caps_c_subtotal_sev_2

DW variable: caps_c_subtotal_sev

Form

caps_ca5_2nd_data_entry

cbt calc

caps_c_subtotal_symptom_2

DW variable: caps_c_subtotal_symptom

Form

caps_ca5_2nd_data_entry

cbt calc

caps_d_subtotal_sev_2

DW variable: caps_d_subtotal_sev

Form

caps_ca5_2nd_data_entry

cbt calc

caps_d_subtotal_symptom_2

DW variable: caps_d_subtotal_symptom

Form

caps_ca5_2nd_data_entry

cbt text

caps_date_2

DW variable: caps_date

Form

caps_ca5_2nd_data_entry

Label

Date of interview

cbt calc

caps_dissoc_subtotal_sev_2

DW variable: caps_dissoc_subtotal_sev

Form

caps_ca5_2nd_data_entry

cbt calc

caps_dissoc_subtotal_sym_2

DW variable: caps_dissoc_subtotal_sym

Form

caps_ca5_2nd_data_entry

cbt calc

caps_e_subtotal_sev_2

DW variable: caps_e_subtotal_sev

Form

caps_ca5_2nd_data_entry

cbt calc

caps_e_subtotal_symptom_2

DW variable: caps_e_subtotal_symptom

Form

caps_ca5_2nd_data_entry

cbt calc

caps_g_subtotal_sev_2

DW variable: caps_g_subtotal_sev

Form

caps_ca5_2nd_data_entry

cbt calc

caps_g_subtotal_symptom_2

DW variable: caps_g_subtotal_symptom

Form

caps_ca5_2nd_data_entry

cbt radio

caps_lang_2

DW variable: caps_lang_2

Form

caps_ca5_2nd_data_entry

Label

In which language was the CAPS administered?

Choices

• 1, English
• 2, Spanish
• 3, Other Language

cbt text

caps_lang_other2

DW variable: caps_lang_other2

Form

caps_ca5_2nd_data_entry

Label

Others, please specify

cbt radio

caps_one_2_2nd

DW variable: caps_one_2_2nd

Form

caps_ca5_2nd_data_entry

Label

Was the CTRN CAPS-CA-5 completed more than TWO WEEKS ago?

Choices

• 1, Yes
• 2, No

cbt radio

caps_one_2nd

DW variable: caps_one_2nd

Form

caps_ca5_2nd_data_entry

Label

Was the CTRN CAPS-CA-5 completed more than ONE month ago?

Choices

• 1, Yes
• 2, No

cbt calc

caps_ptsd_total_sev_2

DW variable: caps_ptsd_total_sev

Form

caps_ca5_2nd_data_entry

cbt calc

caps_ptsd_total_symptom_2

DW variable: caps_ptsd_total_symptom

Form

caps_ca5_2nd_data_entry

cbt yesno

caps_sum_delayed_2

DW variable: caps_sum_delayed

Form

caps_ca5_2nd_data_entry

Label

(21) With delayed onset (>= 6 months)

cbt calc

caps_sum_depers_q29_2

DW variable: caps_sum_depers_q29

Form

caps_ca5_2nd_data_entry

cbt radio

caps_sum_depers_sev_q29_2

DW variable: caps_sum_depers_sev_q29

Form

caps_ca5_2nd_data_entry

Label

29) 1 -- Depersonalization--Persistent or recurrent experiences of feeling detached from, and as if one were an outside observer of, one's mental processes or body (e.g., feeling as though one were in a dream; feeling a sense of unreality of self or body or of time moving slowly).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_sum_dereal_q30_2

DW variable: caps_sum_dereal_q30

Form

caps_ca5_2nd_data_entry

cbt radio

caps_sum_dereal_sev_q30_2

DW variable: caps_sum_dereal_sev_q30

Form

caps_ca5_2nd_data_entry

Label

30) 2 -- Derealization--Persistent or recurrent experiences of unreality of surroundings (e.g., the world around the individual is experienced as unreal, dreamlike, distant, or distorted).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt yesno

caps_sum_dissociative_2

DW variable: caps_sum_dissociative

Form

caps_ca5_2nd_data_entry

Label

With dissociative symptoms?

cbt yesno

caps_sum_ptsd_present_2

DW variable: caps_sum_ptsd_present

Form

caps_ca5_2nd_data_entry

Label

PTSD PRESENT - ALL CRITERIA (A-G) MET?

cbt radio

caps_summary_a1_2

DW variable: caps_summary_a1

Form

caps_ca5_2nd_data_entry

Label

Criterion A met?

Choices

• 1, Yes
• 0, No

cbt calc

caps_summary_b1_q1_2

DW variable: caps_summary_b1_q1

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_b1_sev_q1_2

DW variable: caps_summary_b1_sev_q1

Form

caps_ca5_2nd_data_entry

Label

B1 Severity:--Recurrent, involuntary, and intrusive distressing memories of the traumatic event(s).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_b2_q2_2

DW variable: caps_summary_b2_q2

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_b2_sev_q2_2

DW variable: caps_summary_b2_sev_q2

Form

caps_ca5_2nd_data_entry

Label

B2 Severity:--Recurrent distressing dreams in which the content and/or affect of the dream are related to the event(s).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_b3_q3_2

DW variable: caps_summary_b3_q3

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_b3_sev_q3_2

DW variable: caps_summary_b3_sev_q3

Form

caps_ca5_2nd_data_entry

Label

B3 Severity:--Dissociative reactions (e.g., flashbacks) in which the individual feels or acts as if the traumatic event(s) were recurring. (Such reactions may occur on a continuum, with the most extreme expression being a complete loss of awareness of present surroundings.)

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_b4_q4_2

DW variable: caps_summary_b4_q4

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_b4_sev_q4_2

DW variable: caps_summary_b4_sev_q4

Form

caps_ca5_2nd_data_entry

Label

B4 Severity:--Intense or prolonged psychological distress at exposure to internal or external cues that symbolize or resemble an aspect of the traumatic event(s).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_b5_q5_2

DW variable: caps_summary_b5_q5

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_b5_sev_q5_2

DW variable: caps_summary_b5_sev_q5

Form

caps_ca5_2nd_data_entry

Label

B5 Severity:--Marked physiological reactions to internal or external cues that symbolize or resemble an aspect of the traumatic event(s).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_c1_q6_2

DW variable: caps_summary_c1_q6

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_c1_sev_q6_2

DW variable: caps_summary_c1_sev_q6

Form

caps_ca5_2nd_data_entry

Label

C1 Severity:--Avoidance of or efforts to avoid distressing memories, thoughts, or feelings about or closely associated with the traumatic event(s).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_c2_q7_2

DW variable: caps_summary_c2_q7

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_c2_sev_q7_2

DW variable: caps_summary_c2_sev_q7

Form

caps_ca5_2nd_data_entry

Label

C2 Severity:--Avoidance of or efforts to avoid external reminders (people, places, conversations, activities, objects, situations) that arouse distressing memories, thoughts, or feelings about or closely associated with the traumatic event(s).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_d1_q8_2

DW variable: caps_summary_d1_q8

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_d1_sev_q8_2

DW variable: caps_summary_d1_sev_q8

Form

caps_ca5_2nd_data_entry

Label

D1 Severity:--Inability to remember an important aspect of the traumatic event(s) (typically due to dissociative amnesia and not to other factors such as head injury, alcohol, or drugs).

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_d2_q9_2

DW variable: caps_summary_d2_q9

Form

caps_ca5_2nd_data_entry

cbt radio

caps_summary_d2_sev_q9_2

DW variable: caps_summary_d2_sev_q9

Form

caps_ca5_2nd_data_entry

Label

D2 Severity:--Persistent and exaggerated negative beliefs or expectations about oneself, others, or the world (e.g., "I am bad," "No one can be trusted," "The world is completely dangerous," "My whole nervous system is permanently ruined").

Choices

• 0, (0) Absent
• 1, (1) Mild / subthreshold
• 2, (2) Moderate / threshold
• 3, (3) Severe / markedly elevated
• 4, (4) Extreme / incapacitating

cbt calc

caps_summary_d3_q10_2

DW variable: caps_summary_d3_q10

Form

caps_ca5_2nd_data_entry