Reporting View Source: SORLCUR

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

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
SORLCUR_ACTIVITY_DATE	SGASTDN	NO					NA
SORLCUR_ACYR_CODE	SGASTDN	NO
SORLCUR_ADMT_CODE	SGASTDN	NO	REPORTING VIEW	RECRUITMENT_INFORMATION ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	ADMISSION_POPULATION ADMISSIONS_POPULATION ADMISSIONS_POPULATION	NO NO NO	NA
SORLCUR_APPL_KEY_SEQNO	SGASTDN	NO					NA
SORLCUR_APPL_SEQNO	SGASTDN	NO					NA
SORLCUR_CACT_CODE	SGASTDN	NO					NA
SORLCUR_CAMP_CODE	SGASTDN	NO	REPORTING VIEW	RECRUITMENT_INFORMATION ACADEMIC_OUTCOME_SLOT GOVERNMENT_ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION GOVERNMENT_ADMISSIONS GOVERNMENT_STUDENT ACADEMIC_OUTCOME_SLOT FIELD_OF_STUDY COMBINED_ACADEMIC_OUTCOME ACADEMIC_STUDY	CAMPUS CAMPUS_1 CAMPUS CAMPUS_3 CAMPUS CAMPUS CAMPUS CAMPUS CAMPUS_2 CAMPUS CAMPUS CAMPUS	NO NO NO NO NO NO NO NO NO NO NO NO	NA
SORLCUR_COLL_CODE	SGASTDN	NO	REPORTING VIEW	ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED FIELD_OF_STUDY GOVERNMENT_ADMISSIONS RECRUITMENT_INFORMATION ACADEMIC_OUTCOME_SLOT ADMISSIONS_APPLICATION	COLLEGE COLLEGE_2 COLLEGE COLLEGE COLLEGE_1 COLLEGE COLLEGE COLLEGE COLLEGE COLLEGE COLLEGE_3 COLLEGE	NO NO NO NO NO NO NO NO NO NO NO NO
SORLCUR_CURRENT_CDE	TBD	NO
SORLCUR_DEGC_CODE	SGASTDN	NO	REPORTING VIEW	ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ADMISSIONS_APPLICATION GOVERNMENT_ACADEMIC_OUTCOME REGISTRATION_PLAN ACADEMIC_OUTCOME_SLOT GOVERNMENT_ADMISSIONS ACADEMIC_STUDY_EXTENDED FIELD_OF_STUDY ACADEMIC_STUDY GOVERNMENT_STUDENT ACADEMIC_OUTCOME_SLOT RECRUITMENT_INFORMATION	DEGREE OUTCOME_1 DEGREE DEGREE DEGREE OUTCOME_3 DEGREE DEGREE DEGREE DEGREE DEGREE OUTCOME_2 DEGREE	NO NO NO NO NO NO NO NO NO NO NO NO NO	NA
SORLCUR_END_DATE	SGASTDN	NO					NA
SORLCUR_EXP_GRAD_DATE	SGASTDN	NO	REPORTING VIEW	FIELD_OF_STUDY	FIELD_OF_STUDY	NO
SORLCUR_KEY_SEQNO	SGASTDN	NO	REPORTING VIEW	FIELD_OF_STUDY	SOURCE_SEQUENCE_NUMBER	NO	NA
SORLCUR_LEAV_CODE	SGASTDN	NO
SORLCUR_LEAV_FROM_DATE	SGASTDN	NO
SORLCUR_LEAV_TO_DATE	SGASTDN	NO
SORLCUR_LEVL_CODE	SGASTDN	NO	REPORTING VIEW	GOVERNMENT_FINANCIAL_AID ACADEMIC_OUTCOME_SLOT RECRUITMENT_INFORMATION ACADEMIC_OUTCOME_SLOT ADMISSIONS_APPLICATION GOVERNMENT_STUDENT COMBINED_ACADEMIC_OUTCOME GOVERNMENT_ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_OUTCOME_SLOT FIELD_OF_STUDY GOVERNMENT_ADMISSIONS ACADEMIC_STUDY_EXTENDED REGISTRATION_PLAN	STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL_1 STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL_2 STUDENT_LEVEL STUDENT_LEVEL_3 STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL STUDENT_LEVEL	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO	NA
SORLCUR_LMOD_CODE	SGASTDN	NO	REPORTING VIEW	FIELD_OF_STUDY	SOURCE	NO	NA
SORLCUR_PIDM	NA	NO
SORLCUR_PRIORITY_NO	SGASTDN	NO	REPORTING VIEW	ACADEMIC_OUTCOME ADMISSIONS_APPLICATION ACADEMIC_STUDY_EXTENDED FIELD_OF_STUDY RECRUITMENT_INFORMATION ACADEMIC_STUDY	CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY CURRICULUM_PRIORITY_NUMBER CURRICULUM_PRIORITY_NUMBER	NO NO NO NO NO NO	NA
SORLCUR_PROGRAM	SGASTDN	NO	REPORTING VIEW	ACADEMIC_STUDY_EXTENDED ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT ACADEMIC_OUTCOME_SLOT FIELD_OF_STUDY GOVERNMENT_ADMISSIONS RECRUITMENT_INFORMATION COMBINED_ACADEMIC_OUTCOME ACADEMIC_STUDY ADMISSIONS_APPLICATION GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT	PROGRAM PROGRAM_3 PROGRAM_1 PROGRAM_2 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM	NO NO NO NO NO NO NO NO NO NO NO NO	NA
SORLCUR_RATE_CODE	SGASTDN	NO
SORLCUR_ROLLED_SEQNO	SGASTDN	NO	REPORTING VIEW	STUDENT STUDENT_EXTENDED	OUTCOME_NUMBER OUTCOME_NUMBER	NO NO	NA
SORLCUR_ROLL_IND	SGASTDN	NO					NA
SORLCUR_SEQNO	SGASTDN	NO					NA
SORLCUR_SITE_CODE	SGASTDN	NO
SORLCUR_START_DATE	SGASTDN	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ADMISSIONS_APPLICATION RECRUITMENT_INFORMATION	START_DATE START_DATE START_DATE START_DATE	NO NO NO NO	NA
SORLCUR_STYP_CODE	SGASTDN	NO
SORLCUR_TERM_CODE	SGASTDN	NO					NA
SORLCUR_TERM_CODE_ADMIT	SGASTDN	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	ACADEMIC_PERIOD_ADMITTED ACADEMIC_PERIOD_ADMITTED	NO NO	NA
SORLCUR_TERM_CODE_CTLG	SGASTDN	NO	REPORTING VIEW	ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	CATALOG_ACADEMIC_PERIOD CATALOG_ACADEMIC_PERIOD	NO NO	NA
SORLCUR_TERM_CODE_END	SGASTDN	NO					NA
SORLCUR_TERM_CODE_GRAD	SGASTDN	NO
SORLCUR_TERM_CODE_MATRIC	SGASTDN	NO	REPORTING VIEW	GOVERNMENT_STUDENT ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED	ACADEMIC_PERIOD_MATRICULATED ACADEMIC_PERIOD_MATRICULATED ACADEMIC_PERIOD_MATRICULATED	NO NO NO	NA
SORLCUR_USER_ID	SGASTDN	NO					NA

Ver: 9.2