Banner EDW Source: WFT_BANNER_COMMUNICATION

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
BANNER_COMMUNICATION_GROUP_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS	BANNER_COMMUNICATION_GROUP_KEY	STUDENT PROGRESS	NO
BANNER_COMMUNICATION_KEY	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS	LAST_BANNER_COMMUNICATION_KEY FIRST_BANNER_COMMUNICATION_KEY	STUDENT PROGRESS STUDENT PROGRESS	NO NO
COMMUNICATION_INIT_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS	FIRST_BANNER_COMM_INIT_DATE LAST_BANNER_COMM_INIT_DATE	STUDENT PROGRESS STUDENT PROGRESS	NO NO
COMMUNICATION_SENT_DATE	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS	LAST_BANNER_COMM_SENT_DATE FIRST_BANNER_COMM_SENT_DATE	STUDENT PROGRESS STUDENT PROGRESS	NO NO
PENDING_LETTER_IND	NO	AGGREGATE FACT TABLE	WAT_STUDENT_PROGRESS WAT_STUDENT_PROGRESS	FIRST_BANNER_COMM_PENDING_IND LAST_BANNER_COMM_PENDING_IND	STUDENT PROGRESS STUDENT PROGRESS	NO NO

Ver: 8.4.3