Banner EDW Source: ADMISSIONS_RATING

	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 RATING	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	APPLICATION RATING APPLICATION RATING	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	APPLICATION RATING	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	APPLICATION RATING APPLICATION RATING	NO NO
ADMINISTRATOR_RATING	NO	FACT TABLE	WFT_APPLICATION_RATING	APPLICATION_RATING	APPLICATION RATING	NO
ADMINISTRATOR_ROLE	NO	DIMENSION TABLE	WDT_ADMINISTRATOR_ROLE	ADMINISTRATOR_ROLE	ADMINISTRATOR, APPLICATION RATING	NO
ADMINISTRATOR_ROLE_DESC	NO	DIMENSION TABLE	WDT_ADMINISTRATOR_ROLE WDT_ADMINISTRATOR_ROLE	ADMINISTRATOR_ROLE_LD ADMINISTRATOR_ROLE_SD	ADMINISTRATOR, APPLICATION RATING ADMINISTRATOR, APPLICATION RATING	NO NO
ADMINISTRATOR_UID	NO	FACT TABLE	WFT_APPLICATION_RATING	ADMINISTRATOR_UID	APPLICATION RATING	NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_APPLICATION_RATING	PERSON_UID PERSON_UID	APPLICATION RATING APPLICATION RATING	NO NO
RATING_TYPE	NO	DIMENSION TABLE	WDT_APPLICATION_RATING	APPLICATION_RATING_TYPE	APPLICATION RATING	NO
RATING_TYPE_DESC	NO	DIMENSION TABLE	WDT_APPLICATION_RATING WDT_APPLICATION_RATING	APPLICATION_RATING_TYPE_SD APPLICATION_RATING_TYPE_LD	APPLICATION RATING APPLICATION RATING	NO NO

Ver: 9.0