RETURN TO FACT TABLE REPORTS LIST
Advancement Gift Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ADVANCEMENT_GIFT

Description Advancement Gift Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person or entity per time frame per gift number and optionally pledge number.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
AUXILIARY_ACTUAL_VALUE Dependent on the corresponding auxiliary code. May include the amount of the gift to be designated to a particular donor category or class year, the actual cost to the institution for a benefit/premium, or the face value of a gift. NUMBER

GIFT_AUXILIARY

ACTUAL_VALUE

NO

NO

ADVANCEMENT GIFT

AUXILIARY_VALUE Dependent on the corresponding auxiliary code. May include the fair market value of an associated benefit/premium, or the present market value of a gift. NUMBER

GIFT_AUXILIARY

AUXILIARY_VALUE

NO

NO

ADVANCEMENT GIFT

CAMPAIGN_KEY Key for the campaign dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

CONSTITUENT_KEY Key for the constituent dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

DESIGNATION_KEY Key for the designation dimension. NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

ENTITY_UID Unique identifier for the person or organization. NUMBER

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

PERSON_UID

ENTITY_UID

NO

NO

ADVANCEMENT GIFT

GIFT_AMOUNT Amount collected for the gift. NUMBER

GIFT

GIFT_AMOUNT

NO

NO

ADVANCEMENT GIFT

GIFT_KEY Key for the gift dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

GIFT_NUMBER Gift number associated with the donation. VARCHAR2(63)

GIFT_AUXILIARY

GIFT_NUMBER

NO

NO

ADVANCEMENT GIFT

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

ORIGINAL_PLEDGE_AMOUNT Amount assigned when this was pledged to the institution NUMBER

PLEDGE

PLEDGE_AMOUNT

NO

NO

ADVANCEMENT GIFT

OUTSTANDING_PLEDGE_AMOUNT Amount of the original pledged amount that has not been collected. NUMBER

PLEDGE

PLEDGE_BALANCE

NO

NO

ADVANCEMENT GIFT

PLEDGE_KEY Key for the pledge dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

PLEDGE_NUMBER Match the PLEDGE_NUMBER on the GIFT with the PLEDGE_NUMBER on the PLEDGE. VARCHAR2(63)

GIFT

PLEDGE_NUMBER

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

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT



Ver: 3.1