RETURN TO DIMENSION TABLE REPORTS LIST
Advancement Gift Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_PLEDGE

Description Pledge Dimension table provides information on whether the gift was the result of a pledge. This information includes type of pledge, method of pledge and amount of pledge, etc.. It uses the cleansing rules in the EDW for the short and long descriptions and for the ranges for the original and outstanding pledge amounts.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
FINAL_INSTALL_MONTH Month the final installment is scheduled to be received. Calculated based on the PLEDGE_INSTALLMENT reporting view - INSTALLMENT_DATE that is the greatest and using the Year part of the date. VARCHAR2(63)

PLEDGE

FUNCTION

NO

NO

ADVANCEMENT GIFT

FINAL_INSTALL_MONTH_LD Long description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

FINAL_INSTALL_MONTH_SD Short description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

FINAL_INSTALL_YEAR Year the final installment is scheduled to be received. Calculated based on the PLEDGE_INSTALLMENT reporting view - INSTALLMENT_DATE that is the greatest and using the month part of the date. VARCHAR2(63)

PLEDGE

FUNCTION

NO

NO

ADVANCEMENT GIFT

FINAL_INSTALL_YEAR_LD Long description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

FINAL_INSTALL_YEAR_SD Short description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

ORIGINAL_PLEDGE_RANGE Determined by the rules defined and the original PLEDGE_AMOUNT. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

ORIGINAL_PLEDGE_RANGE_LD Long description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

ORIGINAL_PLEDGE_RANGE_SD Short description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

OUTSTANDING_PLEDGE_RANGE Determined by the rules defined and the PLEDGE_BALANCE. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

OUTSTANDING_PLEDGE_RANGE_LD Long description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

OUTSTANDING_PLEDGE_RANGE_SD Short description defined in the cleansing process. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

ADVANCEMENT GIFT

PLEDGE_KEY Key for the pledge dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

PLEDGE_TYPE Specifies the type of pledge recorded. VARCHAR2(63)

PLEDGE

PLEDGE_TYPE

NO

NO

ADVANCEMENT GIFT

PLEDGE_TYPE_LD Long description of the pledge type code. VARCHAR2(255)

PLEDGE

PLEDGE_TYPE_DESC

NO

NO

ADVANCEMENT GIFT

PLEDGE_TYPE_SD Short description defined in the cleansing process. VARCHAR2(255)

PLEDGE

PLEDGE_TYPE_DESC

NO

NO

ADVANCEMENT GIFT

PLEDGE_VEHICLE Pledge gift vehicle code associated with this pledge. This might be cash, property, vehicle, etc. VARCHAR2(63)

PLEDGE

PLEDGE_VEHICLE

NO

NO

ADVANCEMENT GIFT

PLEDGE_VEHICLE_LD Long description of the pledge gift vehicle. VARCHAR2(255)

PLEDGE

PLEDGE_VEHICLE_DESC

NO

NO

ADVANCEMENT GIFT

PLEDGE_VEHICLE_SD Short description defined in the cleansing process. VARCHAR2(255)

PLEDGE

PLEDGE_VEHICLE_DESC

NO

NO

ADVANCEMENT GIFT

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT



Ver: 3.1