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

Banner Operational Data Store
Reporting View Target: ACADEMIC_OUTCOME

Description Contains data about all awards sought and/or earned by a student. Details include program of academic study, majors, degree GPA, total credits earned, institutional and departmental honors, etc. The GOVERNMENT_ACADEMIC_OUTCOME reporting view may be used to report on only those outcomes that were awarded.
Key & Frequency One row per person per outcome number.
Recommended Search Columns PERSON_UID, OUTCOME_NUMBER
STATUS, STUDENT_LEVEL
ACADEMIC_PERIOD_GRADUATION
PROGRAM, MAJOR, PERSON_UID
COLLEGE, DEPARTMENT, PERSON_UID

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(63)

SHRDGMR

SHRDGMR_TERM_CODE_STUREC

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ACADEMIC_PERIOD_GRADUATION Academic period when graduation requirements were or will be completed. VARCHAR2(63)

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

NO

NO
ACADEMIC_PERIOD_GRAD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

NO

NO
ACADEMIC_YEAR_GRADUATION Year associated with this graduation date. VARCHAR2(63)

SHRDGMR

SHRDGMR_ACYR_CODE

NO

NO
ACADEMIC_YEAR_GRADUATION_DESC Graduation year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

NO

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

NA

NA

NO

NO
APPLIED_FOR_OUTCOME_IND Indicates whether the person has applied to officially receive this specific degree or award as an academic outcome. VARCHAR2(1)

FUNCTION

F_APPLIED_FOR_DEGREE

NO

NO
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

NO

NO
AWARD_CATEGORY_DESC Award category description. VARCHAR2(255)

STVACAT

STVACAT_DESC

NO

NO
BULLETIN_YEAR Academic year associated with the documented requirements to be completed for this academic outcome to be confirmed. VARCHAR2(63)

SHRDGMR

SHRDGMR_ACYR_CODE_BULLETIN

NO

NO
BULLETIN_YEAR_DESC Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

NO

NO
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

NO

NO
CAMPUS_DESC Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

NO

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

SORLCUR

SORLCUR_COLL_CODE

NO

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

STVCOLL

STVCOLL_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
CURRICULUM_ORDER Unique sequence number that identifies this academic study or program for the student. NUMBER

CALCULATION

ROW_NUMBER

NO

NO
CURRICULUM_PRIORITY_NUMBER Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

NO

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

SORLCUR

SORLCUR_DEGC_CODE

NO

NO
DEGREE_DESC Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

NO

NO
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

NO

NO
DEPARTMENTAL_HONORS_COUNT Count of all honors recorded for the student. Indicates the honor was approved by the department. NUMBER

FUNCTION

MSKFUNC.F_COUNT_HONORS

NO

NO
DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

NO
FIRST_CONCENTRATION Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FIRST_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
FIRST_MINOR Minor subject area of the person's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FIRST_MINOR_DESC Minor subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_DEPARTMENT Department responsible for this major subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

NO

NO
FOURTH_DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

NO
FOURTH_MAJOR Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

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

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MAJOR_CONC_2 Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MAJOR_CONC_3 Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MAJOR_DESC Major or subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MINOR Fourth minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MINOR_DESC Minor area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

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

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
FOURTH_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

NO

NO
GPA Calculated grade point average or average for the 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 earned this degree or other award from the institution. VARCHAR2(1)

FUNCTION

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

NO

NO
GRADUATION_STATUS Identifies that an academic outcome is completed or still being sought, etc. VARCHAR2(3)

SHRDGMR

SHRDGMR_GRST_CODE

NO

NO
GRADUATION_STATUS_DESC Current graduation status description. VARCHAR2(255)

STVGRST

STVGRST_DESC

NO

NO
GRAD_AUTHORIZED_ADDS_CHGS Identifies that the student is authorized to add or drop based on graduation requirements. VARCHAR2(63)

SHRDGMR

SHRDGMR_AUTHORIZED

NO

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

SHRDGMR

SHRDGMR_TERM_CODE_COMPLETED

NO

NO
GRAD_REQ_COMP_ACAD_PER_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

MSKFUNC.F_COUNT_HONORS

NO

NO
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

NO

NO
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

FUNCTION

MSKFUNC.F_COUNT_HONORS

NO

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
INSTITUTION_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
INSTITUTION_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
INSTITUTION_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
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

NO

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

SORLFOS

SORLFOS_MAJR_CODE

NO

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

STVMAJR

STVMAJR_DESC

NO

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

NA

NA

NO

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

NA

NA

NO

NO
NAME Name of the student (Last name, First name Middle Initial format). VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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 that the student applied for graduation in this academic outcome. DATE

SHRDGMR

SHRDGMR_APPL_DATE

NO

NO
OUTCOME_AWARDED_IND Identifies whether the academic outcome, award or degree has been officially awarded to the person. VARCHAR2(1)

STVDEGS

STVDEGS_AWARD_STATUS_IND

NO

NO
OUTCOME_GRADUATION_DATE Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed. DATE

SHRDGMR

SHRDGMR_GRAD_DATE

NO

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

NA

SHRDGMR

SOKODSF.F_COUNT_COMPLETED_OUTCOMES

SHRDGMR_SEQ_NO

NO

NO

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

SHRDGMR

SHRDGMR_PIDM

NO

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

NA

NA

NO

NO
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

NO

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

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

NO

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

SMRPRLE

SMRPRLE_PROGRAM_DESC

NO

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

NO

NO
SECOND_CONCENTRATION Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

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

SORLFOS

SORLFOS_DEPT_CODE

NO

NO
SECOND_DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

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

SORLFOS

SORLFOS_MAJR_CODE

NO

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

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_CONC_2 Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_CONC_3 Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_DESC Major or subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MINOR Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MINOR_DESC Minor subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

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

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
SECOND_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

NO

NO
STATUS Current status of the academic outcome. For example, pending, awarded, etc. VARCHAR2(63)

SHRDGMR

SHRDGMR_DEGS_CODE

NO

NO
STATUS_DESC Outcome or award status description. VARCHAR2(255)

STVDEGS

STVDEGS_DESC

NO

NO
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

NO

NO
STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

NO

NO
SUB_ACADEMIC_PERIOD_GRADUATION Graduation sub academic period or portion of the academic period when recorded for the student's completion. VARCHAR2(63)

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_GRAD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

NO

NO
THIRD_CONCENTRATION Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_DEPARTMENT Department responsible for the major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

NO

NO
THIRD_DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

NO
THIRD_MAJOR Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

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

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MAJOR_CONC_2 Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MAJOR_CONC_3 Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MAJOR_DESC Major or subject area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MINOR Third minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MINOR_DESC Minor area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

NO

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

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
THIRD_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

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


Ver: 9.2