RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: TMP_WAT_RQPP_DES_COLL_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_COLL

CONS_YRS_OF_PARTICIPATION

RQPP YEARLY DES COLL 

NO

DES_COLL_KEY NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_COLL

DESIGNATION_COLLEGE_KEY

RQPP YEARLY DES COLL 

NO

ENTITY_KEY NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_COLL

ENTITY_KEY

RQPP YEARLY DES COLL 

NO

ENTITY_UID NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_COLL

ENTITY_UID

RQPP YEARLY DES COLL 

NO

MULTI_SOURCE_KEY NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_COLL

MULTI_SOURCE_KEY

RQPP YEARLY DES COLL 

NO

YEAR_OF_GIVING NO

AGGREGATE FACT TABLE

WAT_RQPP_YEARLY_DES_COLL

YEAR_OF_GIVING

RQPP YEARLY DES COLL 

NO



Ver: 9.0