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

Banner Operational Data Store
Reporting View Target: COMBINED_ACADEMIC_OUTCOME

Description Contains an overall list of all the degrees, awards, certificates, etc for the person as awarded by this institution or through an external institution educational experience. These academic outcomes will not be duplicated for the person, institution, degree and major or program recorded on the individual records.
Key & Frequency Multiple rows per person per outcome_number.
Recommended Search Columns PERSON_UID, OUTCOME_NUMBER
STUDENT_LEVEL
ACADEMIC_PERIOD_GRADUATION
PROGRAM, MAJOR, PERSON_UID
COLLEGE, DEPARTMENT, PERSON_UID
PERSON_UID, INSTITUTION
PERSON_UID, INSTITUTION, DEGREE
DEGREE, PERSON_UID

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD_GRADUATION Academic Period Graduation Academic period when graduation requirements were completed. VARCHAR2(63)

SORDEGR

SORDEGR_TERM_DEGREE

ACADEMIC_PERIOD_GRAD_DESC Academic Period Graduate Description Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_GRADUATION Academic Year Graduation Academic year associated with this graduation date. VARCHAR2(63)

SORDEGR

SORDEGR_DEGC_YEAR

ACADEMIC_YEAR_GRADUATION_DESC Academic Year Graduation Description Academic year description. VARCHAR2(255)

SORDEGR

SORDEGR_DEGC_YEAR

ADDITIONAL_MAJORS_IND Additional Majors Indicator Indicates whether there are additional majors or subject areas for this academic outcome. VARCHAR2(63)

FUNCTION

DECODE(SOKODSF.F_GET_SORMAJR_DATA)

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

NA

NA

ATTEND_FROM_DATE Attend From Date Previous education first date of attendance. DATE

SHRTRAM

SORDEGR

SHRTRAM_ATTN_BEGIN_DATE

SORDEGR_ATTEND_FROM

ATTEND_TO_DATE Attend To Date Previous education last date of attendance. DATE

SHRTRAM

SORDEGR

SHRTRAM_ATTN_END_DATE

SORDEGR_ATTEND_TO

AWARD_CATEGORY Award Category Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc. VARCHAR2(63)

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award Category Description Award category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS Campus Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Campus Description Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

COLLEGE College First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

SORDEGR

SORDEGR_COLL_CODE

COLLEGE_DESC College Description College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

CREDITS_EARNED Credits Earned Sum of credits earned by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

DEGREE Degree Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme. VARCHAR2(63)

SHRTRAM

SORDEGR

SHRTRAM_DEGC_CODE

SORDEGR_DEGC_CODE

DEGREE_COMMENT Degree Comment Free form text comments about this degree. VARCHAR2(2000)

APRADEG

APRADEG_COMMENTS

DEGREE_DATE Degree Date Date the degree was awarded to the person. DATE

SORDEGR

SORDEGR_DEGC_DATE

DEGREE_DESC Degree Description Description (for example, bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT Department Department responsible for the major subject area of a student course or associated with the major within the student academic study. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department Description Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

DEPARTMENT_HONORS_COUNT Department Honors Count Count of all honors recorded for the student. Indicates the honor was approved by the department. NUMBER

CALCULATION

FUNCTION

DECODE(APRADEG_HOND_CODE_1)

MSKFUNC.F_COUNT_HONORS

FIRST_CONCENTRATION First Concentration First concentration or focus of study within this student's major. This may be blank when concentrations are not being used, or when the major does not have a concentration. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

FIRST_CONCENTRATION_DESC First Concentration Description Description of the first concentration on the major. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

FIRST_MINOR First Minor Minor for the student within the academic study. This may be blank if no minor was specified. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

FIRST_MINOR_DESC First Minor Description First minor description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

GPA Average or Grade Point Average Grade point average or average calculated for this academic outcome. VARCHAR2(63)

SORDEGR

SORDEGR_GPA_TRANSFERRED

GPA_CREDITS Credits used in Grade Point Average or Average Sum of credits used in the GPA calculation for this student for this academic outcome. NUMBER

SORDEGR

SORDEGR_HOURS_TRANSFERRED

HONORS_COUNT Honors Count Count of all honors recorded for the student. NUMBER

FUNCTION

DECODE(SORDEGR_HONR_CODE, NULL, 0, 1),

ID 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

INSTITUTION Institution Institution at which the constituent earned the degree. VARCHAR2(63)

SHRTRIT

SORDEGR

SORPCOL

SHRTRIT_SBGI_CODE

SORDEGR_SBGI_CODE

SORPCOL_SBGI_CODE

INSTITUTIONAL_HONORS_COUNT Institutional Honors Count Count of all honors recorded for the student. Indicate that the honor was approved at the institution level, including honors such as Cum Laude, Summa Cum Laude, First Class, etc. NUMBER

CALCULATION

FUNCTION

DECODE(APRADEG_HONR_CODE)

MSKFUNC.F_COUNT_HONORS

INSTITUTION_CREDITS_ATTEMPTED Institution Credits Attempted Sum of institution course credits attempted by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_CREDITS_EARNED Institution Credits Earned Sum of institution course credits earned by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_CREDITS_PASSED Institution Credits Passed Sum of institution course credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_DESC Institution Description Name of the Institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INSTITUTION_GPA Institution GPA - Grade Point Average or Average Calculated of institution course grade point average or average for the set of courses completed. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_GPA_CREDITS Institution GPA - Grade Point Average or Average Credits Sum of institution course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_QUALITY_POINTS Institution Quality Points Sum of institution course quality points used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_TYPE Institution Type Identifies a type for the source/background institution to be used for reporting. VARCHAR2(1)

STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC Institution Type Description Type of institution description. VARCHAR2(255)

CONSTANT

COLLEGE

INTERNAL_ACADEMIC_OUTCOME_IND Internal Academic Outcome Indicator Indicates whether the award, degree, academic outcome was completed at a different institution as identified by the institution noted for this record. This will be set to Y when the award is from this institution and to an N when this is an external award. VARCHAR2(1)

CONSTANT

N

MAJOR Major Major subject area of the person's academic study. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

MAJOR_DESC Major Description Name of the student's major subject area. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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 for the record when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Person's name combining the last name, first name middle initial. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OFFICIAL_DOCUMENT_NAME Official Document Name Name of the person as it appears on the outcome document. VARCHAR2(500)

SHBDIPL

SHBDIPL_NAME

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

SORDEGR

SORDEGR_DEGC_DATE

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

SHRTRAM

SORDEGR

SHRTRAM_SEQ_NO

SORDEGR_DEGR_SEQ_NO

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

SHRTRIT

SORDEGR

SORPCOL

SHRTRIT_PIDM

SORDEGR_PIDM

SORPCOL_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

PROGRAM Program Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)

