Reporting View Source: SORPCOL

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

**Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SORPCOL_ACTIVITY_DATE	TBD	REPORTING VIEW	PREVIOUS_EDUCATION PREVIOUS_EDUCATION_ATTENDANCE	EDUCATION_ACTIVITY_DATE EDUCATION_ACTIVITY_DATE
SORPCOL_ADMR_CODE	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION	REQUIREMENT
SORPCOL_DATA_ORIGIN	NA	REPORTING VIEW	PREVIOUS_EDUCATION	EDUCATION_DATA_ORIGIN
SORPCOL_OFFICIAL_TRANS	SOAPCOL	REPORTING VIEW	PRE_STUDENT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE	PS_OFFICIAL_TRANSCRIPT_IND PS_OFFICIAL_TRANSCRIPT_IND_1 PS_OFFICIAL_TRANSCRIPT_IND_3 SS_OFFICIAL_TRANSCRIPT_IND PS_OFFICIAL_TRANSCRIPT_IND_2 OFFICIAL_TRANSCRIPT_IND	NA
SORPCOL_PIDM	NA	REPORTING VIEW	PREVIOUS_EDUCATION PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME	PERSON_UID PERSON_UID PERSON_UID PERSON_UID	NA
SORPCOL_SBGI_CODE	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT COMBINED_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS	INSTITUTION POST_SECONDARY_SCHOOL_2 POST_SECONDARY_SCHOOL_3 SECONDARY_SCHOOL POST_SECONDARY_SCHOOL_1 INSTITUTION LATEST_POST_SECONDARY_SCHOOL	NA
SORPCOL_TRANS_RECV_DATE	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	PS_TRANSCRIPT_RECEIVED_DATE_1 TRANSCRIPT_RECEIVED_DATE SS_TRANSCRIPT_RECEIVED_DATE PS_TRANSCRIPT_RECEIVED_DATE_3 PS_TRANSCRIPT_RECEIVED_DATE_2	NA
SORPCOL_TRANS_REV_DATE	SOAPCOL	REPORTING VIEW	PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT PREVIOUS_EDUCATION_SLOT	PS_TRANSCRIPT_REVIEWED_DATE_3 PS_TRANSCRIPT_REVIEWED_DATE_1 PS_TRANSCRIPT_REVIEWED_DATE_2 SS_TRANSCRIPT_REVIEWED_DATE	NA
SORPCOL_USER_ID	NA	REPORTING VIEW	PREVIOUS_EDUCATION	EDUCATION_USER_ID

Ver: 9.1