SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GIVING_CODE
Description
Giving code dimension table provides the giving code, giving code type and description. 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
GIVING_CODE
VARCHAR2(63)
NO
GIVING_CODE_KEY
NUMBER
NO
GIVING_CODE_LD
VARCHAR2(255)
NO
GIVING_CODE_SD
VARCHAR2(255)
NO
GIVING_CODE_TYPE
VARCHAR2(63)
NO
GIVING_CODE_TYPE_LD
VARCHAR2(255)
NO
GIVING_CODE_TYPE_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.