Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SORLFOS Student
SGHE Banner Operational Data Store Composite View Source: SORLFOS - NULL

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_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_FIELD_OF_STUDY

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

DEPARTMENT

DEPARTMENT

SECOND_DEPARTMENT

FOURTH_DEPARTMENT

THIRD_DEPARTMENT

SECOND_DEPARTMENT

DEPARTMENT

FOURTH_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 > >

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

" "AS_CURRICULUM_FOS_COMP_target.html#SECOND_MAJOR_CONC_1">SECOND_MAJOR_CONC_1

SECOND_MAJOR_CONC_2

THIRD_MAJOR

THIRD_MAJOR_CONC_2

FOURTH_MAJOR_CONC_1

SECOND_MAJOR

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.0