Reporting Resources and Tools for a Safe Return to Yale

Last Updated June 18, 2021

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.
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
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.
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
Health Check Report Identify authorized staff on campus who have not completed the daily health check.
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 Committees

REPORTS and tools available Report Description Sent to Who
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. Public Health Committee, Testing and Tracing Committee
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. Public Health Committee, Testing and Tracing Committee
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. Public Health Committee, Testing and Tracing Committee
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. Testing and Tracing Committee
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(%). Testing and Tracing Committee
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 and Tracing Committee
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. Testing and Tracing Committee
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.  
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. Vaccine Advisory Committee

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.
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
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:30 a.m. 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:30 a.m.

Academic HSLs, Compliance Trackers
Quarantine & Isolation Report Digest of students currently in quarantine or isolation. Report is sent from Yale Health. Daily at 5:00 p.m. 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:30 a.m.
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:30 a.m. 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:30 a.m. 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

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:30 a.m. 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 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:00 a.m. 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:30 a.m. Supervisors, HRGs