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
CODE_SEQUENCE
System generated one-up number uniquely identifying the giving code record for an individual giving transaction.
NUMBER
NO
GIVING_CODE_AMOUNT
Gift code amount.
NUMBER
NO
GIVING_CODE_DATE
Date a gift or pledge is received for the gift code.
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
Gift transaction receipt number. All gifts associated with one primary gift or a matching gift will have the same gift number.
VARCHAR2(63)
NO
TRANSACTION_SEQUENCE
System generated one-up number uniquely identifying the gift record.