Banner EDW Source: ADMISSIONS_REQUIREMENT

	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 REQUIREMENT	NO
ACADEMIC_PERIOD_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD	APPLICATION REQUIREMENT APPLICATION REQUIREMENT	NO NO
ACADEMIC_YEAR	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME	ACADEMIC_YEAR	APPLICATION REQUIREMENT	NO
ACADEMIC_YEAR_DESC	NO	DIMENSION TABLE	WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME	ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD	APPLICATION REQUIREMENT APPLICATION REQUIREMENT	NO NO
COMPLETED_IND	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	REQUIREMENT_COMPLETED_IND	APPLICATION REQUIREMENT	NO
FIRST_REQUEST_DATE	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	FIRST_REQUEST_DATE	APPLICATION REQUIREMENT	NO
MOST_RECENT_REQUEST_DATE	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	MOST_RECENT_REQUEST_DATE	APPLICATION REQUIREMENT	NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_APPLICATION_REQUIREMENT	PERSON_UID PERSON_UID	APPLICATION REQUIREMENT APPLICATION REQUIREMENT	NO NO
REQUIREMENT	NO	DIMENSION TABLE	WDT_APPLICATION_REQUIREMENT	APPLICATION_REQUIREMENT	APPLICATION REQUIREMENT	NO
REQUIREMENT_DEADLINE_DATE	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	REQUIREMENT_DEADLINE_DATE	APPLICATION REQUIREMENT	NO
REQUIREMENT_DESC	NO	DIMENSION TABLE	WDT_APPLICATION_REQUIREMENT WDT_APPLICATION_REQUIREMENT	APPLICATION_REQUIREMENT_SD APPLICATION_REQUIREMENT_LD	APPLICATION REQUIREMENT APPLICATION REQUIREMENT	NO NO
REQUIREMENT_MANDATORY_IND	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	REQUIREMENT_MANDATORY_IND	APPLICATION REQUIREMENT	NO
REQUIREMENT_RECEIVED_DATE	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	REQUIREMENT_RECEIVED_DATE	APPLICATION REQUIREMENT	NO
REQUIREMENT_REQUESTED_COUNT	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	REQUIREMENT_REQUESTED_COUNT	APPLICATION REQUIREMENT	NO
WAIVED_IND	NO	FACT TABLE	WFT_APPLICATION_REQUIREMENT	REQUIREMENT_WAIVED_IND	APPLICATION REQUIREMENT	NO

Ver: 9.0