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

Source Column Source Form Target Type Target Target Column Calculation Formula
SORLCUR_ACTIVITY_DATE SGASTDN       NA
SORLCUR_ACYR_CODE SGASTDN        
SORLCUR_ADMT_CODE SGASTDN

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

RECRUITMENT_INFORMATION

ADMISSIONS_POPULATION

ADMISSIONS_POPULATION

ADMISSION_POPULATION

NA
SORLCUR_APPL_KEY_SEQNO SGASTDN       NA
SORLCUR_APPL_SEQNO SGASTDN       NA
SORLCUR_CACT_CODE SGASTDN       NA
SORLCUR_CAMP_CODE SGASTDN

REPORTING VIEW

ACADEMIC_OUTCOME_SLOT

GOVERNMENT_STUDENT

ACADEMIC_OUTCOME

FIELD_OF_STUDY

GOVERNMENT_ACADEMIC_OUTCOME

GOVERNMENT_ADMISSIONS

ACADEMIC_OUTCOME_SLOT

COMBINED_ACADEMIC_OUTCOME

ACADEMIC_OUTCOME_SLOT

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

ADMISSIONS_APPLICATION

RECRUITMENT_INFORMATION

CAMPUS_1

CAMPUS

CAMPUS

CAMPUS

CAMPUS

CAMPUS

CAMPUS_3

CAMPUS

CAMPUS_2

CAMPUS

CAMPUS

CAMPUS

CAMPUS

NA
SORLCUR_COLL_CODE SGASTDN

REPORTING VIEW

ACADEMIC_STUDY

GOVERNMENT_ADMISSIONS

ACADEMIC_OUTCOME_SLOT

ACADEMIC_OUTCOME_SLOT

ADMISSIONS_APPLICATION

GOVERNMENT_ACADEMIC_OUTCOME

ACADEMIC_STUDY_EXTENDED

FIELD_OF_STUDY

GOVERNMENT_STUDENT

ACADEMIC_OUTCOME_SLOT

RECRUITMENT_INFORMATION

COLLEGE

COLLEGE

COLLEGE_1

COLLEGE_2

COLLEGE

COLLEGE

COLLEGE

COLLEGE

COLLEGE

COLLEGE_3

COLLEGE

 
SORLCUR_CURRENT_CDE TBD        
SORLCUR_DEGC_CODE SGASTDN

REPORTING VIEW

ACADEMIC_STUDY

ACADEMIC_STUDY_EXTENDED

GOVERNMENT_ADMISSIONS

ACADEMIC_OUTCOME_SLOT

RECRUITMENT_INFORMATION

ACADEMIC_OUTCOME

FIELD_OF_STUDY

GOVERNMENT_ACADEMIC_OUTCOME

ACADEMIC_OUTCOME_SLOT

ADMISSIONS_APPLICATION

REGISTRATION_PLAN

ACADEMIC_OUTCOME_SLOT

GOVERNMENT_STUDENT

DEGREE

DEGREE

DEGREE

OUTCOME_2

DEGREE

DEGREE

DEGREE

DEGREE

OUTCOME_1

DEGREE

DEGREE

OUTCOME_3

DEGREE

NA
SORLCUR_END_DATE SGASTDN       NA
SORLCUR_EXP_GRAD_DATE SGASTDN

REPORTING VIEW

FIELD_OF_STUDY

FIELD_OF_STUDY

 
SORLCUR_KEY_SEQNO SGASTDN

REPORTING VIEW

FIELD_OF_STUDY

SOURCE_SEQUENCE_NUMBER

NA
SORLCUR_LEAV_CODE SGASTDN        
SORLCUR_LEAV_FROM_DATE SGASTDN        
SORLCUR_LEAV_TO_DATE SGASTDN        
SORLCUR_LEVL_CODE SGASTDN

REPORTING VIEW

ACADEMIC_OUTCOME_SLOT

GOVERNMENT_ACADEMIC_OUTCOME

ACADEMIC_OUTCOME_SLOT

ACADEMIC_OUTCOME_SLOT

COMBINED_ACADEMIC_OUTCOME

FIELD_OF_STUDY

