Reporting View Source: SORLFOS

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: SORLFOS Student Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SORLFOS_ACTIVITY_DATE	SGASTDN				NA
SORLFOS_CACT_CODE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY FIELD_OF_STUDY	CURRICULUM_ACTIVITY_STATUS FIELD_OF_STUDY_ACTIVITY_STATUS	NA
SORLFOS_CSTS_CODE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	CURRICULUM_CHANGE_REASON	NA
SORLFOS_DEPT_CODE	SGASTDN	REPORTING VIEW	ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION FIELD_OF_STUDY GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT GOVERNMENT_STUDENT GOVERNMENT_STUDENT GOVERNMENT_STUDENT RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION RECRUITMENT_INFORMATION COMBINED_ACADEMIC_OUTCOME COMBINED_ACADEMIC_OUTCOME	0 000" FACE="Arial" SIZE="2">THIRD_DEPARTMENT DEPARTMENT SECOND_DEPARTMENT	NA
SORLFOS_END_DATE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	END_DATE	NA
SORLFOS_LCUR_SEQNO	SGASTDN				NA
SORLFOS_LFST_CODE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	FIELD_OF_STUDY_TYPE	NA
SORLFOS_MAJR_CODE	SGASTDN	REPORTING VIEW	= ="2">ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION ADMISSIONS_APPLICATION R R="#000000" FACE="Arial" SIZE="2">SECONDARY_MAJOR_2 SECONDARY_MAJOR_3 SECONDARY_MAJOR_CONC1_1 SECONDARY_MAJOR_CONC1_2 SECONDARY_MAJOR_CONC1_3 SECONDARY_MAJOR_CONC2_1 SECONDARY_MAJOR_CONC2_2 SECONDARY_MAJOR_CONC2_3 SECONDARY_MAJOR_CONC3_1 SECONDARY_MAJOR_CONC3_2 SECONDARY_MAJOR_CONC3_3 SECONDARY_MINOR_1 SECONDARY_MINOR_2 SECONDARY_MINOR_3 FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 FOURTH_MINOR MAJOR SECOND_CONCENTRATION SECOND_MAJOR SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 SECOND_MINOR THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR FIRST_CONCENTRATION SECONDARY_MAJOR_2 SECONDARY_MAJOR_3 SECONDARY_MAJOR_CONC1_1 SECONDARY_MAJOR_CONC1_2 SECONDARY_MAJOR_CONC1_3 SECONDARY_MAJOR_CONC2_1 SECONDARY_MAJOR_CONC2_2 SECONDARY_MAJOR_CONC2_3 SECONDARY_MAJOR_CONC3_1 SECONDARY_MAJOR_CONC3_2 SECONDARY_MAJOR_CONC3_3 SECONDARY_MINOR_1 SECONDARY_MINOR_2 SECONDARY_MINOR_3 FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 FOURTH_MINOR MAJOR SECOND_CONCENTRATION SECOND_MAJOR SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 SECOND_MINOR THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 FOURTH_MINOR MAJOR SECOND_CONCENTRATION SECOND_MAJOR SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 SECOND_MINOR THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_M R="#000000" FACE="Arial" SIZE="2">SECONDARY_MAJOR_2 SECONDARY_MAJOR_3 SECONDARY_MAJOR_CONC1_1 SECONDARY_MAJOR_CONC1_2 SECONDARY_MAJOR_CONC1_3 SECONDARY_MAJOR_CONC2_1 SECONDARY_MAJOR_CONC2_2 SECONDARY_MAJOR_CONC2_3 SECONDARY_MAJOR_CONC3_1 SECONDARY_MAJOR_CONC3_2 SECONDARY_MAJOR_CONC3_3 SECONDARY_MINOR_1 SECONDARY_MINOR_2 SECONDARY_MINOR_3 FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 FOURTH_MINOR MAJOR SECOND_CONCENTRATION SECOND_MAJOR SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 SECOND_MINOR THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 FOURTH_MINOR MAJOR SECOND_CONCENTRATION SECOND_MAJOR SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 SECOND_MINOR THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_M R="#000000" FACE="Arial" SIZE="2">SECONDARY_MAJOR_2 SECONDARY_MAJOR_3 SECONDARY_MAJOR_CONC1_1 SECONDARY_MAJOR_CONC1_2 SECONDARY_MAJOR_CONC1_3 SECONDARY_MAJOR_CONC2_1 SECONDARY_MAJOR_CONC2_2 SECONDARY_MAJOR_CONC2_3 SECONDARY_MAJOR_CONC3_1 SECONDARY_MAJOR_CONC3_2 SECONDARY_MAJOR_CONC3_3 SECONDARY_MINOR_1 SECONDARY_MINOR_2 SECONDARY_MINOR_3 FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 FOURTH_MINOR MAJOR SECOND_CONCENTRATION SECOND_MAJOR SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 SECOND_MINOR THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_MAJOR_CONC_1 FOURTH_MAJOR_CONC_2 FOURTH_MAJOR_CONC_3 FOURTH_MINOR MAJOR SECOND_CONCENTRATION SECOND_MAJOR SECOND_MAJOR_CONC_1 SECOND_MAJOR_CONC_2 SECOND_MAJOR_CONC_3 SECOND_MINOR THIRD_CONCENTRATION THIRD_MAJOR THIRD_MAJOR_CONC_1 THIRD_MAJOR_CONC_2 THIRD_MAJOR_CONC_3 THIRD_MINOR FIRST_CONCENTRATION FIRST_MINOR FOURTH_MAJOR FOURTH_M	NA
SORLFOS_MAJR_CODE_ATTACH	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	CONCENTRATION_MAJOR	NA
SORLFOS_PIDM	NA	REPORTING VIEW	FIELD_OF_STUDY	PERSON_UID
SORLFOS_PRIORITY_NO	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	PRIORITY	NA
SORLFOS_ROLLED_SEQNO	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	OUTCOME_NUMBER	NA
SORLFOS_SEQNO	SGASTDN				NA
SORLFOS_START_DATE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	START_DATE	NA
SORLFOS_TERM_CODE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	ACADEMIC_PERIOD	NA
SORLFOS_TERM_CODE_CTLG	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	CATALOG_ACADEMIC_PERIOD	NA
SORLFOS_TERM_CODE_END	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	LAST_ACTIVE_ACADEMIC_PERIOD	NA
SORLFOS_TMST_CODE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	CURRENT_TIME_STATUS	NA
SORLFOS_USER_ID	SGASTDN				NA

Ver: 8.1