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: