This is a collection of queries related to Medical and Health that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

MHS:  List of Students with a Medical History Code 

Provides a list of student who have a Medical History Code


LIST STU MHS STU.ID STU.NM STU.GR MHS.CD MHS.CD? IF MHS.CD # " " 


MHS:  List of Student with a Medical History Code by Teacher Name for Elementary with Master Schedule School Type

Provides a list of students with attendance period teacher who have a Medical History Code sorted by Teacher 


LIST MHS STU SEC MST TCH TCH.TE MST.PD STU.NM STU.GR MHS.CD? MHS.CO BY TCH.TE IF MHS.CD # " " OR MHS.CO # " "


IMM:  List of Kindergarten/Transitional Kindergarten Immunizations

Provides a list of Immunizations for students in Kindergarten/Transitional Kindergarten


LIST STU IMM STU.ID STU.NM STU.GR STU.BD IMM.S1 IMM.E1 IMM.E3 IMM.E2 IMM.PE IMM.DE IMM.AE IMM.IE IMM.VE IMM.PC IMM.DC IMM.AC IMM.IC IMM.VC IF GR = 0 OR GR = -1


IMM:  List of Student without Immunization Records

Provides a list of students that do not have any Immunizations entered


LIST STU IMM STU.ID STU.NM STU.BD STU.ED STU.GR BY STU.GR IF IMM.P1 = NULL


IMM:  List of 7th Grade Students Missing Immunizations

Provides a list of students in 7th grade that are missing required Immunizations


LIST STU IMM STU.ID STU.NM STU.BD IMM.E3 IMM.A1 IMM.A2 IMM.AE IMM.IE IMM.I1 IMM.I2 IMM.I3 IF IMM.A2 = NULL OR IMM.I3 = NULL AND GR = 7


IMM:  List of Students Missing Physical (CHDP)

Provides a list of students missing a Physical (CHDP) record


LIST STU IMM TCH STU.ID STU.NM STU.GR TCH.TE IMM.E3 IMM.H1 IF IMM.H1 = NULL


IMM:  List of 1st Grade Students and Physical (CHDP) Data

Provides a list of all 1st graders and any Physical (CHDP) data


LIST STU IMM TCH STU.ID STU.NM STU.GR TCH.TE IMM.E3 IMM.H1 IMM.HW IMM.HC IF STU.GR = 1


IMM:  List of Students and Tuberculosis (TB) Data

Provides a list of all students and any Tuberculosis (TB) data sorted by Grade


LIST STU IMM STU.ID STU.NM STU.LS STU.ED STU.BCU IMM.BP IMM.E3 IMM.T1 IMM.N1 IMM.N2 IMM.B1 IMM.XD IMM.XN IMM.XA IMM.XC STU.GR BY STU.GR


IMM:  List of Students and Mantoux Report Data (TB)

Provides a list a students with the Mantoux Report Data (TB)


LIST STU IMM STU.ID STU.NM STU.GR IMM.BP STU.LS STU.ED IMM.T1 IMM.N1 IMM.B1 IMM.T2 IMM.N2 IMM.B2 IMM.XD IMM.XN IMM.XA IMM.XC


IMM:  List of 6th Grade Students and Hepatitis (HEPB) and Measles Mumps Rubella (MMR) data

Provides a list of all 6th graders and any HEPB and MMR data


LIST STU IMM STU.ID STU.NM STU.GR IMM.E3 IMM.IE IMM.I1 IMM.I2 IMM.I3 IMM.AE STU.BD IMM.A1 IMM.A2 IF IMM.I3 = NULL OR IMM.A2 = NULL AND STU.GR = 6


IMM:  List of 7th Grade Student Missing Hepatitis 3 and includes Measles Mumps and Rubella (MMR) and Hepatitis (HEP) Information

Provides a list of 7th grade students missing Hepatitis 3 Immunization and includes Measles Mumps and Rubella (MMR) and Hepatitis (HEP) Information


LIST STU IMM STU.SN STU.NM IMM.E3 STU.BD IMM.A1 IMM.A2 IMM.I1 IMM.I2 IMM.I3 IF IMM.I3 = NULL AND GR = 7


HRN:  List of Students and Hearing Screening Data

Provides a list of all students and any Hearing Screening data sorted by Grade


