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