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