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_OFFICIAL_TRANS SOAPCOL

REPORTING VIEW

PRE_STUDENT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PS_OFFICIAL_TRANSCRIPT_IND

PS_OFFICIAL_TRANSCRIPT_IND_2

PS_OFFICIAL_TRANSCRIPT_IND_1

OFFICIAL_TRANSCRIPT_IND

PS_OFFICIAL_TRANSCRIPT_IND_3

SS_OFFICIAL_TRANSCRIPT_IND

NA
SORPCOL_PIDM NA

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

COMBINED_ACADEMIC_OUTCOME

PERSON_UID

PERSON_UID

PERSON_UID

NA
SORPCOL_SBGI_CODE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

GOVERNMENT_ADMISSIONS

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

COMBINED_ACADEMIC_OUTCOME

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

POST_SECONDARY_SCHOOL_1

LATEST_POST_SECONDARY_SCHOOL

SECONDARY_SCHOOL

INSTITUTION

INSTITUTION

POST_SECONDARY_SCHOOL_3

POST_SECONDARY_SCHOOL_2

NA
SORPCOL_TRANS_RECV_DATE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

SS_TRANSCRIPT_RECEIVED_DATE

PS_TRANSCRIPT_RECEIVED_DATE_2

PS_TRANSCRIPT_RECEIVED_DATE_3

PS_TRANSCRIPT_RECEIVED_DATE_1

TRANSCRIPT_RECEIVED_DATE

NA
SORPCOL_TRANS_REV_DATE SOAPCOL

REPORTING VIEW

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_SLOT

PREVIOUS_EDUCATION_ATTENDANCE

PS_TRANSCRIPT_REVIEWED_DATE_2

PS_TRANSCRIPT_REVIEWED_DATE_3

SS_TRANSCRIPT_REVIEWED_DATE

PS_TRANSCRIPT_REVIEWED_DATE_1

TRANSCRIPT_REVIEWED_DATE

NA


Ver: 8.0