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

Banner Operational Data Store
Reporting View Target: DEGREE

Description Contains detail information for each degree earned by a constituent from this or any other institution.
Key & Frequency One row per person per degree number.
Recommended Search Columns PERSON_UID
MAJOR1, DEGREE
COLLEGE, DEPARTMENT1

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER    

APRADEG

APRADEG_PIDM

NO

NO
ID 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
NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
DEGREE_NUMBER Degree Number Internal sequence number. NUMBER    

APRADEG

APRADEG_SEQ_NO

NO

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

APRADEG

APRADEG_SBGI_CODE

NO

NO
INSTITUTION_DESC Institution Description Source/background institution name. VARCHAR2(255)    

STVSBGI

STVSBGI_DESC

NO

NO
INSTITUTION_IND Institution Indicator Indicates whether the degree or award was earned at this institution. VARCHAR2(1)    

CALCULATION

DECODE(APRADEG_SBGI_CODE,AUBINST_SBGI_CODE,'Y','N')

NO

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

APRADEG

APRADEG_DEGC_CODE

NO

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

STVDEGC

STVDEGC_DESC

NO

NO
DEGREE_DATE Degree Date Date the degree was awarded to the constituent. DATE    

APRADEG

APRADEG_DATE

NO

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

APRADEG

APRADEG_COLL_CODE

NO

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

STVCOLL

STVCOLL_DESC

NO

NO
ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(63)    

APRADEG

APRADEG_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)    

STVACYR

STVACYR_DESC

NO

NO
BULLETIN_YEAR Bulletin Year Academic year associated with the requirements completed for this graduation. VARCHAR2(63)    

APRADEG

APRADEG_ACYR_CODE_BULLETIN

NO

NO
BULLETIN_YEAR_DESC Bulletin Year Description Academic year description. VARCHAR2(255)    

STVACYR

STVACYR_DESC

NO

NO
CAMPUS Campus Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)    

APRADEG

APRADEG_CAMP_CODE

NO

NO
CAMPUS_DESC Campus Description Institution campus name. VARCHAR2(255)    

STVCAMP

STVCAMP_DESC

NO

NO
DEPARTMENT1 Department 1 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(63)    

APRADEG

APRADEG_DEPT_CODE

NO

NO
DEPARTMENT1_DESC Department 1 Description Department name. VARCHAR2(255)    

STVDEPT

STVDEPT_DESC

NO

NO
DEPARTMENT2 Department 2 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(63)    

APRADEG

APRADEG_DEPT_CODE_2

NO

NO
DEPARTMENT2_DESC Department 2 Description Department name. VARCHAR2(255)    

STVDEPT

STVDEPT_DESC

NO

NO
MAJOR1 Major 1 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)    

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

STVMAJR

STVMAJR_DESC

NO

NO
MAJOR2 Major 2 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)    

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

STVMAJR

STVMAJR_DESC

NO

NO
MAJOR3 Major 3 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(63)    

APRAMAJ

APRAMAJ_MAJR_CODE

NO

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

STVMAJR

STVMAJR_DESC

NO

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

FUNCTION

AOKODSF.F_CHECK_FOR_MORE_MAJORS

NO

NO
HONOR1 Honor 1 Honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HONR_CODE

NO

NO
HONOR1_DESC Honor 1 Description Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)    

STVHONR

STVHONR_DESC

NO

NO
HONOR2 Honor 2 Honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HONR_CODE_2

NO

NO
HONOR2_DESC Honor 2 Description Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)    

STVHONR

STVHONR_DESC

NO

NO
HONOR3 Honor 3 Honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HONR_CODE_3

NO

NO
HONOR3_DESC Honor 3 Description Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)    

STVHONR

STVHONR_DESC

NO

NO
HONOR4 Honor 4 Honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HONR_CODE_4

NO

NO
HONOR4_DESC Honor 4 Description Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)    

STVHONR

STVHONR_DESC

NO

NO
HONOR5 Honor 5 Honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HONR_CODE_5

NO

NO
HONOR5_DESC Honor 5 Description Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(255)    

STVHONR

STVHONR_DESC

NO

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

APRADEG

APRADEG_MAJR_CODE_MINR_1

NO

NO
FIRST_MINOR_DESC First Minor Description Major or subject area of study description. VARCHAR2(255)    

STVMAJR

STVMAJR_DESC

NO

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

APRADEG

APRADEG_MAJR_CODE_MINR_2

NO

NO
SECOND_MINOR_DESC Second Minor Description Major or subject area of study description. VARCHAR2(255)    

STVMAJR

STVMAJR_DESC

NO

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

APRADEG

APRADEG_MAJR_CODE_CONC_1

NO

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

STVMAJR

STVMAJR_DESC

NO

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

APRADEG

APRADEG_MAJR_CODE_CONC_2

NO

NO
SECOND_CONCENTRATION_DESC Second Concentration Description Student's concentration description. VARCHAR2(255)    

STVMAJR

STVMAJR_DESC

NO

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

APRADEG

APRADEG_MAJR_CODE_CONC_3

NO

NO
THIRD_CONCENTRATION_DESC Third Concentration Description Student's concentration description. VARCHAR2(255)    

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_CONC_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. VARCHAR2(63)    

APRADEG

APRADEG_MAJR_CODE_CONC_4

NO

NO
SECOND_MAJOR_CONC_1_DESC Second Major Concentration 1 Description Student's concentration description. VARCHAR2(255)    

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_CONC_2 Second Major Concentration 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)    

APRADEG

APRADEG_MAJR_CODE_CONC_5

NO

NO
SECOND_MAJOR_CONC_2_DESC Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)    

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_CONC_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. VARCHAR2(63)    

APRADEG

APRADEG_MAJR_CODE_CONC_6

NO

NO
SECOND_MAJOR_CONC_3_DESC Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)    

STVMAJR

STVMAJR_DESC

NO

NO
DEPARTMENT_HONOR1 Department Honor 1 Departmental honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HOND_CODE_1

NO

NO
DEPARTMENT_HONOR1_DESC Department Honor 1 Description Name of the departmental honor recorded. VARCHAR2(255)    

STVHOND

STVHOND_DESC

NO

NO
DEPARTMENT_HONOR2 Department Honor 2 Departmental honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HOND_CODE_2

NO

NO
DEPARTMENT_HONOR2_DESC Department Honor 2 Description Name of the departmental honor recorded. VARCHAR2(255)    

STVHOND

STVHOND_DESC

NO

NO
DEPARTMENT_HONOR3 Department Honor 3 Departmental honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HOND_CODE_3

NO

NO
DEPARTMENT_HONOR3_DESC Department Honor 3 Description Name of the departmental honor recorded. VARCHAR2(255)    

STVHOND

STVHOND_DESC

NO

NO
DEPARTMENT_HONOR4 Department Honor 4 Departmental honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HOND_CODE_4

NO

NO
DEPARTMENT_HONOR4_DESC Department Honor 4 Description Name of the departmental honor recorded. VARCHAR2(255)    

STVHOND

STVHOND_DESC

NO

NO
DEPARTMENT_HONOR5 Department Honor 5 Departmental honors the constituent received with the associated degree. VARCHAR2(63)    

APRADEG

APRADEG_HOND_CODE_5

NO

NO
DEPARTMENT_HONOR5_DESC Department Honor 5 Description Name of the departmental honor recorded. VARCHAR2(255)    

STVHOND

STVHOND_DESC

NO

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

APRADEG

APRADEG_COMMENTS

NO

NO
MULTI_SOURCE 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 Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)    

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

NO


Ver: 9.2