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

Ver: 9.2