Banner EDW Source: ACADEMIC_OUTCOME

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

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ACADEMIC_PERIOD	NO	DIMENSION TABLE	WDT_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD ACADEMIC_PERIOD	GRADUATION COMPLETION ACADEMIC OUTCOME	NO NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION GRADUATION COMPLETION GRADUATION COMPLETION	NO NO NO NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
APPLIED_FOR_OUTCOME_IND	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME	APPLIED_FOR_OUTCOME_IND	ACADEMIC OUTCOME	NO
AWARD_CATEGORY	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	AWARD_CATEGORY	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
AWARD_CATEGORY_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	AWARD_CATEGORY_SD AWARD_CATEGORY_LD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
BULLETIN_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME	BULLETIN_YEAR	ACADEMIC OUTCOME	NO
BULLETIN_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME WDT_ACADEMIC_OUTCOME	BULLETIN_YEAR_LD BULLETIN_YEAR_SD	ACADEMIC OUTCOME ACADEMIC OUTCOME	NO NO
CAMPUS	NO	DIMENSION TABLE	WDT_GRADUATION WDT_ACADEMIC_STUDY	GRADUATION_CAMPUS CAMPUS	GRADUATION COMPLETION ACADEMIC OUTCOME	NO NO
CAMPUS_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_GRADUATION WDT_GRADUATION WDT_ACADEMIC_STUDY	CAMPUS_LD GRADUATION_CAMPUS_LD GRADUATION_CAMPUS_SD CAMPUS_SD	ACADEMIC OUTCOME GRADUATION COMPLETION GRADUATION COMPLETION ACADEMIC OUTCOME	NO NO NO NO
COLLEGE	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	COLLEGE	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
COLLEGE_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	COLLEGE_LD COLLEGE_SD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
CREDITS_ATTEMPTED	NO	FACT TABLE	WFT_ACADEMIC_OUTCOME WFT_GRADUATION_COMPLETION	CREDITS_ATTEMPTED CREDITS_ATTEMPTED	ACADEMIC OUTCOME GRADUATION COMPLETION	NO NO
CREDITS_EARNED	NO	FACT TABLE	WFT_ACADEMIC_OUTCOME WFT_GRADUATION_COMPLETION	CREDITS_EARNED CREDITS_EARNED	ACADEMIC OUTCOME GRADUATION COMPLETION	NO NO
CREDITS_PASSED	NO	FACT TABLE	WFT_ACADEMIC_OUTCOME WFT_GRADUATION_COMPLETION	CREDITS_PASSED CREDITS_PASSED	ACADEMIC OUTCOME GRADUATION COMPLETION	NO NO
CURRICULUM_ORDER	NO	FACT TABLE	WFT_ACADEMIC_OUTCOME	CURRICULUM_ORDER	ACADEMIC OUTCOME	NO
CURRICULUM_PRIORITY_NUMBER	NO	FACT TABLE	WFT_ACADEMIC_OUTCOME	CURRICULUM_PRIORITY	ACADEMIC OUTCOME	NO
DEGREE	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_POST_SECONDARY_SCHOOL	DEGREE POST_SECONDARY_DEGREE	ACADEMIC OUTCOME, GRADUATION COMPLETION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION	NO NO
DEGREE_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	DEGREE_LD DEGREE_SD POST_SECONDARY_DEGREE_LD POST_SECONDARY_DEGREE_SD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION	NO NO NO NO
DEPARTMENT	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	DEPARTMENT	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
DEPARTMENT_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	DEPARTMENT_LD DEPARTMENT_SD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
GPA	NO	DIMENSION TABLE FACT TABLE	WDT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL WFT_ACADEMIC_OUTCOME	POST_SECONDARY_GPA_RANGE POST_SECONDARY_GPA GPA	POST SECONDARY SCHOOL POST SECONDARY SCHOOL ACADEMIC OUTCOME	NO NO NO
GPA_CREDITS	NO	FACT TABLE	WFT_GRADUATION_COMPLETION WFT_ACADEMIC_OUTCOME	GPA_CREDITS GPA_CREDITS	GRADUATION COMPLETION ACADEMIC OUTCOME	NO NO
GRADUATED_IND	NO	DIMENSION TABLE	WDT_GRADUATION_MULTI_YEAR WDT_GRADUATION_MULTI_YEAR WDT_GRADUATION_MULTI_YEAR WDT_GRADUATION_MULTI_YEAR WDT_GRADUATION_MULTI_YEAR WDT_GRADUATION_MULTI_YEAR WDT_GRADUATION_MULTI_YEAR WDT_GRADUATION_MULTI_YEAR	YEAR1_GRADUATION_IND YEAR6_GRADUATION_IND YEAR4_GRADUATION_IND YEAR7_GRADUATION_IND YEAR5_GRADUATION_IND YEAR8_GRADUATION_IND YEAR2_GRADUATION_IND YEAR3_GRADUATION_IND	RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS	NO NO NO NO NO NO NO NO
GRADUATION_STATUS	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME	GRADUATION_STATUS	ACADEMIC OUTCOME	NO
GRADUATION_STATUS_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME WDT_ACADEMIC_OUTCOME	GRADUATION_STATUS_SD GRADUATION_STATUS_LD	ACADEMIC OUTCOME ACADEMIC OUTCOME	NO NO
GRAD_REQ_COMPLETED_ACAD_PER	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME	OUTCOME_REQ_COMPLETED_IND	ACADEMIC OUTCOME	NO
MAJOR	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY	POST_SECONDARY_MAJOR MAJOR	EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
MAJOR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_POST_SECONDARY_SCHOOL	MAJOR_SD POST_SECONDARY_MAJOR_SD MAJOR_LD POST_SECONDARY_MAJOR_LD	ACADEMIC OUTCOME, GRADUATION COMPLETION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION ACADEMIC OUTCOME, GRADUATION COMPLETION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION	NO NO NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
OUTCOME_APPLICATION_DATE	NO	FACT TABLE	WFT_STUDENT WFT_ACADEMIC_OUTCOME	OUTCOME_APPLICATION_DATE OUTCOME_APPLICATION_DATE	STUDENT ACADEMIC OUTCOME	NO NO
OUTCOME_AWARDED_IND	NO	DIMENSION TABLE FACT TABLE	WDT_ACADEMIC_OUTCOME WFT_POST_SECONDARY_SCHOOL	OUTCOME_AWARDED_IND OUTCOME_AWARD_IND	ACADEMIC OUTCOME POST SECONDARY SCHOOL	NO NO
OUTCOME_GRADUATION_DATE	NO	DIMENSION TABLE FACT TABLE	WDT_TIME WDT_TIME WDT_GRADUATION WFT_ACADEMIC_OUTCOME WFT_STUDENT	CALENDAR_MONTH CALENDAR_YEAR OUTCOME_GRADUATION_DATE OUTCOME_GRADUATION_DATE OUTCOME_GRADUATION_DATE	EMPLOYEE DEGREE, GRADUATION COMPLETION EMPLOYEE DEGREE, GRADUATION COMPLETION GRADUATION COMPLETION ACADEMIC OUTCOME STUDENT	NO NO NO NO NO
OUTCOME_NUMBER	NO	FACT TABLE	WFT_GRADUATION_COMPLETION WFT_ACADEMIC_OUTCOME	OUTCOME_NUMBER OUTCOME_NUMBER	GRADUATION COMPLETION ACADEMIC OUTCOME	NO NO
PERSON_UID	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	PERSON_UID	POST SECONDARY SCHOOL	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
PROGRAM	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	PROGRAM	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
PROGRAM_CLASSIFICATION	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_CONCENTRATION	PROGRAM_CLASSIFICATION PROGRAM_CLASSIFICATION	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC PROGRAM COURSE	NO NO
PROGRAM_CLASSIFICATION_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	PROGRAM_CLASSIFICATION_SD PROGRAM_CLASSIFICATION_LD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
PROGRAM_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	PROGRAM_LD PROGRAM_SD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
QUALITY_POINTS	NO	FACT TABLE	WFT_GRADUATION_COMPLETION WFT_ACADEMIC_OUTCOME	QUALITY_POINTS QUALITY_POINTS	GRADUATION COMPLETION ACADEMIC OUTCOME	NO NO
SECOND_DEPARTMENT	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	SECOND_DEPARTMENT	ACADEMIC OUTCOME	NO
SECOND_DEPARTMENT_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	SECOND_DEPARTMENT_SD SECOND_DEPARTMENT_LD	ACADEMIC OUTCOME ACADEMIC OUTCOME	NO NO
SECOND_MAJOR	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	SECOND_MAJOR	ACADEMIC OUTCOME	NO
SECOND_MAJOR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	SECOND_MAJOR_LD SECOND_MAJOR_SD	ACADEMIC OUTCOME ACADEMIC OUTCOME	NO NO
SECOND_PROGRAM_CLASSIFICATION	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	SECOND_PROG_CLASSIFICATION	ACADEMIC OUTCOME	NO
SECOND_PROGRAM_CLASSIF_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	SECOND_PROG_CLASSIFICATION_LD SECOND_PROG_CLASSIFICATION_SD	ACADEMIC OUTCOME ACADEMIC OUTCOME	NO NO
STATUS	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME	ACADEMIC_OUTCOME_STATUS	ACADEMIC OUTCOME	NO
STATUS_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME WDT_ACADEMIC_OUTCOME	ACADEMIC_OUTCOME_STATUS_SD ACADEMIC_OUTCOME_STATUS_LD	ACADEMIC OUTCOME ACADEMIC OUTCOME	NO NO
STUDENT_LEVEL	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	STUDENT_LEVEL	ACADEMIC OUTCOME, GRADUATION COMPLETION	NO
STUDENT_LEVEL_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	STUDENT_LEVEL_SD STUDENT_LEVEL_LD	ACADEMIC OUTCOME, GRADUATION COMPLETION ACADEMIC OUTCOME, GRADUATION COMPLETION	NO NO
TRANSFER_WORK_EXISTS_IND	NO	DIMENSION TABLE	WDT_ACADEMIC_OUTCOME	TRANSFER_WORK_EXISTS_IND	ACADEMIC OUTCOME	NO

Ver: 9.0