Reporting View Target: GPA_BY

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	(Banner EDW Source Report)
	Student Reporting View Reports

Banner Operational Data Store
Reporting View Target: GPA_BY_TERM

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

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)
SHRTGPA

SHRTGPA_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

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)
SHRTGPA

SHRTGPA_LEVL_CODE

ACADEMIC_STUDY_VALUE_DESC Student level description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

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

NA

AID_ENROLLMENT_PERIOD Aid enrollment period associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)
FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_ENROLLMENT_PERIOD_DESC Aid enrollment period description. VARCHAR2(255)
FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)
FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)
FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

CLASS_RANK Student's institutional class rank. NUMBER
NA

NA

CLASS_SIZE Student's institutional class size. NUMBER
NA

NA

COMPUTATION_DATE Date the GPA was calculated. DATE
SHRTGPA

SHRTGPA_ACTIVITY_DATE

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
SHRTGPA

SHRTGPA_HOURS_ATTEMPTED

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
SHRTGPA

SHRTGPA_HOURS_EARNED

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
SHRTGPA

SHRTGPA_HOURS_PASSED

GPA Calculated grade point average or average for a set of courses completed. NUMBER
SHRTGPA

SHRTGPA_GPA

GPA_CREDITS Credits used to calculate the average or grade point average for the courses completed by the person. NUMBER
SHRTGPA

SHRTGPA_GPA_HOURS

GPA_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)
SHRTGPA

SHRTGPA_GPA_TYPE_IND

GPA_TYPE_DESC GPA type description. VARCHAR2(11)
CALCULATION

DECODE(SHRTGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER')

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

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

NA

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

MGKFUNC.F_GET_PERSON_INFO

OFFICIAL_GPA_IND Indicates whether the GPA information is official. VARCHAR2(1)
NA

NA

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER
SHRTGPA

SHRTGPA_PIDM

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

NA

QUALITY_POINTS Student's cumulative quality points. NUMBER
SHRTGPA

SHRTGPA_QUALITY_POINTS

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

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)
NA

NA

Ver: 9.1

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

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	SHRTGPA	SHRTGPA_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
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)	SHRTGPA	SHRTGPA_LEVL_CODE
ACADEMIC_STUDY_VALUE_DESC	Student level description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_ENROLLMENT_PERIOD	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
AID_ENROLLMENT_PERIOD_DESC	Aid enrollment period description.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_AID_ENROLL_PERIOD
CLASS_RANK	Student's institutional class rank.	NUMBER	NA	NA
CLASS_SIZE	Student's institutional class size.	NUMBER	NA	NA
COMPUTATION_DATE	Date the GPA was calculated.	DATE	SHRTGPA	SHRTGPA_ACTIVITY_DATE
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	SHRTGPA	SHRTGPA_HOURS_ATTEMPTED
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	SHRTGPA	SHRTGPA_HOURS_EARNED
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	SHRTGPA	SHRTGPA_HOURS_PASSED
GPA	Calculated grade point average or average for a set of courses completed.	NUMBER	SHRTGPA	SHRTGPA_GPA
GPA_CREDITS	Credits used to calculate the average or grade point average for the courses completed by the person.	NUMBER	SHRTGPA	SHRTGPA_GPA_HOURS
GPA_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)	SHRTGPA	SHRTGPA_GPA_TYPE_IND
GPA_TYPE_DESC	GPA type description.	VARCHAR2(11)	CALCULATION	DECODE(SHRTGPA_GPA_TYPE_IND,'I','INSTITUTION','T','TRANSFER')
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_GPA_IND	Indicates whether the GPA information is official.	VARCHAR2(1)	NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRTGPA	SHRTGPA_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
QUALITY_POINTS	Student's cumulative quality points.	NUMBER	SHRTGPA	SHRTGPA_QUALITY_POINTS
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA