The following are examples of Medical queries that can be generated to produce specific reports. These queries can be generated and saved. 


HLT K Assessment


KEEP STU IF GR = 0


LIST STU IMM STU.SN STU.LN STU.FN 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


HLT CHDP - Only students missing CHDP

 

LIST STU IMM TCH STU.SN STU.LN STU.FN STU.GR TCH.TE IMM.E3 IMM.H1 IF IMM.H1 = "null" OR IMM.H1 < 3/1/2001


HLT CHDP Mailing

 

LIST STU IMM "TO THE PARENT OF:" \ STU.FN STU.LN \ STU.AD \ STU.CY "," STU.ST STU.ZC IF IMM.H1 = NULL OR IMM.H1 < 03/01/2001


HLT CHDP REPORT

 

TOTAL STU IF GR = 1


KEEP STU IF GR = 1


LIST STU IMM TCH STU.SN STU.LN STU.FN STU.GR TCH.TE IMM.E3 IMM.H1 IMM.HW IMM.HC IF STU.GR = 1


HLT TB LIST - Grades 1-12

 

KEEP STU IF ED > 11/14/2001


KEEP STU IF LS = 2 OR LS = “NULL” OR LS = 0


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


Kindergarten


KEEP STU IF GR = 0


LIST STU IMM STU.SN STU.NM STU.LS STU.ED STU.BCU IMM.E3 IMM.T1 IMM.N1 IMM.B1 IMM.XD IMM.XN IMM.XA IMM.XC STU.GR


HLT HBV & MMR Follow Up


KEEP STU IF GR = 6


LIST STU IMM STU.SN STU.NM 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


HLT Hearing Report

 

LIST STU HRN STU.SN STU.LN STU.FN HRN.SCN STU.GR BY STU.GR IF HRN.SCN = I AND HRN.TD > 08/15/2001


KEEP STU HRN IF HRN.TD > 8/15/2001


LIST STU HRN STU.SN STU.NM HRN.SCN HRN.PF STU.GR BY STU.GR IF HRN.PF = F AND HRN.SCN = "T2"


LIST STU HRN STU.SN STU.NM HRN.TD HRN.CT STU.GR BY STU.GR IF HRN.CT = "N"


LIST STU HRN STU.SN STU.LN STU.FN HRN.DR HRN.DT STU.GR BY STU.GR IFHRN.DR = "R"


FOLLOW UP FOR HEARING AND VISION SCREENING 


Run this query to get a list of students needing follow-up hearing or vision testing grouped by teacher. 

 

LIST STU HRN VSN TCH STU.SN STU.NM STU.GR HRN.FO VSN.FOTCH.TE BY TCH.TE IF HRN.FO : F OR HRN.FO : N OR VSN.FO = F OR VSN.FO = N 



SCOLIOSIS


HLT Scoliosis


KEEP STU IF GR = 7(8) AND SX = F (M)


LIST STU SCO STU.SN STU.LN STU.FN STU.GR SCO.SCN SCO.PF IF SCO.PF = P AND SCO.TD > 01/15/02


LIST STU SCO STU.SN STU.LN STU.FN STU.GR SCO.SCN SCO.PF IF SCO.PF = F AND SCO.TD > 01/15/02


LIST STU SCO STU.SN STU.LN STU.FN STU.GR SCO.TD SCO.DR SCO.DT IF SCO.TD > 01/15/02


Disaster Labels


These are used for attendance purposes in the event of an emergency.  Label is placed on child. Any staff member supervising child is notified of health concerns or precautions.


LIST STU TCH STU.LN STU.FN \ STU.HP \ TCH.TE BY TCH.TE IF STU.HP # " " 


CLASS LISTS WITH HEALTH PROBLEMS FOR TEACHERS

 

Run this to see output, then run as a report with page break for each teacher

 

LIST STU SEC MST TCH STU.SN STU.NM STU.GR STU.HP MST.RM MST.PD TCH.TE MST.SE BY MST.SE IF MST.CN : 7707


FOLLOW UP FOR HEARING AND VISION SCREENING


Run this query to get a list of students needing hearing or vision testing grouped by teacher.


LIST STU HRN VSN TCH STU.SN STU.NM STU.GR HRN.FO VSN.FO TCH.TE BY TCH.TE IF HRN.FO : F OR HRN.FO : N OR VSN.FO = F OR VSN.FO = N



