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)
|
|
|
AFRCSOL
|
AFRCSOL_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
|
SOLICITATION_TYPE
|
Solicitation Type
|
Campaign solicitation type.
|
VARCHAR2(63)
|
|
|
AFRCSOL
|
AFRCSOL_SOLC_CODE
|
NO
|
NO
|
SOLICITATION_TYPE_DESC
|
Solicitation Type Description
|
Campaign solicitation type description.
|
VARCHAR2(255)
|
|
|
ATVSOLC
|
ATVSOLC_DESC
|
NO
|
NO
|
CAMPAIGN_SOLICITATION_GOAL
|
Campaign Solicitation Goal
|
Amount of the solicitation goal for the campaign.
|
NUMBER
|
|
|
CALCULATION
|
NVL(AFRCSOL_GOAL,0)
|
NO
|
NO
|
SOLICITATION_TOTAL_PLEDGES
|
Solicitation Total Pledges
|
Total amount of pledges made as a result of this solicitation type for this campaign.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES
|
NO
|
NO
|
SOLICITATION_PLEDGE_PAYMENTS
|
Solicitation Pledge Payments
|
Total amount of pledge payments received as a result of this solicitation type for this campaign.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS
|
NO
|
NO
|
SOLICITATION_PLEDGE_BALANCE
|
Solicitation Pledge Balance
|
Total amount of outstanding pledges for this campaign solicitation type combination.
|
NUMBER
|
|
|
CALCULATION
|
MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS
|
NO
|
NO
|
SOLICITATION_TOTAL_GIFTS
|
Solicitation Total Gifts
|
Total amount of gifts received towards this campaign solicitation type combination, including pledge payments and outright gifts.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS
|
NO
|
NO
|
SOLICITATION_OUTRIGHT_GIFTS
|
Solicitation Outright Gifts
|
Total amount of outright gifts received as a result of this solicitation type for this campaign.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS
|
NO
|
NO
|
ACTIVITY_DATE
|
Activity Date
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
|
|
AFRCSOL
|
AFRCSOL_ACTIVITY_DATE
|
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
|
SOLT_PERCENT_OF_CAMPAIGN_GOAL
|
Solt Percent Of Campaign Goal
|
Percentage of the overall campaign goal this solicitation type goal represents.
|
NUMBER
|
|
|
CALCULATION
|
AFRCSOL_GOAL / AFBCAMP_GOAL * 100
|
NO
|
NO
|
PCT_SOLT_PROGRESS_CAMP_GOAL
|
Percent Solt Progress Camp Goal
|
Percentage of progress toward the campaign goal represented by the gift amount received for this solicitation type. This includes the outstanding pledge balance.
|
NUMBER
|
|
|
CALCULATION
|
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100
|
NO
|
NO
|
PCT_PROGRESS_SOLT_GOAL
|
Percent Progress Solt Goal
|
Percentage of progress toward the solicitation goal for this campaign represented by the gift amount received for this solicitation type. This includes the outstanding pledge balance.
|
NUMBER
|
|
|
CALCULATION
|
(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFRCSOL_GOAL * 100
|
NO
|
NO
|
SOLT_PLEDGE_DONOR_COUNT
|
Solt Pledge Donor Count
|
Total number of donors who made one or more pledges as a result of this solicitation type for this campaign. This includes original donors and any individuals who received hard credit.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_PLEDGE_DONOR_COUNT
|
NO
|
NO
|
SOLT_PLEDGE_COUNT
|
Solt Pledge Count
|
Total number of pledges made as a result of this solicitation type for this campaign.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_PLEDGE_COUNT
|
NO
|
NO
|
SOLT_CAMP_TOTAL_DONOR_COUNT
|
Solt Camp Total Donor Count
|
Total number of donors who have made one or more gifts to this solicitation type for this campaign. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT
|
NO
|
NO
|
SOLT_PLEDGE_DONOR_PAID_COUNT
|
Solt Pledge Donor Paid Count
|
Total number of donors who have made payments toward at least one of their pledges to this solicitation type for this campaign. This could be fully paid or partial paid for any one or more of the pledges.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT
|
NO
|
NO
|
SOLT_PLEDGE_DONOR_NO_PAY_COUNT
|
Solt Pledge Donor Number Pay Count
|
Total number of donors who have not made any payments toward their pledges to this solicitation type for this campaign.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_PLEDGE_DONOR_COUNT
|
NO
|
NO
|
SOLT_OUTRIGHT_GIFT_DONOR_COUNT
|
Solt Outright Gift Donor Count
|
Total number of donors who made one or more outright gifts to this solicitation type for this campaign.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT
|
NO
|
NO
|
SOLT_CAMP_TOTAL_GIFT_COUNT
|
Solt Camp Total Gift Count
|
Total number of gifts made to this solicitation type for this campaign. This includes both payments and outright gifts.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLG_CAMP_GIFT_COUNT
|
NO
|
NO
|
SOLT_CAMP_OUTRIGHT_GIFT_COUNT
|
Solt Camp Outright Gift Count
|
Total number of outright gifts made to this campaign designation combination.
|
NUMBER
|
|
|
FUNCTION
|
MAKFUNC.F_SOLG_CAMP_GIFT_COUNT
|
NO
|
NO
|