Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SORDEGR Student Reporting View Meta Data Reports
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

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_DEGREE

ATTEND_FROM_DATE

PS_ATTEND_FROM_DATE_2

ATTEND_FROM_DATE

ATTEND_PERIOD_FROM_DATE

SS_ATTEND_FROM_DATE

PS_ATTEND_FROM_DATE_1

PS_ATTEND_FROM_DATE_3

ATTEND_FROM_DATE

NA
SORDEGR_ATTEND_TO SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_DEGREE

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PS_ATTEND_TO_DATE_1

ATTEND_PERIOD_TO_DATE

PS_ATTEND_TO_DATE_3

ATTEND_TO_DATE

SS_ATTEND_TO_DATE

ATTEND_TO_DATE

ATTEND_TO_DATE

PS_ATTEND_TO_DATE_2

NA
SORDEGR_COLL_CODE TBD

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_DEGREE

PREVIOUS_EDUCATION_ATTENDANCE

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

POST_SECONDARY_COLLEGE_2

POST_SECONDARY_COLLEGE_3

COLLEGE

COLLEGE

COLLEGE

COLLEGE

POST_SECONDARY_COLLEGE_1

 
SORDEGR_DATA_ORIGIN SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

DATA_SOURCE

 
SORDEGR_DEGC_CODE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PRE_STUDENT

PREVIOUS_EDUCATION

PREVIOUS_DEGREE

POST_SECONDARY_DEGREE_1

POST_SECONDARY_DEGREE1

POST_SECONDARY_DEGREE

POST_SECONDARY_DEGREE_2

POST_SECONDARY_DEGREE_3

DEGREE

POST_SECONDARY_DEGREE2

POST_SECONDARY_DEGREE

DEGREE

NA
SORDEGR_DEGC_DATE SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

PRE_STUDENT

COMBINED_ACADEMIC_OUTCOME

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

DEGREE_DATE

POST_SECONDARY_DEGREE_DATE_1

POST_SECONDARY_DEGREE_DATE

POST_SECONDARY_DEGREE_DATE_2

POST_SECONDARY_DEGREE_DATE1

POST_SECONDARY_DEGREE_DATE2

DEGREE_DATE

OUTCOME_GRADUATION_DATE

POST_SECONDARY_DEGREE_DATE

POST_SECONDARY_DEGREE_DATE_3

NA
SORDEGR_DEGC_YEAR SOAPCOL

REPORTING VIEW

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_DEGREE

ACADEMIC_YEAR_GRADUATION

POST_SECONDARY_DEGREE_YEAR

ACADEMIC_YEAR_GRADUATION_DESC

POST_SECONDARY_DEGREE_YEAR

POST_SECONDARY_DEGREE_YEAR_1

POST_SECONDARY_DEGREE_YEAR_2

POST_SECONDARY_DEGREE_YEAR_3

DEGREE_YEAR

NA
SORDEGR_DEGR_SEQ_NO SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION_ATTENDANCE

SEQUENCE_NUMBER

POST_SECONDARY_DEGREE_SEQUENCE

POST_SECONDARY_DEGREE_SEQ_3

POST_SECONDARY_DEGREE_SEQ_2

OUTCOME_NUMBER

POST_SECONDARY_DEGREE_SEQ_1

POST_SECONDARY_DEGREE

POST_SECONDARY_DEGREE_SEQUENCE

NA
SORDEGR_EGOL_CODE TBD

REPORTING VIEW

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_DEGREE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

EDUCATION_GOAL

PS_EDUCATION_GOAL_2

PS_EDUCATION_GOAL_3

EDUCATION_GOAL

PS_EDUCATION_GOAL_1

EDUCATION_GOAL

 
SORDEGR_GPA_TRANSFERRED SOAPCOL

REPORTING VIEW

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION

PREVIOUS_DEGREE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

GPA

PS_SCHOOL_GPA_2

SCHOOL_GPA

SS_SCHOOL_GPA

PS_GPA_TRANSFERRED

SCHOOL_GPA

SCHOOL_GPA

PS_SCHOOL_GPA_1

PS_SCHOOL_GPA_3

NA
SORDEGR_HONR_CODE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_DEGREE

POST_SECONDARY_HONORS_2

POST_SECONDARY_HONORS

POST_SECONDARY_HONORS

POST_SECONDARY_HONORS

POST_SECONDARY_HONORS_1

POST_SECONDARY_HONORS_3

HONOR

NA
SORDEGR_HOURS_TRANSFERRED SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

COMBINED_ACADEMIC_OUTCOME

TRANSFER_HOURS

GPA_CREDITS

 
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

PREVIOUS_DEGREE

COMBINED_ACADEMIC_OUTCOME

INSTITUTION

INSTITUTION

 
SORDEGR_TERM_DEGREE SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

COMBINED_ACADEMIC_OUTCOME

ACADEMIC_PERIOD_DEGREE

ACADEMIC_PERIOD_GRADUATION

 
SORDEGR_USER_ID SOAPCOL

REPORTING VIEW

PREVIOUS_DEGREE

USER_ID

 


Ver: 9.2