Reporting View Source: SORPCOL

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
SORPCOL_ACTIVITY_DATE	TBD	PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION	EDUCATION_ACTIVITY_DATE EDUCATION_ACTIVITY_DATE
SORPCOL_OFFICIAL_TRANS	SOAPCOL	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PRE_STUDENT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	PS_OFFICIAL_TRANSCRIPT_IND_1 OFFICIAL_TRANSCRIPT_IND PS_OFFICIAL_TRANSCRIPT_IND_2 PS_OFFICIAL_TRANSCRIPT_IND PS_OFFICIAL_TRANSCRIPT_IND_3 SS_OFFICIAL_TRANSCRIPT_IND
SORPCOL_PIDM	NA	PREVIOUS_EDUCATION_ATTENDANCE COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT	PERSON_UID PERSON_UID PERSON_UID
SORPCOL_SBGI_CODE	SOAPCOL	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT GOVERNMENT_ADMISSIONS PREVIOUS_EDUCATION_ATTENDANCE COMBINED_ACADEMIC_OUTCOME PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	SECONDARY_SCHOOL POST_SECONDARY_SCHOOL_2 LATEST_POST_SECONDARY_SCHOOL INSTITUTION INSTITUTION POST_SECONDARY_SCHOOL_3 POST_SECONDARY_SCHOOL_1
SORPCOL_TRANS_RECV_DATE	SOAPCOL	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	SS_TRANSCRIPT_RECEIVED_DATE TRANSCRIPT_RECEIVED_DATE PS_TRANSCRIPT_RECEIVED_DATE_2 PS_TRANSCRIPT_RECEIVED_DATE_1 PS_TRANSCRIPT_RECEIVED_DATE_3
SORPCOL_TRANS_REV_DATE	SOAPCOL	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	PS_TRANSCRIPT_REVIEWED_DATE_3 PS_TRANSCRIPT_REVIEWED_DATE_1 TRANSCRIPT_REVIEWED_DATE PS_TRANSCRIPT_REVIEWED_DATE_2 SS_TRANSCRIPT_REVIEWED_DATE

Ver: 8.3