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

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_ACYR_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

GRAD_YEAR_INTENDED

 
SORLCUR_ADMT_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

ADMISSIONS_POPULATION

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_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

CAMPUS

CAMPUS

CAMPUS

NA
SORLCUR_COLL_CODE SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

COLLEGE

COLLEGE

COLLEGE

 
SORLCUR_CURRENT_CDE TBD COMPOSITE VIEW

AS_CURRICULUM

CURRENT_IND

 
SORLCUR_DEGC_CODE SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

DEGREE

DEGREE

DEGREE

NA
SORLCUR_END_DATE SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

END_DATE

END_DATE

END_DATE

NA
SORLCUR_EXP_GRAD_DATE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

EXPECTED_GRADUATION_DATE

 
SORLCUR_KEY_SEQNO SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

SOURCE_SEQUENCE_NUMBER

SOURCE_SEQUENCE_NUMBER

SOURCE_SEQUENCE_NUMBER

NA
SORLCUR_LEAV_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

LEAVE_REASON

 
SORLCUR_LEAV_FROM_DATE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

LEAVE_DATE_FROM

 
SORLCUR_LEAV_TO_DATE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

LEAVE_DATE_TO

 
SORLCUR_LEVL_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

STUDENT_LEVEL

STUDENT_LEVEL

PROGRAM_LEVEL

NA
SORLCUR_LMOD_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

SOURCE

SOURCE

NA
SORLCUR_PIDM NA COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

AS_CURRICULUM_FOS

PERSON_UID

PERSON_UID

PERSON_UID

 
SORLCUR_PRIORITY_NO SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

CURRICULUM_PRIORITY

CURRICULUM_PRIORITY

CURRICULUM_PRIORITY

NA
SORLCUR_PROGRAM SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

PROGRAM

PROGRAM

PROGRAM

NA
SORLCUR_RATE_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

STUDENT_RATE

 
SORLCUR_ROLLED_SEQNO SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

OUTCOME_NUMBER

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_SITE_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

SITE

 
SORLCUR_START_DATE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

START_DATE

START_DATE

START_DATE

NA
SORLCUR_STYP_CODE SGASTDN COMPOSITE VIEW

AS_CURRICULUM

STUDENT_POPULATION

 
SORLCUR_TERM_CODE SGASTDN COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

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

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

CATALOG_ACADEMIC_PERIOD

CATALOG_ACADEMIC_PERIOD

CATALOG

NA
SORLCUR_TERM_CODE_END SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

LAST_ACTIVE_ACADEMIC_PERIOD

LAST_ACTIVE_ACADEMIC_PERIOD

NA
SORLCUR_TERM_CODE_GRAD SGASTDN COMPOSITE VIEW

AS_CURRICULUM

GRAD_ACADEMIC_PERIOD_INTENDED

 
SORLCUR_TERM_CODE_MATRIC SGASTDN COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

ACADEMIC_PERIOD_MATRICULATED

ACADEMIC_PERIOD_MATRICULATED

NA
SORLCUR_USER_ID SGASTDN COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

USER_ID

USER_ID

USER_ID

NA


Ver: