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
Comment With Us
Hello DataDriven Community!
DataDriven For Schools has undergone some updates that will make it easier and faster for us to push out all of those tips and updates that you have gotten to read about when it comes to PowerSchool, CALPADS, Reports, etc. If you have not already subscribed to our Blog feed, be sure to do so now because there are lots of new posts that will be coming your way.
We have received a lot of great feedback via email from our readers and we are now happy to announce that comments are now live on all previous and future blog posts! Have something to add to our post? Comment! Want to say hi? Comment! Of course traditional channels are still always open for those that prefer more private channels of communication.
We are excited about what our DataDriven community is doing for schools and we can’t wait to hear from you!