|
|
|
|
|
|
|
Contents
|
|
Students are selected if
They have a default entity.
-- AND --
Their default entity is within the entity range selected when the report is run. [In the Student-Entity records, find the record where Student Default Entity (Student-Entity.X-Default-Entity = "Y" for Yes); in that record, if the School ID (Student-Entity.School-ID) is one of the schools chosen, continue processing.]
-- AND --
Their default entity is not 999 (Student-Entity.Entity-ID
999).
-- AND --
They do not already have an SSID in their record (Student.Mn-Ede-Nbr = zero or blank).
-- AND --
For the entities selected, they have an Entry-Withdrawal record where the Entry Date is not greater than the current month and the Withdrawal Date is blank (Student-EW.EW-Date is not greater than the current month and Student-EW.Withdrawal-Date = blank),
-- OR --
For the entities selected, they have an Entry-Withdrawal record where the Entry Date is not greater than the current month and the Withdrawal Date is in the current or prior month, based on the system date (Student-EW.EW-Date is not greater than the current month and Student-EW.Withdrawal-Date is not blank and is in the current or prior month.)
-- AND --
They are age 20 or less on September 1 at the beginning of the school year.
A student is defined as being under the age of 21 on September 1 of the school year if the student was born prior to September 1 of the end of the school year and is under age 21 on September 1 at the beginning of the school year. That is, where the school year = yyyy-zzzz, the student’s birth date (NAME.BIRTH-DATE) must be less than 9/1/zzzz and greater than or equal to 9/1/yyyy minus 21. The school year yyyy-zzzz is determined as follows:
If the month of the system date is 1 through 8, zzzz = the year of the system date. Example: If the system date = 1/4/2005, zzzz = 2005; therefore, the school year is 2004-2005.
If the month of the system date is 9 through 12, zzzz = the year of the system date + 1. Example: If the system date = 9/1/2004, zzzz = 2004 + 1 which is 2005; therefore, the school year is 2004-2005.
Students are reported only once within a school district (in their default entity), even if they attend more than one school.
Page Updated 8/06