Banner EDW Source: ACADEMIC

	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	ACADEMIC_PERIOD	GRADUATION COMPLETION	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_TIME	ACADEMIC_YEAR	GRADUATION COMPLETION	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	GRADUATION COMPLETION	NO
ATTEND_FROM_DATE	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	POST_SECONDARY_ATTEND_FROM	POST SECONDARY SCHOOL	NO
ATTENT_TO_DATE	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	POST_SECONDARY_ATTEND_TO	POST SECONDARY SCHOOL	NO
AWARD_CATEGORY	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	AWARD_CATEGORY	GRADUATION COMPLETION	NO
AWARD_CATEGORY_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	AWARD_CATEGORY_LD AWARD_CATEGORY_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
CAMPUS	NO	DIMENSION TABLE	WDT_GRADUATION	GRADUATION_CAMPUS	GRADUATION COMPLETION	NO
CAMPUS_DESC	NO	DIMENSION TABLE	WDT_GRADUATION WDT_GRADUATION	GRADUATION_CAMPUS_LD GRADUATION_CAMPUS_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
COLLEGE	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	COLLEGE	GRADUATION COMPLETION	NO
COLLEGE_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	COLLEGE_LD COLLEGE_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
CREDITS_ATTEMPTED	NO	FACT TABLE	WFT_GRADUATION_COMPLETION	CREDITS_ATTEMPTED	GRADUATION COMPLETION	NO
CREDITS_EARNED	NO	FACT TABLE	WFT_GRADUATION_COMPLETION	CREDITS_EARNED	GRADUATION COMPLETION	NO
CREDITS_PASSED	NO	FACT TABLE	WFT_GRADUATION_COMPLETION	CREDITS_PASSED	GRADUATION COMPLETION	NO
DEGREE	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY	POST_SECONDARY_DEGREE DEGREE	EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION GRADUATION COMPLETION	NO NO
DEGREE_DESC	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	POST_SECONDARY_DEGREE_LD POST_SECONDARY_DEGREE_SD DEGREE_LD DEGREE_SD	EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION GRADUATION COMPLETION GRADUATION COMPLETION	NO NO NO NO
DEPARTMENT	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	DEPARTMENT	GRADUATION COMPLETION	NO
DEPARTMENT_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	DEPARTMENT_LD DEPARTMENT_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
GPA	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_GPA_RANGE	POST SECONDARY SCHOOL	NO
GPA_CREDITS	NO	FACT TABLE	WFT_GRADUATION_COMPLETION	GPA_CREDITS	GRADUATION COMPLETION	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 GRADUATION COMPLETION	NO NO
MAJOR_DESC	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	POST_SECONDARY_MAJOR_LD POST_SECONDARY_MAJOR_SD MAJOR_LD MAJOR_SD	EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION GRADUATION COMPLETION GRADUATION COMPLETION	NO NO NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	GRADUATION COMPLETION	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_LD MULTI_SOURCE_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
OUTCOME_GRADUATION_DATE	NO	DIMENSION TABLE	WDT_TIME WDT_TIME WDT_GRADUATION	CALENDAR_MONTH CALENDAR_YEAR OUTCOME_GRADUATION_DATE	EMPLOYEE DEGREE, GRADUATION COMPLETION EMPLOYEE DEGREE, GRADUATION COMPLETION GRADUATION COMPLETION	NO NO NO
OUTCOME_NUMBER	NO	FACT TABLE	WFT_GRADUATION_COMPLETION	OUTCOME_NUMBER	GRADUATION COMPLETION	NO
PERSON_UID	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	PERSON_UID	POST SECONDARY SCHOOL	NO
POST_SECONDARY_DEGREE_DATE	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL	OUTCOME_AWARD_IND POST_SECONDARY_DEGREE_DATE	POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	GRADUATION COMPLETION	NO
PROGRAM	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	PROGRAM	GRADUATION COMPLETION	NO
PROGRAM_CLASSIFICATION	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	PROGRAM_CLASSIFICATION	GRADUATION COMPLETION	NO
PROGRAM_CLASSIFICATION_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	PROGRAM_CLASSIFICATION_LD PROGRAM_CLASSIFICATION_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
PROGRAM_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	PROGRAM_LD PROGRAM_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
QUALITY_POINTS	NO	FACT TABLE	WFT_GRADUATION_COMPLETION	QUALITY_POINTS	GRADUATION COMPLETION	NO
SCHOOL_GPA	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	POST_SECONDARY_GPA	POST SECONDARY SCHOOL	NO
STUDENT_LEVEL	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY	STUDENT_LEVEL	GRADUATION COMPLETION	NO
STUDENT_LEVEL_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_STUDY WDT_ACADEMIC_STUDY	STUDENT_LEVEL_LD STUDENT_LEVEL_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO
SUB_ACADEMIC_PERIOD	NO	DIMENSION TABLE	WDT_TIME	SUB_ACADEMIC_PERIOD	GRADUATION COMPLETION	NO
SUB_ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD	GRADUATION COMPLETION GRADUATION COMPLETION	NO NO

Ver: 8.1