RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GIVING_CODE_DETAIL

Description Giving code detail dimension table provides detail information about giving codes, including gift, pledge and matching gift code indicators and the associated transaction and sequence number. 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
GIFT_IND   NUMBER       NO
GIFT_IND_LD   VARCHAR2(255)       NO
GIFT_IND_SD   VARCHAR2(255)       NO
GIVING_CODE_COMMENT   VARCHAR2(255)       NO
GIVING_CODE_DETAIL_KEY   NUMBER       NO
GIVING_CODE_ID_NAME   VARCHAR2(255)       NO
GIVING_CODE_ID_NUMBER   VARCHAR2(63)       NO
MATCHING_GIFT_IND   NUMBER       NO
MATCHING_GIFT_IND_LD   VARCHAR2(255)       NO
MATCHING_GIFT_IND_SD   VARCHAR2(255)       NO
PLEDGE_IND   NUMBER       NO
PLEDGE_IND_LD   VARCHAR2(255)       NO
PLEDGE_IND_SD   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
TRANSACTION_NUMBER   VARCHAR2(63)       NO
TRANSACTION_SEQUENCE   NUMBER       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: 8.4.2