Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner Operational Data Store
Composite View Target: AS_GPA_LEVEL

Description Source composite view contains student's GPA values as stored by type (institutional, transfer or overall) cumulative for all courses by each student level at which the student attended courses and received grades or transfered course work.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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(0)

NA

NA

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(0)

NA

NA

NO

NO
ACADEMIC_STUDY_AREA This field displays the type of academic study area the GPA is being maintained for. Such as Level, College, Major, etc. VARCHAR2(30)

CONSTANT

'LEVEL'

NO

NO
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(2)

SHRLGPA

SHRLGPA_LEVL_CODE

NO

NO
ACADEMIC_STUDY_VALUE_DESC Student level description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(0)

NA

NA

NO

NO
ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(0)

NA

NA

NO

NO
CLASS_RANK Student's institutional class rank. NUMBER

NA

NA

NO

NO
CLASS_SIZE Student's institutional class size. NUMBER

NA

NA

NO

NO
COMPUTATION_DATE Date the GPA was calculated. DATE

SHRLGPA

SHRLGPA_ACTIVITY_DATE

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

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

SHRLGPA

SHRLGPA_GPA

NO

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

SHRLGPA

SHRLGPA_GPA_HOURS

NO

NO
GPA_GROUPING This field specifies if 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 associated time period. VARCHAR2(6)

CONSTANT

'C'

NO

NO
GPA_GROUPING_DESC This field specifies the description of the GPA grouping. VARCHAR2(30)

CONSTANT

'CUMULATIVE VALUES'

NO

NO
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(1)

CONSTANT

'N'

NO

NO
GPA_TIME_IND_DESC This field specifies the description of the time period associated with the GPA information. VARCHAR2(30)

CONSTANT

'NON-TIME BASED'

NO

NO
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

SHRLGPA_GPA_TYPE_IND

NO

NO
GPA_TYPE_DESC GPA type description. VARCHAR2(11)

CALCULATION

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

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
OFFICIAL_GPA_IND Indicators which specifies whether the gpa info is official. VARCHAR2(1)

NA

NA

NO

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

SHRLGPA

SHRLGPA_PIDM

NO

NO
QUALITY_POINTS Student's cumulative quality points. NUMBER

SHRLGPA

SHRLGPA_QUALITY_POINTS

NO

NO
SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(0)

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(0)

NA

NA

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: