Banner EDW Source: STVACTC

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
STVACTC_ACCG_CODE	NO	REPORTING VIEW	SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY SPORT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT STUDENT_ACTIVITY SPECIAL_ACTIVITY_YEAR_SLOT SPECIAL_ACTIVITY_YEAR	ACTIVITY_CATEGORY3 ACTIVITY_CATEGORY ACTIVITY_CATEGORY ACTIVITY_CATEGORY1 ACTIVITY_CATEGORY2 ACTIVITY_CATEGORY ACTIVITY_CATEGORY ACTIVITY_CATEGORY	NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO
STVACTC_ACTP_CODE	NO	REPORTING VIEW	SPECIAL_ACTIVITY_YEAR_SLOT ACTIVITY SPORT STUDENT_ACTIVITY SPECIAL_ACTIVITY SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_YEAR	ACTIVITY_TYPE ACTIVITY_TYPE ACTIVITY_TYPE ACTIVITY_TYPE ACTIVITY_TYPE ACTIVITY_TYPE2 ACTIVITY_TYPE1 ACTIVITY_TYPE3 ACTIVITY_TYPE	NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO
STVACTC_DESC	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_ACTIVITY WDT_ADVANCEMENT_ACTIVITY SPECIAL_ACTIVITY_YEAR_SLOT ACTIVITY STUDENT_ACTIVITY SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_YEAR SPECIAL_ACTIVITY WDT_ADVANCEMENT_ACTIVITY WDT_ADVANCEMENT_ACTIVITY SPECIAL_ACTIVITY_YEAR_SLOT ACTIVITY STUDENT_ACTIVITY SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_YEAR SPECIAL_ACTIVITY	ACTIVITY_SD ACTIVITY_LD ACTIVITY_DESC ACTIVITY_DESC ACTIVITY_DESC SPECIAL_ACTIVITY_DESC3 SPECIAL_ACTIVITY_DESC1 SPECIAL_ACTIVITY_DESC2 ACTIVITY_DESC SPECIAL_ACTIVITY_DESC ACTIVITY_SD ACTIVITY_LD ACTIVITY_DESC ACTIVITY_DESC ACTIVITY_DESC SPECIAL_ACTIVITY_DESC3 SPECIAL_ACTIVITY_DESC1 SPECIAL_ACTIVITY_DESC2 ACTIVITY_DESC SPECIAL_ACTIVITY_DESC	ADVANCEMENT ACTIVITY ADVANCEMENT ACTIVITY NA NA NA NA NA NA NA NA ADVANCEMENT ACTIVITY ADVANCEMENT ACTIVITY NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
STVACTC_LEAD_CODE	NO	REPORTING VIEW	STUDENT_ACTIVITY	LEADERSHIP_ROLE	NA	NO

Ver: 8.4.2