Derived Level and Class Level

Last Update: 4/27/2020

To classify students’ academic level and class level in a manner that aids in reporting, several derived fields were created[1].  The logic for these derived fields relies on several fields in the Student Information System (SIS) (ex: academic level on the term table and degree education level on the plan and degree tables) to determine specific levels for students. 

Note that for future terms, the basis for these derived level/class fields is “projected” until the first day of classes, based on “passed” and “in progress” classes in prior and current terms.  Beginning on the first day of classes for a term, the basis for these fields changes to reflect only “passed” classes in prior terms.  In order to compare headcounts by class level for future terms with similar “projected” figures for prior terms as of a comparison date, users can use the following reports.  These reports have frozen data from different historical dates:

• IUIE data group: IR Daily Term Snapshot (IR_DAILY_TRM_DTL_SNPSHT_GT and SR_DAILY_TRM_DTL_SNPSHT_ST)
• SQL table:  IR_CEN_TRM_WKLY_SNPSHT_ST

On the term table (SR_STU_TERM_GT) there are three sets of fields that contain a sort field and a description field.  The sort fields are needed in order to sort the names in a way that is most acceptable (ex.: Undergrad, Grad, Prof, Non-degree) and not alphabetical (Grad, Non-Degree, Prof, Undergrad).  Note that all of these fields are independent of a student’s academic career.  For example, a student with a career of LAW who is in a master’s degree program has an Academic Level of “Graduate.”

Academic Level fields – Using the sort field in connection with the description field produces this list:    

Class Level fields – Using the sort field in connection with the description field produces this list:

 Expanded Level fields – Using the sort field in connection with the description field produces this list:

On the census table (IR_CEN_TRM_SNPSHT_GT) there are additional description fields to aid in official reporting:

Current UIRR Academic Level fields

Current UIRR Class Level fields

Historical UIRR Academic Level fields

Historical UIRR Class Level fields

[1] A grid of all columns, column values, and how they relate to one another can be found in the data warehouse table DSS_SH.SH_SR_DRVD_CRR_LVL_DM, as well as in this companion IR Data Guide:  https://uirr.iu.edu/doc/resources/ir-data-guides/Derived%20Level%20and%20Class%20Level%20Crosswalk%20and%20Logic.xls