| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_ACYR_CODE
|
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
|
STVACYR
|
STVACYR_DESC
|
|
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
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
BULLETIN_YEAR
|
Bulletin Year
|
Academic year associated with the requirements completed for this graduation.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_ACYR_CODE_BULLETIN
|
|
BULLETIN_YEAR_DESC
|
Bulletin Year Description
|
Academic year description.
|
VARCHAR2(255)
|
|
STVACYR
|
STVACYR_DESC
|
|
CAMPUS
|
Campus
|
Campus associated with this degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_CAMP_CODE
|
|
CAMPUS_DESC
|
Campus Description
|
Institution campus name.
|
VARCHAR2(255)
|
|
STVCAMP
|
STVCAMP_DESC
|
|
COLLEGE
|
College
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_COLL_CODE
|
|
COLLEGE_DESC
|
College Description
|
College, faculty or school name.
|
VARCHAR2(255)
|
|
STVCOLL
|
STVCOLL_DESC
|
|
DEGREE
|
Degree
|
Degree or award code associated with the academic study.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_DEGC_CODE
|
|
DEGREE_COMMENT
|
Degree Comment
|
Free form text comments about this degree.
|
VARCHAR2(2000)
|
|
APRADEG
|
APRADEG_COMMENTS
|
|
DEGREE_DATE
|
Degree Date
|
Date the degree was awarded to the constituent.
|
DATE
|
|
APRADEG
|
APRADEG_DATE
|
|
DEGREE_DESC
|
Degree Description
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255)
|
|
STVDEGC
|
STVDEGC_DESC
|
|
DEGREE_NUMBER
|
Degree Number
|
Internal sequence number.
|
NUMBER
|
|
APRADEG
|
APRADEG_SEQ_NO
|
|
DEPARTMENT1
|
Department 1
|
Department responsible to verify the academic outcome requirements are completed.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_DEPT_CODE
|
|
DEPARTMENT1_DESC
|
Department 1 Description
|
Department name.
|
VARCHAR2(255)
|
|
STVDEPT
|
STVDEPT_DESC
|
|
DEPARTMENT2
|
Department 2
|
Department responsible to verify the academic outcome requirements are completed.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_DEPT_CODE_2
|
|
DEPARTMENT2_DESC
|
Department 2 Description
|
Department name.
|
VARCHAR2(255)
|
|
STVDEPT
|
STVDEPT_DESC
|
|
DEPARTMENT_HONOR1
|
Department Honor 1
|
Departmental honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HOND_CODE_1
|
|
DEPARTMENT_HONOR1_DESC
|
Department Honor 1 Description
|
Name of the departmental honor recorded.
|
VARCHAR2(255)
|
|
STVHOND
|
STVHOND_DESC
|
|
DEPARTMENT_HONOR2
|
Department Honor 2
|
Departmental honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HOND_CODE_2
|
|
DEPARTMENT_HONOR2_DESC
|
Department Honor 2 Description
|
Name of the departmental honor recorded.
|
VARCHAR2(255)
|
|
STVHOND
|
STVHOND_DESC
|
|
DEPARTMENT_HONOR3
|
Department Honor 3
|
Departmental honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HOND_CODE_3
|
|
DEPARTMENT_HONOR3_DESC
|
Department Honor 3 Description
|
Name of the departmental honor recorded.
|
VARCHAR2(255)
|
|
STVHOND
|
STVHOND_DESC
|
|
DEPARTMENT_HONOR4
|
Department Honor 4
|
Departmental honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HOND_CODE_4
|
|
DEPARTMENT_HONOR4_DESC
|
Department Honor 4 Description
|
Name of the departmental honor recorded.
|
VARCHAR2(255)
|
|
STVHOND
|
STVHOND_DESC
|
|
DEPARTMENT_HONOR5
|
Department Honor 5
|
Departmental honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HOND_CODE_5
|
|
DEPARTMENT_HONOR5_DESC
|
Department Honor 5 Description
|
Name of the departmental honor recorded.
|
VARCHAR2(255)
|
|
STVHOND
|
STVHOND_DESC
|
|
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
|
|
FIRST_CONCENTRATION_DESC
|
First Concentration Description
|
Description of the first concentration on the major.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
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
|
|
FIRST_MINOR_DESC
|
First Minor Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
HONOR1
|
Honor 1
|
Honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HONR_CODE
|
|
HONOR1_DESC
|
Honor 1 Description
|
Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
|
VARCHAR2(255)
|
|
STVHONR
|
STVHONR_DESC
|
|
HONOR2
|
Honor 2
|
Honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HONR_CODE_2
|
|
HONOR2_DESC
|
Honor 2 Description
|
Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
|
VARCHAR2(255)
|
|
STVHONR
|
STVHONR_DESC
|
|
HONOR3
|
Honor 3
|
Honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HONR_CODE_3
|
|
HONOR3_DESC
|
Honor 3 Description
|
Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
|
VARCHAR2(255)
|
|
STVHONR
|
STVHONR_DESC
|
|
HONOR4
|
Honor 4
|
Honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HONR_CODE_4
|
|
HONOR4_DESC
|
Honor 4 Description
|
Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
|
VARCHAR2(255)
|
|
STVHONR
|
STVHONR_DESC
|
|
HONOR5
|
Honor 5
|
Honors the constituent received with the associated degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_HONR_CODE_5
|
|
HONOR5_DESC
|
Honor 5 Description
|
Institutional honor (e.g., magna cum laude) associated with the institutional honor code.
|
VARCHAR2(255)
|
|
STVHONR
|
STVHONR_DESC
|
|
ID
|
ID
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
INSTITUTION
|
Institution
|
Institution at which the constituent earned the degree.
|
VARCHAR2(63)
|
|
APRADEG
|
APRADEG_SBGI_CODE
|
|
INSTITUTION_DESC
|
Institution Description
|
Source/background institution name.
|
VARCHAR2(255)
|
|
STVSBGI
|
STVSBGI_DESC
|
|
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')
|
|
MAJOR1
|
Major 1
|
Concentration of study or emphasis attached to the major for this academic study.
|
VARCHAR2(63)
|
|
APRAMAJ
|
APRAMAJ_MAJR_CODE
|
|
MAJOR1_DESC
|
Major 1 Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
MAJOR2
|
Major 2
|
Concentration of study or emphasis attached to the major for this academic study.
|
VARCHAR2(63)
|
|
APRAMAJ
|
APRAMAJ_MAJR_CODE
|
|
MAJOR2_DESC
|
Major 2 Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
MAJOR3
|
Major 3
|
Concentration of study or emphasis attached to the major for this academic study.
|
VARCHAR2(63)
|
|
APRAMAJ
|
APRAMAJ_MAJR_CODE
|
|
MAJOR3_DESC
|
Major 3 Description
|
Name of the student's major subject area.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_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 when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PERSON_UID
|
Person UID
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
|
NUMBER
|
|
APRADEG
|
APRADEG_PIDM
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
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
|
|
SECOND_CONCENTRATION_DESC
|
Second Concentration Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
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
|
|
SECOND_MAJOR_CONC_1_DESC
|
Second Major Concentration 1 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
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
|
|
SECOND_MAJOR_CONC_2_DESC
|
Second Major Concentration 2 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
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
|
|
SECOND_MAJOR_CONC_3_DESC
|
Second Major Concentration 3 Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
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
|
|
SECOND_MINOR_DESC
|
Second Minor Description
|
Major or subject area of study description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|
|
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
|
|
THIRD_CONCENTRATION_DESC
|
Third Concentration Description
|
Student's concentration description.
|
VARCHAR2(255)
|
|
STVMAJR
|
STVMAJR_DESC
|