Tool Search: Student Immunization and Susceptibility Report
"Student Immunization and Susceptibility Report summarizes vaccine compliance for each student attending the school. This report also functions as Section B for OR's Immunization Primary Review Summary."
"The susceptibility report identifies students susceptible to a specific disease (students not complete for the vaccine or immune) in case of an outbreak (Oregon Administrative Rule 333-050-0100)."
See the Oregon Immunization Rules article for vaccine compliance rules and requirements.
screenshot
Extract Editor
| Field | Description |
|---|---|
| Calendar Selection | Defaults to the Calendar selected in the Campus Toolbar At least one calendar is Required Has radio button selection: active year list by school list by year Default: active year |
| Student Selection | Options
|
| Select Grades | Becomes available with "Select Grades" is checked List all State Grades from locked attribute All Grades PK KG 01 02 03 04 05 06 07 08 09 10 11 12 UE UM US |
| Ad Hoc Filter | Becomes available with "Ad Hoc Filter" is checked Populates with saved Ad Hoc Filters |
| Enrollments | Students with Primary Enrollment All Students Students with Primary Enrollment (Type: P) Should default to this option Reports all students enrolled in the selected Calendar on the Enrollment Date (Service Type = P) AND with a current enrollment in the selected calendar When "All Students" is selected, reports all students with any enrollment (Type = P, N or S) in the calendar Reports all students enrolled in the selected Calendar on the Enrollment Date (Service Type = P, S or N) AND with a current enrollment in the selected calendar |
| Susceptible Students | Reports only the students with Susceptibility to the selected vaccines. If this is selected, student with the following compliance status(es) SHOULD report: Up-to-Date Incomplete State Exemptions Codes (NMO, NMH, PM, TM) If this is selected, students with the following compliance status(s) should NOT report Compliant State Exemption Code I: Immunity |
| Choose Vaccines | Becomes available if "Susceptible Students" is selected Defaults to "All" Options include: N/A All DTaP-DTP DTaP Tdap Tdap Polio Polio Varicella Varicella MMR MMR HepB HepB HepA HepA Hib Hib |
| Sort Options | Options: Student Name Overall Status Grade Teacher Defaults to Student Name Student Name (sorts by last name) Overall Status (Compliance Status for all vaccines) Grade Teacher (sorts by last name) |
| Enrollment Date | Date must be within the school year selected in the toolbar |
| Generate Report | Generates the report in HTML format. |
Due Dates
| Report Section(s) | Due Date |
|---|---|
| A (PRS Report) | January 17 |
| B-D (Student Immunization and Susceptibility Report) | January 17 |
| E (PRS Report) | March 4 |
| F-H (PRS Report) | March 4 |
Report Population
Students report when:
- They are enrolled in the selected calendar on the Enrollment Date and have a current enrollment in the selected calendar. All enrollments end dated before the Enrollment Date are excluded.
- They are enrolled in the selected calendar on the Enrollment Date with a Service Type of P, S, or N and have a current enrollment in the selected calendar.
Students are excluded when:
- They are marked as No Show.
- They are in State Grade(s) UM, UE, and US.
Logic
- Student information repeats for each student enrolled in the selected calendar on the Enrollment Date.
- A single record per student reports.
- Compliance data pulls in from the ImmComplianceStatus database table.
- The report can be run against a district's active year or prior years.
- The report generates in human-readable format (HTML).
Layout
Header
| Data Element Label | Description |
|---|---|
| Calendar | Reports the calendar name selected in the extract editor. |
| Report Date and Time | Reports the date and time the report was generated. MM/DD/YYYY 00:00:00 |
| Infinite Campus | Reports as Infinite Campus. |
| Student Immunization and Susceptibility Report | Reports as Student Immunization and Susceptibility Report. |
| Enrollment Date | Reports the Enrollment Date selected on the extract editor. |
| Total Students | Reports the number of students included in the report. |
| Page | Reports the current page and total pages of the report. (X of X) |
Report Data Elements
| Data Element Label | Description | Location |
|---|---|---|
| Student Name | The student's first and last name. | Demographics > First Name, Last Name identity.firstName, identity.lastName |
| Birthdate | The student's date of birth. | Demographics > Birth Date identity.birthDate |
| Grade | The student's grade level. | Enrollments > Grade |
| Teacher | Reports the student's homeroom teacher. The report first looks for courses marked as Homeroom in the student's Schedule. Otherwise, the report looks for courses marked as Advisory. | Student Information > Schedule Course Information/Section Information > Homeroom OR Advisory |
| Parent/Guardian Information | Reports Information on Guardian 1 Look at Students Enrollment record during current date Then look at Guardians on the Relationship tab that fit the current date Then look at the Guardian's Household Location for an address that fits into current date Then look to see if the Guardian's relationship tab is checked for mailing AND the Guardian's Household location is check for mailing during the current date and is not end dated Then look and see if the student is member of the Household Then look and see if the student is not End dated in the Household AND if the Household is the students Primary Household location Then look and see if Guardian is Primary household member in the Household If there are more than 2 guardians that meet the above criteria, report the 2 guardians with the oldest personID Guardian Information to report: Report First and Last Name of person marked as guardian for student in household Reports primary household address P.O. Box Number Prefix Street Tag Direction Apt City State Zip Phone | Relationships > Guardian Household Information > Address Household Information > Phone |
| Parent/Guardian Information | Reports Information on Guardian 2 Look at Students Enrollment record during current date Then look at Guardians on the Relationship tab that fit the current date Then look at the Guardian's Household Location for an address that fits into current date Then look to see if the Guardian's relationship tab is checked for mailing AND the Guardian's Household location is check for mailing during the current date and is not end dated Then look and see if the student is member of the Household Then look and see if the student is not End dated in the Household AND if the Household is the students Primary Household location Then look and see if Guardian is Primary household member in the Household If there are more than 2 guardians that meet the above criteria, report the 2 guardians with the oldest personID Guardian Information to report: Report First and Last Name of person marked as guardian for student in household Reports primary household address P.O. Box Number Prefix Street Tag Direction Apt City State Zip Phone | Relationships > Guardian Household Information > Address Household Information > Phone |
Tool Rights
Read - Generate the report.
Write - N/A
Add - N/A
Delete - N/A
For additional information, see the Individual User Tool Rights article.
