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

SGHE Banner Operational Data Store
Reporting View Target: ACADEMIC_OUTCOME_SLOT

Description Uses data from the ACADEMIC_OUTCOME reporting view. Displays up to 3 sets of values based on the student level. Currently, there are no associated display rules so the three most recent academic outcomes will be displayed.
Key & Frequency One row per person per student level.
Recommended Search Columns PERSON_UID, STUDENT_LEVEL
ACTIVITY_DATE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD_GRAD_1 Academic Period Graduate Degree 1 Academic period when all graduation requirements were completed or will be completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

ACADEMIC_PERIOD_GRAD_2 Academic Period Graduate Degree 2 Academic period when all graduation requirements were completed or will be completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

ACADEMIC_PERIOD_GRAD_3 Academic Period Graduate Degree 3 Academic period when all graduation requirements were completed or will be completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

ACADEMIC_PERIOD_GRAD_DESC_1 Academic Period Graduate Degree 1 Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_PERIOD_GRAD_DESC_2 Academic Period Graduate Degree 2 Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_PERIOD_GRAD_DESC_3 Academic Period Graduate Degree 3 Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_GRAD_1 Academic Year Graduate Degree 1 Academic year associated with this graduation date. VARCHAR2(63)  

SHRDGMR

SHRDGMR_ACYR_CODE

ACADEMIC_YEAR_GRAD_2 Academic Year Graduate Degree 2 Academic year associated with this graduation date. VARCHAR2(63)  

SHRDGMR

SHRDGMR_ACYR_CODE

ACADEMIC_YEAR_GRAD_3 Academic Year Graduate Degree 3 Academic year associated with this graduation date. VARCHAR2(63)  

SHRDGMR

SHRDGMR_ACYR_CODE

ACADEMIC_YEAR_GRAD_DESC_1 Academic Year Graduate Degree 1 Description Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_GRAD_DESC_2 Academic Year Graduate Degree 2 Description Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_GRAD_DESC_3 Academic Year Graduate Degree 3 Description Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DATE Activity Date Date record was inserted or updated DATE  

NA

SYSDATE

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

NA

NA

APPLICATION_DATE_1 Degree 1 Application Date Date applied for graduation and completion of this academic outcome. DATE  

SHRDGMR

SHRDGMR_APPL_DATE

APPLICATION_DATE_2 Degree 2 Application Date Date applied for graduation and completion of this academic outcome. DATE  

SHRDGMR

SHRDGMR_APPL_DATE

APPLICATION_DATE_3 Degree 3 Application Date Date applied for graduation and completion of this academic outcome. DATE  

SHRDGMR

SHRDGMR_APPL_DATE

BULLETIN_YEAR_1 Degree 1 Bulletin Year Academic year associated with the requirements completed for this graduation. VARCHAR2(63)  

SHRDGMR

SHRDGMR_ACYR_CODE_BULLETIN

BULLETIN_YEAR_2 Degree 2 Bulletin Year Academic year associated with the requirements completed for this graduation. VARCHAR2(63)  

SHRDGMR

SHRDGMR_ACYR_CODE_BULLETIN

BULLETIN_YEAR_3 Degree 3 Bulletin Year Academic year associated with the requirements completed for this graduation. VARCHAR2(63)  

SHRDGMR

SHRDGMR_ACYR_CODE_BULLETIN

BULLETIN_YEAR_DESC_1 Degree 1 Bulletin Year Description Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

BULLETIN_YEAR_DESC_2 Degree 2 Bulletin Year Description Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

BULLETIN_YEAR_DESC_3 Degree 3 Bulletin Year Description Academic year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS_1 Degree 1 Campus Campus where the academic outcome requirements were completed. VARCHAR2(63)  

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_2 Degree 2 Campus Campus where the academic outcome requirements were completed. VARCHAR2(63)  

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_3 Degree 3 Campus Campus where the academic outcome requirements were completed. VARCHAR2(63)  

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC_1 Degree 1 Campus Description Institution campus name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS_DESC_2 Degree 2 Campus Description Institution campus name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS_DESC_3 Degree 3 Campus Description Institution campus name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

