With a large majority of student tables being available to front end users via DDE/DDA in PowerSchool, there may come a time when you will require an extraction of Health Vaccinations only to find that the tables are not available to you through DDE/DDA! (As of version 7.7) And worse off, Reportworks only provides limited display options. ODBC to the rescue!
If you are not familiar with Open Database Connectivity(ODBC), then you will need to contact your system administrator to grant you access and is usually a straightforward process. Using SQL queries will now grant you access to the following Health related tables not available through DDE:
- HealthGradeLevel
- HealthImmExempt
- HealthImmSource
- HealthMainStudRec
- HealthOfficeVisit
- HealthScreenChngDetail
- HealthScreenLookup
- HealthScreenWaiver
- HealthStudChngDetail
- HealthStudChngRsn
- HealthStudDoseRec (<= Vaccination doses stored here!)
- HealthStudGradeLevel
- HealthStudHearing
- HealthStudImmRec
- HealthStudOral
- HealthStudScolio
- HealthStudTB
- HealthStudVision
- HealthVaccine
- HealthVitalSigns
A simple sql query of Vaccination doses such as the one below can help to pull this information out of PowerSchool and into your own tool for migration, analysis or backup!
SELECT
Students.Student_Number as STUDENT_NUMBER_1,
Healthvaccine.vaccinename as VACCINATION_NAME_2,
Healthvaccine.vaccinecode as VACCINATION_CODE_3,
Healthstuddoserec.DateAdministered as DATE_ADMINISTERED_4
FROM HEALTHSTUDDOSEREC
LEFT JOIN HEALTHVACCINE ON
healthstuddoserec.healthvaccineid=healthvaccine.healthvaccineid
LEFT JOIN STUDENTS ON
healthstuddoserec.studentid=students.id
WHERE Healthstuddoserec.DateAdministered IS NOT NULL