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

Ver: 9.0