Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVE_DESIGNATION_IND
|
Designation status active indicator determining if the status is active (Y)es, or inactive (N)o.
|
VARCHAR2(1)
|
ATVDSTA
|
ATVDSTA_ACTIVE_IND
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
CAMPAIGN
|
Campaign that the constituent has responded to with a gift or pledge payment.
|
VARCHAR2(63)
|
AFRDESG
|
AFRDESG_CAMPAIGN
|
NO
|
NO
|
CAMPAIGN_DESG_STATUS
|
Indicates designation status for the campaign.
|
VARCHAR2(63)
|
AFRDESG
|
AFRDESG_DSTA_CODE
|
NO
|
NO
|
CAMPAIGN_DESG_STATUS_DESC
|
Designation status description.
|
VARCHAR2(255)
|
ATVSDTA
|
ATVDSTA_DESC
|
NO
|
NO
|
CAMPAIGN_DESIGNATION_GOAL
|
Amount of the designation goal for the campaign.
|
NUMBER
|
CALCULATION
|
NVL(AFRDESG_GOAL,0)
|
NO
|
NO
|
CAMPAIGN_NAME
|
Campaign name.
|
VARCHAR2(255)
|
AFBCAMP
|
AFBCAMP_NAME
|
NO
|
NO
|
CAMPAIGN_TYPE
|
Type of campaign recorded.
|
VARCHAR2(63)
|
AFBCAMP
|
AFBCAMP_CMTP_CODE
|
NO
|
NO
|
CAMPAIGN_TYPE_DESC
|
Campaign type description.
|
VARCHAR2(255)
|
ATVCMTP
|
ATVCMTP_DESC
|
NO
|
NO
|
CAMP_DESG_MATCHING_GIFTS_PAID
|
Corporate gift received that matches an eligible employee gift to this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_MATCH_GIFTS_PAID
|
NO
|
NO
|
CAMP_DESG_OUTRIGHT_GIFTS
|
Total amount received toward this campaign designation combination for outright gifts.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS
|
NO
|
NO
|
CAMP_DESG_OUTRIGHT_GIFT_COUNT
|
Total number of outright gifts made to this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_GIFT_COUNT
|
NO
|
NO
|
CAMP_DESG_PLEDGE_BALANCE
|
Total amount of outstanding pledges for this campaign designation combination.
|
NUMBER
|
CALCULATION
|
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS
|
NO
|
NO
|
CAMP_DESG_PLEDGE_COUNT
|
Total number of pledges made to this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_COUNT
|
NO
|
NO
|
CAMP_DESG_PLEDGE_DONOR_COUNT
|
Total number of donors who made one or more pledges to this campaign designation combination. This includes original donors and any individuals who received hard credit.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT
|
NO
|
NO
|
CAMP_DESG_PLEDGE_PAYMENTS
|
Total amount of pledge payments made to this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS
|
NO
|
NO
|
CAMP_DESG_TOTAL_DONOR_COUNT
|
Total number of donors who have made one or more gifts to this campaign designation combination. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
|
NO
|
NO
|
CAMP_DESG_TOTAL_GIFTS
|
Total amount of gifts received toward this campaign designation combination, including pledge payments and outright gifts.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS
|
NO
|
NO
|
CAMP_DESG_TOTAL_GIFT_COUNT
|
Total number of gifts made to this campaign designation combination. This includes both payments and outright gifts.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_GIFT_COUNT
|
NO
|
NO
|
CAMP_DESG_TOTAL_PLEDGES
|
Total amount of pledges made to this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES
|
NO
|
NO
|
DESG_GROUP
|
Group associated with the designation. You can group similar designations together for institutional reporting. For example, designations by campaign objectives.
|
VARCHAR2(63)
|
ADBDESG
|
ADBDESG_DGRP_CODE
|
NO
|
NO
|
DESG_GROUP_DESC
|
Designation group description.
|
VARCHAR2(255)
|
ATVDGRP
|
ATVDGRP_DESC
|
NO
|
NO
|
DESG_MATCH_GIFTS_ANTICIPATED
|
Total amount of anticipated matching gifts toward this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED
|
NO
|
NO
|
DESG_OUTRIGHT_GIFT_DONOR_COUNT
|
Total number of donors who made one or more outright gifts to this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
|
NO
|
NO
|
DESG_PERCENT_OF_CAMPAIGN_GOAL
|
Percentage of the overall campaign goal this designation goal represents.
|
NUMBER
|
CALCULATION
|
AFRDESG_GOAL / AFBCAMP_GOAL * 100
|
NO
|
NO
|
DESG_PLEDGE_DONOR_NO_PAY_COUNT
|
Total number of donors who have not made any payments toward their pledges to this campaign designation combination.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT
|
NO
|
NO
|
DESG_PLEDGE_DONOR_PAID_COUNT
|
Total number of donors who have made payments toward their pledges to this campaign designation combination. This could be fully paid or partial paid.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
|
NO
|
NO
|
DESG_TYPE
|
Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing.
|
VARCHAR2(63)
|
ADBDESG
|
ADBDESG_DSTP_CODE
|
NO
|
NO
|
DESG_TYPE_DESC
|
Designation type description.
|
VARCHAR2(255)
|
ATVDSTP
|
ATVDSTP_DESC
|
NO
|
NO
|
DESG_VSE
|
Predefined code determining the purpose for giving as defined for Council for Aid to Education reporting.
|
VARCHAR2(63)
|
ADBDESG
|
ADBDESG_CFAE_CODE
|
NO
|
NO
|
DESG_VSE_DESC
|
Voluntary Support of Education purpose description.
|
VARCHAR2(255)
|
ATVCFAE
|
ATVCFAE_DESC
|
NO
|
NO
|
DESG_VSE_PURPOSE_TYPE
|
Voluntary Support of Education purpose type as defined for Council for Aid to Education reporting.
|
NUMBER
|
ATVCFAE
|
ATVCFAE_TYPE
|
NO
|
NO
|
DESG_VSE_PURPOSE_TYPE_DESC
|
Voluntary Support of Education purpose type description.
|
VARCHAR2(255)
|
CONSTANT
|
HARCODED DESCRIPTIONS. SEE THE ONLINE HELP FOR BANNER FORM ATVVSER FOR A COMPLETE LIST OF VALUES.
|
NO
|
NO
|
DESIGNATION
|
User defined code for a designation.
|
VARCHAR2(63)
|
AFRDESG
|
AFRDESG_DESG
|
NO
|
NO
|
DESIGNATION_NAME
|
Designation name.
|
VARCHAR2(255)
|
ADBDESG
|
ADBDESG_NAME
|
NO
|
NO
|
MATCHING_GIFT_VSE_PURPOSE
|
The Matching Gift Purpose associates the Voluntary Support of Education code to a matching gift related purpose.
|
VARCHAR2(63)
|
ATVCFAE
|
ATVCFAE_MG_PURPOSE
|
NO
|
NO
|
MATCHING_GIFT_VSE_PURPOSE_DESC
|
Matching gift Voluntary Support of Education purpose description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(ATVCFAE_MG_PURPOSE,'A','ALUMNI OR OTHER ASSOCIATIONS','B','RELIGIOUS PURPOSES AT THE INSTITUTION','C','POLITICAL PURPOSES AT THE INSTITUTION','D','ATHLETIC ACTIVITIES','E','ATHLETIC SCHOLARSHIP FUNDS','F','NON-ATHLETIC SCHOLARSHIP FUNDS',ETC.)
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PCT_DESG_PROGRESS_CAMP_GOAL
|
Percentage of progress toward the campaign goal represented by the gift amount received for this designation. This includes the outstanding pledge balance.
|
NUMBER
|
CALCULATION
|
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100
|
NO
|
NO
|
PCT_PROGRESS_DESIGNATION_GOAL
|
Percentage progress toward the designation goal for this campaign represented by the gift amount received for this designation. This includes the outstanding pledge balance.
|
NUMBER
|
CALCULATION
|
(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
RESTRICTED_IND
|
Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.
|
VARCHAR2(1)
|
ADBDESG
|
ADBDESG_RESTR_IND
|
NO
|
NO
|