To identify students who are new this year, follow these detailed steps:
1. Identify Students from Last Year:
- First, generate a list of students who were enrolled last year. This helps in identifying which students to skip in the next steps:
- This query lists students with their school code, ID, name, enrollment year, and enrollment end date, filtering for those enrolled last year: (change the year to last year if last year is not 2023)
LIST STU ENR STU.SC STU.ID STU.NM ENR.YR ENR.ED IF ENR.YR = 2023 AND STU.SC = ENR.SC
2. Skip Students from Last Year:
- Use the following command to skip the students identified in the previous step:
- This ensures that only students who are new this year are considered in the subsequent steps.
SKIP STU ENR IF ENR.YR < 2024 AND STU.SC = ENR.SC
3. List New Students and Their Enrollment Details:
After skipping the students from last year, list the new students along with their enrollment details:
This query provides a detailed list of new students, including their school code, ID, name, enrollment year, enrollment enter and end date, sorted by name and enrollment date.
LIST STU ENR STU.SC STU.ID STU.NM ENR.YR ENR.ED ENR.LD BY STU.NM ENR.ED IF STU.SC = ENR.SC
4. Generate a Non-Duplicated List:
This query generates a concise list of new students with their school code, ID, name, grade, and enrollment date, ensuring no duplicates.