Banner EDW Source: RECRUITMENT_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	RECRUITMENT COHORT	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD	RECRUITMENT COHORT RECRUITMENT COHORT	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	RECRUITMENT COHORT	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	RECRUITMENT COHORT RECRUITMENT COHORT	NO NO
COHORT	NO	DIMENSION TABLE	WDT_COHORT	COHORT	RECRUITMENT COHORT	NO
COHORT_DESC	NO	DIMENSION TABLE	WDT_COHORT WDT_COHORT	COHORT_SD COHORT_LD	RECRUITMENT COHORT RECRUITMENT COHORT	NO NO
COHORT_INACTIVE_REASON	NO	DIMENSION TABLE	WDT_COHORT	COHORT_INACTIVE_REASON	RECRUITMENT COHORT	NO
COHORT_INACTIVE_REASON_DESC	NO	DIMENSION TABLE	WDT_COHORT WDT_COHORT	COHORT_INACTIVE_REASON_LD COHORT_INACTIVE_REASON_SD	RECRUITMENT COHORT RECRUITMENT COHORT	NO NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_RECRUITMENT_COHORT	PERSON_UID PERSON_UID	RECRUITMENT COHORT RECRUITMENT COHORT	NO NO

Ver: 9.0