Banner EDW Source: WFT_STUDENT

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ACADEMIC_OUTCOME_ROLL_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACADEMIC_OUTCOME_ROLL_KEY	STUDENT PROGRESS	NO
ACADEMIC_PERIOD_FRSTATTEND_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACADEMIC_PERIOD_FRSTATTEND_KEY	STUDENT PROGRESS	NO
ACADEMIC_PERIOD_GPA	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACADEMIC_PERIOD_GPA	STUDENT PROGRESS	NO
ACADEMIC_PERIOD_LASTATTEND_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACADEMIC_PERIOD_LASTATTEND_KEY	STUDENT PROGRESS	NO
ACADEMIC_STUDY_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACADEMIC_STUDY_KEY	STUDENT PROGRESS	NO
ACADEMIC_TIME_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACADEMIC_TIME_KEY	STUDENT PROGRESS	NO
ACADEMIC_YEAR_GPA	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACADEMIC_YEAR_GPA	STUDENT PROGRESS	NO
ACAD_PERIOD_ATTEND_COUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ACAD_PERIOD_ATTEND_COUNT	STUDENT PROGRESS	NO
ADMIT_AGE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ADMIT_AGE	STUDENT PROGRESS	NO
APPLICATION_POSTAL_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	APPLICATION_POSTAL_KEY	STUDENT PROGRESS	NO
CHANGED_MAJOR_COUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	CHANGED_MAJOR_COUNT	STUDENT PROGRESS	NO
CUMULATIVE_GPA	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	CUMULATIVE_GPA	STUDENT PROGRESS	NO
CURRENT_TIME_STATUS_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	CURRENT_TIME_STATUS_DATE	STUDENT PROGRESS	NO
CURRICULUM_ORDER	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	CURRICULUM_ORDER	STUDENT PROGRESS	NO
CURRICULUM_PRIORITY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	CURRICULUM_PRIORITY	STUDENT PROGRESS	NO
DEMOGRAPHIC_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	DEMOGRAPHIC_KEY	STUDENT PROGRESS	NO
ENROLLMENT_STATUS_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ENROLLMENT_STATUS_DATE	STUDENT PROGRESS	NO
ENROLLMENT_STATUS_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	ENROLLMENT_STATUS_KEY	STUDENT PROGRESS	NO
EXPECTED_GRAD_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	EXPECTED_GRAD_DATE	STUDENT PROGRESS	NO
FINANCIAL_AID_STATUS_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	FINANCIAL_AID_STATUS_KEY	STUDENT PROGRESS	NO
FINANCIAL_AID_YEAR_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	FINANCIAL_AID_YEAR_KEY	STUDENT PROGRESS	NO
GEOGRAPHIC_REGION_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	GEOGRAPHIC_REGION_KEY	STUDENT PROGRESS	NO
INITIAL_ENROLL_STATUS_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	INITIAL_ENROLL_STATUS_DATE	STUDENT PROGRESS	NO
LEAVE_FROM_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	LEAVE_FROM_DATE	STUDENT PROGRESS	NO
LEAVE_TO_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	LEAVE_TO_DATE	STUDENT PROGRESS	NO
MULTI_SOURCE_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	MULTI_SOURCE_KEY	STUDENT PROGRESS	NO
PERSON_UID	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	PERSON_UID	STUDENT PROGRESS	NO
POSTAL_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	POSTAL_KEY	STUDENT PROGRESS	NO
PREVIOUS_ACADEMIC_PERIOD_GPA	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	PREVIOUS_ACADEMIC_PERIOD_GPA	STUDENT PROGRESS	NO
PRE_STUDENT_STATUS_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	PRE_STUDENT_STATUS_KEY	STUDENT PROGRESS	NO
RACE_GROUP_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	RACE_GROUP_KEY	STUDENT PROGRESS	NO
RETENTION_LIKE_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	RETENTION_LIKE_KEY	STUDENT PROGRESS	NO
RETENTION_SEQUENTIAL_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	RETENTION_SEQUENTIAL_KEY	STUDENT PROGRESS	NO
RETENTION_TIME_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	RETENTION_TIME_KEY	STUDENT PROGRESS	NO
START_DATE_MATRICULATED	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	START_DATE_MATRICULATED	STUDENT PROGRESS	NO
STREET_LINE_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	STREET_LINE_KEY	STUDENT PROGRESS	NO
STUDENT_FTE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	FTE	STUDENT PROGRESS	NO
STUDENT_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	STUDENT_KEY	STUDENT PROGRESS	NO
STUDENT_PERFORMANCE_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	STUDENT_PERFORMANCE_KEY	STUDENT PROGRESS	NO
STUDENT_STATUS_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	STUDENT_STATUS_KEY	STUDENT PROGRESS	NO
TOTAL_ACAD_PERIOD_ATTEND_COUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	TOTAL_ACAD_PERIOD_ATTEND_COUNT	STUDENT PROGRESS	NO
UNDECLARED_MAJOR_COUNT	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	UNDECLARED_MAJOR_COUNT	STUDENT PROGRESS	NO

Ver: 9.0