Reporting View Target: COMBINED_ACADEMIC

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Common Reporting View Reports

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

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD_GRADUATION Academic period when graduation requirements were completed. VARCHAR2(63)
SORDEGR

SORDEGR_TERM_DEGREE

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

SORDEGR_DEGC_YEAR

ACADEMIC_YEAR_GRADUATION_DESC Academic year description. VARCHAR2(255)
SORDEGR

SORDEGR_DEGC_YEAR

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

DECODE(SOKODSF.F_GET_SORMAJR_DATA)

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

SHRTRAM_ATTN_BEGIN_DATE
SORDEGR_ATTEND_FROM

ATTEND_TO_DATE Previous education last date of attendance. DATE
SHRTRAM
SORDEGR

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

STVCAMP_DESC

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

SORDEGR_COLL_CODE

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

STVCOLL_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)
SHRTRAM
SORDEGR

SHRTRAM_DEGC_CODE
SORDEGR_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
SORDEGR

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

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

SOKODSF.F_GET_SORCONC_DATA

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

SOKODSF.F_GET_SORCONC_DATA

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. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMINR_DATA

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

SORDEGR_GPA_TRANSFERRED

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

SORDEGR_HOURS_TRANSFERRED

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

DECODE(SORDEGR_HONR_CODE, NULL, 0, 1),

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)
SHRTRIT
SORDEGR
SORPCOL

SHRTRIT_SBGI_CODE
SORDEGR_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. VARCHAR2(1)
CONSTANT

N

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

SOKODSF.F_GET_SORMAJR_DATA

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

SOKODSF.F_GET_SORMAJR_DATA

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(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SHBDIPL_NAME

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

SORDEGR_DEGC_DATE

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 System generated, unique, internal identification number assigned to the person. NUMBER
SHRTRIT
SORDEGR
SORPCOL

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

SOKODSF.F_GET_SORMAJR_DATA

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

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

SOKODSF.F_GET_SORCONC_DATA

SECOND_CONCENTRATION_DESC Student's concentration description. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORCONC_DATA

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

STVDEPT_DESC

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

SOKODSF.F_GET_SORMAJR_DATA

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

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

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

STVMAJR_DESC

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

SOKODSF.F_GET_SORMAJR_DATA

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 Minor area of study description. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMINR_DATA

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 Program classification description. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

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

SOKODSF.F_GET_SORCONC_DATA

THIRD_CONCENTRATION_DESC Student's concentration description. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORCONC_DATA

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 Name of the student's major subject area. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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 Program classification description. VARCHAR2(255)
FUNCTION

SOKODSF.F_GET_SORMAJR_DATA

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

MSKFUNC.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)
CALCULATION

DECODE(SORDEGR_SBGI_CODE)

Ver: 8.1

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 DEGREE

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD_GRADUATION	Academic period when graduation requirements were completed.	VARCHAR2(63)	SORDEGR	SORDEGR_TERM_DEGREE
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)	SORDEGR	SORDEGR_DEGC_YEAR
ACADEMIC_YEAR_GRADUATION_DESC	Academic year description.	VARCHAR2(255)	SORDEGR	SORDEGR_DEGC_YEAR
ADDITIONAL_MAJORS_IND	Indicates whether there are additional majors or subject areas for this academic outcome.	VARCHAR2(63)	FUNCTION	DECODE(SOKODSF.F_GET_SORMAJR_DATA)
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	SHRTRAM SORDEGR	SHRTRAM_ATTN_BEGIN_DATE SORDEGR_ATTEND_FROM
ATTEND_TO_DATE	Previous education last date of attendance.	DATE	SHRTRAM SORDEGR	SHRTRAM_ATTN_END_DATE 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)	STVCAMP	STVCAMP_DESC
COLLEGE	College, faculty or school to which the academic study for the person is associated.	VARCHAR2(63)	SORDEGR	SORDEGR_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_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)	SHRTRAM SORDEGR	SHRTRAM_DEGC_CODE SORDEGR_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	SORDEGR	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)	STVDEPT	STVDEPT_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)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
FIRST_CONCENTRATION_DESC	Description of the first concentration on the major.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
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.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
GPA	Grade point average or average calculated for this academic outcome.	VARCHAR2(63)	SORDEGR	SORDEGR_GPA_TRANSFERRED
GPA_CREDITS	Sum of credits used in the GPA calculation for this student for this academic outcome.	NUMBER	SORDEGR	SORDEGR_HOURS_TRANSFERRED
HONORS_COUNT	Count of all honors recorded for the student.	NUMBER	FUNCTION	DECODE(SORDEGR_HONR_CODE, NULL, 0, 1),
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)	SHRTRIT SORDEGR SORPCOL	SHRTRIT_SBGI_CODE SORDEGR_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.	VARCHAR2(1)	CONSTANT	N
MAJOR	First subject area or major focus recorded for the student's curriculum. This may not be blank.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_DOCUMENT_NAME	Name of the person as it appears on the outcome document.	VARCHAR2(500)	SHBDIPL	SHBDIPL_NAME
OUTCOME_GRADUATION_DATE	Date for the formal completion or graduation in this academic outcome.	DATE	SORDEGR	SORDEGR_DEGC_DATE
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	System generated, unique, internal identification number assigned to the person.	NUMBER	SHRTRIT SORDEGR SORPCOL	SHRTRIT_PIDM SORDEGR_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	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_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)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
SECOND_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
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)	STVDEPT	STVDEPT_DESC
SECOND_MAJOR	Second subject area or major focus recorded for the student's curriculum. This may not be blank.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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)	STVMAJR	STVMAJR_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)	STVMAJR	STVMAJR_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)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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	Minor area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA
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	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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)	STVLEVL	STVLEVL_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)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
THIRD_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA
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	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
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	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA
TOTAL_TRANSFER_CREDITS	Number of transfer credits received from the previous post secondary institution.	NUMBER	FUNCTION	MSKFUNC.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)	CALCULATION	DECODE(SORDEGR_SBGI_CODE)