SORLCUR

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Program Classification Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC Program Classification Description Program classification description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_DESC Program Description Program or course of study description. VARCHAR2(255)

SMRPRLE

SMRPRLE_PROGRAM_DESC

QUALITY_POINTS Quality Points Sum of the quality points used to calculate the grade point average for this outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

SECOND_CONCENTRATION Second Concentration Second concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

SECOND_CONCENTRATION_DESC Second Concentration Description Student's concentration description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

SECOND_DEPARTMENT Second Department Department responsible for the second major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Second Department Description Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

SECOND_MAJOR Second Major Major subject area of the person's academic study. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

SECOND_MAJOR_CONC_1 Second Major Concentration 1 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Second Major Concentration 1 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_2 Second Major Concentration 2 Second concentration or focus of study within this student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_3 Second Major Concentration 3 Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_DESC Second Major Description Name of the student's major subject area. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

SECOND_MINOR Second Minor Second minor for the student within this academic study. This may be blank if no minor was specified. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

SECOND_MINOR_DESC Second Minor Description Minor area of study description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMINR_DATA

SECOND_PROGRAM_CLASSIFICATION Second Program Classification Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

SECOND_PROGRAM_CLASSIF_DESC Second Program Classif Description Program classification description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

STUDENT_LEVEL Student Level Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student Level Description Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

SUB_ACADEMIC_PERIOD_GRAD Sub Academic Period Graduate Graduation date within this sub academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_GRAD_DESC Sub Academic Period Graduate Description Sub academic period description. VARCHAR2(255)

NA

NA

THIRD_CONCENTRATION Third Concentration Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

THIRD_CONCENTRATION_DESC Third Concentration Description Student's concentration description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORCONC_DATA

THIRD_MAJOR Third Major Third subject area or major focus recorded for the student's curriculum. This may not be blank. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

THIRD_MAJOR_DESC Third Major Description Name of the student's major subject area. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

THIRD_PROGRAM_CLASSIFICATION Third Program Classification Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

THIRD_PROGRAM_CLASSIF_DESC Third Program Classif Description Program classification description. VARCHAR2(255)

FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

TOTAL_TRANSFER_CREDITS Total Transfer Credits Number of transfer credits received from the previous post secondary institution. NUMBER

FUNCTION

MSKFUNC.F_CALC_TRANSFER_CREDITS

TRANSFER_CREDITS_ATTEMPTED Transfer Credits Attempted Sum of transfer course credits attempted by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_CREDITS_EARNED Transfer Credits Earned Sum of transfer course credits earned by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_GPA Transfer GPA - Grade Point Average or Average Calculated of transfer course grade point average or average for the set of courses completed. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_GPA_CREDITS Transfer GPA - Grade Point Average or Average Credits Sum of transfer course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_QUALITY_POINTS 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

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

CALCULATION

DECODE(SORDEGR_SBGI_CODE)



Ver: 9.2