ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_YEAR_1	Academic year associated with the academic period on this record.			APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_2	Academic year associated with the academic period on this record.			APRADEG	APRADEG_ACYR_CODE
ACADEMIC_YEAR_3	Academic year associated with the academic period on this record.			APRADEG	APRADEG_ACYR_CODE
ACTIVITY_DATE	Date record was inserted or updated.			NA	SYSDATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
COLLEGE_1	College, faculty or school to which the academic study for the student is associated.			APRADEG	APRADEG_COLL_CODE
COLLEGE_2	College, faculty or school to which the academic study for the student is associated.			APRADEG	APRADEG_COLL_CODE
COLLEGE_3	College, faculty or school to which the academic study for the student is associated.			APRADEG	APRADEG_COLL_CODE
COLLEGE_DESC_1	College, faculty or school name.			FUNCTION	GOKODSF.F_GET_DESC
COLLEGE_DESC_2	College, faculty or school name.			FUNCTION	GOKODSF.F_GET_DESC
COLLEGE_DESC_3	College, faculty or school name.			FUNCTION	GOKODSF.F_GET_DESC
DEGREE_1	Degree or award code associated with the academic study.			APRADEG	APRADEG_DEGC_CODE
DEGREE_2	Degree or award code associated with the academic study.			APRADEG	APRADEG_DEGC_CODE
DEGREE_3	Degree or award code associated with the academic study.			APRADEG	APRADEG_DEGC_CODE
DEGREE_DATE_1	Date the degree was awarded to the constituent.			APRADEG	APRADEG_DATE
DEGREE_DATE_2	Date the degree was awarded to the constituent.			APRADEG	APRADEG_DATE
DEGREE_DATE_3	Date the degree was awarded to the constituent.			APRADEG	APRADEG_DATE
DEGREE_DESC_1	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.			FUNCTION	GOKODSF.F_GET_DESC
DEGREE_DESC_2	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.			FUNCTION	GOKODSF.F_GET_DESC
DEGREE_DESC_3	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.			FUNCTION	GOKODSF.F_GET_DESC
DEGREE_LEVEL_1	Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.			NA	NA
DEGREE_LEVEL_2	Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.			NA	NA
DEGREE_LEVEL_3	Level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.			NA	NA
DEGREE_LEVEL_DESC_1	Level description.			NA	NA
DEGREE_LEVEL_DESC_2	Level description.			NA	NA
DEGREE_LEVEL_DESC_3	Level description.			NA	NA
HONOR1_1	Honors the constituent received with the associated degree.			APRADEG	APRADEG_HONR_CODE
HONOR1_2	Honors the constituent received with the associated degree.			APRADEG	APRADEG_HONR_CODE
HONOR1_3	Honors the constituent received with the associated degree.			APRADEG	APRADEG_HONR_CODE
HONOR1_DESC_1	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.			FUNCTION	GOKODSF.F_GET_DESC
HONOR1_DESC_2	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.			FUNCTION	GOKODSF.F_GET_DESC
HONOR1_DESC_3	Institutional honor (e.g., magna cum laude) associated with the institutional honor code.			FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_1	Institution at which the constituent earned the degree.			APRADEG	APRADEG_SBGI_CODE
INSTITUTION_2	Institution at which the constituent earned the degree.			APRADEG	APRADEG_SBGI_CODE
INSTITUTION_3	Institution at which the constituent earned the degree.			APRADEG	APRADEG_SBGI_CODE
INSTITUTION_DESC_1	Source/background institution name.			FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC_2	Source/background institution name.			FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_DESC_3	Source/background institution name.			FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_IND	Indicates whether the degree or award was earned at this institution.			CALCULATION	DECODE(APRADEG_SBGI_CODE,AUBINST_SBGI_CODE,'Y','N')
MAJOR1_1	Concentration of study or emphasis attached to the major for this academic study.			APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_2	Concentration of study or emphasis attached to the major for this academic study.			APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_3	Concentration of study or emphasis attached to the major for this academic study.			APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR1_DESC_1	Name of the student's major subject area.			FUNCTION	GOKODSF.F_GET_DESC
MAJOR1_DESC_2	Name of the student's major subject area.			FUNCTION	GOKODSF.F_GET_DESC
MAJOR1_DESC_3	Name of the student's major subject area.			FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_1	Concentration of study or emphasis attached to the major for this academic study.			APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_2	Concentration of study or emphasis attached to the major for this academic study.			APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_3	Concentration of study or emphasis attached to the major for this academic study.			APRAMAJ	APRAMAJ_MAJR_CODE
MAJOR2_DESC_1	Name of the student's major subject area.			FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_DESC_2	Name of the student's major subject area.			FUNCTION	GOKODSF.F_GET_DESC
MAJOR2_DESC_3	Name of the student's major subject area.			FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.			APRADEG	APRADEG_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3