Reporting Resources and Tools for a Safe Return to Yale

    All members of the Yale community who oversee individuals who are returning to campus are expected to conduct a weekly review of the following reports to ensure University compliance. Report data is available on-demand for Lead Administrators and Division Heads and automatically emailed to responsible individuals.

    Using and Protecting Report Data

    Those who oversee individuals who are approved to return to campus will receive notifications and scheduled reports, including:

    • Real-time emailed notifications: Sent only if a person you oversee is asked to enter or leave isolation. 
    • Emailed reports: Sent weekly, and include information on compliance with training, daily health checks, routine testing, badge access, and more.
    • on-demand reports: Available as needed through the Power BI Report Server, and provide information on compliance with return to campus authorization, training, daily health checks, and badge access.

    This data is used to enforce compliance and encourage appropriate behavior as outlined in the Community Compact or Statement of Expectations. For those in academic units, it may also be used to facilitate academic accommodation, assist with access to isolation housing, and ensure adequate public health response. For those in administrative units, it may also be used to facilitate work accommodation. 

    Faculty, co-workers, peers, and others will be notified by contact tracing if there is a need for further action by individuals who may have been exposed. In all cases, data may only be shared for legitimate educational and business needs in support of campus health and safety. Watch and learn more about privacy requirements for Health and Safety Reports. Additionally, learn more about Privacy Practices for [the] Yale COVID-19 Campus Health and Safety Program.

    On Demand Reports for Academic and Administrative Health and Safety Leaders and Compliance Trackers

    Reports and tools available Report Description
    Faculty and Staff Testing Summary Aggregated report with filters showing for employees with sum of tests and unique individuals tested by week from August 30, 2020 to present by planning unit and job category.
    Graduate and Professional Student Testing Summary Aggregated report with filters showing students enrolled in residence with sum of tests and unique individuals tested by week from August 30, 2020 to present by graduate or professional school and learning location.
    New Haven Remote Undergraduate Student Testing Summary Aggregated report with filters showing undergraduate students enrolled remotely but residing in Greater New Haven Area with sum of tests and unique individuals tested by week from August 30, 2020 to present by residential college and learning location.
    High Contact List Population Overview Aggregated report with filters and counts showing faculty and staff with routine testing requirement, views by job category, job title, planning union, bargaining unit, location, and compliance override.
    Repeat Non-Compliance for Testing Report Aggregated report for each school which shows individuals who have a history of non-compliance with routine testing requirements and had resulting badge restrictions.
    School of Music Compliance Exception Report for Students from Other Programs in Music Facilities Report for the School of Music health and safety team indicating which students in other programs who access the music facilities are noncompliant with flu vaccine, on-arrival test, or routine testing.
    School of Nursing Routine Testing Exception Report Report for the School of Nursing health and safety team with students who have not completed a test through Yale Health within the last 8 days. Students completing off-site clinical rotations may test elsewhere.
    School of Nursing COVID-19 Vaccinations Report for the School of Nursing health and safety team with vaccination status of students for clinical rotation requirements based on vaccinations done by or voluntarily transferred to student health.
    Student Testing Pause Ending This Week Report for each school which shows individuals who have an active testing pause and will resume their normal testing requirements within the next 7 days. Individuals must test on the final day of the pause to avoid noncompliance reminders and reports the following day.
    Dept. of Internal Medicine Daily Health Check Summary Report for the Dept. of Internal Medicine health and safety team with aggregate daily counts of responses to the daily health check questions, including numbers on-campus, remote, and responding yes or no to symptoms.

    On-demand Reports for Deans

    Reports and tools available report description
    Access Exception Report View a list of individuals who are on campus, but do not have authorization to be on campus.
    Faculty and Staff Testing Summary Aggregated report with filters showing for employees with sum of tests and unique individuals tested by week from August 30, 2020 to present by planning unit and job category.
    Graduate and Professional Student Testing Summary Aggregated report with filters showing students enrolled in residence with sum of tests and unique individuals tested by week from August 30, 2020 to present by graduate or professional school and learning location.
    Health Check Report Identify authorized individuals on campus who have not completed the daily health check.
    High Contact List Population Overview Aggregated report with filters and counts showing faculty and staff with routine testing requirement, views by job category, job title, planning union, bargaining unit, location, and compliance override.
    Isolation Email Notification Email notification when a student enters or leaves isolation.
    New Haven Remote Undergraduate Student Testing Summary Aggregated report with filters showing undergraduate students enrolled remotely but residing in Greater New Haven Area with sum of tests and unique individuals tested by week from August 30, 2020 to present by residential college and learning location.
    Return to Campus Authorization Application

    An application for individuals who will oversee the review and approval of faculty and staff returning to campus. Any request must have the dean’s endorsement or vice president that oversees their particular area.
    Training Exception Report Identify authorized individuals on campus who have not completed the required training.

    On-demand Reports for Lead Administrators and Division Heads

    Reports and tools available Report description
    Access Exception Report View a list of staff who are on campus, but do not have authorization to be on campus.
    Health Check Report Identify authorized staff on campus who have not completed the daily health check.
    Return to Campus Authorization Application An application for individuals who will oversee the review and approval of faculty and staff returning to campus.
    Training Compliance Report View a list of staff who have, or have not, completed the required training within your Department.
    Training Exception Report Identify authorized staff on campus who have not completed the required training.

    On-demand Reports for the Public Health Committee

    REPORTS and tools available Report Description
    Faculty and Staff Testing Summary Aggregated report with filters showing for employees with sum of tests and unique individuals tested by week from August 30, 2020 to present by planning unit and job category.
    Graduate and Professional Student Testing Summary Aggregated report with filters showing students enrolled in residence with sum of tests and unique individuals tested by week from August 30, 2020 to present by graduate or professional school and learning location.
    New Haven Remote Undergraduate Student Testing Summary Aggregated report with filters showing undergraduate students enrolled remotely but residing in Greater New Haven Area with sum of tests and unique individuals tested by week from August 30, 2020 to present by residential college and learning location.
    High Contact List Population Overview Aggregated report with filters and counts showing faculty and staff with routine testing requirement, views by job category, job title, planning union, bargaining unit, location, and compliance override.

    On-demand Reports for the Testing and Tracing Committee

    REPORTS and tools available Report Description
    Key Performance Indicators Aggregated report with filters showing weekly trends for 17 metrics related to testing and training operations: Completed Tests (Asymptomatic, Symptomatic), No Shows (% of appointments), Unique Testers, Turn Around Time Median In Hours By Lab, Turn Around Time <= 24 Hours By Lab (% of total), Lab Results Processing Exceptions (% of total), Schedule Utilization (% of capacity) (Routine Asymptomatic, Voluntary Asymptomatic, Symptomatic), Daily Compliance Notifications, Routine Test Badge Restrictions By Audience, ServiceNow Incidents Created and Resolved, Label Reprinting Issues, Positives By Week By Population, Positive Cases Interviewed within 24 Hours (%), Number in Quarantine By Week by Population, Individuals Quarantine Testing Positive (%), Median Number of Contact Cases Per Positive Case, Contact Cases Notified within 24 Hours(%).
    Compliance Notifications and Badge Restrictions Aggregated report with daily and weekly counts for notifications and badge restrictions for the compliance restrictions for student compact, student training, on-arrival test, flu vaccine, and routine testing by category (student, staff, and faculty).
    Testing Appointments Today By Site By Time Aggregated report with filters for test sites showing the hours of operation for today and the count of appointments at each scheduled time per site.
    Medical Resident Testing Summary Aggregated report with counts of medical residents testing over time.
    Faculty and Staff Testing Summary Aggregated report with filters showing for employees with sum of tests and unique individuals tested by week from August 30, 2020 to present by planning unit and job category.
    Graduate and Professional Student Testing Summary Aggregated report with filters showing students enrolled in residence with sum of tests and unique individuals tested by week from August 30, 2020 to present by graduate or professional school and learning location.
    New Haven Remote Undergraduate Student Testing Summary Aggregated report with filters showing undergraduate students enrolled remotely but residing in Greater New Haven Area with sum of tests and unique individuals tested by week from August 30, 2020 to present by residential college and learning location.
    High Contact List Population Overview Aggregated report with filters and counts showing faculty and staff with routine testing requirement, views by job category, job title, planning union, bargaining unit, location, and compliance override.

    On-demand Reports for the Vaccination Advisory Committee

    REPORTS and tools available Report Description
    COVID Vaccination Invitation and Uptake Trends Aggregated report with COVID-19 vaccinations done by or voluntarily transferred to student and employee health. Includes counts over time of individuals eligible, invited, and doses administered by manufacturer. Filters include views by social vulnerability index zip code; for employees by planning unit, department, job category, affiliation; for students by school and college.

    Emailed Reports for Academic Health and Safety Leaders (HSLs) and Compliance Trackers

    These reports have been set up to be sent to Academic Health and Safety Leaders and Compliance Trackers who are assigned at the school level. Each report only contains students assigned to that particular HSL or Compliance Tracker.

    Reports report description cadence sent to who
    Daily Health Check:
    Positive Symptom Report    		 List of students who reported experiencing COVID-19 symptoms on the daily health check. Daily at 1:00pm and 7:00pm Academic HSLs
    Flu Shot Compliance Report List of students who have not received their Flu Shot Fridays, 8:30am Academic HSLs, Compliance Trackers
    Health Check Compliance Report Exception report of students who have accessed campus three or more consecutive times without completing a daily health check. Monday – Friday 8:30am Academic HSLs, Compliance Trackers
    Isolation Email Notification Email notification when a student enters or leaves isolation. On-demand Academic HSLs
    On Arrival Testing Compliance Report Exception report of in-residence students who have not taken required on-arrival test. Review Yale’s Health and Safety Guidelines.

    Monday – Sunday 8:30am

    		 Academic HSLs, Compliance Trackers
    Quarantine & Isolation Report Digest of students currently in quarantine or isolation. Report is sent from Yale Health. Daily at 5:00pm Academic HSLs, Deans (Graduate and Undergraduate), and Heads of College.
    Routine Testing Compliance Report

    Exception report of in-residence students required to participate in routine-testing who have gone 4 or more days without a test. Review Yale’s Health and Safety Guidelines.

    		 Monday – Sunday
    8:30am    		 Academic HSLs, Compliance Trackers
    Student Voluntary Testing Badge Access Report List of students who have been on campus at least 2 days out of the past 14 days who do not have routine testing requirements through their school nor housing. Students on this report may have completed voluntary tests during that period. Monday – Friday 8:30am Academic HSLs, Compliance Trackers
    Training and Yale Community Compact Compliance Report Exception report of in-residence students who have not completed the required student Return to Campus Training on Canvas and/or have not agreed to the Yale Community Compact (also refer to the Community Compact Enforcement page). Monday – Friday 8:30am Academic HSLs, Compliance Trackers

    Emailed Reports for Supervisors/Managers, Human Resources Generalists, and Lead Administrators

    The following reports are sent to supervisors/managers, Human Resources Generalists (HRGs), and Lead Administrators (LAs). The exception reports are triggered if anyone you directly supervise is on any of the 3 exception reports for the past week. For LAs, these reports are for their entire organization(s).

    REPORTS

    REPORT DESCRIPTION

    CADENCE

    SENT TO WHO

    Access Exception Report

    Anyone reporting to campus, should have first received authorization and be on an approved list.   See Access Exception Report – highlighting which days (in the past week) people were on campus without recorded authorization.

    Weekly on Monday mornings

    Supervisors or Principal Investigator, LAs
    Faculty and Staff Health Check Compliance Report Exception report of faculty/staff who have accessed campus three or more consecutive times without completing a health check. Monday – Friday 8:30am Supervisors, LAs, HRGs

    Health Check Activity Summary Report

    Anyone using the Daily Health Check. Report includes all check in activity and symptoms reported for the previous day.

    Daily in the morning

    Supervisors or Principal Investigator

    Health Check Exception Report

    Are those people, who are on campus, using the health checking survey? If not, they will be listed on the Health Check Report – highlighting which days (in the past week) they did not complete the survey.

    Weekly on Monday mornings

    Supervisors or Principal Investigator, LAs

    Health Check Positive Symptom Report

    Anyone who has reported symptoms using the Daily Health Check.

    Twice Daily, mid-day and evening

    Supervisors or Principal Investigator
    High Contact
    Faculty/Staff Routine Testing
    Compliance Report    		 Exception report of faculty and staff deemed “high-contact” who are required to participate in routine-testing and who have gone 8 or more days without a test. Review Yale’s Health and Safety Guidelines. Monday – Friday 9:00am Supervisors, HRGs
    Isolation Email Report Email notification when high-contact staff enter or leave isolation. On-demand Supervisors or Managers
    On-Arrival Testing Exception Report for High Contact Faculty and Staff Exception report of faculty and staff deemed “high-contact” who have not taken required on-arrival test. Monday – Friday 8:30am Supervisors, HRGs

    Training Exception Report

    Managers can use the Workday Return to Campus - Detail -Yale report to check who has completed the Return to Campus training in their respective areas.

    Have those people, who are on campus, completed the required training? If not, they will appear on the Training Exception Report.

    Weekly on Monday mornings

    Supervisors or Principal Investigator, LAs