Reporting View Source: SORTEST

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SORTEST_ACTIVITY_DATE	NA	REPORTING VIEW	TEST	TEST_ACTIVITY_DATE
SORTEST_ADMR_CODE	SOATEST	REPORTING VIEW	TEST	REQUIREMENT
SORTEST_APPL_NO	SOATEST	REPORTING VIEW	TEST	TEST_ASSOCIATED_APPL_NUMBER
SORTEST_DATA_ORIGIN	NA	REPORTING VIEW	TEST	TEST_DATA_ORIGIN
SORTEST_EQUIV_IND	SOATEST	REPORTING VIEW	C_TEST TEST	EQUIVALENCY_IND EQUIVALENCY_IND	NA
SORTEST_PIDM	NA	REPORTING VIEW	C_TEST TEST C_TEST_SLOT TEST_SLOT	PERSON_UID PERSON_UID PERSON_UID PERSON_UID	NA
SORTEST_RCRV_IND	SOATEST	REPORTING VIEW	C_TEST TEST	RECENTERED_OR_REVISED_IND RECENTERED_OR_REVISED_IND	NA
SORTEST_SAT_ESSAY_ID	SOATEST	REPORTING VIEW	TEST	TEST_SAT_ESSAY_ID
SORTEST_SAT_ORIG_SCORE	SOATEST	REPORTING VIEW	TEST C_TEST	ORIGINAL_SCORE ORIGINAL_SCORE	NA
SORTEST_TADM_CODE	SOATEST	REPORTING VIEW	C_TEST TEST	TEST_ADMIN_TYPE TEST_ADMIN_TYPE	NA
SORTEST_TEAC_CODE	SOATEST	REPORTING VIEW	C_TEST TEST	TEST_ACCOMODATION TEST_ACCOMODATION	NA
SORTEST_TEFR_CODE	SOATEST	REPORTING VIEW	TEST C_TEST	TEST_FORM TEST_FORM	NA
SORTEST_TEIN_CODE	SOATEST	REPORTING VIEW	TEST C_TEST	INSTRUMENT INSTRUMENT	NA
SORTEST_TEPR_CODE	SOATEST	REPORTING VIEW	TEST C_TEST	TEST_PURPOSE TEST_PURPOSE	NA
SORTEST_TERM_CODE_ENTRY	SOATEST	REPORTING VIEW	TEST	TEST_ASSOCIATED_ACAD_PERIOD
SORTEST_TESC_CODE	SOATEST	REPORTING VIEW	GOVERNMENT_ADMISSIONS TEST_SLOT C_TEST_SLOT C_GOVERNMENT_ADMISSIONS C_TEST GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS TEST_SLOT C_GOVERNMENT_ADMISSIONS TEST_SLOT C_TEST_SLOT C_GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS TEST_SLOT C_TEST_SLOT TEST_SLOT C_TEST_SLOT C_GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS TEST C_TEST_SLOT C_TEST_SLOT C_GOVERNMENT_ADMISSIONS TEST_SLOT TEST_SLOT C_TEST_SLOT C_GOVERNMENT_ADMISSIONS C_GOVERNMENT_ADMISSIONS	TEST1 TEST4 TEST7 TEST7 TEST TEST4 TEST5 TEST2 TEST5 TEST7 TEST5 TEST6 TEST7 TEST5 TEST4 TEST3 TEST1 TEST1 TEST2 TEST3 TEST6 TEST TEST2 TEST3 TEST4 TEST1 TEST6 TEST6 TEST2 TEST3	NA
SORTEST_TEST_DATE	SOATEST	REPORTING VIEW	C_TEST_SLOT TEST_SLOT TEST_SLOT TEST_SLOT TEST_SLOT TEST_SLOT C_TEST_SLOT C_TEST_SLOT C_TEST_SLOT C_TEST_SLOT TEST_SLOT C_TEST C_TEST_SLOT TEST TEST_SLOT C_TEST_SLOT	TEST_DATE4 TEST_DATE3 TEST_DATE4 TEST_DATE6 TEST_DATE1 TEST_DATE2 TEST_DATE1 TEST_DATE5 TEST_DATE6 TEST_DATE2 TEST_DATE5 TEST_DATE TEST_DATE7 TEST_DATE TEST_DATE7 TEST_DATE3	NA
SORTEST_TEST_SCORE	SOATEST	REPORTING VIEW	TEST_SLOT C_GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS C_TEST C_TEST_SLOT C_TEST_SLOT C_TEST_SLOT TEST TEST_SLOT TEST_SLOT TEST_SLOT C_GOVERNMENT_ADMISSIONS C_GOVERNMENT_ADMISSIONS TEST_SLOT GOVERNMENT_ADMISSIONS C_TEST_SLOT C_TEST_SLOT TEST_SLOT GOVERNMENT_ADMISSIONS C_GOVERNMENT_ADMISSIONS C_GOVERNMENT_ADMISSIONS C_TEST_SLOT C_TEST_SLOT C_GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS C_GOVERNMENT_ADMISSIONS TEST_SLOT GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS GOVERNMENT_ADMISSIONS	TEST_SCORE5 TEST_SCORE7 TEST_SCORE5 TEST_SCORE TEST_SCORE3 TEST_SCORE5 TEST_SCORE6 TEST_SCORE TEST_SCORE1 TEST_SCORE2 TEST_SCORE4 TEST_SCORE5 TEST_SCORE6 TEST_SCORE3 TEST_SCORE2 TEST_SCORE1 TEST_SCORE2 TEST_SCORE7 TEST_SCORE1 TEST_SCORE2 TEST_SCORE4 TEST_SCORE4 TEST_SCORE7 TEST_SCORE3 TEST_SCORE6 TEST_SCORE1 TEST_SCORE6 TEST_SCORE3 TEST_SCORE4 TEST_SCORE7	NA
SORTEST_TSRC_CODE	SOATEST	REPORTING VIEW	TEST C_TEST	TEST_SOURCE TEST_SOURCE	NA
SORTEST_USER_ID	NA	REPORTING VIEW	TEST	TEST_ENTRY_USER_ID

Ver: 8.5