| 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 degree.
|
VARCHAR2(3)
|
APRADEG
|
APRADEG_CAMP_CODE
|
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(30)
|
STVCAMP
|
STVCAMP_DESC
|
|
COLLEGE
|
College, faculty or school to which the academic study for the student is associated.
|
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
|
Degree or award code associated with the academic study.
|
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(5)
|
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(8)
|
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
|