| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| SORLCUR_ACTIVITY_DATE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS |
ACTIVITY_DATE ACTIVITY_DATE ACTIVITY_DATE |
NO NO NO |
NA |
| SORLCUR_ACYR_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
GRAD_YEAR_INTENDED |
NO |
|
| SORLCUR_ADMT_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_CURRICULUM AS_LEARNER_CURRICULUM_FOS |
ADMISSIONS_POPULATION ADMISSIONS_POPULATION ADMISSIONS_POPULATION |
NO NO NO |
NA |
| SORLCUR_APPL_KEY_SEQNO |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
APPLICATION_NUMBER |
NO |
NA |
| SORLCUR_APPL_SEQNO |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
APPLICATION_CURRIC_SEQUENCE |
NO |
NA |
| SORLCUR_CACT_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
CURRICULUM_ACTIVITY_STATUS |
NO |
NA |
| SORLCUR_CAMP_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS |
CAMPUS CAMPUS CAMPUS |
NO NO NO |
NA |
| SORLCUR_COLL_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM_FOS AS_CURRICULUM |
COLLEGE COLLEGE COLLEGE |
NO NO NO |
|
| SORLCUR_CURRENT_CDE |
TBD |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
CURRENT_IND |
NO |
|
| SORLCUR_DEGC_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS |
DEGREE DEGREE DEGREE |
NO NO NO |
NA |
| SORLCUR_END_DATE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS |
END_DATE END_DATE END_DATE |
NO NO NO |
NA |
| SORLCUR_EXP_GRAD_DATE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
EXPECTED_GRADUATION_DATE |
NO |
|
| SORLCUR_KEY_SEQNO |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM |
SOURCE_SEQUENCE_NUMBER SOURCE_SEQUENCE_NUMBER SOURCE_SEQUENCE_NUMBER |
NO NO NO |
NA |
| SORLCUR_LEAV_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
LEAVE_REASON |
NO |
|
| SORLCUR_LEAV_FROM_DATE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
LEAVE_DATE_FROM |
NO |
|
| SORLCUR_LEAV_TO_DATE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
LEAVE_DATE_TO |
NO |
|
| SORLCUR_LEVL_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM |
STUDENT_LEVEL PROGRAM_LEVEL STUDENT_LEVEL |
NO NO NO |
NA |
| SORLCUR_LMOD_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_CURRICULUM |
SOURCE SOURCE |
NO NO |
NA |
| SORLCUR_PIDM |
NA |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS |
PERSON_UID PERSON_UID PERSON_UID |
NO NO NO |
|
| SORLCUR_PRIORITY_NO |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_CURRICULUM AS_LEARNER_CURRICULUM_FOS |
CURRICULUM_PRIORITY CURRICULUM_PRIORITY CURRICULUM_PRIORITY |
NO NO NO |
NA |
| SORLCUR_PROGRAM |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS |
PROGRAM PROGRAM PROGRAM |
NO NO NO |
NA |
| SORLCUR_RATE_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
STUDENT_RATE |
NO |
|
| SORLCUR_ROLLED_SEQNO |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_LEARNER_CURRICULUM_FOS |
OUTCOME_NUMBER OUTCOME_NUMBER |
NO NO |
NA |
| SORLCUR_ROLL_IND |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
OUTCOME_ROLL_IND |
NO |
NA |
| SORLCUR_SEQNO |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM_FOS |
CURRICULUM_SEQUENCE CURRICULUM_SEQUENCE CURRICULUM_SEQUENCE |
NO NO NO |
NA |
| SORLCUR_SITE_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
SITE |
NO |
|
| SORLCUR_START_DATE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_CURRICULUM AS_LEARNER_CURRICULUM_FOS |
START_DATE START_DATE START_DATE |
NO NO NO |
NA |
| SORLCUR_STYP_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
STUDENT_POPULATION |
NO |
|
| SORLCUR_TERM_CODE |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM_FOS |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
NO NO |
NA |
| SORLCUR_TERM_CODE_ADMIT |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_LEARNER_CURRICULUM_FOS |
ACADEMIC_PERIOD_ADMITTED ACADEMIC_PERIOD_ADMITTED |
NO NO |
NA |
| SORLCUR_TERM_CODE_CTLG |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM |
CATALOG_ACADEMIC_PERIOD CATALOG CATALOG_ACADEMIC_PERIOD |
NO NO NO |
NA |
| SORLCUR_TERM_CODE_END |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM AS_CURRICULUM_FOS |
LAST_ACTIVE_ACADEMIC_PERIOD LAST_ACTIVE_ACADEMIC_PERIOD |
NO NO |
NA |
| SORLCUR_TERM_CODE_GRAD |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM |
GRAD_ACADEMIC_PERIOD_INTENDED |
NO |
|
| SORLCUR_TERM_CODE_MATRIC |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM |
ACADEMIC_PERIOD_MATRICULATED ACADEMIC_PERIOD_MATRICULATED |
NO NO |
NA |
| SORLCUR_USER_ID |
SGASTDN |
NO |
COMPOSITE VIEW |
AS_CURRICULUM_FOS AS_CURRICULUM AS_LEARNER_CURRICULUM_FOS |
USER_ID USER_ID USER_ID |
NO NO NO |
NA |