IMMUNIZATIONS


Students needing 2nd MMR shot or any hepatitis shots


LIST STU IMM STU.LN STU.FN IMM.A2 IMM.I1 IMM.I2 IMM.I3 IF IMM.A2 = NULL OR IMM.I1 = NULL OR IMM.I2 = NULL OR IMM.I3 = NULL


Immunization - labels to parents


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


7th Grade Missing Immunizations 


LIST STU IMM STU.SN STU.LN STU.FN IMM.E3 STU.BD IMM.A1 IMM.A2 IMM.AE IMM.IE IMM.I1 IMM.I2 IMM.I3 IF IMM.A2 = NULL OR IMM.I3 = NULL


Student with no immunizations in IMM table


LIST STU IMM STU.SN STU.LN STU.FN STU.BD STU.ED STU.GR BY STU.GR IF IMM.P1 = "null"


Missing HBV MMR


LIST STU IMM STU.SN STU.LN STU.FN STU.LS IMM.E3 IMM.I1 IMM.I2 IMM.I3 IMM.IC IMM.IE STU.BD IMM.A1 IMM.A2 IMM.AC IMM.AE IF IMM.I3 = NULL OR IMM.A2 = NULL


Missing HBV MMR Exempt


LIST STU IMM STU.SN STU.LN STU.FN IMM.E3 IMM.I1 IMM.I2 IMM.I3 IMM.IE IMM.A1 IMM.A2 IMM.AE IF IMM.I1 = "NULL" OR IMM.A2 = "NULL"


Missing Hepatitis3


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


Mantoux report data (EH)


LIST STU IMM STU.SN STU.LN STU.FN 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



HEARING


LIST STU HRN STU.SN STU.HP HRN.TD HRN.PF HRN.SCN HRN.DR HRN.DT STU.GR BY STU.GR IF HRN.TD > 9/01/2001


Hearing Results by year


LIST STU HRN STU.SN STU.LN STU.FN STU.GR HRN.TD HRN.PF HRN.FO IF HRN.TD > 9/01/2000



VISION


Recheck vision


LIST STU VSN STU.SN STU.LN STU.FN STU.GR STU.ED VSN.FO IF VSN.FO = "F" OR VSN.FO = "N"


Vision Referral Follow up


LIST STU VSN STU.SN STU.LN STU.FN STU.GR VSN.TD VSN.DR VSN.DT IF VSN.DR : R


Vision Results for Charting


LIST STU VSN STU.SN STU.LN STU.FN STU.GR VSN.TD VSN.PF VSN.RG VSN.LG VSN.BG VSN.RN VSN.LN VSN.BN VSN.CT



SCOLIOSIS


Labels SCO Dr. Referral


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


Scoliosis Follow Up


LIST STU SCO STU.SN STU.LN STU.FN STU.GR SCO.TD SCO.SCN SCO.PF SCO.CO IF SCO.PF = F OR SCO.PF = NULL


Scoliosis Mole


LIST STU SCO STU.SN STU.LN STU.FN SCO.TD SCO.PF SCO.CO IF SCO.CO : "Mole"


Scoliosis not tested


LIST STU SCO STU.SN STU.LN STU.FN STU.SX STU.GR SCO.PF IF SCO.PF = NULL


Scoliosis Referrals


LIST STU SCO STU.SN STU.LN STU.FN SCO.TD SCO.SCN SCO.DR SCO.CO IF SCO.DR = "R"


Scoliosis Results


LIST STU SCO STU.SN STU.LN STU.FN SCO.TD SCO.PF IF SCO.PF : P AND STU.GR = 7 AND STU.SX = F


TB Report STATS 


LIST STU IMM STU.SN STU.LN STU.FN STU.LS IMM.BP IMM.T1 IMM.N1 IMM.B1 IMM.T2 IMM.N2 IMM.B2 IMM.XD IMM.XN



Miscellaneous Medical Queries 


Emergency Student List


LIST STU SEC MST STU.SN STU.LN STU.FN MST.PD MST.RM STU.PG STU.TL STU.FW STU.FX STU.MW STU.MX BY MST.RM STU.LN STU.FN STU.SN IF MST.PD = 3


MHS list of students by teacher by period


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 # " " 


COD list of medical codes and descriptions


LIST COD CD DE IF TC = MED AND FC = "CD"


Medical History Problem List


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