| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| SORHSCH_ACTIVITY_DATE |
TBD |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_HSCH |
EDUCATION_ACTIVITY_DATE |
NO |
|
| SORHSCH_ADMR_CODE |
SOAHSCH |
NO |
|
|
|
|
|
| SORHSCH_CLASS_RANK |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PRE_STUDENT AS_PREVIOUS_EDUCATION_HSCH |
SECONDARY_SCHOOL_RANK SCHOOL_RANK |
NO NO |
NA |
| SORHSCH_CLASS_SIZE |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PRE_STUDENT AS_PREVIOUS_EDUCATION_HSCH |
SECONDARY_SCHOOL_SIZE SCHOOL_SIZE |
NO NO |
NA |
| SORHSCH_COLL_PREP_IND |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_HSCH |
COLLEGE_PREP |
NO |
NA |
| SORHSCH_DATA_ORIGIN |
NA |
NO |
|
|
|
|
|
| SORHSCH_DPLM_CODE |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PRE_STUDENT AS_PREVIOUS_EDUCATION_HSCH |
SECONDARY_SCHOOL_DIPLOMA SECONDARY_DIPLOMA |
NO NO |
NA |
| SORHSCH_GPA |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_HSCH AS_PRE_STUDENT |
SCHOOL_GPA SECONDARY_SCHOOL_REPORTED_GPA |
NO NO |
NA |
| SORHSCH_GRADUATION_DATE |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PRE_STUDENT AS_PREVIOUS_EDUCATION_HSCH |
SECONDARY_SCHOOL_GRAD_DATE SECONDARY_SCHOOL_GRAD_DATE |
NO NO |
NA |
| SORHSCH_PERCENTILE |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PRE_STUDENT AS_PREVIOUS_EDUCATION_HSCH |
SECONDARY_SCHOOL_PERCENTILE PERCENTILE |
NO NO |
NA |
| SORHSCH_PIDM |
NA |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_HSCH |
PERSON_UID |
NO |
NA |
| SORHSCH_SBGI_CODE |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PRE_STUDENT AS_PREVIOUS_EDUCATION_HSCH |
LATEST_SECONDARY_SCHOOL INSTITUTION |
NO NO |
NA |
| SORHSCH_TRANS_RECV_DATE |
SOAHSCH |
NO |
COMPOSITE VIEW |
AS_PREVIOUS_EDUCATION_HSCH AS_PRE_STUDENT |
TRANSCRIPT_RECEIVED_DATE SEC_TRANSCRIPT_RECEIVED_DATE |
NO NO |
NA |
| SORHSCH_USER_ID |
NA |
NO |
|
|
|
|
|