This is a collection of queries related to State/Federal Reporting 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

GSS:  Using the Report Tag Feature with the Golden State Seal Merit Diploma

As the Golden State Seal Merit Diploma processes, the Report Tags (RTG) table is updated with a record for each student. The Not Qualified students will have a Report Tag (RTG.QT) value of "NQ" and the Qualified students will have a Report Tag (RTG.QT) value of "QF".  Queries can be run to further evaluate these students or to KEEP the students for other processing (printing letters or certificates). This query lists the Not Qualified Students with their Status, School, Student ID, Name, Grade, Completion Status and Completion Date along with their Golden State Seal Merit Diploma report tag value.


LIST STU RTG STU.TG STU.SC STU.SN STU.ID STU.LN STU.FN STU.GR STU.HSG STU.DG RTG.RNM RTG.QT IF RTG.RNM = "GoldenStateSealMeritDiploma"  AND RTG.QT = "NQ"

GSS:  Using the Report Tag Feature with the Golden State Seal Merit Diploma

As the Golden State Seal Merit Diploma processes, the Report Tags (RTG) table is updated with a record for each student. The Not Qualified students will have a Report Tag (RTG.QT) value of "NQ" and the Qualified students will have a Report Tag (RTG.QT) value of "QF".  Queries can be run to further evaluate these students or to KEEP the students for other processing (printing letters or certificates). This query lists the Qualified Students with their Status, School, Student ID, Name, Grade, Completion Status and Completion Date along with their Golden State Seal Merit Diploma report tag value.


LIST STU RTG STU.TG STU.SC STU.SN STU.ID STU.LN STU.FN STU.GR STU.HSG STU.DG RTG.RNM RTG.QT IF RTG.RNM = "GoldenStateSealMeritDiploma"  AND RTG.QT = "QF"

SSB:  Using the Report Tag Feature with the State Seal of Biliteracy 

As the State Seal of Biliteracy processes, the Report Tags (RTG) table is updated with a record for each student. The Potentially Qualified students will have a Report Tag (RTG.QT) value of "RQs" and the Qualified students will have a Report Tag (RTG.QT) value of "QF".  Queries can be run to further evaluate these students or to KEEP the students for other processing (printing letters or certificates).  This query lists the Potentially Qualified Students with their Status, School, Student ID, Name, Grade, Completion Status and Completion Date along with their State Seal of Eligibility report tag value.


LIST STU RTG STU.TG STU.SC STU.SN STU.ID STU.LN STU.FN STU.GR STU.HSG STU.DG RTG.RNM RTG.QT IF RTG.RNM = "StateSealOfBiliteracy"  AND RTG.QT = "RQS"

SSB:  Using the Report Tag Feature with the State Seal of Biliteracy 

As the State Seal of Biliteracy processes, the Report Tags (RTG) table is updated with a record for each student. The Potentially Qualified students will have a Report Tag (RTG.QT) value of "RQs" and the Qualified students will have a Report Tag (RTG.QT) value of "QF".  Queries can be run to further evaluate these students or to KEEP the students for other processing (printing letters or certificates).  This query lists the Qualified Students with their Status, School, Student ID, Name, Grade, Completion Status and Completion Date along with their State Seal of Eligibility report tag value.


IST STU RTG STU.TG STU.SC STU.SN STU.ID STU.LN STU.FN STU.GR STU.HSG STU.DG RTG.RNM RTG.QT IF RTG.RNM = "StateSealOfBiliteracy"  AND RTG.QT = "QF"