Banner EDW Source: RECRUITMENT_SOURCE

	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	COMBINED ADMISSIONS SOURCE	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	COMBINED ADMISSIONS SOURCE COMBINED ADMISSIONS SOURCE	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	COMBINED ADMISSIONS SOURCE	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD	COMBINED ADMISSIONS SOURCE COMBINED ADMISSIONS SOURCE	NO NO
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	COMBINED ADMISSIONS SOURCE	NO
DATE_SOURCE_REPORTED	NO	FACT TABLE	WFT_COMBINED_ADMISSIONS_SOURCE	SOURCE_REPORTED_DATE	COMBINED ADMISSIONS SOURCE	NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	COMBINED ADMISSIONS SOURCE	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_LD MULTI_SOURCE_SD	COMBINED ADMISSIONS SOURCE COMBINED ADMISSIONS SOURCE	NO NO
PERSON_UID	NO	FACT TABLE	WFT_COMBINED_ADMISSIONS_SOURCE	PERSON_UID	COMBINED ADMISSIONS SOURCE	NO
PRIMARY_SOURCE_IND	NO	FACT TABLE	WFT_COMBINED_ADMISSIONS_SOURCE	PRIMARY_SOURCE_IND	COMBINED ADMISSIONS SOURCE	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	COMBINED ADMISSIONS SOURCE	NO

Ver: 9.0