The following processes and queries are intended to provide some data validation options for prior year data conversion implementations.  



Data Table
Query 
Calendar (DAY)Create a Calendar.  Use Push and Pull Setup Tables to copy to all schools.
Terms (TRM)Build the Terms.  Use Push and Pull Setup Tables to copy to all schools.
Student Data (STU)LIST STU SC ID NM GR BD AD CY ST ZC BY SC GR NM  
EnrollmentLIST STU ENR STU.ID STU.NM STU.GR ENR.YR ENR.SC ENR.PR ENR.GR ENR.TN ENR.ED ENR.LD ENR.ER ENR.IT
Language Assessment (LAC)LIST STU SC CID ID NM HL HL? LF BY SC HL LF IF LF # "English program code"
Transcripts (HIS)Run the Transcript Reportto validate the following for Valedictorian and Salutatorian and five students at each grade level:
  • Transcript Data
  • GPAs
  • Graduation Requirements
  • Credits
Assertive Discipline (ADS)LIST STU ADS DSP STU.ID STU.NM STU.GR STU.SX STU.ETH STU.RC1 ADS.CD ADS.CD? ADS.DT DSP.DS DSP.DY DSP.DD DSP.ED DSP.AA DSP.PL DSP.RS IF ADS.DT > 06/30/20##
Immunizations (IMZ)
  • Check  the Immunization records for five elementary students, 7th grade students, and high school students.
  • Query listing students missing Immunization records:  LIST STU IMM STU.ID STU.NM STU.BD STU.ED STU.GR BY STU.GR IF IMM.P1 = NULL
  • Query listing Transitional Kindergarten/Kindergarten Immunization records:  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
  • Query listing 7th grade students missing Immunization records:  IMZ:  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       
Medical History (MHS)LIST STU MHS STU.ID STU.NM STU.GR MHS.CD MHS.CD? MED.CO IF MHS.CD # " "
Flags (FLG)LIST FLG