RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Operational Data Store
Reporting View Target: GPA

Description Contains detail data for any type of student grade point average (GPA) or Average. Details include all the data required to calculate different types of GPAs. The current data loaded includes only overall level (undergraduate, graduate), academic period GPA information.
Key & Frequency One row per person per GPA time indicator (time based or not) per GPA group (cummulative or period) per academic study area (level) per GPA type (institution or transfer) per academic period.
Recommended Search Columns PERSON_UID, ACADEMIC_STUDY_VALUE, GPA_TIME_IND, ACADEMIC_PERIOD, GPA_GROUPING, GPA_TYPE
PERSON_UID, ACADEMIC_STUDY_VALUE, ACADEMIC_PERIOD, GPA_TYPE
GPA_TIME_IND, GPA_GROUPING, ACADEMIC_STUDY_AREA, ACADEMIC_STUDY_VALUE

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with the average or GPA information recorded. VARCHAR2(63)

SHRTGPA

SHRTGPA_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_STUDY_AREA Type of academic study area the GPA is being maintained for, such as level, college, major, etc. VARCHAR2(255)

CONSTANT

'LEVEL'

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

SHRTGPA

SHRLGPA_LEVL_CODE

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 Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

SHRLGPA

SHRLGPA_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

SHRLGPA

SHRTGPA

SHRLGPA_HOURS_ATTEMPTED

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

SHRLGPA

SHRTGPA

SHRLGPA_HOURS_EARNED

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

SHRLGPA

SHRTGPA

SHRLGPA_HOURS_PASSED

SHRTGPA_HOURS_PASSED

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

SHREGPA

SHRGPAC

SHRGPAL

SHRLGPA

SHRTGPA

SHREGPA_GPA_I

SHRGPAC_GPA

SHRGPAL_GPA

SHRLGPA_GPA

SHRTGPA_GPA

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

SHRLGPA

SHRTGPA

SHRLGPA_GPA_HOURS

SHRTGPA_GPA_HOURS

GPA_GROUPING Specifies whether the GPA information is displayed for the specified academic period, or if it is cumulative up to and including the current time period associated with this record. Valid values are C for cumulative and P for associated time period. VARCHAR2(255)

CONSTANT

'C'

'P'

GPA_GROUPING_DESC GPA grouping description. VARCHAR2(255)

CONSTANT

'CUMULATIVE VALUES'

'PERIOD BASED VALUES'

GPA_TIME_IND Time period associated with the GPA information. Valid values identify academic year, academic period, sub academic period, and not time based. VARCHAR2(255)

CONSTANT

'N'

'P'

GPA_TIME_IND_DESC GPA time period description. VARCHAR2(255)

CONSTANT

'NON-TIME BASED'

'PERIOD'

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)

SHRLGPA

SHRTGPA

SHRLGPA_GPA_TYPE_IND

SHRTGPA_GPA_TYPE_IND

GPA_TYPE_DESC GPA type description. VARCHAR2(11)

CALCULATION

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

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

ID Person's or organization's current identification number. 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(94)

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

SHRLGPA

SHRTGPA

SHRLGPA_PIDM

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

SHRLGPA

SHRTGPA

SHRLGPA_QUALITY_POINTS

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: 3.1