RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE 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 One row 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
DEGREE

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD_GRADUATION Academic period when graduation requirements were 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)

APRADEG

SHRDGMR

SORDEGR

APRADEG_ACYR_CODE

SHRDGMR_TERM_CODE_GRAD

SORDEGR_DEGC_YEAR

ACADEMIC_YEAR_GRADUATION_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

AOKODSF.F_CHECK_FOR_MORE_MAJORS

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

NA

NA

ATTEND_FROM_DATE Previous education first date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_FROM

ATTEND_TO_DATE Previous education last date of attendance. DATE

SORDEGR

SORDEGR_ATTEND_TO

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

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

SORLCUR

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 person is associated. VARCHAR2(63)

SORLCUR

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 Sum of credits earned by a student for this academic outcome. 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

DEGREE Specified degree, award or certificate are tied to this academic outcome. VARCHAR2(63)

SORLCUR

SORLCUR_DEGC_CODE

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

APRADEG

APRADEG_COMMENTS

DEGREE_DATE Date the degree was awarded to the person. DATE

APRADEG

SHRDGMR

SORDEGR

APRADEG_DATE

SHRDGMR_GRAD_DATE

SORDEGR_DEGC_DATE

DEGREE_DESC 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 responsible for verifying that academic outcome requirements are completed. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC First minor description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SORDEGR

SOKODSF.F_GET_DEGREE_GPA_DATA

SORDEGR_GPA_TRANSFERRED

GPA_CREDITS Sum of credits used in the GPA calculation for this student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

HONORS_COUNT Count of all honors recorded for the student. NUMBER

CALCULATION

FUNCTION

DECODE(APRADEG_HOND_CODE_1)

DECODE(SORDEGR_HONR_CODE)

MSKFUNC.F_COUNT_HONORS

ID Person's identification number used to access the records associated with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

APRADEG

SORPCOL

APRADEG_SBGI_CODE

SORPCOL_SBGI_CODE

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_DESC Name of the Institution. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVSBGI

STVSBGI_TYPE_IND

INSTITUTION_TYPE_DESC Type of institution description. VARCHAR2(255)

CONSTANT

'COLLEGE'

INTERNAL_ACADEMIC_OUTCOME_IND 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. CHAR(1)

CONSTANT

'N'

'Y'

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

SORLFOS

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 Person's name combining the last name, first name middle initial. 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_GRADUATION_DATE Date for the formal completion or graduation in this academic outcome. DATE

SHRDGMR

SHRDGMR_GRAD_DATE

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

APRADEG

SHRDGMR

APRADEG_SEQ_NO

SHRDGMR_SEQ_NO

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

APRADEG

SHRDGMR

SORPCOL

APRADEG_PIDM

SHRDGMR_PIDM

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

SORLCUR

SORLCUR_PROGRAM

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

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

SORLFOS

SORLFOS_MAJR_CODE

SECOND_CONCENTRATION_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

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 if the major does not have a concentration. VARCHAR2(63)

SORLFOS

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 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 Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_CONC_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 Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Minor 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 Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_LEVEL Student level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc. VARCHAR2(63)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SUB_ACADEMIC_PERIOD_GRAD Graduation date within this sub academic period VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_GRAD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

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)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_CONCENTRATION_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

GOKODSF.F_GET_DESC

THIRD_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SOKODSF.F_CALC_TRANSFER_CREDITS

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