Dental Screenings Date Range Dental Screenings Date Range Health

SELECT
        s.dcid,
        DECODE(s.grade_level,0,'K',-1,'PK',to_char(s.grade_level)),
        s.lastfirst,
        s.student_number,
        s.gender,
        DECODE(ildemo.FER,11,'Hispanic or Latino',12,'American Indian or Alaska Native',13,'Asian',14,'Black or African American',15,'Native Hawaiian or Other Pac Islander',16,'White',17,'Multiple Races','No Entry'),
        to_char(hso.screendate,'MM/DD/YYYY'),
        hso.GRADELEVELATSCREEN,
        DECODE(hso.ISDENTALSEALANTPRESENT,1,'Y',0,'N',''),
        DECODE(hso.ISMALOCCLUSIONPRESENT,1,'Y',0,'N',''),
        DECODE(hso.ISHISTORYCARIESPRESENT,1,'Y',0,'N',''),
        DECODE(hso.ISUNTREATEDCARIESPRESENT,1,'Y',0,'N',''),
        tu.healthcategory,
        hso.screencomment,
        hso.screenername
        
FROM 
        healthstudoral hso
        join healthmainstudrec hmsr on hmsr.healthmainstudrecid = hso.healthmainstudrecid
        join students s on s.id = hmsr.studentid
        left outer join S_IL_STU_Demographics_X ildemo ON s.DCID = ildemo.STUDENTSDCID
        left outer join healthscreenlookup tu on tu.healthscreenlookupid = hso.treaturgencyluid
WHERE
        hso.screendate BETWEEN TO_DATE('%param1%','tilde[dateformat]') AND TO_DATE('%param2%','tilde[dateformat]')
        AND s.schoolid = tilde(curschoolid)

ORDER BY
        s.GRADE_LEVEL,
        s.LASTFIRST,
        hso.screendate

DCIDStudentCurrent Grade LevelStudent NumberGenderRace/EthnicityScreening DateScreening Grade LevelSealant Present?Malocclusion Present?History of Caries?Untreated Caries?Treatment Urgency?CommentScreener Beginning Date 11/15/2019 1 Ending Date 5/15/2021 1 1 0 3,9, 0 0 0 1 1 Opt1