Reporting View Source: SORDEGR

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: SORDEGR Student Reporting View Meta Data Reports

**Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SORDEGR_ACTIVITY_DATE	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE	ACTIVITY_DATE
SORDEGR_ATTEND_FROM	SOAPCOL	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE	ATTEND_FROM_DATE PS_ATTEND_FROM_DATE_2 ATTEND_FROM_DATE ATTEND_PERIOD_FROM_DATE SS_ATTEND_FROM_DATE PS_ATTEND_FROM_DATE_1 PS_ATTEND_FROM_DATE_3 ATTEND_FROM_DATE	NA
SORDEGR_ATTEND_TO	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT	PS_ATTEND_TO_DATE_1 ATTEND_PERIOD_TO_DATE PS_ATTEND_TO_DATE_3 ATTEND_TO_DATE SS_ATTEND_TO_DATE ATTEND_TO_DATE ATTEND_TO_DATE PS_ATTEND_TO_DATE_2	NA
SORDEGR_COLL_CODE	TBD	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE PREVIOUS_EDUCATION_ATTENDANCE COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT	POST_SECONDARY_COLLEGE_2 POST_SECONDARY_COLLEGE_3 COLLEGE COLLEGE COLLEGE COLLEGE POST_SECONDARY_COLLEGE_1
SORDEGR_DATA_ORIGIN	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE	DATA_SOURCE
SORDEGR_DEGC_CODE	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PRE_STUDENT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PRE_STUDENT PREVIOUS_EDUCATION PREVIOUS_DEGREE	POST_SECONDARY_DEGREE_1 POST_SECONDARY_DEGREE1 POST_SECONDARY_DEGREE POST_SECONDARY_DEGREE_2 POST_SECONDARY_DEGREE_3 DEGREE POST_SECONDARY_DEGREE2 POST_SECONDARY_DEGREE DEGREE	NA
SORDEGR_DEGC_DATE	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PRE_STUDENT PRE_STUDENT COMBINED_ACADEMIC_OUTCOME COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT	DEGREE_DATE POST_SECONDARY_DEGREE_DATE_1 POST_SECONDARY_DEGREE_DATE POST_SECONDARY_DEGREE_DATE_2 POST_SECONDARY_DEGREE_DATE1 POST_SECONDARY_DEGREE_DATE2 DEGREE_DATE OUTCOME_GRADUATION_DATE POST_SECONDARY_DEGREE_DATE POST_SECONDARY_DEGREE_DATE_3	NA
SORDEGR_DEGC_YEAR	SOAPCOL	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE	ACADEMIC_YEAR_GRADUATION POST_SECONDARY_DEGREE_YEAR ACADEMIC_YEAR_GRADUATION_DESC POST_SECONDARY_DEGREE_YEAR POST_SECONDARY_DEGREE_YEAR_1 POST_SECONDARY_DEGREE_YEAR_2 POST_SECONDARY_DEGREE_YEAR_3 DEGREE_YEAR	NA
SORDEGR_DEGR_SEQ_NO	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT GOVERNMENT_ADMISSIONS PREVIOUS_EDUCATION_ATTENDANCE	SEQUENCE_NUMBER POST_SECONDARY_DEGREE_SEQUENCE POST_SECONDARY_DEGREE_SEQ_3 POST_SECONDARY_DEGREE_SEQ_2 OUTCOME_NUMBER POST_SECONDARY_DEGREE_SEQ_1 POST_SECONDARY_DEGREE POST_SECONDARY_DEGREE_SEQUENCE	NA
SORDEGR_EGOL_CODE	TBD	REPORTING VIEW	PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE	EDUCATION_GOAL PS_EDUCATION_GOAL_2 PS_EDUCATION_GOAL_3 EDUCATION_GOAL PS_EDUCATION_GOAL_1 EDUCATION_GOAL
SORDEGR_GPA_TRANSFERRED	SOAPCOL	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT GOVERNMENT_ADMISSIONS PREVIOUS_EDUCATION PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	GPA PS_SCHOOL_GPA_2 SCHOOL_GPA SS_SCHOOL_GPA PS_GPA_TRANSFERRED SCHOOL_GPA SCHOOL_GPA PS_SCHOOL_GPA_1 PS_SCHOOL_GPA_3	NA
SORDEGR_HONR_CODE	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE GOVERNMENT_ADMISSIONS PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE	POST_SECONDARY_HONORS_2 POST_SECONDARY_HONORS POST_SECONDARY_HONORS POST_SECONDARY_HONORS POST_SECONDARY_HONORS_1 POST_SECONDARY_HONORS_3 HONOR	NA
SORDEGR_HOURS_TRANSFERRED	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE COMBINED_ACADEMIC_OUTCOME	TRANSFER_HOURS GPA_CREDITS
SORDEGR_PIDM	NA	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PREVIOUS_DEGREE	PERSON_UID PERSON_UID
SORDEGR_PRIMARY_IND	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE	PRIMARY_IND
SORDEGR_SBGI_CODE	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE COMBINED_ACADEMIC_OUTCOME	INSTITUTION INSTITUTION
SORDEGR_TERM_DEGREE	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE COMBINED_ACADEMIC_OUTCOME	ACADEMIC_PERIOD_DEGREE ACADEMIC_PERIOD_GRADUATION
SORDEGR_USER_ID	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE	USER_ID

Ver: 9.2