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

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

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

ACTIVITY_DATE

ACTIVITY_DATE

ACTIVITY_DATE

NO

NO

NO

NA
SORLCUR_ACYR_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

GRAD_YEAR_INTENDED

NO

 
SORLCUR_ADMT_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

ADMISSIONS_POPULATION

ADMISSIONS_POPULATION

ADMISSIONS_POPULATION

NO

NO

NO

NA
SORLCUR_APPL_KEY_SEQNO SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

APPLICATION_NUMBER

NO

NA
SORLCUR_APPL_SEQNO SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

APPLICATION_CURRIC_SEQUENCE

NO

NA
SORLCUR_CACT_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

CURRICULUM_ACTIVITY_STATUS

NO

NA
SORLCUR_CAMP_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

CAMPUS

CAMPUS

CAMPUS

NO

NO

NO

NA
SORLCUR_COLL_CODE SGASTDN NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

AS_CURRICULUM

COLLEGE

COLLEGE

COLLEGE

NO

NO

NO

 
SORLCUR_CURRENT_CDE TBD NO COMPOSITE VIEW

AS_CURRICULUM

CURRENT_IND

NO

 
SORLCUR_DEGC_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

DEGREE

DEGREE

DEGREE

NO

NO

NO

NA
SORLCUR_END_DATE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

END_DATE

END_DATE

END_DATE

NO

NO

NO

NA
SORLCUR_EXP_GRAD_DATE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

EXPECTED_GRADUATION_DATE

NO

 
SORLCUR_KEY_SEQNO SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

SOURCE_SEQUENCE_NUMBER

SOURCE_SEQUENCE_NUMBER

SOURCE_SEQUENCE_NUMBER

NO

NO

NO

NA
SORLCUR_LEAV_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

LEAVE_REASON

NO

 
SORLCUR_LEAV_FROM_DATE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

LEAVE_DATE_FROM

NO

 
SORLCUR_LEAV_TO_DATE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

LEAVE_DATE_TO

NO

 
SORLCUR_LEVL_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

STUDENT_LEVEL

PROGRAM_LEVEL

STUDENT_LEVEL

NO

NO

NO

NA
SORLCUR_LMOD_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

SOURCE

SOURCE

NO

NO

NA
SORLCUR_PIDM NA NO COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

PERSON_UID

PERSON_UID

PERSON_UID

NO

NO

NO

 
SORLCUR_PRIORITY_NO SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

CURRICULUM_PRIORITY

CURRICULUM_PRIORITY

CURRICULUM_PRIORITY

NO

NO

NO

NA
SORLCUR_PROGRAM SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

PROGRAM

PROGRAM

PROGRAM

NO

NO

NO

NA
SORLCUR_RATE_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

STUDENT_RATE

NO

 
SORLCUR_ROLLED_SEQNO SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

OUTCOME_NUMBER

OUTCOME_NUMBER

NO

NO

NA
SORLCUR_ROLL_IND SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

OUTCOME_ROLL_IND

NO

NA
SORLCUR_SEQNO SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

CURRICULUM_SEQUENCE

CURRICULUM_SEQUENCE

CURRICULUM_SEQUENCE

NO

NO

NO

NA
SORLCUR_SITE_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

SITE

NO

 
SORLCUR_START_DATE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

START_DATE

START_DATE

START_DATE

NO

NO

NO

NA
SORLCUR_STYP_CODE SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

STUDENT_POPULATION

NO

 
SORLCUR_TERM_CODE SGASTDN NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM_FOS

ACADEMIC_PERIOD

ACADEMIC_PERIOD

NO

NO

NA
SORLCUR_TERM_CODE_ADMIT SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

ACADEMIC_PERIOD_ADMITTED

ACADEMIC_PERIOD_ADMITTED

NO

NO

NA
SORLCUR_TERM_CODE_CTLG SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

CATALOG_ACADEMIC_PERIOD

CATALOG

CATALOG_ACADEMIC_PERIOD

NO

NO

NO

NA
SORLCUR_TERM_CODE_END SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

AS_CURRICULUM_FOS

LAST_ACTIVE_ACADEMIC_PERIOD

LAST_ACTIVE_ACADEMIC_PERIOD

NO

NO

NA
SORLCUR_TERM_CODE_GRAD SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM

GRAD_ACADEMIC_PERIOD_INTENDED

NO

 
SORLCUR_TERM_CODE_MATRIC SGASTDN NO COMPOSITE VIEW

AS_LEARNER_CURRICULUM_FOS

AS_CURRICULUM

ACADEMIC_PERIOD_MATRICULATED

ACADEMIC_PERIOD_MATRICULATED

NO

NO

NA
SORLCUR_USER_ID SGASTDN NO COMPOSITE VIEW

AS_CURRICULUM_FOS

AS_CURRICULUM

AS_LEARNER_CURRICULUM_FOS

USER_ID

USER_ID

USER_ID

NO

NO

NO

NA


Ver: