RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_GIVING_CODE

Description Giving code fact table provides giving code measures related to gifts, pledges and matching gifts, including giving date, amount, transaction number, and transaction sequence number.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
GIVING_CODE_AMOUNT   NUMBER       NO
GIVING_CODE_DATE   DATE       NO
GIVING_CODE_DETAIL_KEY   NUMBER       NO
GIVING_CODE_GROUP_KEY   NUMBER       NO
GIVING_CODE_KEY   NUMBER       NO
MULTI_SOURCE_KEY   NUMBER       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_MEASURE_01   NUMBER       NO
USER_MEASURE_02   NUMBER       NO
USER_MEASURE_03   NUMBER       NO
USER_MEASURE_04   NUMBER       NO
USER_MEASURE_05   NUMBER       NO


Ver: 8.4.2