Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_DEGREE

Description Source composite view contains information on all degrees received by a person from any institution as applicable.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(4)

APRADEG

APRADEG_ACYR_CODE

ACADEMIC_YEAR_BULLETIN Academic year associated with the requirements completed for this graduation. VARCHAR2(4)

APRADEG

APRADEG_ACYR_CODE_BULLETIN

ACADEMIC_YEAR_BULLETIN_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

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

FUNCTION

AOKODSF.F_CHECK_FOR_MORE_MAJORS

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

APRADEG

APRADEG_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(30)

STVCAMP

STVCAMP_DESC

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

APRADEG

APRADEG_COLL_CODE

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

STVCOLL

STVCOLL_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

APRADEG

APRADEG_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 constituent. DATE

APRADEG

APRADEG_DATE

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

STVDEGC

STVDEGC_DESC

DEGREE_NUMBER Internal sequence number. NUMBER

APRADEG

APRADEG_SEQ_NO

DEPARTMENT1 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(4)

APRADEG

APRADEG_DEPT_CODE

DEPARTMENT1_DESC Department name. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

DEPARTMENT2 Department responsible to verify the academic outcome requirements are completed. VARCHAR2(4)

APRADEG

APRADEG_DEPT_CODE_2

DEPARTMENT2_DESC Department name. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

DEPARTMENT_HONOR1 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_1

DEPARTMENT_HONOR1_DESC Name of the departmental honor recorded. VARCHAR2(30)

STVHOND

STVHOND_DESC

DEPARTMENT_HONOR2 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_2

DEPARTMENT_HONOR2_DESC Name of the departmental honor recorded. VARCHAR2(30)

STVHOND

STVHOND_DESC

DEPARTMENT_HONOR3 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_3

DEPARTMENT_HONOR3_DESC Name of the departmental honor recorded. VARCHAR2(30)

STVHOND

STVHOND_DESC

DEPARTMENT_HONOR4 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_4

DEPARTMENT_HONOR4_DESC Name of the departmental honor recorded. VARCHAR2(30)

STVHOND

STVHOND_DESC

DEPARTMENT_HONOR5 Departmental honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HOND_CODE_5

DEPARTMENT_HONOR5_DESC Name of the departmental honor recorded. VARCHAR2(30)

STVHOND

STVHOND_DESC

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

APRADEG

APRADEG_MAJR_CODE_CONC_1

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

STVMAJR

STVMAJR_DESC

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

APRADEG

APRADEG_MAJR_CODE_MINR_1

FIRST_MINOR_DESC Major or subject area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

HONOR1 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE

HONOR1_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code recorded. VARCHAR2(30)

STVHONR

STVHONR_DESC

HONOR2 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_2

HONOR2_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code recorded. VARCHAR2(30)

STVHONR

STVHONR_DESC

HONOR3 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_3

HONOR3_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code recorded. VARCHAR2(30)

STVHONR

STVHONR_DESC

HONOR4 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_4

HONOR4_DESC Institutional honor (magna cum laude, for example) associated with the recorded institutional honor code. VARCHAR2(30)

STVHONR

STVHONR_DESC

HONOR5 Honors the constituent received with the associated degree. VARCHAR2(6)

APRADEG

APRADEG_HONR_CODE_5

HONOR5_DESC Institutional honor (e.g., magna cum laude) associated with the institutional honor code. VARCHAR2(30)

STVHONR

STVHONR_DESC

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

APRADEG

APRADEG_SBGI_CODE

INSTITUTION_DESC Name of the previous, secondary, or post secondary institution recorded for the person. VARCHAR2(30)

STVSBGI

STVSBGI_DESC

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

CALCULATION

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

MAJOR1 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(4)

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR1_DESC Name of the student's major subject area. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

MAJOR2 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(4)

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR2_DESC Name of the student's major subject area. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

MAJOR3 Concentration of study or emphasis attached to the major for this academic study. VARCHAR2(4)

APRAMAJ

APRAMAJ_MAJR_CODE

MAJOR3_DESC Name of the student's major subject area. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

MIF_DESC Institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

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

APRADEG

APRADEG_PIDM

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

APRADEG

APRADEG_MAJR_CODE_CONC_2

SECOND_CONCENTRATION_DESC Student's concentration description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_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(4)

APRADEG

APRADEG_MAJR_CODE_CONC_4

SECOND_MAJOR_CONC_1_DESC Student's concentration description. VARCHAR2(30)

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

APRADEG

APRADEG_MAJR_CODE_CONC_5

SECOND_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(30)

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

APRADEG

APRADEG_MAJR_CODE_CONC_6

SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

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

APRADEG

APRADEG_MAJR_CODE_MINR_2

SECOND_MINOR_DESC Major or subject area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

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

APRADEG

APRADEG_MAJR_CODE_CONC_3

THIRD_CONCENTRATION_DESC Student's concentration description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

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

NA

NA



Ver: