Composite View Source: SORLCUR

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SORLCUR Student

**Banner Operational Data Store**
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

Ver: