黑料不打烊

Academic views

The academic views contain columns for personal information (ID, name, address, mother tongue, etc.), primary and secondary curriculum (level, faculty, degree, major, etc.), GPA information (cumulative, term, sessional, hours attempted, hours earned, etc.), various indicators (registration, applied for graduation, degree awarded, etc.) as well as many other data elements.

All the academic views are keyed by the term code (TERM_CODE_KEY). These views contain all the terms since Banner went live (200209 and greater). The views will return one row of information per student per term.

Current term views (ones that contain CURR_TERM in the name) are filtered to automatically return only records for the active current term. They switch over with the first day of classes each term.

The view names you see will depend on the level of access you have been granted. The naming convention is as follows:

Developer level: SRM_ACADEMIC,

SRM_ACADEMIC_CURR_TERM
Central User level: SRU_ACADEMIC,

SRU_ACADEMIC_CURR_TERM
Faculty level: SR_ACADEMIC_FAC,

SR_ACADEMIC_CURR_TERM_FAC
Service level: SR_ACADEMIC_SERV,

SR_ACADEMIC_CURR_TERM_SERV
Basic level: SR_ACADEMIC_BASIC,

SR_ACADEMIC_CURR_TERM_BASIC
Alumni level: SR_ACADEMIC_DARS,

SR_ACADEMIC_CURR_TERM_DARS

Other "special" academic views have been created for specific cases.

Academic views听摆.辫诲蹿闭

The academic view contains details about the students and their curriculum. It will return one row per student per term.

Academic views听摆.虫濒蝉闭

The academic view contains details about the students and their curriculum. It will return one row per student per term.

Back to top