The following processes and queries are intended to provide some data validation options for prior year data conversion implementations.
|Create a Calendar. Use Push and Pull Setup Tables to copy to all schools.
|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
|LIST 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"
|Run the Transcript Reportto validate the following for Valedictorian and Salutatorian and five students at each grade level:
|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##
|Medical History (MHS)
|LIST STU MHS STU.ID STU.NM STU.GR MHS.CD MHS.CD? MED.CO IF MHS.CD # " "