Composite View Source: SORLCUR

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

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

Ver: 8.2