RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: SORLFOS Student Composite View Reports
SGHE Operational Data Store Composite View Source: SORLFOS

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_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_FIELD_OF_STUDY

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

DEPARTMENT

DEPARTMENT

FOURTH_DEPARTMENT

THIRD_DEPARTMENT

SECOND_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_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_FIELD_OF_STUDY

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM_FOS

THIRD_MAJOR_CONC_2

FOURTH_MINOR

SECOND_MAJOR

THIRD_MINOR

FOURTH_MAJOR_CONC_3

THIRD_MAJOR_CONC_1

FOURTH_MAJOR_CONC_3

SECOND_MAJOR_CONC_3

THIRD_MAJOR_CONC_3

FIRST_MAJOR_CONC_3

FIRST_MINOR

FOURTH_MAJOR

FOURTH_MAJOR

FOURTH_MINOR

SECOND_MAJOR_CONC_1

THIRD_MAJOR_CONC_3

FOURTH_MAJOR_CONC_2

MAJOR

FOURTH_MAJOR_CONC_2

MAJOR

FIRST_MAJOR_CONC_2

THIRD_MAJOR_CONC_1

FIRST_MAJOR_CONC_2

FIRST_MINOR

SECOND_MAJOR_CONC_2

SECOND_MAJOR_CONC_3

THIRD_MAJOR

THIRD_MINOR

FIELD_OF_STUDY

FIRST_MAJOR_CONC_1

SECOND_MINOR

FIRST_MAJOR_CONC_1

FIRST_MAJOR_CONC_3

FOURTH_MAJOR_CONC_1

SECOND_MINOR

FOURTH_MAJOR_CONC_1

SECOND_MAJOR

SECOND_MAJOR_CONC_1

SECOND_MAJOR_CONC_2

THIRD_MAJOR

THIRD_MAJOR_CONC_2

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: 3.1