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

Ver: