Banner EDW Source: PREVIOUS

	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
ATTEND_FROM_DATE	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	POST_SECONDARY_ATTEND_FROM	POST SECONDARY SCHOOL	NO
ATTENT_TO_DATE	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	POST_SECONDARY_ATTEND_TO	POST SECONDARY SCHOOL	NO
COLLEGE_PREP	NO	DIMENSION TABLE	WDT_SECONDARY_SCHOOL	COLLEGE_PREP_IND	EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION	NO
FUNCTION	NO
INSTITUTION	NO
INSTITUTION_DESC	NO
INSTITUTION_TYPE	NO
INSTITUTION_TYPE_DESC	NO
PERCENTILE	NO	DIMENSION TABLE FACT TABLE	WDT_SECONDARY_SCHOOL WFT_PROSPECTIVE_STUDENT	SECONDARY_PERCENTILE_RANGE SECONDARY_SCHOOL_PERCENTILE	PROSPECTIVE STUDENT PROSPECTIVE STUDENT	NO NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_POST_SECONDARY_SCHOOL	PERSON_UID PERSON_UID	POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO
POST_SECONDARY_DEGREE	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_DEGREE	POST SECONDARY SCHOOL	NO
POST_SECONDARY_DEGREE1	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_DEGREE	EMPLOYEE DEGREE	NO
POST_SECONDARY_DEGREE_DATE	NO	DIMENSION TABLE FACT TABLE	WDT_TIME WDT_TIME WFT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL	CALENDAR_MONTH CALENDAR_YEAR OUTCOME_AWARD_IND POST_SECONDARY_DEGREE_DATE	EMPLOYEE DEGREE EMPLOYEE DEGREE POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO NO NO
POST_SECONDARY_DEGREE_DESC	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_DEGREE_LD POST_SECONDARY_DEGREE_SD	POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO
POST_SECONDARY_DEGREE_DESC1	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_DEGREE_LD POST_SECONDARY_DEGREE_SD	EMPLOYEE DEGREE EMPLOYEE DEGREE	NO NO
POST_SECONDARY_DEGREE_MAJOR1	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_MAJOR	POST SECONDARY SCHOOL	NO
POST_SECONDARY_MAJOR1	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_MAJOR	EMPLOYEE DEGREE	NO
POST_SECONDARY_MAJOR_DESC1	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_MAJOR_LD POST_SECONDARY_MAJOR_SD	EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL	NO NO
POST_SECONDARY_SCHOOL_1	NO
SCHOOL_GPA	NO	DIMENSION TABLE FACT TABLE	WDT_POST_SECONDARY_SCHOOL WDT_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL WFT_PROSPECTIVE_STUDENT	POST_SECONDARY_GPA_RANGE SECONDARY_GPA_RANGE POST_SECONDARY_GPA SECONDARY_SCHOOL_GPA	POST SECONDARY SCHOOL PROSPECTIVE STUDENT POST SECONDARY SCHOOL PROSPECTIVE STUDENT	NO NO NO NO
SECONDARY_DIPLOMA	NO	DIMENSION TABLE	WDT_SECONDARY_SCHOOL	SECONDARY_DIPLOMA	PROSPECTIVE STUDENT	NO
SECONDARY_DIPLOMA_DESC	NO	DIMENSION TABLE	WDT_SECONDARY_SCHOOL WDT_SECONDARY_SCHOOL	SECONDARY_DIPLOMA_LD SECONDARY_DIPLOMA_SD	PROSPECTIVE STUDENT PROSPECTIVE STUDENT	NO NO
SECONDARY_SCHOOL_GRAD_DATE	NO	FACT TABLE	WFT_PROSPECTIVE_STUDENT	SECONDARY_SCHOOL_GRAD_DATE	PROSPECTIVE STUDENT	NO
SS_DIPLOMA	NO
SS_DIPLOMA_DESC	NO
TOTAL_TRANSFER_CREDITS	NO	DIMENSION TABLE FACT TABLE	WDT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL	TRANSFER_CREDIT_RANGE POST_SECONDARY_TRANS_CREDITS	POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO

Ver: 8.1