LIST STU HRN STU.ID STU.NM STU.HP HRN.TD HRN.PF HRN.SCN HRN.DR HRN.DT STU.GR BY STU.GR


HRN:  List of Students who Failed the Hearing Screening after a Specific Date

Provides a list of students who failed a Hearing Screening that was given after a specific date sorted by Grade


LIST STU HRN STU.ID  STU.NM HRN.TD HRN.SCN HRN.PF STU.GR BY STU.GR IF HRN.PF = F AND HRN.TD > ##/##/20##


HRN:  List of Students with Hearing Doctor Referrals by Teacher

Provides a list of students with data in the Doctor Referral field in Hearing sorted by Grade


LIST STU HRN STU.ID STU.NM HRN.DR HRN.DT STU.GR BY STU.GR IF HRN.DR # " "


HRN/VSN:  List of Students with Hearing or Vision Follow Up Data by Teacher

Provides a list of students with data in the Follow Up fields in Hearing or Vision sorted by Teacher


LIST STU HRN VSN TCH STU.ID STU.NM STU.GR HRN.FO VSN.FO TCH.TE BY TCH.TE IF VSN.FO # " " OR HRN.FO # " "


VSN:  List of Students with Vision Testing Results (Pass/Fall) within a Specific Date Range by Teacher/Counselor

List of students Pass/Fail results for Vision testing within a specific date range sorted by Teacher/Counselor Number


LIST STU VSN STU.ID STU.NM VSN.PF STU.CU BY STU.CU IF ( VSN.DT > ##/##/20## AND VSN.DT < ##/##/20## )


VSN:  Vision Results on Students for Charting

Provides a list of students with Vision results for charting


LIST STU VSN STU.ID STU.NM STU.GR VSN.TD VSN.PF VSN.RG VSN.LG VSN.BG VSN.RN VSN.LN VSN.BN VSN.CT


SCO:  List of Students with Scoliosis Screening Results for the Current School Year

Provides a list of students with Pass or Fail data on a Scoliosis Screening tested during the current school year


1.  7th Grade Females

     LIST STU SCO STU.ID STU.SC STU.NM STU.GR SCO.TD SCO.SCN SCO.PF IF SCO.PF = P AND SCO.TD >          06/30/20## AND STU.GR = 7 AND STU.SX = F

     (Change SCO.PF = F to search for students who Failed the screening)

2.  8th Grade Males

     LIST STU SCO STU.ID STU.SC STU.NM STU.GR SCO.TD SCO.SCN SCO.PF IF SCO.PF = P AND SCO.TD >          06/30/20## AND STU.GR = 8 AND STU.SX = M

     (Change SCO.PF = F to search for students who Failed the screening)


SCO:  List of Students who were Not Screened or Failed the Scoliosis Screening

Provides a list of students who do not have any data in the Pass/Fail field or Failed the Scoliosis Screening


LIST STU SCO STU.ID STU.NM STU.GR SCO.TD SCO.SCN SCO.PF SCO.CO IF SCO.PF = F OR SCO.PF = NULL 


SCO:  List of Students with a Doctor Referral - DR = R

Provides a list of students who were given a Doctor Referral (DR = R) after Scoliosis Screening


LIST STU SCO STU.ID STU.NM SCO.TD SCO.SCN SCO.DR SCO.CO IF SCO.DR = "R"


Label Queries

IMM:  Address Labels to Parents for Students Missing Physical (CHDP)

Labels to parents of students who are missing a Physical (CHDP)


LIST STU IMM "TO THE PARENT OF:" \ STU.FN STU.LN \ STU.AD \ STU.CY "," STU.ST STU.ZC IF IMM.H1 = NULL


IMM:  Address Labels to Parents for Students Missing 2nd MMR or any Hepatitis Vaccinations

Labels to parents of students who are missing the 2nd MMR vaccine or any of the hepatitis shots 


LIST STU IMM STU.PG \ "RE:" STU.NM \ STU.AD \ STU.CY STU.ST STU.ZC IF IMM.A2 = NULL OR IMM.I1 = NULL OR IMM.I2 = NULL OR IMM.I3 = NULL


SCO:  Address Labels to Parents for Students with a Doctor Referral

Labels to parents of student who require a Doctor Referral from the Scoliosis Screening


LIST STU SCO "To the parent of:" \ STU.FN STU.LN \ STU.AD \ STU.CY STU.ZC IF SCO.DR = "R"