New Online Columns

Overview

For background on Online Definitions at IU, please refer to the document at the bottom of this page called ‘Read more about definitions’ https://teachingonline.iu.edu/about/index.html.

Some new columns are available (on 8/22/2020) in SR_STU_TERM_ST/GT and the daily snapshot (SR_DAILY_TRM_DTL_SNPSHT_ST/V/IR_DAILY_TRM_DTL_SNPSHT_GT) to make reporting on online status a bit easier.

The new columns represent counts and indicators by student/institution (or reporting institution)/term. The reporting institution set of columns combines IUPUI/Columbus/Ft Wayne into one set of counts and indicators. It is important to note that these columns aggregate class counts for students who are in multiple careers at an institution into a single count, and repeat these aggregated counts on all career rows for the student.

The new columns are class counts by instruction modes rolled up at the institution (or reporting institution) level. There are also some indicator codes that aggregate class counts into an indicator, such as, is the student enrolled in All, Some, or No online courses? Or, is the student enrolled in any courses that have an on-campus presence requirement?

You must use the ROW_USE_HDCT_UNDUPL_IND if you want unduplicated counts at the institution or report institution level. If you want unduplicated counts for a campus, without regard to the student's level, only include rows where the ROW_USE_HDCT_UNDUPL_IND=Y. That will retrieve the record with the highest designated primacy, and it will contain the student’s total institution class counts and status, not just for that career (if the student is taking classes from more than one career).

If, however, you want a count of undergraduate students (not undergraduate level courses) and their class counts or status, you can limit to undergraduate level students using one of the derived level columns. Understand that their class counts will be across their entire institution, even if they took a non-undergraduate course.

SR_STU_TERM_ST and SR_DAILY_TRM_DTL_SNPSHT_ST and SR_DAILY_TRM_DTL_SNPSHT_V will have the following new columns:

SR_STU_TERM_GT ,IR_DAILY_TRM_SNPSHT_GT and IR_CEN_TRM_SNPSHT_GT contain the following new columns: