Updated: Sun, 10/06/2024 - 10:30

From Saturday, Oct. 5 through Monday, Oct. 7, the Downtown and Macdonald Campuses will be open only to McGill students, employees and essential visitors. Many classes will be held online. Remote work required where possible. See Campus Public Safety website for details.

Du samedi 5 octobre au lundi 7 octobre, le campus du centre-ville et le campus Macdonald ne seront accessibles qu’aux étudiants et aux membres du personnel de l’Université McGill, ainsi qu’aux visiteurs essentiels. De nombreux cours auront lieu en ligne. Le personnel devra travailler à distance, si possible. Voir le site Web de la Direction de la protection et de la prévention pour plus de détails.

McGill.CA / Enrolment Services / SIS Data Warehouse / FAQs

Multiple student rows

There may be a number of reasons why you are seeing multiple rows of the same student. Some of the common reasons can be:

  • If you are using the faculty view, you may be seeing a student for every term that they have enrolled in. Either use the "CURR_TERM" view or set the "TERM_CODE_KEY" to return students for the term you want to see.
  • If you are using the course view, you will get a record for every course that they have taken in each term.
  • If you are joining two tables, you may have not set the join condition properly. In most cases the tables should be joined by setting "ID" to "ID" or "PIDM" to "PIDM".

Please request assistance if you are have trouble getting the data you are expecting.

Back to top