Banner EDW Source: STUDENT_COHORT

	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	STUDENT COHORT	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	STUDENT COHORT STUDENT COHORT	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	STUDENT COHORT	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	STUDENT COHORT STUDENT COHORT	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	STUDENT COHORT	NO
COHORT	NO	DIMENSION TABLE	WDT_GRADUATION WDT_COHORT	COHORT COHORT	GRADUATION COMPLETION STUDENT COHORT	NO NO
COHORT_DESC	NO	DIMENSION TABLE	WDT_GRADUATION WDT_COHORT WDT_GRADUATION WDT_COHORT	COHORT_LD COHORT_LD COHORT_SD COHORT_SD	GRADUATION COMPLETION STUDENT COHORT GRADUATION COMPLETION STUDENT COHORT	NO NO NO NO
COHORT_END_ACADEMIC_PERIOD	NO	FACT TABLE	WFT_STUDENT_COHORT	COHORT_ACAD_TIME_END_KEY	STUDENT COHORT	NO
COHORT_INACTIVE_REASON	NO	DIMENSION TABLE	WDT_COHORT	COHORT_INACTIVE_REASON	STUDENT COHORT	NO
COHORT_INACTIVE_REASON_DESC	NO	DIMENSION TABLE	WDT_COHORT WDT_COHORT	COHORT_INACTIVE_REASON_LD COHORT_INACTIVE_REASON_SD	STUDENT COHORT STUDENT COHORT	NO NO
COHORT_START_ACADEMIC_PERIOD	NO	FACT TABLE	WFT_STUDENT_COHORT	COHORT_ACAD_TIME_START_KEY	STUDENT COHORT	NO
FTE_COHORT_REPORT_IND	NO	DIMENSION TABLE	WDT_COHORT	COHORT_REPORT_IND	STUDENT COHORT	NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	STUDENT COHORT	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	STUDENT COHORT STUDENT COHORT	NO NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	STUDENT COHORT	NO

Ver: 9.0