CATEGORY_1 Degree 1 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

CATEGORY_2 Degree 2 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

CATEGORY_3 Degree 3 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

CATEGORY_DESC_1 Degree 1 Award Category Description Award category description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

CATEGORY_DESC_2 Degree 2 Award Category Description Award category description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

CATEGORY_DESC_3 Degree 3 Award Category Description Award category description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

SORLCUR

SORLCUR_COLL_CODE

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

SORLCUR

SORLCUR_COLL_CODE

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

SORLCUR

SORLCUR_COLL_CODE

COLLEGE_DESC_1 Degree 1 College Description College, faculty or school name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE_DESC_2 Degree 2 College Description College, faculty or school name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE_DESC_3 Degree 3 College Description College, faculty or school name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_1 Degree 1 Department Department responsible to verify that academic outcome requirements are completed. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_2 Degree 2 Department Department responsible to verify that academic outcome requirements are completed. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_3 Degree 3 Department Department responsible to verify that academic outcome requirements are completed. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC_1 Degree 1 Department Description Department name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_DESC_2 Degree 2 Department Description Department name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT_DESC_3 Degree 3 Department Description Department name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

GRADUATION_DATE_1 Degree 1 Graduation Date Date for the formal completion or graduation in this academic outcome. DATE  

SHRDGMR

SHRDGMR_GRAD_DATE

GRADUATION_DATE_2 Degree 2 Graduation Date Date for the formal completion or graduation in this academic outcome. DATE  

SHRDGMR

SHRDGMR_GRAD_DATE

GRADUATION_DATE_3 Degree 3 Graduation Date Date for the formal completion or graduation in this academic outcome. DATE  

SHRDGMR

SHRDGMR_GRAD_DATE

GRADUATION_STATUS_1 Degree 1 Graduation Status Indicates when an academic outcome is completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_GRST_CODE

GRADUATION_STATUS_2 Degree 2 Graduation Status Indicates when an academic outcome is completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_GRST_CODE

GRADUATION_STATUS_3 Degree 3 Graduation Status Indicates when an academic outcome is completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_GRST_CODE

GRADUATION_STATUS_DESC_1 Degree 1 Graduation Status Description Current graduation status description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

GRADUATION_STATUS_DESC_2 Degree 2 Graduation Status Description Current graduation status description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

GRADUATION_STATUS_DESC_3 Degree 3 Graduation Status Description Current graduation status description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

GRAD_AUTHORIZED_ADDS_CHGS_1 Graduate Authorized Adds Charges 1 Indicates if the student is authorized to add or drop based on graduation requirements. VARCHAR2(255)  

SHRDGMR

SHRDGMR_AUTHORIZED

GRAD_AUTHORIZED_ADDS_CHGS_2 Graduate Authorized Adds Charges 2 Indicates if the student is authorized to add or drop based on graduation requirements. VARCHAR2(255)  

SHRDGMR

SHRDGMR_AUTHORIZED

GRAD_AUTHORIZED_ADDS_CHGS_3 Graduate Authorized Adds Charges 3 Indicates if the student is authorized to add or drop based on graduation requirements. VARCHAR2(255)  

SHRDGMR

SHRDGMR_AUTHORIZED

GRAD_REQ_COMPLETED_TERM_1 Degree 1 Graduate Requirements Completed Academic Period Academic period when all graduation requirements were completed or will be completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_COMPLETED

GRAD_REQ_COMPLETED_TERM_2 Degree 2 Graduate Requirements Completed Academic Period Academic period when all graduation requirements were completed or will be completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_COMPLETED

GRAD_REQ_COMPLETED_TERM_3 Degree 3 Graduate Requirements Completed Academic Period Academic period when all graduation requirements were completed or will be completed. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_COMPLETED

GRAD_REQ_COMPLETED_TERM_DESC1 Degree 1 Graduate Requirements Completed Academic Period Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

GRAD_REQ_COMPLETED_TERM_DESC2 Degree 2 Graduate Requirements Completed Academic Period Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

