RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: APRCATG - NULL

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

DIMENSION TABLE










REPORTING VIEW

WDT_CONSTITUENT_ENTITY_TYPE

GIFT_TRANSACTION

CONSTITUENT

DONOR_CATEGORY_SLOT

DONOR_CATEGORY_SLOT

DONOR_CATEGORY_SLOT

GIFT

ORGANIZATIONAL_CONSTITUENT

DONOR_CATEGORY

DONOR_CATEGORY_SLOT

CONSTITUENT_ENTITY_TYPE

PRIMARY_DONOR_CATEGORY

PREF_DONOR_CATEGORY

DONOR_CATEGORY1

DONOR_CATEGORY3

DONOR_CATEGORY4

PRIMARY_DONOR_CATEGORY

PRIMARY_DONOR_CATEGORY

DONOR_CATEGORY

DONOR_CATEGORY2

ANALYZE FUNDRAISING, CONSTITUENT ENTITY, CONSTITUENT ENTITY TYPE, GIFT, MANAGE PROSPECT PIPELINE, MATCHING CLAIM, PLEDGE, RQPP ENTITY 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

APRCATG_PIDM NO

REPORTING VIEW

DONOR_CATEGORY

DONOR_CATEGORY_SLOT

ENTITY_UID

ENTITY_UID

NA 

NA 

NO

NO



Ver: 9.0