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
|