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

CONSTITUENT_CONTACT

CONSTITUENT_CONTACT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

PROSPECT_MOVES_MANAGEMENT

PROSPECT_MOVES_MANAGEMENT

ANNUAL_GIVING_SLOT

ANNUAL_GIVING_SLOT

YEAR_OF_GIVING

CONTACT_DATE_FISCAL_YEAR

START_DATE_FISCAL_YEAR

FISCAL_YEAR4

FISCAL_YEAR

FISCAL_YEAR1

FISCAL_YEAR3

FISCAL_YEAR6

PLANNED_MOVE_FISCAL_YEAR

START_DATE_FISCAL_YEAR

FISCAL_YEAR5

FISCAL_YEAR2

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

CONSTITUENT

DESIGNATION_GIVING_HISTORY

GIFT

PLEDGE

CAMPAIGN_EXPENSE

PLEDGE_TRANSACTION

CAMPAIGN_GIVING_HISTORY

GIFT_TRANSACTION

YEAR_OF_GIVING_SD

YEAR_OF_GIVING_LD

FISCAL_YEAR_DESC

HIGHEST_GIFT_FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

FISCAL_YEAR_DESC

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: 8.4.2