Banner EDW Source: PREVIOUS_EDUCATION

	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 FACT TABLE	WFT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL	POST_SECONDARY_ATTEND_FROM POST_SECONDARY_ATTEND_FROM	POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO
ATTEND_TO_DATE	NO	FACT TABLE	WFT_POST_SECONDARY_SCHOOL	POST_SECONDARY_ATTEND_TO	POST SECONDARY SCHOOL	NO
AWARD_CATEGORY	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_AWD_CATEGORY	ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION	NO
AWARD_CATEGORY_DESC	NO	DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_AWD_CATEGORY_SD POST_SECONDARY_AWD_CATEGORY_LD	ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION	NO NO
COLLEGE_PREP	NO	DIMENSION TABLE DIMENSION TABLE	WDT_SECONDARY_SCHOOL WDT_SECONDARY_SCHOOL	COLLEGE_PREP_IND COLLEGE_PREP_IND	EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, STUDENT ENGAGEMENT, STUDENT PROGRESS EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, STUDENT ENGAGEMENT, STUDENT PROGRESS	NO NO
PERCENTILE	NO	DIMENSION TABLE FACT TABLE DIMENSION TABLE FACT TABLE	WDT_SECONDARY_SCHOOL WFT_PROSPECTIVE_STUDENT WDT_SECONDARY_SCHOOL WFT_PROSPECTIVE_STUDENT	SECONDARY_PERCENTILE_RANGE SECONDARY_SCHOOL_PERCENTILE SECONDARY_PERCENTILE_RANGE SECONDARY_SCHOOL_PERCENTILE	EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS PROSPECTIVE STUDENT EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS PROSPECTIVE STUDENT	NO NO NO NO
PERSON_UID	NO	DIMENSION TABLE FACT TABLE DIMENSION TABLE FACT TABLE	WDT_PERSON WFT_POST_SECONDARY_SCHOOL WDT_PERSON WFT_POST_SECONDARY_SCHOOL	PERSON_UID PERSON_UID PERSON_UID PERSON_UID	POST SECONDARY SCHOOL POST SECONDARY SCHOOL POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO NO NO
POST_SECONDARY_DEGREE	NO	DIMENSION TABLE DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_DEGREE POST_SECONDARY_DEGREE	ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL	NO NO
POST_SECONDARY_DEGREE_DATE	NO	DIMENSION TABLE FACT TABLE DIMENSION TABLE FACT TABLE	WDT_TIME WDT_TIME WFT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL WDT_TIME WDT_TIME WFT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL	CALENDAR_YEAR CALENDAR_MONTH OUTCOME_AWARD_IND POST_SECONDARY_DEGREE_DATE CALENDAR_YEAR CALENDAR_MONTH OUTCOME_AWARD_IND POST_SECONDARY_DEGREE_DATE	EMPLOYEE DEGREE EMPLOYEE DEGREE POST SECONDARY SCHOOL POST SECONDARY SCHOOL EMPLOYEE DEGREE EMPLOYEE DEGREE POST SECONDARY SCHOOL POST SECONDARY SCHOOL	NO NO NO NO NO NO NO NO
POST_SECONDARY_DEGREE_DESC	NO	DIMENSION TABLE DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_DEGREE_SD POST_SECONDARY_DEGREE_LD POST_SECONDARY_DEGREE_SD POST_SECONDARY_DEGREE_LD	ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL	NO NO NO NO
POST_SECONDARY_MAJOR1	NO	DIMENSION TABLE DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_MAJOR POST_SECONDARY_MAJOR	ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, POST SECONDARY SCHOOL	NO NO
POST_SECONDARY_MAJOR_DESC1	NO	DIMENSION TABLE DIMENSION TABLE	WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL	POST_SECONDARY_MAJOR_SD POST_SECONDARY_MAJOR_LD POST_SECONDARY_MAJOR_SD POST_SECONDARY_MAJOR_LD	ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL	NO NO NO NO
SCHOOL_GPA	NO	DIMENSION TABLE FACT TABLE DIMENSION TABLE FACT TABLE	WDT_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WFT_PROSPECTIVE_STUDENT WDT_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WFT_PROSPECTIVE_STUDENT	SECONDARY_GPA_RANGE POST_SECONDARY_GPA_RANGE SECONDARY_SCHOOL_GPA SECONDARY_GPA_RANGE POST_SECONDARY_GPA_RANGE SECONDARY_SCHOOL_GPA	EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS ADMISSIONS APPLICATION, EMPLOYEE APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION PROSPECTIVE STUDENT EMPLOYMENT APPLICATION, PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS ADMISSIONS APPLICATION, EMPLOYEE APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION PROSPECTIVE STUDENT	NO NO NO NO NO NO
SCHOOL_RANK	NO	FACT TABLE	WFT_PROSPECTIVE_STUDENT	SECONDARY_SCHOOL_RANK	PROSPECTIVE STUDENT	NO
SCHOOL_SIZE	NO	FACT TABLE	WFT_PROSPECTIVE_STUDENT	SECONDARY_SCHOOL_SIZE	PROSPECTIVE STUDENT	NO
SECONDARY_DIPLOMA	NO	DIMENSION TABLE DIMENSION TABLE	WDT_SECONDARY_SCHOOL WDT_SECONDARY_SCHOOL	SECONDARY_DIPLOMA SECONDARY_DIPLOMA	PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS	NO NO
SECONDARY_DIPLOMA_DESC	NO	DIMENSION TABLE DIMENSION TABLE	WDT_SECONDARY_SCHOOL WDT_SECONDARY_SCHOOL WDT_SECONDARY_SCHOOL WDT_SECONDARY_SCHOOL	SECONDARY_DIPLOMA_LD SECONDARY_DIPLOMA_SD SECONDARY_DIPLOMA_LD SECONDARY_DIPLOMA_SD	PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS PROSPECTIVE STUDENT, STUDENT ENGAGEMENT, STUDENT PROGRESS	NO NO NO NO
SECONDARY_SCHOOL_GRAD_DATE	NO	FACT TABLE FACT TABLE	WFT_PROSPECTIVE_STUDENT WFT_PROSPECTIVE_STUDENT	SECONDARY_SCHOOL_GRAD_DATE SECONDARY_SCHOOL_GRAD_DATE	PROSPECTIVE STUDENT PROSPECTIVE STUDENT	NO NO
TOTAL_TRANSFER_CREDITS	NO	DIMENSION TABLE FACT TABLE DIMENSION TABLE FACT TABLE	WDT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL WDT_POST_SECONDARY_SCHOOL WFT_POST_SECONDARY_SCHOOL	TRANSFER_CREDIT_RANGE POST_SECONDARY_TRANS_CREDITS TRANSFER_CREDIT_RANGE POST_SECONDARY_TRANS_CREDITS	ADMISSIONS APPLICATION, EMPLOYEE APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION POST SECONDARY SCHOOL ADMISSIONS APPLICATION, EMPLOYEE APPLICATION, EMPLOYEE DEGREE, EMPLOYMENT APPLICATION, POST SECONDARY SCHOOL, RECRUITING AND ADMISSION POST SECONDARY SCHOOL	NO NO NO NO

Ver: 8.4.3