Banner EDW Source: ADMINISTRATOR

	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	ADMINISTRATOR	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD	ADMINISTRATOR ADMINISTRATOR	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	ADMINISTRATOR	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	ADMINISTRATOR ADMINISTRATOR	NO NO
ADMINISTRATOR_UID	NO	FACT TABLE	WFT_ADMINISTRATOR	ADMINISTRATOR_UID	ADMINISTRATOR	NO
APPLICATION_RECRUIT_NUMBER	NO	FACT TABLE	WFT_ADMINISTRATOR	RECORD_NUMBER	ADMINISTRATOR	NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_ADMINISTRATOR	PERSON_UID PERSON_UID	ADMINISTRATOR ADMINISTRATOR	NO NO

Ver: 9.0