| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| SORLCUR_ACTIVITY_DATE |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_ACYR_CODE |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_ADMT_CODE |
SGASTDN |
NO |
REPORTING VIEW |
RECRUITMENT_INFORMATION ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED |
ADMISSION_POPULATION ADMISSIONS_POPULATION ADMISSIONS_POPULATION |
NO NO NO |
NA |
| SORLCUR_APPL_KEY_SEQNO |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_APPL_SEQNO |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_CACT_CODE |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_CAMP_CODE |
SGASTDN |
NO |
REPORTING VIEW |
RECRUITMENT_INFORMATION ACADEMIC_OUTCOME_SLOT GOVERNMENT_ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT ACADEMIC_OUTCOME_SLOT FIELD_OF_STUDY COMBINED_ACADEMIC_OUTCOME ACADEMIC_STUDY |
CAMPUS CAMPUS_1 CAMPUS CAMPUS_3 CAMPUS CAMPUS CAMPUS CAMPUS CAMPUS_2 CAMPUS CAMPUS CAMPUS |
NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| SORLCUR_COLL_CODE |
SGASTDN |
NO |
REPORTING VIEW |
ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED FIELD_OF_STUDY GOVERNMENT_ADMISSIONS RECRUITMENT_INFORMATION ACADEMIC_OUTCOME_SLOT ADMISSIONS_APPLICATION |
COLLEGE COLLEGE_2 COLLEGE COLLEGE COLLEGE_1 COLLEGE COLLEGE COLLEGE COLLEGE COLLEGE COLLEGE_3 COLLEGE |
NO NO NO NO NO NO NO NO NO NO NO NO |
|
| SORLCUR_CURRENT_CDE |
TBD |
NO |
|
|
|
|
|
| SORLCUR_DEGC_CODE |
SGASTDN |
NO |
REPORTING VIEW |
ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ADMISSIONS_APPLICATION GOVERNMENT_ACADEMIC_OUTCOME REGISTRATION_PLAN ACADEMIC_OUTCOME_SLOT GOVERNMENT_ADMISSIONS ACADEMIC_STUDY_EXTENDED FIELD_OF_STUDY ACADEMIC_STUDY GOVERNMENT_STUDENT ACADEMIC_OUTCOME_SLOT RECRUITMENT_INFORMATION |
DEGREE OUTCOME_1 DEGREE DEGREE DEGREE OUTCOME_3 DEGREE DEGREE DEGREE DEGREE DEGREE OUTCOME_2 DEGREE |
NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| SORLCUR_END_DATE |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_EXP_GRAD_DATE |
SGASTDN |
NO |
REPORTING VIEW |
FIELD_OF_STUDY |
FIELD_OF_STUDY |
NO |
|
| SORLCUR_KEY_SEQNO |
SGASTDN |
NO |
REPORTING VIEW |
FIELD_OF_STUDY |
SOURCE_SEQUENCE_NUMBER |
NO |
NA |
| SORLCUR_LEAV_CODE |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_LEAV_FROM_DATE |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_LEAV_TO_DATE |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_LEVL_CODE |
SGASTDN |
NO |
REPORTING VIEW |
GOVERNMENT_FINANCIAL_AID ACADEMIC_OUTCOME_SLOT RECRUITMENT_INFORMATION ACADEMIC_OUTCOME_SLOT ADMISSIONS_APPLICATION GOVERNMENT_STUDENT COMBINED_ACADEMIC_OUTCOME GOVERNMENT_ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_OUTCOME_SLOT FIELD_OF_STUDY GOVERNMENT_ADMISSIONS ACADEMIC_STUDY_EXTENDED REGISTRATION_PLAN |
STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL_1 STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL_2 STUDENT_LEVEL STUDENT_LEVEL_3 STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| SORLCUR_LMOD_CODE |
SGASTDN |
NO |
REPORTING VIEW |
FIELD_OF_STUDY |
SOURCE |
NO |
NA |
| SORLCUR_PIDM |
NA |
NO |
|
|
|
|
|
| SORLCUR_PRIORITY_NO |
SGASTDN |
NO |
REPORTING VIEW |
ACADEMIC_OUTCOME ADMISSIONS_APPLICATION ACADEMIC_STUDY_EXTENDED FIELD_OF_STUDY RECRUITMENT_INFORMATION ACADEMIC_STUDY |
CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER |
NO NO NO NO NO NO |
NA |
| SORLCUR_PROGRAM |
SGASTDN |
NO |
REPORTING VIEW |
ACADEMIC_STUDY_EXTENDED ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT FIELD_OF_STUDY GOVERNMENT_ADMISSIONS RECRUITMENT_INFORMATION COMBINED_ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT |
PROGRAM PROGRAM_3 PROGRAM_1 PROGRAM_2 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM |
NO NO NO NO NO NO NO NO NO NO NO NO |
NA |
| SORLCUR_RATE_CODE |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_ROLLED_SEQNO |
SGASTDN |
NO |
REPORTING VIEW |
STUDENT STUDENT_EXTENDED |
OUTCOME_NUMBER OUTCOME_NUMBER |
NO NO |
NA |
| SORLCUR_ROLL_IND |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_SEQNO |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_SITE_CODE |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_START_DATE |
SGASTDN |
NO |
REPORTING VIEW |
ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION |
START_DATE START_DATE START_DATE START_DATE |
NO NO NO NO |
NA |
| SORLCUR_STYP_CODE |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_TERM_CODE |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_TERM_CODE_ADMIT |
SGASTDN |
NO |
REPORTING VIEW |
ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED |
ACADEMIC_PERIOD_ADMITTED ACADEMIC_PERIOD_ADMITTED |
NO NO |
NA |
| SORLCUR_TERM_CODE_CTLG |
SGASTDN |
NO |
REPORTING VIEW |
ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED |
CATALOG_ACADEMIC_PERIOD CATALOG_ACADEMIC_PERIOD |
NO NO |
NA |
| SORLCUR_TERM_CODE_END |
SGASTDN |
NO |
|
|
|
|
NA |
| SORLCUR_TERM_CODE_GRAD |
SGASTDN |
NO |
|
|
|
|
|
| SORLCUR_TERM_CODE_MATRIC |
SGASTDN |
NO |
REPORTING VIEW |
GOVERNMENT_STUDENT ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED |
ACADEMIC_PERIOD_MATRICULATED ACADEMIC_PERIOD_MATRICULATED ACADEMIC_PERIOD_MATRICULATED |
NO NO NO |
NA |
| SORLCUR_USER_ID |
SGASTDN |
NO |
|
|
|
|
NA |