Composite View Source: SHRTCKN

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SHRTCKN Student

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
SHRTCKN_CAMP_CODE	SHATCKC	AS_STUDENT_COURSE_HISTORY	COURSE_CAMPUS
SHRTCKN_COLL_CODE	SHATCKC	AS_STUDENT_COURSE_HISTORY	COURSE_COLLEGE
SHRTCKN_CRN	SHATCKC	AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_GRADE_CHG	COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER
SHRTCKN_CRSE_NUMB	SHATCKC	AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY	COURSE_NUMBER COURSE_NUMBER COURSE_NUMBER
SHRTCKN_CRSE_TITLE	SHATCKC	AS_STUDENT_COURSE_HISTORY	COURSE_TITLE_SHORT
SHRTCKN_DEPT_CODE	SHATCKC	AS_STUDENT_COURSE_HISTORY	COURSE_DEPARTMENT
SHRTCKN_DIVS_CODE	SHATCKC	AS_STUDENT_COURSE_HISTORY	COURSE_DIVISION
SHRTCKN_LONG_COURSE_TITLE	SCASYLB	AS_STUDENT_COURSE_HISTORY	COURSE_TITLE_LONG
SHRTCKN_PIDM	NA	AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY	PERSON_UID PERSON_UID
SHRTCKN_PTRM_CODE	SHATCKC	AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY	SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD
SHRTCKN_REG_SEQ	NA	AS_STUDENT_COURSE_HISTORY	REGISTRATION_SEQUENCE_NUMBER
SHRTCKN_REPEAT_COURSE_IND	SHATCKC	AS_STUDENT_COURSE_HISTORY	REPEAT_COURSE_IND
SHRTCKN_SCHD_CODE	SHATCKC	AS_STUDENT_COURSE_HISTORY	SCHEDULE_TYPE
SHRTCKN_SEQ_NO	NA	AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY	COURSE_SEQUENCE_NUMBER COURSE_SEQ_NO
SHRTCKN_SEQ_NUMB	SHATCKC	AS_STUDENT_COURSE_HISTORY	COURSE_SECTION_NUMBER
SHRTCKN_SUBJ_CODE	SHATCKC	AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY	SUBJECT SUBJECT SUBJECT
SHRTCKN_TERM_CODE	SHATCKC	AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_HISTORY	ACADEMIC_PERIOD ACADEMIC_PERIOD

Ver: 8.3