How a program admin can access the longitudinal continuity clinic forms for an individual trainee in the dashboard data export:
- Download assessment data via “Export data for everyone, one person per file (zipped) or “Export data for trainees, one trainee per file (zipped)”
- Within an individual trainee file:
- Filter column N (activity_title) to “LONGITUDINAL CONTINUITY CLINIC ASSESSMENT”
- This will show all longitudinal continuity clinic assessments
- The data extract is in long form, so each single assessment is represented in multiple rows, with each row representing a single question/answer of the form.
- Navigate to column J (assessment_event_id). If there is only one id, all of the rows shown pertain to a single assessment (see Screenshot 1). If there are multiple assessment_event_ids shown (see Screenshot 2), filter the column and choose one at a time.
- Navigate to column BA (question_prompt), column BE (answer_option_anchor) and column BF (value) to view the relevant questions/responses for the selected assessment
- Columns AA (rater_first_name) through AD (rater_job_title_during_event) provide information related to the rater who completed the assessment.
- Column R (created_by) indicates who created the assessment.
- Filter column N (activity_title) to “LONGITUDINAL CONTINUITY CLINIC ASSESSMENT”
- The above process will work for any specific activity or sets of activities you want to view data for.
Screenshot 1: One assessment_event_id = one assessment
Screenshot 2: Two assessment_event_ids = two assessments