RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Student Reporting View Reports

SGHE Operational Data Store
Reporting View Target: ACADEMIC_OUTCOME

Description Contains data about all awards sought and/or earned by a student. Details includes 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
ACADEMIC_PERIOD Academic period or time frame associated with this outcome or degree record. VARCHAR2(63)

SHRDGMR

SHRDGMR_TERM_CODE_STUREC

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

ACADEMIC_PERIOD_GRAD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SHRDGMR_ACYR_CODE

ACADEMIC_YEAR_GRADUATION_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

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

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

BULLETIN_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS Campus associated to where the academic outcome requirements were completed. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_CAMP_CODE_2

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_COLL_CODE_1

SHRDGMR_COLL_CODE_2

SORLCUR_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

CURRICULUM_ORDER Unique sequence number that identifies this academic study or program for the student. NUMBER

FUNCTION

ROW_NUMBER

CURRICULUM_PRIORITY_NUMBER Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

DEGREE Degree or award code associated with the academic study. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_DEGC_CODE

SORLCUR_DEGC_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT Department responsible to verify that the academic outcome requirements have been completed. VARCHAR2(63)

SHRDGMR

SORLFOS

SHRDGMR_DEPT_CODE

SHRDGMR_DEPT_CODE_2

SORLFOS_DEPT_CODE

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

DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_CONC_1

SHRDGMR_MAJR_CODE_CONC_2

SORLFOS_MAJR_CODE

FIRST_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_MINR_1

SHRDGMR_MAJR_CODE_MINR_2

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

FOURTH_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

FOURTH_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FOURTH_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FOURTH_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FOURTH_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

GRADUATED_IND Indicates whether the person has graduated or earned any degrees or other awards as academic outcomes to date from this institution. VARCHAR2(1)

FUNCTION

CASE WHEN STVDEGS_AWARD_STATUS_IND = 'A' THEN 'Y' ELSE 'N' END

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

SHRDGMR

SHRDGMR_GRST_CODE

GRADUATION_STATUS_DESC Current graduation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SHRDGMR_AUTHORIZED

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

SHRDGMR

SHRDGMR_TERM_CODE_COMPLETED

GRAD_REQ_COMP_ACAD_PER_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

HONORS_COUNT Count of all honors recorded for the student. NUMBER

FUNCTION

MSKFUNC.F_COUNT_HONORS

ID Student's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_1

SHRDGMR_MAJR_CODE_2

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OFFICIAL_DOCUMENT_NAME Name of the person as it appears on the outcome document. VARCHAR2(255)

SHBDIPL

SHBDIPL_NAME

OUTCOME_APPLICATION_DATE Date that the student applied for graduation in this academic outcome. DATE

SHRDGMR

SHRDGMR_APPL_DATE

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

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

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

SHRDGMR

SHRDGMR_SEQ_NO

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

SHRDGMR

SHRDGMR_PIDM

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

NA

NA

PROGRAM Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_PROGRAM

SORLCUR_PROGRAM

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

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_CONC_1_2

SHRDGMR_MAJR_CODE_CONC_2_2

SORLFOS_MAJR_CODE

SECOND_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SORLFOS

SHRDGMR_DEPT_CODE_1_2

SHRDGMR_DEPT_CODE_2_2

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_1_2

SHRDGMR_MAJR_CODE_2_2

SORLFOS_MAJR_CODE

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)

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_CONC_121

SHRDGMR_MAJR_CODE_CONC_221

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_CONC_122

SHRDGMR_MAJR_CODE_CONC_222

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_CONC_123

SHRDGMR_MAJR_CODE_CONC_223

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_MINR_1_2

SHRDGMR_MAJR_CODE_MINR_2_2

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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 reproting outcomes to the federal government. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SHRDGMR_DEGS_CODE

STATUS_DESC Outcome or award status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_LEVEL Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_LEVL_CODE

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SUB_ACADEMIC_PERIOD_GRAD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_CONC_1_3

SHRDGMR_MAJR_CODE_CONC_2_3

SORLFOS_MAJR_CODE

THIRD_CONCENTRATION_DESC Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

THIRD_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

THIRD_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

THIRD_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

THIRD_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

THIRD_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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



Ver: 3.1