| 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
|