GRAD_REQ_COMPLETED_TERM_DESC3 Degree 3 Graduate Requirements Completed Academic Period Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_1 Degree 1 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_2 Degree 2 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_3 Degree 3 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_CONC1_1 Degree 1 Major Concentration 1 Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC1_2 Degree 2 Major Concentration 1 Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC1_3 Degree 3 Major Concentration 1 Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC1_DESC_1 Degree 1 Major Concentration 1 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC1_DESC_2 Degree 2 Major Concentration 1 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC1_DESC_3 Degree 3 Major Concentration 1 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC2_1 Degree 1 Major Concentration 2 Concentration or study emphasis description. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC2_2 Degree 2 Major Concentration 2 Concentration or study emphasis description. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC2_3 Degree 3 Major Concentration 2 Concentration or study emphasis description. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC2_DESC_1 Degree 1 Major Concentration 2 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC2_DESC_2 Degree 2 Major Concentration 2 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC2_DESC_3 Degree 3 Major Concentration 2 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC3_1 Degree 1 Major Concentration 3 Concentration or study emphasis description. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC3_2 Degree 2 Major Concentration 3 Concentration or study emphasis description. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC3_3 Degree 3 Major Concentration 3 Concentration or study emphasis description. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_CONC3_DESC_1 Degree 1 Major Concentration 3 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC3_DESC_2 Degree 2 Major Concentration 3 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MAJOR_CONC3_DESC_3 Degree 3 Major Concentration 3 Description Concentration or study emphasis description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

SHRDGMR

SORLCUR

SHRDGMR_DEGC_CODE

SORLCUR_DEGC_CODE

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

SHRDGMR

SORLCUR

SHRDGMR_DEGC_CODE

SORLCUR_DEGC_CODE

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

SHRDGMR

SORLCUR

SHRDGMR_DEGC_CODE

SORLCUR_DEGC_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SHRDGMR_SEQ_NO

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

SHRDGMR

SHRDGMR_SEQ_NO

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

SHRDGMR

SHRDGMR_SEQ_NO

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

SHRDGMR

SHRDGMR_PIDM

PRIMARY_MINOR_1 Degree 1 First Minor Minor subject area of the person's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

PRIMARY_MINOR_2 Degree 2 First Minor Minor subject area of the person's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

PRIMARY_MINOR_3 Degree 3 First Minor Minor subject area of the person's academic study. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

PRIMARY_MINOR_DESC_1 Degree 1 First Minor Description Minor subject area description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_MINOR_DESC_2 Degree 2 First Minor Description Minor subject area description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_MINOR_DESC_3 Degree 3 First Minor Description Minor subject area description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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_1 Degree 1 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_2 Degree 2 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_3 Degree 3 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_1 Degree 1 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 to the federal government. VARCHAR2(63)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_2 Degree 2 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 to the federal government. VARCHAR2(63)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_3 Degree 3 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 to the federal government. VARCHAR2(63)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC_1 Degree 1 Program Classification Description Program classification description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC_2 Degree 2 Program Classification Description Program classification description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC_3 Degree 3 Program Classification Description Program classification description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_DESC_1 Degree 1 Program Description Program or course of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_DESC_2 Degree 2 Program Description Program or course of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_DESC_3 Degree 3 Program Description Program or course of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_DEPARTMENT_1 Degree 1 Second Major Department Department responsible for the second major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

SECONDARY_DEPARTMENT_2 Degree 2 Second Major Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

SECONDARY_DEPARTMENT_3 Degree 3 Second Major Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)  

SORLFOS

SORLFOS_DEPT_CODE

SECONDARY_DEPARTMENT_DESC_1 Degree 1 Second Department Description Department name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_DEPARTMENT_DESC_2 Degree 2 Second Department Description Department name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_DEPARTMENT_DESC_3 Degree 3 Second Department Description Department name. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_1 Degree 1 Second Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_2 Degree 2 Second Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_3 Degree 3 Second Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_CONC1_1 Degree 1 Second Major Concentration 1 First 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 or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_CONC1_2 Degree 2 Second Major Concentration 1 First 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 or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_CONC1_3 Degree 3 Second Major Concentration 1 First 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 or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_CONC1_DESC_2 Degree 2 Second Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_CONC1_DESC_3 Degree 3 Second Major Concentration 1 Description Student's concentration description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_CONC2_1 Degree 1 Second Major Concentration 2 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 or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

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