GOVERNMENT_STUDENT

GOVERNMENT_FINANCIAL_AID

ACADEMIC_STUDY_EXTENDED

ADMISSIONS_APPLICATION

RECRUITMENT_INFORMATION

ACADEMIC_OUTCOME_SLOT

ACADEMIC_STUDY

GOVERNMENT_ADMISSIONS

REGISTRATION_PLAN

STUDENT_LEVEL_2

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL_1

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL_3

STUDENT_LEVEL

STUDENT_LEVEL

STUDENT_LEVEL

NA
SORLCUR_LMOD_CODE SGASTDN

REPORTING VIEW

FIELD_OF_STUDY

SOURCE

NA
SORLCUR_PIDM NA        
SORLCUR_PRIORITY_NO SGASTDN

REPORTING VIEW

ADMISSIONS_APPLICATION

ACADEMIC_OUTCOME

ACADEMIC_STUDY_EXTENDED

FIELD_OF_STUDY

ACADEMIC_STUDY

RECRUITMENT_INFORMATION

CURRICULUM_PRIORITY_NUMBER

CURRICULUM_PRIORITY_NUMBER

CURRICULUM_PRIORITY_NUMBER

CURRICULUM_PRIORITY

CURRICULUM_PRIORITY_NUMBER

CURRICULUM_PRIORITY_NUMBER

NA
SORLCUR_PROGRAM SGASTDN

REPORTING VIEW

ACADEMIC_STUDY

FIELD_OF_STUDY

RECRUITMENT_INFORMATION

ACADEMIC_OUTCOME_SLOT

ADMISSIONS_APPLICATION

GOVERNMENT_ADMISSIONS

GOVERNMENT_STUDENT

ACADEMIC_OUTCOME_SLOT

ACADEMIC_OUTCOME_SLOT

COMBINED_ACADEMIC_OUTCOME

ACADEMIC_STUDY_EXTENDED

GOVERNMENT_ACADEMIC_OUTCOME

PROGRAM

PROGRAM

PROGRAM

PROGRAM_2

PROGRAM

PROGRAM

PROGRAM

PROGRAM_1

PROGRAM_3

PROGRAM

PROGRAM

PROGRAM

NA
SORLCUR_RATE_CODE SGASTDN        
SORLCUR_ROLLED_SEQNO SGASTDN

REPORTING VIEW

STUDENT

STUDENT_EXTENDED

OUTCOME_NUMBER

OUTCOME_NUMBER

NA
SORLCUR_ROLL_IND SGASTDN       NA
SORLCUR_SEQNO SGASTDN       NA
SORLCUR_SITE_CODE SGASTDN        
SORLCUR_START_DATE SGASTDN

REPORTING VIEW

ACADEMIC_STUDY

ADMISSIONS_APPLICATION

RECRUITMENT_INFORMATION

ACADEMIC_STUDY_EXTENDED

START_DATE

START_DATE

START_DATE

START_DATE

NA
SORLCUR_STYP_CODE SGASTDN        
SORLCUR_TERM_CODE SGASTDN       NA
SORLCUR_TERM_CODE_ADMIT SGASTDN

REPORTING VIEW

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY

ACADEMIC_PERIOD_ADMITTED

ACADEMIC_PERIOD_ADMITTED

NA
SORLCUR_TERM_CODE_CTLG SGASTDN

REPORTING VIEW

ACADEMIC_STUDY_EXTENDED

ACADEMIC_STUDY

CATALOG_ACADEMIC_PERIOD

CATALOG_ACADEMIC_PERIOD

NA
SORLCUR_TERM_CODE_END SGASTDN       NA
SORLCUR_TERM_CODE_GRAD SGASTDN        
SORLCUR_TERM_CODE_MATRIC SGASTDN

REPORTING VIEW

ACADEMIC_STUDY_EXTENDED

GOVERNMENT_STUDENT

ACADEMIC_STUDY

ACADEMIC_PERIOD_MATRICULATED

ACADEMIC_PERIOD_MATRICULATED

ACADEMIC_PERIOD_MATRICULATED

NA
SORLCUR_USER_ID SGASTDN       NA


Ver: 9.0