Composite View Source: SORLFOS

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
SORLFOS_ACTIVITY_DATE	SGASTDN	AS_FIELD_OF_STUDY	ACTIVITY_DATE
SORLFOS_CACT_CODE	SGASTDN	AS_FIELD_OF_STUDY	FIELD_OF_STUDY_ACTIVITY_STATUS
SORLFOS_CSTS_CODE	SGASTDN	AS_FIELD_OF_STUDY	CURRICULUM_CHANGE_REASON
SORLFOS_DEPT_CODE	SGASTDN	AS_CURRICULUM_FOS AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_CURRICULUM_FOS AS_CURRICULUM_FOS AS_FIELD_OF_STUDY AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS	FOURTH_DEPARTMENT THIRD_DEPARTMENT DEPARTMENT FOURTH_DEPARTMENT DEPARTMENT SECOND_DEPARTMENT DEPARTMENT THIRD_DEPARTMENT SECOND_DEPARTMENT
SORLFOS_END_DATE	SGASTDN	AS_FIELD_OF_STUDY	END_DATE
SORLFOS_LCUR_SEQNO	SGASTDN	AS_FIELD_OF_STUDY	CURRICULUM_SEQUENCE
SORLFOS_LFST_CODE	SGASTDN	AS_FIELD_OF_STUDY	FIELD_OF_STUDY_TYPE
SORLFOS_MAJR_CODE	SGASTDN	> > AS_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS	HREF="AS_LEARNER_CURRICULUM_FOS_COMP_target.html#THIRD_MAJOR">THIRD_MAJOR THIRD_MAJOR_CONC_2 FOURTH_MAJOR_CONC_1 SECOND_MINOR SECOND_MAJOR SECOND_MAJOR_CONC_2
SORLFOS_MAJR_CODE_ATTACH	SGASTDN	AS_FIELD_OF_STUDY	CONCENTRATION_MAJOR
SORLFOS_PIDM	NA	AS_FIELD_OF_STUDY	PERSON_UID
SORLFOS_PRIORITY_NO	SGASTDN	AS_FIELD_OF_STUDY	PRIORITY
SORLFOS_ROLLED_SEQNO	SGASTDN	AS_FIELD_OF_STUDY	OUTCOME_NUMBER
SORLFOS_SEQNO	SGASTDN	AS_FIELD_OF_STUDY	SEQUENCE_NUMBER
SORLFOS_START_DATE	SGASTDN	AS_FIELD_OF_STUDY	START_DATE
SORLFOS_TERM_CODE	SGASTDN	AS_FIELD_OF_STUDY	ACADEMIC_PERIOD
SORLFOS_TERM_CODE_CTLG	SGASTDN	AS_FIELD_OF_STUDY	CATALOG_ACADEMIC_PERIOD
SORLFOS_TERM_CODE_END	SGASTDN	AS_FIELD_OF_STUDY	LAST_ACTIVE_ACADEMIC_PERIOD
SORLFOS_TMST_CODE	SGASTDN	AS_FIELD_OF_STUDY	CURRENT_TIME_STATUS
SORLFOS_USER_ID	SGASTDN	AS_FIELD_OF_STUDY	USER_ID

Ver: 8.3