Banner EDW Source: STUDENT_COURSE_GRADE_CHANGE

	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_ACADEMIC_TIME	ACADEMIC_PERIOD	GRADE CHANGE	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	GRADE CHANGE GRADE CHANGE	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	GRADE CHANGE	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	GRADE CHANGE GRADE CHANGE	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	GRADE CHANGE	NO
COURSE_REFERENCE_NUMBER	NO	DIMENSION TABLE	WDT_COURSE_REFERENCE_NUMBER	COURSE_REFERENCE_NUMBER	GRADE CHANGE	NO
CREDITS_ATTEMPTED	NO	FACT TABLE	WFT_GRADE_CHANGE	CREDITS_ATTEMPTED	GRADE CHANGE	NO
CREDITS_EARNED	NO	FACT TABLE	WFT_GRADE_CHANGE	CREDITS_EARNED	GRADE CHANGE	NO
CREDITS_FOR_GPA	NO	FACT TABLE	WFT_GRADE_CHANGE	CREDITS_FOR_GPA	GRADE CHANGE	NO
CREDITS_PASSED	NO	FACT TABLE	WFT_GRADE_CHANGE	CREDITS_PASSED	GRADE CHANGE	NO
FINAL_GRADE	NO	FACT TABLE	WFT_GRADE_CHANGE	GRADE	GRADE CHANGE	NO
FINAL_GRADE_SEQUENCE_NUMBER	NO	FACT TABLE	WFT_GRADE_CHANGE	GRADE_SEQUENCE_NUMBER	GRADE CHANGE	NO
GRADE_CHANGE_DATE	NO	FACT TABLE	WFT_GRADE_CHANGE	GRADE_CHANGE_DATE	GRADE CHANGE	NO
GRADE_CHANGE_REASON	NO	DIMENSION TABLE	WDT_GRADE_CHANGE	GRADE_CHANGE_REASON	GRADE CHANGE, STUDENT COURSE	NO
GRADE_CHANGE_REASON_DESC	NO	DIMENSION TABLE	WDT_GRADE_CHANGE WDT_GRADE_CHANGE	GRADE_CHANGE_REASON_LD GRADE_CHANGE_REASON_SD	GRADE CHANGE, STUDENT COURSE GRADE CHANGE, STUDENT COURSE	NO NO
GRADE_COMMENT	NO	DIMENSION TABLE	WDT_GRADE_CHANGE	GRADE_COMMENT	GRADE CHANGE, STUDENT COURSE	NO
GRADE_COMMENT_DESC	NO	DIMENSION TABLE	WDT_GRADE_CHANGE WDT_GRADE_CHANGE	GRADE_COMMENT_LD GRADE_COMMENT_SD	GRADE CHANGE, STUDENT COURSE GRADE CHANGE, STUDENT COURSE	NO NO
INCOMPLETE_EXT_DATE	NO	FACT TABLE	WFT_GRADE_CHANGE	INCOMPLETE_EXT_DATE	GRADE CHANGE	NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	GRADE CHANGE	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	GRADE CHANGE GRADE CHANGE	NO NO
PERSON_UID	NO	FACT TABLE	WFT_GRADE_CHANGE	PERSON_UID	GRADE CHANGE	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	GRADE CHANGE	NO
QUALITY_POINTS	NO	FACT TABLE	WFT_GRADE_CHANGE	QUALITY_POINTS	GRADE CHANGE	NO
SUB_ACADEMIC_PERIOD	NO	DIMENSION TABLE	WDT_SUB_ACADEMIC_PERIOD	SUB_ACADEMIC_PERIOD	GRADE CHANGE	NO
SUB_ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_SUB_ACADEMIC_PERIOD WDT_SUB_ACADEMIC_PERIOD	SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD	GRADE CHANGE GRADE CHANGE	NO NO

Ver: 9.0