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

Source Column Source Form Target Type Target Target Column Calculation Formula
SORLCUR_ACTIVITY_DATE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

ACTIVITY_DATE

ACTIVITY_DATE

ACTIVITY_DATE

NA
SORLCUR_ADMT_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

ADMISSIONS_POPULATION

ADMISSIONS_POPULATION

NA
SORLCUR_APPL_KEY_SEQNO SGASTDN COMPOSITE VIEW

AS_CURRICULUM

APPLICATION_NUMBER

NA
SORLCUR_APPL_SEQNO SGASTDN COMPOSITE VIEW

AS_CURRICULUM

APPLICATION_CURRIC_SEQUENCE

NA
SORLCUR_CACT_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

CURRICULUM_ACTIVITY_STATUS

NA
SORLCUR_CAMP_CODE SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM

CAMPUS

CAMPUS

CAMPUS

NA
SORLCUR_COLL_CODE SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

COLLEGE

COLLEGE

COLLEGE

 
SORLCUR_DEGC_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

DEGREE

DEGREE

DEGREE

NA
SORLCUR_END_DATE SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

END_DATE

END_DATE

END_DATE

NA
SORLCUR_KEY_SEQNO SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM

SOURCE_SEQUENCE_NUMBER

SOURCE_SEQUENCE_NUMBER

SOURCE_SEQUENCE_NUMBER

NA
SORLCUR_LEVL_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

STUDENT_LEVEL

PROGRAM_LEVEL

STUDENT_LEVEL

NA
SORLCUR_LMOD_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

SOURCE

SOURCE

NA
SORLCUR_PIDM NA COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

PERSON_UID

PERSON_UID

PERSON_UID

 
SORLCUR_PRIORITY_NO SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

CURRICULUM_PRIORITY

CURRICULUM_PRIORITY

CURRICULUM_PRIORITY

NA
SORLCUR_PROGRAM SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

PROGRAM

PROGRAM

PROGRAM

NA
SORLCUR_ROLLED_SEQNO SGASTDN COMPOSITE VIEW

AS_CURRICULUM

OUTCOME_NUMBER

NA
SORLCUR_ROLL_IND SGASTDN COMPOSITE VIEW

AS_CURRICULUM

OUTCOME_ROLL_IND

NA
SORLCUR_SEQNO SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

CURRICULUM_SEQUENCE

CURRICULUM_SEQUENCE

CURRICULUM_SEQUENCE

NA
SORLCUR_START_DATE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

START_DATE

START_DATE

START_DATE

NA
SORLCUR_TERM_CODE SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM

ACADEMIC_PERIOD

ACADEMIC_PERIOD

ACADEMIC_PERIOD

NA
SORLCUR_TERM_CODE_ADMIT SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

ACADEMIC_PERIOD_ADMITTED

ACADEMIC_PERIOD_ADMITTED

NA
SORLCUR_TERM_CODE_CTLG SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

CATALOG_ACADEMIC_PERIOD

CATALOG_ACADEMIC_PERIOD

CATALOG_ACADEMIC_PERIOD

NA
SORLCUR_TERM_CODE_END SGASTDN COMPOSITE VIEW

AS_CURRICULUM

LAST_ACTIVE_ACADEMIC_PERIOD

NA
SORLCUR_TERM_CODE_MATRIC SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

ACADEMIC_PERIOD_MATRICULATED

ACADEMIC_PERIOD_MATRICULATED

NA
SORLCUR_USER_ID SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

USER_ID

USER_ID

USER_ID

NA


Ver: 3.1