RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: TMP_WAT_RQPP_DES_DEPT_INT - NULL

Source Column Local Source Target Type Target Target Column Star Name Local Target
CONS_YOG NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_DEPT

CONS_YRS_OF_PARTICIPATION

RQPP YEARLY DES DEPT 

NO

DES_DEPT_KEY NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_DEPT

DESIGNATION_DEPT_KEY

RQPP YEARLY DES DEPT 

NO

ENTITY_KEY NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_DEPT

ENTITY_KEY

RQPP YEARLY DES DEPT 

NO

ENTITY_UID NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_DEPT

ENTITY_UID

RQPP YEARLY DES DEPT 

NO

MULTI_SOURCE_KEY NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_DEPT

MULTI_SOURCE_KEY

RQPP YEARLY DES DEPT 

NO

YEAR_OF_GIVING NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_DEPT

YEAR_OF_GIVING

RQPP YEARLY DES DEPT 

NO



Ver: 9.0