RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FUNDRAISING_GOAL

Description Fundraising goal dimension table provides goal information about the goal type, goal identifiers and goal amount. 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
FUNDRAISING_GOAL_AMOUNT Fundraising goal amount. NUMBER       NO
FUNDRAISING_GOAL_IDENTIFIER_01 Fundraising goal first identifier. VARCHAR2(63)       NO
FUNDRAISING_GOAL_IDENTIFIER_02 Fundraising goal second identifier. VARCHAR2(63)       NO
FUNDRAISING_GOAL_IDENTIFIER_03 Fundraising goal third identifier. VARCHAR2(63)       NO
FUNDRAISING_GOAL_KEY   NUMBER       NO
FUNDRAISING_GOAL_TYPE Type of fundraising goal such as (CAMP) campaign, CAMP.DESG for campaign designation, and FNDP for funding purposed. VARCHAR2(63)       NO
FUNDRAISING_GOAL_TYPE_LD Fundraising goal type long description. VARCHAR2(255)       NO
FUNDRAISING_GOAL_TYPE_SD Fundraising goal type short description. VARCHAR2(255)       NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)       NO
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE       NO
USER_ATTRIBUTE_01   VARCHAR2(63)       NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_02   VARCHAR2(63)       NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_03   VARCHAR2(63)       NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_04   VARCHAR2(63)       NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_05   VARCHAR2(63)       NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)       NO


Ver: 9.0