SORLFOS

SORLFOS_MAJR_CODE

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

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_CONC2_DESC_1 Degree 1 Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_CONC2_DESC_3 Degree 3 Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_CONC3_1 Degree 3 Second Major Concentration 1 Third 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 or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_CONC3_2 Degree 3 Second Major Concentration 2 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 or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_CONC3_3 Degree 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 or emphasis. VARCHAR2(63)  

SORLFOS

SORLFOS_MAJR_CODE

SECONDARY_MAJOR_CONC3_DESC_1 Degree 1 Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_CONC3_DESC_2 Degree 2 Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_DESC_1 Degree 1 Second Major Description Major or subject area of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_DESC_2 Degree 2 Second Major Description Major or subject area of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MAJOR_DESC_3 Degree 3 Second Major Description Major or subject area of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MINOR_1 Degree 1 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

SECONDARY_MINOR_2 Degree 2 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

SECONDARY_MINOR_3 Degree 3 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

SECONDARY_MINOR_DESC_1 Degree 1 Second Minor Description Minor area of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MINOR_DESC_2 Degree 2 Second Minor Description Minor area of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SECONDARY_MINOR_DESC_3 Degree 3 Second Minor Description Minor area of study description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SEC_PROGRAM_CLASSIFICATION_1 Degree 1 Second 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

SEC_PROGRAM_CLASSIFICATION_2 Degree 2 Second 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)  

STVMAJR

STVMAJR_CIPC_CODE

SEC_PROGRAM_CLASSIFICATION_3 Degree 3 Second 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 to the federal government. VARCHAR2(63)  

STVMAJR

STVMAJR_CIPC_CODE

SEC_PROGRAM_CLASSIF_DESC_1 Degree 1 Second Program Classification Description Program classification code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SEC_PROGRAM_CLASSIF_DESC_2 Degree 2 Second Program Classification Description Program classification code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SEC_PROGRAM_CLASSIF_DESC_3 Degree 3 Second Program Classification Description Program classification code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STATUS_1 Degree 1 Status Current status of the academic outcome. For example, pending, awarded, etc. VARCHAR2(63)  

SHRDGMR

SHRDGMR_DEGS_CODE

STATUS_2 Degree 2 Status Current status of the academic outcome. For example, pending, awarded, etc. VARCHAR2(63)  

SHRDGMR

SHRDGMR_DEGS_CODE

STATUS_3 Degree 3 Status Current status of the academic outcome. For example, pending, awarded, etc. VARCHAR2(63)  

SHRDGMR

SHRDGMR_DEGS_CODE

STATUS_DESC_1 Degree 1 Status Description Outcome or award status description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STATUS_DESC_2 Degree 2 Status Description Outcome or award status description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STATUS_DESC_3 Degree 3 Status Description Outcome or award status description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_LEVEL 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_1 Degree 1 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_2 Degree 2 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_3 Degree 3 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_1 Degree 1 Student Level Description Student level description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_LEVEL_DESC_2 Degree 2 Student Level Description Student level description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_LEVEL_DESC_3 Degree 3 Student Level Description Student level description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_TERM_1 Degree 1 Academic Period Academic period or time frame associated with this outcome or degree record. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_STUREC

STUDENT_TERM_2 Degree 2 Academic Period Academic period or time frame associated with this outcome or degree record. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_STUREC

STUDENT_TERM_3 Degree 3 Academic Period Academic period or time frame associated with this outcome or degree record. VARCHAR2(63)  

SHRDGMR

SHRDGMR_TERM_CODE_STUREC

STUDENT_TERM_DESC_1 Degree 1 Academic Period Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_TERM_DESC_2 Degree 2 Academic Period Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_TERM_DESC_3 Degree 3 Academic Period Description Academic period description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC



Ver: 9.0