Composite View Source: SORDEGR

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SORDEGR Student

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
SORDEGR_ACTIVITY_DATE	SOAPCOL	AS_PREVIOUS_DEGREE	ACTIVITY_DATE
SORDEGR_ATTEND_FROM	SOAPCOL	AS_PREVIOUS_DEGREE	ATTEND_FROM_DATE
SORDEGR_ATTEND_TO	SOAPCOL	AS_PREVIOUS_DEGREE	ATTEND_TO_DATE
SORDEGR_COLL_CODE	TBD	AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL	COLLEGE COLLEGE
SORDEGR_DATA_ORIGIN	SOAPCOL	AS_PREVIOUS_DEGREE	DATA_SOURCE
SORDEGR_DEGC_CODE	SOAPCOL	AS_PREVIOUS_DEGREE	DEGREE
SORDEGR_DEGC_DATE	SOAPCOL	AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL	DEGREE_DATE POST_SECONDARY_DEGREE_DATE
SORDEGR_DEGC_YEAR	SOAPCOL	AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL	DEGREE_YEAR POST_SECONDARY_DEGREE_YEAR
SORDEGR_DEGR_SEQ_NO	SOAPCOL	AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL	SEQUENCE_NUMBER POST_SECONDARY_DEGREE_SEQUENCE
SORDEGR_EGOL_CODE	TBD	AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL	EDUCATION_GOAL EDUCATION_GOAL
SORDEGR_GPA_TRANSFERRED	SOAPCOL	AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL	SCHOOL_GPA SCHOOL_GPA
SORDEGR_HONR_CODE	SOAPCOL	AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE	POST_SECONDARY_HONORS HONOR
SORDEGR_HOURS_TRANSFERRED	SOAPCOL	AS_PREVIOUS_DEGREE	TRANSFER_HOURS
SORDEGR_PIDM	NA	AS_PREVIOUS_DEGREE	PERSON_UID
SORDEGR_PRIMARY_IND	SOAPCOL	AS_PREVIOUS_DEGREE	PRIMARY_IND
SORDEGR_SBGI_CODE	SOAPCOL	AS_PREVIOUS_DEGREE	INSTITUTION
SORDEGR_TERM_DEGREE	SOAPCOL	AS_PREVIOUS_DEGREE	ACADEMIC_PERIOD_DEGREE
SORDEGR_USER_ID	SOAPCOL	AS_PREVIOUS_DEGREE	USER_ID

Ver: 8.3