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

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

REPORTING VIEW

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION

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

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

NA
SORPCOL_PIDM NA

REPORTING VIEW

PREVIOUS_EDUCATION

PREVIOUS_EDUCATION_ATTENDANCE

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PERSON_UID

PERSON_UID

PERSON_UID

PERSON_UID

NA
SORPCOL_SBGI_CODE SOAPCOL

REPORTING VIEW

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

NA
SORPCOL_TRANS_RECV_DATE SOAPCOL

REPORTING VIEW

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

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.0