Banner EDW Source: ADMISSIONS_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	APPLICATION COHORT	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	APPLICATION COHORT APPLICATION COHORT	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	APPLICATION COHORT	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD	APPLICATION COHORT APPLICATION COHORT	NO NO
COHORT	NO	DIMENSION TABLE	WDT_COHORT	COHORT	APPLICATION COHORT	NO
COHORT_ACTIVE_IND	NO	FACT TABLE	WFT_STUDENT_COHORT	STUDENT_COHORT_ACTIVE_IND	STUDENT COHORT	NO
COHORT_DESC	NO	DIMENSION TABLE	WDT_COHORT WDT_COHORT	COHORT_LD COHORT_SD	APPLICATION COHORT APPLICATION COHORT	NO NO
COHORT_INACTIVE_REASON	NO	DIMENSION TABLE	WDT_COHORT	COHORT_INACTIVE_REASON	APPLICATION COHORT	NO
COHORT_INACTIVE_REASON_DESC	NO	DIMENSION TABLE	WDT_COHORT WDT_COHORT	COHORT_INACTIVE_REASON_SD COHORT_INACTIVE_REASON_LD	APPLICATION COHORT APPLICATION COHORT	NO NO
COHORT_REPORT_IND	NO	DIMENSION TABLE	WDT_COHORT	COHORT_REPORT_IND	APPLICATION COHORT	NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_APPLICATION_COHORT	PERSON_UID PERSON_UID	APPLICATION COHORT APPLICATION COHORT	NO NO

Ver: 9.0