RETURN TO DIMENSION TABLE REPORTS LIST
Advancement Gift Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CAMPAIGN

Description Campaign Dimension table provides information regarding campaigns run by the institution. This information includes the name given to the campaign and the type of campaign. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
CAMPAIGN Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)

CAMPAIGN_GIVING_HISTORY

CAMPAIGN

NO

NO

ADVANCEMENT GIFT

CAMPAIGN_KEY Key for the campaign dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

CAMPAIGN_LD Long descriptive name for the campaign that may include the reason for this specific campaign. VARCHAR2(255)

CAMPAIGN_GIVING_HISTORY

CAMPAIGN_NAME

NO

NO

ADVANCEMENT GIFT

CAMPAIGN_SD Short description defined in the cleansing process. VARCHAR2(255)

CAMPAIGN_GIVING_HISTORY

CAMPAIGN_NAME

NO

NO

ADVANCEMENT GIFT

CAMPAIGN_TYPE_LD Long description for the type of campaign. VARCHAR2(255)

CAMPAIGN_GIVING_HISTORY

CAMPAIGN_TYPE_DESC

NO

NO

ADVANCEMENT GIFT

CAMPAIGN_TYPE_SD Short description defined in the cleansing process. VARCHAR2(255)

CAMPAIGN_GIVING_HISTORY

CAMPAIGN_TYPE_DESC

NO

NO

ADVANCEMENT GIFT

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT



Ver: 3.1