Composite View Source: SORLFOS

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SORLFOS_ACTIVITY_DATE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	ACTIVITY_DATE	NA
SORLFOS_CACT_CODE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	FIELD_OF_STUDY_ACTIVITY_STATUS	NA
SORLFOS_CSTS_CODE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	CURRICULUM_CHANGE_REASON	NA
SORLFOS_DEPT_CODE	SGASTDN	COMPOSITE VIEW	AS_CURRICULUM_FOS AS_CURRICULUM_FOS AS_CURRICULUM_FOS AS_CURRICULUM_FOS AS_FIELD_OF_STUDY AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS	DEPARTMENT FOURTH_DEPARTMENT SECOND_DEPARTMENT THIRD_DEPARTMENT DEPARTMENT DEPARTMENT FOURTH_DEPARTMENT SECOND_DEPARTMENT THIRD_DEPARTMENT	NA
SORLFOS_END_DATE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	END_DATE	NA
SORLFOS_LCUR_SEQNO	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	CURRICULUM_SEQUENCE	NA
SORLFOS_LFST_CODE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	FIELD_OF_STUDY_TYPE	NA
SORLFOS_MAJR_CODE	SGASTDN	COMPOSITE VIEW	L LEARNER_CURRICULUM_FOS_COMP_target.html">AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS AS_LEARNER_CURRICULUM_FOS	U ULUM_FOS_COMP_target.html#THIRD_CONCENTRATION">THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR	NA
SORLFOS_MAJR_CODE_ATTACH	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	CONCENTRATION_MAJOR	NA
SORLFOS_PIDM	NA	COMPOSITE VIEW	AS_FIELD_OF_STUDY	PERSON_UID
SORLFOS_PRIORITY_NO	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	PRIORITY	NA
SORLFOS_ROLLED_SEQNO	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	OUTCOME_NUMBER	NA
SORLFOS_SEQNO	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	SEQUENCE_NUMBER	NA
SORLFOS_START_DATE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	START_DATE	NA
SORLFOS_TERM_CODE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	ACADEMIC_PERIOD	NA
SORLFOS_TERM_CODE_CTLG	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	CATALOG_ACADEMIC_PERIOD	NA
SORLFOS_TERM_CODE_END	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	LAST_ACTIVE_ACADEMIC_PERIOD	NA
SORLFOS_TMST_CODE	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	CURRENT_TIME_STATUS	NA
SORLFOS_USER_ID	SGASTDN	COMPOSITE VIEW	AS_FIELD_OF_STUDY	USER_ID	NA

Ver: 8.1