SGHE Banner Operational Data Store
Composite View Source: WFT_GIFT - NULL
| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
| ADVANCEMENT_APPEAL_KEY |
TBD |
|
|
|
|
| ADVANCEMENT_PROGRAM_KEY |
TBD |
|
|
|
|
| CAMPAIGN_KEY |
TBD |
|
|
|
|
| CAMPAIGN_TRANSACTION_AMOUNT |
TBD |
|
|
|
|
| CLASS_SCHOOL_KEY |
TBD |
|
|
|
|
| CONSTITUENT_ENTITY_TYPE_KEY |
TBD |
|
|
|
|
| DESIGNATION_KEY |
TBD |
|
|
|
|
| DONOR_UID |
TBD |
|
|
|
|
| FUNDRAISING_INITIATIVE_KEY |
TBD |
|
|
|
|
| GIFT_CREDIT2_AMOUNT |
TBD |
|
|
|
|
| GIFT_CURRENCY_AMOUNT |
TBD |
|
|
|
|
| GIFT_DATE_OF_RECORD |
TBD |
|
|
|
|
| GIFT_DESIGNATION_COUNT |
TBD |
|
|
|
|
| GIFT_DETAIL_KEY |
TBD |
|
|
|
|
| GIFT_DONOR_COUNT |
TBD |
|
|
|
|
| GIFT_KEY |
TBD |
|
|
|
|
| GIFT_PREMIUM_COUNT |
TBD |
|
|
|
|
| GIFT_REPORTING_INDICATOR_KEY |
TBD |
|
|
|
|
| GIVING_ATTRIBUTE_KEY |
TBD |
|
|
|
|
| HARD_CREDIT_AMOUNT |
TBD |
|
|
|
|
| HARD_CREDIT_DONOR_COUNT |
TBD |
|
|
|
|
| MATCH_CREDIT_RECIPIENT_COUNT |
TBD |
|
|
|
|
| MATCH_GIFT_AMOUNT |
TBD |
|
|
|
|
| MATCH_GIFT_COUNT |
TBD |
|
|
|
|
| MATCH_GIFT_DONOR_COUNT |
TBD |
|
|
|
|
| MATCH_GIFT_SOFT_CREDIT_AMOUNT |
TBD |
|
|
|
|
| MULTI_SOURCE_KEY |
TBD |
|
|
|
|
| NET_PRESENT_VALUE_AMOUNT |
TBD |
|
|
|
|
| NON_MATCHED_SOFT_CREDIT_AMOUNT |
TBD |
|
|
|
|
| OVERALL_TRANSACTION_AMOUNT |
TBD |
|
|
|
|
| PROPOSAL_KEY |
TBD |
|
|
|
|
| REUNION_CAMPAIGN_KEY |
TBD |
|
|
|
|
| SOFT_CREDIT_AMOUNT |
TBD |
|
|
|
|
| SOFT_CREDIT_DONOR_COUNT |
TBD |
|
|
|
|
| SOURCE_DONOR_ENTITY_KEY |
TBD |
|
|
|
|
| SOURCE_DONOR_UID |
TBD |
|
|
|
|
| TOTAL_GIFT_PREMIUM_AMOUNT |
TBD |
|
|
|
|
| TRANSACTION_COUNT |
TBD |
|
|
|
|
| USER_MEASURE_01 |
TBD |
|
|
|
|
| YEAR_OF_GIVING_KEY |
TBD |
|
|
|
|