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

Banner Operational Data Store
Composite View Target: AS_ACADEMIC_OUTCOME

Description Source composite view contains information associated with each academic outcome tracked by the institution. Information is displayed as one row per outcome award, degree or certificate, etc.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACADEMIC_PERIOD_GRADUATION Academic period when all graduation requirements were completed or will be completed. VARCHAR2(6)

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

NO

NO
ACADEMIC_PERIOD_GRAD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
ACADEMIC_YEAR_GRADUATION Academic year associated with this graduation date. VARCHAR2(4)

SHRDGMR

SHRDGMR_ACYR_CODE

NO

NO
ACADEMIC_YEAR_GRADUATION_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
APPLIED_FOR_OUTCOME_IND Indicates whether the person has applied to official receive the degree or award for this academic outcome. VARCHAR2(1)

FUNCTION

F_APPLIED_FOR_DEGREE

NO

NO
BULLETIN_YEAR Academic year associated with the requirements completed for this graduation. VARCHAR2(4)

SHRDGMR

SHRDGMR_ACYR_CODE_BULLETIN

NO

NO
BULLETIN_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
CATEGORY Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards. VARCHAR2(2)

STVDEGC

STVDEGC_ACAT_CODE

NO

NO
CATEGORY_DESC Award category description. VARCHAR2(30)

STVACAT

STVACAT_DESC

NO

NO
CREDITS_ATTEMPTED Sum of credits attempted by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
CREDITS_PASSED Sum of credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
GPA_CREDITS Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
GRADUATED_IND Indicates whether the person has graduated or earned any academic outcomes to date. VARCHAR2(1)

FUNCTION

DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y','N')

NO

NO
GRADUATION_STATUS Graduation status indicates when an academic outcome has been completed. VARCHAR2(3)

SHRDGMR

SHRDGMR_GRST_CODE

NO

NO
GRADUATION_STATUS_DESC Current graduation status description. VARCHAR2(30)

STVGRST

STVGRST_DESC

NO

NO
GRAD_AUTHORIZED_ADDS_CHGS Indicates if the student is authorized to add or drop based on graduation requirements. VARCHAR2(33)

SHRDGMR

SHRDGMR_AUTHORIZED

NO

NO
GRAD_REQ_COMPLETED_APRD Academic period when all graduation requirements were completed or will be completed. VARCHAR2(6)

SHRDGMR

SHRDGMR_TERM_CODE_COMPLETED

NO

NO
GRAD_REQ_COMPLETED_APRD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
INSTIITUTION_CREDITS_ATTEMPTED Sum of institution course credits attempted by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
INSTIITUTION_CREDITS_EARNED Sum of institution course credits earned by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
INSTIITUTION_CREDITS_PASSED Sum of institution course credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
INSTIITUTION_GPA Calculated of institution course grade point average or average for the set of courses completed. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
INSTIITUTION_GPA_CREDITS Sum of institution course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
INSTIITUTION_QUALITY_POINTS Sum of institution course quality points used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
INSTITUTION_CREDITS_ATTEMPTED   NUMBER       NO
INSTITUTION_CREDITS_EARNED   NUMBER       NO
INSTITUTION_CREDITS_PASSED   NUMBER       NO
INSTITUTION_GPA   NUMBER       NO
INSTITUTION_GPA_CREDITS   NUMBER       NO
INSTITUTION_QUALITY_POINTS   NUMBER       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_DOCUMENT_NAME Name of the person as it appears on the outcome document. VARCHAR2(500)

SHBDIPL

SHBDIPL_NAME

NO

NO
OUTCOME_APPLICATION_DATE Date applied for graduation and completion of this academic outcome. DATE

SHRDGMR

SHRDGMR_APPL_DATE

NO

NO
OUTCOME_AWARDED_IND Indicates when a outcome is awarded, pending or sought per the rules of the institution. VARCHAR2(1)

STVDEGS

STVDEGS_AWARD_STATUS_IND

NO

NO
OUTCOME_GRADUATION_DATE Date for the formal completion or graduation in this academic outcome. DATE

SHRDGMR

SHRDGMR_GRAD_DATE

NO

NO
OUTCOME_NUMBER Degree or award sequence number for this academic outcome for the student. NUMBER

SHRDGMR

SHRDGMR_SEQ_NO

NO

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

SHRDGMR

SHRDGMR_PIDM

NO

NO
QUALITY_POINTS Quality points used to calculate grade point average for this outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
STATUS Identifies the current status of the academic outcome. May be pending, awarded, etc. VARCHAR2(2)

SHRDGMR

SHRDGMR_DEGS_CODE

NO

NO
STATUS_DESC Description for the outcome or award status. VARCHAR2(30)

STVDEGS

STVDEGS_DESC

NO

NO
STUDENT_TERM Academic period or time frame associated with this outcome or degree record. VARCHAR2(6)

SHRDGMR

SHRDGMR_TERM_CODE_STUREC

NO

NO
STUDENT_TERM_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
SUB_ACADEMIC_PERIOD_GRADUATION Graduation sub academic year. VARCHAR2(3)

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_GRAD_DESC Graduation sub academic year description. VARCHAR2(30)

NA

NA

NO

NO
TRANSFER_CREDITS_ATTEMPTED Sum of transfer course credits attempted by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
TRANSFER_CREDITS_EARNED Sum of transfer course credits earned by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
TRANSFER_CREDITS_PASSED Sum of transfer course credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
TRANSFER_GPA Calculated of transfer course grade point average or average for the set of courses completed. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
TRANSFER_GPA_CREDITS Sum of transfer course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
TRANSFER_QUALITY_POINTS Sum of transfer course quality points used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
TRANSFER_WORK_EXISTS_IND Indicates whether any transfer credits are recorded for the student that apply to this academic outcome. VARCHAR2(1)

FUNCTION

F_CHECK_FOR_TRANSFER_WORK

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: