RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SORDEGR Student Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: SORDEGR

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

REPORTING VIEW

PRE_STUDENT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

PS_ATTEND_FROM_DATE

PS_ATTEND_FROM_DATE_2

SS_ATTEND_FROM_DATE

PS_ATTEND_FROM_DATE_3

ATTEND_FROM_DATE

PS_ATTEND_FROM_DATE_1

ATTEND_FROM_DATE

NA
SORDEGR_ATTEND_TO SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION

PRE_STUDENT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

ATTEND_TO_DATE

PS_ATTEND_TO_DATE

PS_ATTEND_TO_DATE_1

SS_ATTEND_TO_DATE

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

POST_SECONDARY_COLLEGE_1

POST_SECONDARY_COLLEGE_2

POST_SECONDARY_COLLEGE_3

COLLEGE

 
SORDEGR_DEGC_CODE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

PRE_STUDENT

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_SLOT

PRE_STUDENT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

PREVIOUS_EDUCATION

COMBINED_ACADEMIC_OUTCOME

POST_SECONDARY_DEGREE_DATE_2

POST_SECONDARY_DEGREE_DATE2

POST_SECONDARY_DEGREE_DATE_1

POST_SECONDARY_DEGREE_DATE_3

POST_SECONDARY_DEGREE_DATE1

POST_SECONDARY_DEGREE_DATE

DEGREE_DATE

NA
SORDEGR_DEGC_YEAR SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

COMBINED_ACADEMIC_OUTCOME

POST_SECONDARY_DEGREE_YEAR_2

POST_SECONDARY_DEGREE_YEAR_1

POST_SECONDARY_DEGREE_YEAR_3

POST_SECONDARY_DEGREE_YEAR

ACADEMIC_YEAR_GRADUATION

NA
SORDEGR_DEGR_SEQ_NO SOAPCOL

REPORTING VIEW

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

POST_SECONDARY_DEGREE

POST_SECONDARY_DEGREE_SEQ_2

POST_SECONDARY_DEGREE_SEQUENCE

POST_SECONDARY_DEGREE_SEQ_1

POST_SECONDARY_DEGREE_SEQ_3

NA
SORDEGR_EGOL_CODE TBD

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PS_EDUCATION_GOAL_3

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

PRE_STUDENT

COMBINED_ACADEMIC_OUTCOME

PS_SCHOOL_GPA_1

PS_SCHOOL_GPA_2

PS_SCHOOL_GPA_3

SS_SCHOOL_GPA

SCHOOL_GPA

PS_GPA_TRANSFERRED

PS_GPA_TRANSFERRED

GPA

NA
SORDEGR_HONR_CODE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION_SLOT

POST_SECONDARY_HONORS_2

POST_SECONDARY_HONORS_1

POST_SECONDARY_HONORS

POST_SECONDARY_HONORS_3

NA


Ver: 3.1