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