Reporting View Source: SORDEGR

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

**SGHE 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_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_DEGREE	ATTEND_FROM_DATE PS_ATTEND_FROM_DATE_2 ATTEND_FROM_DATE PS_ATTEND_FROM_DATE_3 PS_ATTEND_FROM_DATE_1 SS_ATTEND_FROM_DATE ATTEND_PERIOD_FROM_DATE ATTEND_FROM_DATE	NA
SORDEGR_ATTEND_TO	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	ATTEND_TO_DATE PS_ATTEND_TO_DATE_2 SS_ATTEND_TO_DATE ATTEND_TO_DATE ATTEND_TO_DATE ATTEND_PERIOD_TO_DATE PS_ATTEND_TO_DATE_1 PS_ATTEND_TO_DATE_3	NA
SORDEGR_COLL_CODE	TBD	REPORTING VIEW	PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT	COLLEGE POST_SECONDARY_COLLEGE_2 POST_SECONDARY_COLLEGE_3 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 PREVIOUS_EDUCATION_SLOT PRE_STUDENT PREVIOUS_EDUCATION_SLOT PRE_STUDENT PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_ATTENDANCE	POST_SECONDARY_DEGREE POST_SECONDARY_DEGREE_1 POST_SECONDARY_DEGREE2 POST_SECONDARY_DEGREE_2 POST_SECONDARY_DEGREE1 DEGREE POST_SECONDARY_DEGREE_3 DEGREE POST_SECONDARY_DEGREE	NA
SORDEGR_DEGC_DATE	SOAPCOL	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE PREVIOUS_EDUCATION PRE_STUDENT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PRE_STUDENT PREVIOUS_EDUCATION_ATTENDANCE	OUTCOME_GRADUATION_DATE POST_SECONDARY_DEGREE_DATE_3 DEGREE_DATE POST_SECONDARY_DEGREE_DATE POST_SECONDARY_DEGREE_DATE2 POST_SECONDARY_DEGREE_DATE_1 POST_SECONDARY_DEGREE_DATE_2 DEGREE_DATE POST_SECONDARY_DEGREE_DATE1 POST_SECONDARY_DEGREE_DATE	NA
SORDEGR_DEGC_YEAR	SOAPCOL	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION PREVIOUS_DEGREE	ACADEMIC_YEAR_GRADUATION POST_SECONDARY_DEGREE_YEAR_1 POST_SECONDARY_DEGREE_YEAR_3 ACADEMIC_YEAR_GRADUATION_DESC POST_SECONDARY_DEGREE_YEAR POST_SECONDARY_DEGREE_YEAR_2 POST_SECONDARY_DEGREE_YEAR DEGREE_YEAR	NA
SORDEGR_DEGR_SEQ_NO	SOAPCOL	REPORTING VIEW	GOVERNMENT_ADMISSIONS PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION	POST_SECONDARY_DEGREE POST_SECONDARY_DEGREE_SEQUENCE POST_SECONDARY_DEGREE_SEQ_2 SEQUENCE_NUMBER POST_SECONDARY_DEGREE_SEQ_3 OUTCOME_NUMBER POST_SECONDARY_DEGREE_SEQ_1 POST_SECONDARY_DEGREE_SEQUENCE	NA
SORDEGR_EGOL_CODE	TBD	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	PS_EDUCATION_GOAL_2 EDUCATION_GOAL EDUCATION_GOAL EDUCATION_GOAL PS_EDUCATION_GOAL_1 PS_EDUCATION_GOAL_3
SORDEGR_GPA_TRANSFERRED	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME PREVIOUS_DEGREE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION GOVERNMENT_ADMISSIONS	PS_SCHOOL_GPA_1 SCHOOL_GPA PS_SCHOOL_GPA_3 SS_SCHOOL_GPA GPA SCHOOL_GPA PS_SCHOOL_GPA_2 SCHOOL_GPA PS_GPA_TRANSFERRED	NA
SORDEGR_HONR_CODE	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_DEGREE GOVERNMENT_ADMISSIONS PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION PREVIOUS_EDUCATION_SLOT	POST_SECONDARY_HONORS_1 POST_SECONDARY_HONORS_2 HONOR POST_SECONDARY_HONORS POST_SECONDARY_HONORS POST_SECONDARY_HONORS POST_SECONDARY_HONORS_3	NA
SORDEGR_HOURS_TRANSFERRED	SOAPCOL	REPORTING VIEW	COMBINED_ACADEMIC_OUTCOME PREVIOUS_DEGREE	GPA_CREDITS TRANSFER_HOURS
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	COMBINED_ACADEMIC_OUTCOME PREVIOUS_DEGREE	ACADEMIC_PERIOD_GRADUATION ACADEMIC_PERIOD_DEGREE
SORDEGR_USER_ID	SOAPCOL	REPORTING VIEW	PREVIOUS_DEGREE	USER_ID

Ver: 9.0