Banner EDW Source: ADMISSIONS_DECISION

	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 DECISION	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD	APPLICATION DECISION APPLICATION DECISION	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	APPLICATION DECISION	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	APPLICATION DECISION APPLICATION DECISION	NO NO
APPLICANT_ACCEPT_IND	NO	DIMENSION TABLE	WDT_APPLICATION_DECISION	APPLICANT_ACCEPT_IND	APPLICATION DECISION	NO
APPLICATION_INACTIVE_IND	NO	DIMENSION TABLE	WDT_APPLICATION_DECISION	APPLICATION_INACTIVE_IND	APPLICATION DECISION	NO
DECISION	NO	DIMENSION TABLE	WDT_APPLICATION_DECISION	DECISION	APPLICATION DECISION	NO
DECISION_DATE	NO	FACT TABLE	WFT_APPLICATION_DECISION	APPLICATION_DECISION_DATE	APPLICATION DECISION	NO
DECISION_DESC	NO	DIMENSION TABLE	WDT_APPLICATION_DECISION WDT_APPLICATION_DECISION	DECISION_SD DECISION_LD	APPLICATION DECISION APPLICATION DECISION	NO NO
DECISION_SOURCE	NO	DIMENSION TABLE	WDT_APPLICATION_DECISION	DECISION_SOURCE	APPLICATION DECISION	NO
INSTITUTION_ADMIT_IND	NO	DIMENSION TABLE	WDT_APPLICATION_DECISION	INSTITUTION_ADMIT_IND	APPLICATION DECISION	NO
INSTITUTION_DENIED_IND	NO	DIMENSION TABLE	WDT_APPLICATION_DECISION	INSTITUTION_DENIED_IND	APPLICATION DECISION	NO
LATEST_DECISION_IND	NO	FACT TABLE	WFT_APPLICATION_DECISION	LATEST_DECISION_IND	APPLICATION DECISION	NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_APPLICATION_DECISION	PERSON_UID PERSON_UID	APPLICATION DECISION APPLICATION DECISION	NO NO

Ver: 9.0