Student Data > Other > District Student Lookup
School Info > District Student Lookup
Student Search (Multi-Year District Search button)
Student Data > Demographics (Add button, then Search Prior Year button)
The District Student Lookup page allows you to search for students who may have records at multiple schools and/or school years. The search returns a list of any students who have attended the district, as far back as district records exist in the database. The search is useful when trying to determine a student's last enrollment year. |
Prerequisites
- You must have access to more than one school.
- For full functionality, all students who ever attended the district must have records in the Student ID Numbers (IDN) and Enrollment History (ENR) tables .
Steps
Search for a student
- Select the table where you wish to search. Certain search fields are specific to the specified table.
- IDN Records - Search the Student ID Numbers (IDN) table
Searching IDN can retrieve student record that may have been deleted. If needed, the STU record can be undeleted via SQL. - STU Records - Search the Student Data (STU) table
- Both active and inactive records are retrieved.
- Deleted STU records are not retrieved when selecting the STU Records option.
- Active STU Records - Search the Student Data (STU) table for active students only (Status = Active (STU.TG = blank))
- IDN Records - Search the Student ID Numbers (IDN) table
- Enter one of the following search criterion:
Last Name
First NameType all or part of the student last and/or first name (STU.LN, STU.FN). Student ID Type all or part of the student district ID (STU.ID). State/Unique ID Type all or part of the student unique state ID (STU.CID). School AND Stu# The STU Records or Active STU option must be selected to use this search criteria.
Type the three-digit school ID, then type all or part of the student local school ID (STU.SN).Birthdate Type the students birthdate (STU.BD) - Click Search.
Search results are listed. The data displayed depends on the table selected (IDN or STU).Stu ID The student local school ID (STU.SN) Last/First Name The student first and last name (STU.LN, STU, FN) Middle - The student middle name (STU.MN)
- Only included if the IDN Records option is selected
Gender The student gender (STU.GN) Grade - The student grade level (STU.GR)
- Only included if the STU Records or Active STU option is selected
Birthday The student birthdate (STU.BD) Sch - The ID of the school the student attended (STU.SC)
- Only included if the STU Records or Active STU option is selected
Tag - Only included if the STU Records or Active STU option is selected
- Whether the student is inactive, active, pre-enrolled, or some other status (STU.TG)
- Blank indicates active.
- Asterisk indicates pre-enrolled for next year.
Leave Date - The date the student left the school that school year, if applicable (ENR.LD)
- Only included if the STU Records or Active STU option is selected
- Click the row of the student you wish to view.
The student's Enrollment History (ENR) records and Contacts (CON) are listed.Year The school year of the retrieved record (ENR.YR) Schl The school ID of the school the student attended that year (ENR.SC) Stu# The local school ID for the student at that school (ENR.SN) Trk The attendance track in which the student was enrolled at that school (ENR.TR) Prg (California) The attendance program in which the student was enrolled at that school (ENR.PR)
(Texas) The ADA Eligibility program in which the student was enrolled at that school (ENR.PR)Grd The student's grade level that school year (ENR.GR) Tch The student's teacher at that school that school year (ENR.TN) Enter Date The date the student entered the school that school year (ENR.ED) Leave Date The date the student left the school that school year (ENR.LD) Reason The reason the student left the school that school year (ENR.ER)
Print reports
Reports for prior school years can be printed as needed. Reports include data through the Year of the selected row. Only the most recent row will have data from all school years. |
- Click the icon for the report you wish to print.
- Transcript - Print the student's transcript through that school year.
- Enrollment - Print the student's Enrollment History Report through that school year.
- Immunization - Print the student's immunization records. You are prompted to select Blue Card or Regular.
- Click Regular to print the Student Immunization Card Report.
- (California) Click Blue Card to print the report formatted for the State of California Health and Human Services Agency California Pre-Kindergarten and School Immunization Record.
Copy student from prior school year to current school year
NOTE: If the student already exists in the current year the student cannot be copied.
Click the Copy Student icon to copy the student record from a prior school year to the current year.
A warning is displayed if the student is in a grade level outside the range of the school you are logged into. Click Yes if you wish to proceed.
The student record is is copied.