| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| SORDEGR_ACTIVITY_DATE |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
ACTIVITY_DATE |
NO |
|
| SORDEGR_ATTEND_FROM |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
ATTEND_FROM_DATE |
NO |
NA |
| SORDEGR_ATTEND_TO |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
ATTEND_TO_DATE |
NO |
NA |
| SORDEGR_COLL_CODE |
TBD |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL |
COLLEGE COLLEGE |
NO NO |
|
| SORDEGR_DATA_ORIGIN |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
DATA_SOURCE |
NO |
|
| SORDEGR_DEGC_CODE |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
DEGREE |
NO |
NA |
| SORDEGR_DEGC_DATE |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE |
POST_SECONDARY_DEGREE_DATE DEGREE_DATE |
NO NO |
NA |
| SORDEGR_DEGC_YEAR |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE |
POST_SECONDARY_DEGREE_YEAR DEGREE_YEAR |
NO NO |
NA |
| SORDEGR_DEGR_SEQ_NO |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL |
SEQUENCE_NUMBER POST_SECONDARY_DEGREE_SEQUENCE |
NO NO |
NA |
| SORDEGR_EGOL_CODE |
TBD |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL |
EDUCATION_GOAL EDUCATION_GOAL |
NO NO |
|
| SORDEGR_GPA_TRANSFERRED |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_PCOL |
SCHOOL_GPA SCHOOL_GPA |
NO NO |
NA |
| SORDEGR_HONR_CODE |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_PCOL AS_PREVIOUS_DEGREE |
POST_SECONDARY_HONORS HONOR |
NO NO |
NA |
| SORDEGR_HOURS_TRANSFERRED |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
TRANSFER_HOURS |
NO |
|
| SORDEGR_PIDM |
NA |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
PERSON_UID |
NO |
|
| SORDEGR_PRIMARY_IND |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
PRIMARY_IND |
NO |
|
| SORDEGR_SBGI_CODE |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
INSTITUTION |
NO |
|
| SORDEGR_TERM_DEGREE |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
ACADEMIC_PERIOD_DEGREE |
NO |
|
| SORDEGR_USER_ID |
SOAPCOL |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_DEGREE |
USER_ID |
NO |
|