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_ACTIVITY_DATE SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

ACTIVITY_DATE

 
SORDEGR_ATTEND_FROM SOAPCOL

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

NA
SORDEGR_ATTEND_TO SOAPCOL

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

NA
SORDEGR_COLL_CODE TBD

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

 
SORDEGR_DATA_ORIGIN SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

DATA_SOURCE

 
SORDEGR_DEGC_CODE SOAPCOL

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

NA
SORDEGR_DEGC_DATE SOAPCOL

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

NA
SORDEGR_DEGC_YEAR SOAPCOL

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

NA
SORDEGR_DEGR_SEQ_NO SOAPCOL

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

NA
SORDEGR_EGOL_CODE TBD

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

 
SORDEGR_GPA_TRANSFERRED SOAPCOL

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

NA
SORDEGR_HONR_CODE SOAPCOL

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

NA
SORDEGR_HOURS_TRANSFERRED SOAPCOL

REPORTING VIEW

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_DEGREE

GPA_CREDITS

TRANSFER_HOURS

 
SORDEGR_PIDM NA

REPORTING VIEW

PREVIOUS_DEGREE

COMBINED_ACADEMIC_OUTCOME

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: 8.5