Target Column |
Business Name |
Business Definition |
Database Data Type |
Business Data Type |
Domain Value |
Source Name |
Source Column |
Local Source |
Local Target |
CAMPAIGN
|
Campaign
|
Campaign that the constituent has responded to with a gift or pledge payment.
|
VARCHAR2(63)
|
|
|
AFRDESG
|
AFRDESG_CAMPAIGN
|
NO
|
NO
|
CAMPAIGN_NAME
|
Campaign Name
|
Campaign name.
|
VARCHAR2(255)
|
|
|
AFBCAMP
|
AFBCAMP_NAME
|
NO
|
NO
|
CAMPAIGN_TYPE
|
Campaign Type
|
Type of campaign recorded.
|
VARCHAR2(63)
|
|
|
AFBCAMP
|
AFBCAMP_CMTP_CODE
|
NO
|
NO
|
CAMPAIGN_TYPE_DESC
|
Campaign Type Description
|
Campaign type description.
|
VARCHAR2(255)
|
|
|
ATVCMTP
|
ATVCMTP_DESC
|
NO
|
NO
|
DESIGNATION
|
Designation
|
User defined code for a designation.
|
VARCHAR2(63)
|
|
|
AFRDESG
|
AFRDESG_DESG
|
NO
|
NO
|
DESIGNATION_NAME
|
Designation Name
|
Designation name.
|
VARCHAR2(255)
|
|
|
ADBDESG
|
ADBDESG_NAME
|
NO
|
NO
|
DESG_TYPE
|
Designation 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
|
Designation type description.
|
VARCHAR2(255)
|
|
|
ATVDSTP
|
ATVDSTP_DESC
|
NO
|
NO
|
DESG_GROUP
|
Designation 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
|
Designation group description.
|
VARCHAR2(255)
|
|
|
ATVDGRP
|
ATVDGRP_DESC
|
NO
|
NO
|
CAMPAIGN_DESIGNATION_GOAL
|
Campaign Designation Goal
|
Amount of the designation goal for the campaign.
|
NUMBER
|
|
|
CALCULATION
|
NVL(AFRDESG_GOAL,0)
|
NO
|
NO
|
DESG_PERCENT_OF_CAMPAIGN_GOAL
|
Designation Percent Of Campaign Goal
|
Percentage of the overall campaign goal this designation goal represents.
|
NUMBER
|
|
|
CALCULATION
|
AFRDESG_GOAL / AFBCAMP_GOAL * 100
|
NO
|
NO
|
PCT_DESG_PROGRESS_CAMP_GOAL
|
Percent Designation 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
|
Percent 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
|
CAMPAIGN_DESG_STATUS
|
Campaign Designation Status
|
Indicates designation status for the campaign.
|
VARCHAR2(63)
|
|
|
AFRDESG
|
AFRDESG_DSTA_CODE
|
NO
|
NO
|
CAMPAIGN_DESG_STATUS_DESC
|
Campaign Designation Status Description
|
Designation status description.
|
VARCHAR2(255)
|
|
|
ATVSDTA
|
ATVDSTA_DESC
|
NO
|
NO
|
DESG_VSE
|
Designation VSE - Voluntary Support of Education
|
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
|
Designation VSE - Voluntary Support of Education Description
|
Voluntary Support of Education purpose description.
|
VARCHAR2(255)
|
|
|
ATVCFAE
|
ATVCFAE_DESC
|
NO
|
NO
|
DESG_VSE_PURPOSE_TYPE
|
Designation VSE - Voluntary Support of Education 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
|
Designation VSE - Voluntary Support of Education Purpose Type Description
|
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
|
MATCHING_GIFT_VSE_PURPOSE
|
Matching Gift VSE - Voluntary Support of Education 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 VSE - Voluntary Support of Education Purpose Description
|
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
|
CAMP_DESG_TOTAL_PLEDGES
|
Camp Designation Total Pledges
|
Total amount of pledges made to this campaign designation combination.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES
|
NO
|
NO
|
CAMP_DESG_PLEDGE_PAYMENTS
|
Camp Designation 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_PLEDGE_BALANCE
|
Camp Designation 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_TOTAL_GIFTS
|
Camp Designation 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_OUTRIGHT_GIFTS
|
Camp Designation Outright Gifts
|
Total amount received toward this campaign designation combination for outright gifts.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS
|
NO
|
NO
|
RESTRICTED_IND
|
Restricted Indicator
|
Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.
|
VARCHAR2(1)
|
|
|
ADBDESG
|
ADBDESG_RESTR_IND
|
NO
|
NO
|
DESG_MATCH_GIFTS_ANTICIPATED
|
Designation Match Gifts Anticipated
|
Total amount of anticipated matching gifts toward this campaign designation combination.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED
|
NO
|
NO
|
CAMP_DESG_MATCHING_GIFTS_PAID
|
Camp Designation 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_PLEDGE_DONOR_COUNT
|
Camp Designation 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_COUNT
|
Camp Designation Pledge Count
|
Total number of pledges made to this campaign designation combination.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_COUNT
|
NO
|
NO
|
CAMP_DESG_TOTAL_DONOR_COUNT
|
Camp Designation 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
|
DESG_PLEDGE_DONOR_PAID_COUNT
|
Designation 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_PLEDGE_DONOR_NO_PAY_COUNT
|
Designation Pledge Donor Number 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_OUTRIGHT_GIFT_DONOR_COUNT
|
Designation 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
|
CAMP_DESG_OUTRIGHT_GIFT_COUNT
|
Camp Designation Outright Gift Count
|
Total number of outright gifts made to this campaign designation combination.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_DESG_CAMP_GIFT_COUNT
|
NO
|
NO
|
MULTI_SOURCE
|
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
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
|
NA
|
NA
|
NO
|
NO
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
|
NA
|
NA
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
|
NA
|
NA
|
NO
|
NO
|
CAMP_DESG_TOTAL_GIFT_COUNT
|
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
|
ACTIVE_DESIGNATION_IND
|
Active Designation Indicator
|
Designation status active indicator determining if the status is active (Y)es, or inactive (N)o.
|
VARCHAR2(1)
|
|
|
ATVDSTA
|
ATVDSTA_ACTIVE_IND
|
NO
|
NO
|