Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Institution Description	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: