Related Topics   

State Student Identifier Data Extract

Contents

1 Overview

2 Editing

3 Extract File

4 Extract Report

5 Exception Report

 

 

6 Report Summary

7 Report Parameters

8 How-to

9 Extract File Fields

10 Extract & Exception Rpt Fields

11 Selection Criteria

2 Editing

Students with invalid data are put on the exception report and are excluded from the extract file and extract report.  Data is identified as invalid when

  1. A student is age 21 or more on September 1 at the beginning of the school year.

Error message = *** Student must be under the age of 21 on September 1 of the school year ***

  1. A student’s birth date is on or after September 1 of the end of the school year.

Error message = *** Student must be born before 9/1/ZZZZ ***, where ZZZZ is the end year of the school year range.

  1. A student’s birth date is greater than the system date.

Error message = *** Birth Date is greater than the current date ***

  1. A student does not have a default entity from among the entities which were selected for running the extract process.

Error message = *** Student does not have a default entity ***

  1. A student’s most recent district enrollment date is blank.

Error message = *** District Entry Date must not be blank ***

  1. A student’s most recent district enrollment date is more than one year in the future.

Error message = ***District Entry Date is more than one year in the future ***

  1. A student’s most recent district enrollment date is less than the system date minus 23 years.

Error message = *** District Entry Date is more than 23 years in the past ***

  1. A student’s most recent district enrollment date is after the most recent school enrollment date.

Error message = *** District Entry Date is after Entity Entry Date MM/DD/YYYY in Entity NNN ***, where MM/DD/YYYY is the most recent school enrollment date in the student’s default entity and NNN is the student’s default entity number.

  1. The state building code is zero.

Error message = *** In Entity XXX, School YYY does not have a State Building Code ***, where XXX is the student’s default entity number and YYY is the school number.

  1. A student’s most recent school enrollment date is more than one year in the future.

Error message = *** Entity Entry Date MM/DD/YYYY is more than one year in the future in Entity NNN ***, where MM/DD/YYYY is the STUDENT-EW.EW-DATE and NNN is the student’s default entity number.

  1. A student’s most recent school enrollment date is less than the system date minus 23 years.

Error message = *** Entity Entry Date MM/DD/YYYY is more than 23 years in the past in Entity NNN ***, where MM/DD/YYYY is the STUDENT-EW.EW-DATE and NNN is the student’s default entity number.

Page Updated 8/06