RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse Banner EDW Source: ATVFISC - NULL

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

DIMENSION TABLE












REPORTING VIEW

WDT_YEAR_OF_GIVING

ANNUAL_GIVING_SLOT

PROSPECT_MOVES_MANAGEMENT

CONSTITUENT_CONTACT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

CONSTITUENT_CONTACT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

PROSPECT_MOVES_MANAGEMENT

YEAR_OF_GIVING

FISCAL_YEAR2

PLANNED_MOVE_FISCAL_YEAR

START_DATE_FISCAL_YEAR

FISCAL_YEAR4

FISCAL_YEAR3

FISCAL_YEAR

FISCAL_YEAR5

CONTACT_DATE_FISCAL_YEAR

FISCAL_YEAR1

FISCAL_YEAR6

START_DATE_FISCAL_YEAR

ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

ATVFISC_DESC NO

DIMENSION TABLE










REPORTING VIEW

WDT_YEAR_OF_GIVING

WDT_YEAR_OF_GIVING

ANNUAL_GIVING

PLEDGE_TRANSACTION

CAMPAIGN_EXPENSE

GIFT

PLEDGE

GIFT_TRANSACTION

CONSTITUENT

CAMPAIGN_GIVING_HISTORY

DESIGNATION_GIVING_HISTORY

YEAR_OF_GIVING_LD

YEAR_OF_GIVING_SD

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

HIGHEST_GIFT_FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION 

ANALYZE FUNDRAISING, GIFT, MATCHING CLAIM, PLEDGE, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NA 

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

NO

ATVFISC_END_DATE NO        
ATVFISC_START_DATE NO        


Ver: 9.0