Reporting View Target: GPA_BY

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GPA_BY_LEVEL

Description Contains GPA (grade point average) or average details for a person by student level of academic study (undergraduate, graduate). Details include the component data used to calculate the GPA.
Key & Frequency One row per person per academic study area (student level) per GPA Type (institution, transfer, overall).
Recommended Search Columns PERSON_UID, ACADEMIC_STUDY_VALUE, ACADEMIC_PERIOD, GPA_TYPE
ACADEMIC_STUDY_VALUE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic Period Academic period that relates to the information in this record. VARCHAR2(63)
NA

NA

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)
NA

NA

ACADEMIC_STUDY_VALUE Academic Study Value Area this GPA represents such as student level, college, major, etc. types of GPAs. In this example the type is the student level average or GPA. VARCHAR2(63)
SHRLGPA

SHRLGPA_LEVL_CODE

ACADEMIC_STUDY_VALUE_DESC Academic Study Value Description Student level description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(63)
NA

NA

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)
NA

NA

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CLASS_RANK Class Rank Student's institutional class rank. NUMBER
NA

NA

CLASS_SIZE Class Size Student's institutional class size. NUMBER
NA

NA

COMPUTATION_DATE Computation Date Date the GPA was calculated. DATE
SHRLGPA

SHRLGPA_ACTIVITY_DATE

CREDITS_ATTEMPTED Credits Attempted Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted. NUMBER
SHRLGPA

SHRLGPA_HOURS_ATTEMPTED

CREDITS_EARNED Credits Earned Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. NUMBER
SHRLGPA

SHRLGPA_HOURS_EARNED

CREDITS_PASSED Credits Passed Credits passed as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. NUMBER
SHRLGPA

SHRLGPA_HOURS_PASSED

GPA GPA - Grade Point Average or Average Calculated grade point average or average for a set of courses completed. NUMBER
SHRLGPA

SHRLGPA_GPA

GPA_CREDITS GPA - Grade Point Average or Average Credits Credits used to calculate the average or grade point average for the courses completed by the person. NUMBER
SHRLGPA

SHRLGPA_GPA_HOURS

GPA_TYPE GPA - Grade Point Average or Average Type Type of GPA displayed. Valid values are Institution (courses completed at this institution), Transfer (courses completed at another institution and transferred for credit), or Overall (all courses completed). VARCHAR2(1)
SHRLGPA

SHRLGPA_GPA_TYPE_IND

GPA_TYPE_DESC GPA - Grade Point Average or Average Type Description GPA type description. VARCHAR2(11)
CALCULATION

DECODE(SHRLGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER','O','OVERALL')

ID ID Person's or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OFFICIAL_GPA_IND Official GPA - Grade Point Average or Average Indicator Indicates whether the GPA information is official. VARCHAR2(1)
NA

NA

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
SHRLGPA

SHRLGPA_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

QUALITY_POINTS Quality Points Student's cumulative quality points. NUMBER
SHRLGPA

SHRLGPA_QUALITY_POINTS

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)
NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Contains GPA (grade point average) or average details for a person by student level of academic study (undergraduate, graduate). Details include the component data used to calculate the GPA.
Key & Frequency	One row per person per academic study area (student level) per GPA Type (institution, transfer, overall).
Recommended Search Columns	PERSON_UID, ACADEMIC_STUDY_VALUE, ACADEMIC_PERIOD, GPA_TYPE ACADEMIC_STUDY_VALUE

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period that relates to the information in this record.	VARCHAR2(63)	NA	NA
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	NA	NA
ACADEMIC_STUDY_VALUE	Academic Study Value	Area this GPA represents such as student level, college, major, etc. types of GPAs. In this example the type is the student level average or GPA.	VARCHAR2(63)	SHRLGPA	SHRLGPA_LEVL_CODE
ACADEMIC_STUDY_VALUE_DESC	Academic Study Value Description	Student level description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)	NA	NA
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	NA	NA
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CLASS_RANK	Class Rank	Student's institutional class rank.	NUMBER	NA	NA
CLASS_SIZE	Class Size	Student's institutional class size.	NUMBER	NA	NA
COMPUTATION_DATE	Computation Date	Date the GPA was calculated.	DATE	SHRLGPA	SHRLGPA_ACTIVITY_DATE
CREDITS_ATTEMPTED	Credits Attempted	Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted.	NUMBER	SHRLGPA	SHRLGPA_HOURS_ATTEMPTED
CREDITS_EARNED	Credits Earned	Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.	NUMBER	SHRLGPA	SHRLGPA_HOURS_EARNED
CREDITS_PASSED	Credits Passed	Credits passed as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.	NUMBER	SHRLGPA	SHRLGPA_HOURS_PASSED
GPA	GPA - Grade Point Average or Average	Calculated grade point average or average for a set of courses completed.	NUMBER	SHRLGPA	SHRLGPA_GPA
GPA_CREDITS	GPA - Grade Point Average or Average Credits	Credits used to calculate the average or grade point average for the courses completed by the person.	NUMBER	SHRLGPA	SHRLGPA_GPA_HOURS
GPA_TYPE	GPA - Grade Point Average or Average Type	Type of GPA displayed. Valid values are Institution (courses completed at this institution), Transfer (courses completed at another institution and transferred for credit), or Overall (all courses completed).	VARCHAR2(1)	SHRLGPA	SHRLGPA_GPA_TYPE_IND
GPA_TYPE_DESC	GPA - Grade Point Average or Average Type Description	GPA type description.	VARCHAR2(11)	CALCULATION	DECODE(SHRLGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER','O','OVERALL')
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_GPA_IND	Official GPA - Grade Point Average or Average Indicator	Indicates whether the GPA information is official.	VARCHAR2(1)	NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRLGPA	SHRLGPA_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
QUALITY_POINTS	Quality Points	Student's cumulative quality points.	NUMBER	SHRLGPA	SHRLGPA_QUALITY_POINTS
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA