RETURN TO BANNER EDW META DATA REPORTS LIST
(Banner ODS Target Report)

SGHE Enterprise Data Warehouse Banner EDW Source: VISA - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
VISA_TYPE NO

DIMENSION TABLE



DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

NON_RESIDENT_IND

VISA_TYPE

NON_RESIDENT_IND

VISA_TYPE

ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADE CHANGE, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

NO

NO

NO

NO

VISA_TYPE_DESC NO

DIMENSION TABLE



DIMENSION TABLE

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

WDT_DEMOGRAPHIC

VISA_TYPE_SD

VISA_TYPE_LD

VISA_TYPE_SD

VISA_TYPE_LD

ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RACE, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

ACADEMIC OUTCOME, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVISOR, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, ATHLETIC, BANNER COMMUNICATION, COMBINED ADMISSIONS SOURCE, CONTACT, GRADE CHANGE, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, RETENTION MULTI YEAR, SECONDARY SCHOOL SUBJECT, STUDENT, STUDENT ACTIVITY, STUDENT ATTRIBUTE, STUDENT COHORT, STUDENT COURSE, STUDENT PROGRESS, TEST 

NO

NO

NO

NO



Ver: 9.0