Reporting View Source: SORLCUR

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: SORLCUR Student Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
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_EXTENDED ACADEMIC_STUDY 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 ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION ACADEMIC_STUDY_EXTENDED	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 APP_ADMT_CURRICULUM_KSU APP_ADMT_CURRICULUM_KSU APPLIED_CURRICULUM_KSU FIELD_OF_STUDY GOVERNMENT_STUDENT ACADEMIC_STUDY_EXTENDED ACADEMIC_OUTCOME_SLOT RECRUITMENT_INFORMATION	COLLEGE COLLEGE COLLEGE_1 COLLEGE_2 COLLEGE COLLEGE ADM_COLLEGE APP_COLLEGE COLLEGE COLLEGE COLLEGE COLLEGE COLLEGE_3 COLLEGE
SORLCUR_CURRENT_CDE	TBD
SORLCUR_DEGC_CODE	SGASTDN	REPORTING VIEW	ACADEMIC_STUDY GOVERNMENT_ADMISSIONS ACADEMIC_STUDY_EXTENDED APPLIED_CURRICULUM_KSU ACADEMIC_OUTCOME_SLOT RECRUITMENT_INFORMATION APP_ADMT_CURRICULUM_KSU ACADEMIC_OUTCOME FIELD_OF_STUDY GOVERNMENT_ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ADMISSIONS_APPLICATION APP_ADMT_CURRICULUM_KSU ACADEMIC_OUTCOME_SLOT GOVERNMENT_STUDENT	DEGREE DEGREE DEGREE DEGREE OUTCOME_2 DEGREE ADM_DEGREE DEGREE DEGREE DEGREE OUTCOME_1 DEGREE APP_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 APPLIED_CURRICULUM_KSU APP_ADMT_CURRICULUM_KSU	SOURCE_SEQUENCE_NUMBER APPLICATION_NUMBER APPLICATION_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 APPLIED_CURRICULUM_KSU ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT COMBINED_ACADEMIC_OUTCOME FIELD_OF_STUDY GOVERNMENT_STUDENT APP_ADMT_CURRICULUM_KSU GOVERNMENT_FINANCIAL_AID ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION ACADEMIC_STUDY_EXTENDED ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY GOVERNMENT_ADMISSIONS	STUDENT_LEVEL_2 STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL_1 STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL_3 STUDENT_LEVEL STUDENT_LEVEL	NA
SORLCUR_LMOD_CODE	SGASTDN	REPORTING VIEW	FIELD_OF_STUDY	SOURCE	NA
SORLCUR_PIDM	NA	REPORTING VIEW	APPLIED_CURRICULUM_KSU APP_ADMT_CURRICULUM_KSU	PERSON_UID PERSON_UID
SORLCUR_PRIORITY_NO	SGASTDN	REPORTING VIEW	ADMISSIONS_APPLICATION APPLIED_CURRICULUM_KSU ACADEMIC_OUTCOME FIELD_OF_STUDY ACADEMIC_STUDY_EXTENDED ACADEMIC_STUDY RECRUITMENT_INFORMATION APP_ADMT_CURRICULUM_KSU	CURRICULUM_PRIORITY_NUMBER APPLICATION_PRIORITY_NO CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER APPLICATION_PRIORITY_NO	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 APP_ADMT_CURRICULUM_KSU GOVERNMENT_ACADEMIC_OUTCOME ACADEMIC_STUDY_EXTENDED APPLIED_CURRICULUM_KSU APP_ADMT_CURRICULUM_KSU	PROGRAM PROGRAM PROGRAM PROGRAM_2 PROGRAM PROGRAM PROGRAM PROGRAM_1 PROGRAM_3 PROGRAM ADM_PROGRAM PROGRAM PROGRAM PROGRAM APP_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	REPORTING VIEW	APPLIED_CURRICULUM_KSU APP_ADMT_CURRICULUM_KSU	APPLICATION_SEQNO APPLICATION_SEQNO	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	REPORTING VIEW	APPLIED_CURRICULUM_KSU APP_ADMT_CURRICULUM_KSU	ACADEMIC_PERIOD ACADEMIC_PERIOD	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: 8.4.1