RETURN TO DIMENSION TABLE REPORTS LIST
Advancement Gift Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_GIFT

Description Gift Dimension table provides details regarding the gift. This information includes information on the type of gift, whether there is an auxiliary or matching gift and the method by which the gift was received. 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_AUXILIARY_TYPE Identifies the type of auxiliary gift is associated with this gift when the amount is greater than zero. VARCHAR2(63)

GIFT_AUXILIARY

AUXILARY

NO

NO

ADVANCEMENT GIFT

GIFT_AUXILIARY_TYPE_LD Long description for the auxiliary code associated with the gift. VARCHAR2(255)

GIFT_AUXILIARY

AUXILARY_DESC

NO

NO

ADVANCEMENT GIFT

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

GIFT_AUXILIARY

AUXILARY_DESC

NO

NO

ADVANCEMENT GIFT

GIFT_KEY Key for the gift dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

GIFT_TYPE Gift vehicle for example in honor of, In memory of, anonymous. VARCHAR2(63)

GIFT

GIFT_TYPE

NO

NO

ADVANCEMENT GIFT

GIFT_TYPE_LD Long description for the type of gift. VARCHAR2(255)

GIFT

GIFT_TYPE_DESC

NO

NO

ADVANCEMENT GIFT

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

GIFT

GIFT_TYPE_DESC

NO

NO

ADVANCEMENT GIFT

GIFT_VEHICLE Method of how the gift was received. This might be cash, property, vehicle, etc. VARCHAR2(63)

GIFT

GIFT_VEHICLE

NO

NO

ADVANCEMENT GIFT

GIFT_VEHICLE_LD Long description for the vehicle for the gift. VARCHAR2(255)

GIFT

GIFT_VEHICLE_DESC

NO

NO

ADVANCEMENT GIFT

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

GIFT

GIFT_VEHICLE_DESC

NO

NO

ADVANCEMENT GIFT

GIVING_TOWARD_GOAL_IND Indicates if the giving was toward a campaign goal. This will be populated with a 'Y' or yes when the CAMPAIGN on the GIFT reporting view is not blank. VARCHAR2(63)

GIFT

FUNCTION

NO

NO

ADVANCEMENT GIFT

MATCH_IND Determined when the GIFT has a MATCHING_GIFT_COUNT that is greater than zero. VARCHAR2(63)

GIFT

FUNCTION

NO

NO

ADVANCEMENT GIFT

PLEDGE_PAYMENT_IND Determined when the PLEDGE - PLEDGE_AMOUNT_PAID is greater than zero. VARCHAR2(63)

GIFT

FUNCTION

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