Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SORDEGR Student Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: SORDEGR - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
SORDEGR_ATTEND_FROM SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

ATTEND_PERIOD_FROM_DATE

PS_ATTEND_FROM_DATE_2

SS_ATTEND_FROM_DATE

PS_ATTEND_FROM_DATE_3

ATTEND_FROM_DATE

ATTEND_FROM_DATE

PS_ATTEND_FROM_DATE_1

NA
SORDEGR_ATTEND_TO SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

ATTEND_TO_DATE

ATTEND_PERIOD_TO_DATE

PS_ATTEND_TO_DATE_1

ATTEND_TO_DATE

SS_ATTEND_TO_DATE

PS_ATTEND_TO_DATE_2

PS_ATTEND_TO_DATE_3

NA
SORDEGR_COLL_CODE TBD

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_ATTENDANCE

POST_SECONDARY_COLLEGE_1

POST_SECONDARY_COLLEGE_2

POST_SECONDARY_COLLEGE_3

COLLEGE

COLLEGE

 
SORDEGR_DEGC_CODE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

PRE_STUDENT

POST_SECONDARY_DEGREE

POST_SECONDARY_DEGREE

POST_SECONDARY_DEGREE_2

POST_SECONDARY_DEGREE_1

POST_SECONDARY_DEGREE_3

POST_SECONDARY_DEGREE2

POST_SECONDARY_DEGREE1

NA
SORDEGR_DEGC_DATE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

POST_SECONDARY_DEGREE_DATE

POST_SECONDARY_DEGREE_DATE_2

POST_SECONDARY_DEGREE_DATE2

POST_SECONDARY_DEGREE_DATE_1

POST_SECONDARY_DEGREE_DATE_3

POST_SECONDARY_DEGREE_DATE1

DEGREE_DATE

POST_SECONDARY_DEGREE_DATE

NA
SORDEGR_DEGC_YEAR SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

POST_SECONDARY_DEGREE_YEAR

POST_SECONDARY_DEGREE_YEAR_2

POST_SECONDARY_DEGREE_YEAR_1

POST_SECONDARY_DEGREE_YEAR_3

ACADEMIC_YEAR_GRADUATION

POST_SECONDARY_DEGREE_YEAR

NA
SORDEGR_DEGR_SEQ_NO SOAPCOL

REPORTING VIEW

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

POST_SECONDARY_DEGREE

POST_SECONDARY_DEGREE_SEQ_2

POST_SECONDARY_DEGREE_SEQUENCE

POST_SECONDARY_DEGREE_SEQUENCE

POST_SECONDARY_DEGREE_SEQ_1

POST_SECONDARY_DEGREE_SEQ_3

NA
SORDEGR_EGOL_CODE TBD

REPORTING VIEW

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

EDUCATION_GOAL

PS_EDUCATION_GOAL_3

EDUCATION_GOAL

PS_EDUCATION_GOAL_1

PS_EDUCATION_GOAL_2

 
SORDEGR_GPA_TRANSFERRED SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

GOVERNMENT_ADMISSIONS

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_ATTENDANCE

PS_SCHOOL_GPA_1

PS_SCHOOL_GPA_2

PS_SCHOOL_GPA_3

SS_SCHOOL_GPA

SCHOOL_GPA

PS_GPA_TRANSFERRED

GPA

SCHOOL_GPA

NA
SORDEGR_HONR_CODE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION_SLOT

POST_SECONDARY_HONORS

POST_SECONDARY_HONORS_2

POST_SECONDARY_HONORS

POST_SECONDARY_HONORS_1

POST_SECONDARY_HONORS

POST_SECONDARY_HONORS_3

NA


Ver: 8.0