How Does Aeries Determine Student Organizational Unit in Google When Student is Affiliated With Multiple Schools?

1. Students are ranked first by Tag (TG). 
2. Then ranked by program code.
   1. Lower program codes take precedence.
3. Then student enrollment end date in STU.ED is checked.
   1. Records with earlier end dates are prioritized, but if ED is NULL, it uses a far future placeholder (9999-12-31).
4. Then it looks at enrollment year.
   1. Most recent year (higher value) wins
   2. Among same year enrollments, the earlier end date wins.
5. Then compares last date of enrollment (LD).
   1. More recent LD wins (DESC).
6. Final tiebreaker: School Code.
   1. If everything else is equal, lower school code wins (e.g., 894 beats 994)