Composite View Source: SORLCUR

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

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

Ver: 8.3