Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SORPCOL Student Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: SORPCOL - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
SORPCOL_ACTIVITY_DATE TBD NO

REPORTING VIEW

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION

EDUCATION_ACTIVITY_DATE

EDUCATION_ACTIVITY_DATE

NO

NO

 
SORPCOL_ADMR_CODE SOAPCOL NO

REPORTING VIEW

PREVIOUS_EDUCATION

REQUIREMENT

NO

 
SORPCOL_DATA_ORIGIN NA NO

REPORTING VIEW

PREVIOUS_EDUCATION

EDUCATION_DATA_ORIGIN

NO

 
SORPCOL_OFFICIAL_TRANS SOAPCOL NO

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PRE_STUDENT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PS_OFFICIAL_TRANSCRIPT_IND_2

PS_OFFICIAL_TRANSCRIPT_IND_1

SS_OFFICIAL_TRANSCRIPT_IND

PS_OFFICIAL_TRANSCRIPT_IND

OFFICIAL_TRANSCRIPT_IND

PS_OFFICIAL_TRANSCRIPT_IND_3

NO

NO

NO

NO

NO

NO

NA
SORPCOL_PIDM NA NO

REPORTING VIEW

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION

COMBINED_ACADEMIC_OUTCOME

PERSON_UID

PERSON_UID

PERSON_UID

PERSON_UID

NO

NO

NO

NO

NA
SORPCOL_SBGI_CODE SOAPCOL NO

REPORTING VIEW

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

LATEST_POST_SECONDARY_SCHOOL

INSTITUTION

POST_SECONDARY_SCHOOL_2

INSTITUTION

POST_SECONDARY_SCHOOL_1

POST_SECONDARY_SCHOOL_3

SECONDARY_SCHOOL

NO

NO

NO

NO

NO

NO

NO

NA
SORPCOL_TRANS_RECV_DATE SOAPCOL NO

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

SS_TRANSCRIPT_RECEIVED_DATE

PS_TRANSCRIPT_RECEIVED_DATE_2

PS_TRANSCRIPT_RECEIVED_DATE_1

PS_TRANSCRIPT_RECEIVED_DATE_3

NO

NO

NO

NO

NA
SORPCOL_TRANS_REV_DATE SOAPCOL NO

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

SS_TRANSCRIPT_REVIEWED_DATE

PS_TRANSCRIPT_REVIEWED_DATE_1

PS_TRANSCRIPT_REVIEWED_DATE_2

PS_TRANSCRIPT_REVIEWED_DATE_3

NO

NO

NO

NO

NA
SORPCOL_USER_ID NA NO

REPORTING VIEW

PREVIOUS_EDUCATION

EDUCATION_USER_ID

NO

 


Ver: 9.2