Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVE_DESIGNATION_IND
|
Designation status active indicator. Determines if the status is active (Y)es, or inactive (N)o.
|
VARCHAR2(1)
|
ATVDSTA
|
ATVDSTA_ACTIVE_IND
|
NO
|
NO
|
ACTIVITY_DATE
|
Date information for this record in the table was entered or last updated.
|
DATE
|
ADBDESG
|
ADBDESG_ACTIVITY_DATE
|
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
|
ALLOW_WEB_GIFT_IND
|
Indicates if gifts for this designation will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(ADBDESG_WEB_GIFT_IND,'N')
|
NO
|
NO
|
ALLOW_WEB_PLEGE_IND
|
Indicates if pledges for this designation will be accepted from the Web. (Y)es is accepted. (N)ot is not accepted.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(ADBDESG_WEB_PLDG_IND,'N')
|
NO
|
NO
|
DESG_COLLEGE
|
Specific college to which the fund is allocated or designated.
|
VARCHAR2(63)
|
ADBDESG
|
ADBDESG_COLL_CODE
|
NO
|
NO
|
DESG_COLLEGE_DESC
|
College description.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
DESG_DEPARTMENT
|
Department associated with the designation.
|
VARCHAR2(63)
|
ADBDESG
|
ADBDESG_DEPT_CODE
|
NO
|
NO
|
DESG_DEPARTMENT_DESC
|
Designation department description.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
DESG_GROUP
|
User defined attribute associating designations of similar purpose or function. 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 designation.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED
|
NO
|
NO
|
DESG_OUTRIGHT_GIFT_COUNT
|
Total number of outright gifts made to this designation.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_OUTRIGHT_GIFT_COUNT
|
NO
|
NO
|
DESG_OUTRIGHT_GIFT_DONOR_COUNT
|
Total number of donors who made one or more outright gifts to this designation.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_OUTRIGHT_GIFT_DONOR_CNT
|
NO
|
NO
|
DESG_PLEDGE_DONOR_NO_PAY_COUNT
|
Total number of donors who have not made any payments toward their pledges.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_DONOR_NO_PAY_CNT
|
NO
|
NO
|
DESG_PLEDGE_DONOR_PAID_COUNT
|
Total number of donors who have made payments toward their pledges. This could be fully paid or partial paid.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_DONOR_PAID_COUNT
|
NO
|
NO
|
DESG_STATUS
|
Current designation status.
|
VARCHAR2(63)
|
ADBDESG
|
ADBDESG_DSTA_CODE
|
NO
|
NO
|
DESG_STATUS_DESC
|
Designation status description.
|
VARCHAR2(255)
|
ATVSDTA
|
ATVDSTA_DESC
|
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)
|
ADBDESG
|
ADBDESG_DESG
|
NO
|
NO
|
DESIGNATION_END_DATE
|
Date the designation is no longer active.
|
DATE
|
ADBDESG
|
ADBDESG_END_DATE
|
NO
|
NO
|
DESIGNATION_NAME
|
Designation name.
|
VARCHAR2(255)
|
ADBDESG
|
ADBDESG_NAME
|
NO
|
NO
|
DESIGNATION_OUTRIGHT_GIFTS
|
Total amount received toward this designation for outright gifts.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_OUTRIGHT_GIFTS
|
NO
|
NO
|
DESIGNATION_PLEDGE_BALANCE
|
Total amount of outstanding pledges for this designation.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_BALANCE
|
NO
|
NO
|
DESIGNATION_PLEDGE_COUNT
|
Total number of pledges made to this designation.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_COUNT
|
NO
|
NO
|
DESIGNATION_PLEDGE_DONOR_COUNT
|
Total number of donors who made one or more pledges to this designation. This includes original donors and any individuals who received hard credit.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT
|
NO
|
NO
|
DESIGNATION_PLEDGE_PAYMENTS
|
Total amount of pledge payments made to this designation.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_PLEDGE_PAYMENT
|
NO
|
NO
|
DESIGNATION_PROJECT
|
Project to which this designation is assigned.
|
VARCHAR2(63)
|
AMRDESG
|
AMRDESG_PROJ_CODE
|
NO
|
NO
|
DESIGNATION_PROJECT_DESC
|
Designation project description.
|
VARCHAR2(255)
|
ATVPROJ
|
ATVPROJ_DESC
|
NO
|
NO
|
DESIGNATION_START_DATE
|
Date the designation becomes active.
|
DATE
|
ADBDESG
|
ADBDESG_START_DATE
|
NO
|
NO
|
DESIGNATION_TOTAL_DONOR_COUNT
|
Total number of donors who have made one or more gifts to this designation. This includes donors who have received hard credit from gifts made to this designation. This includes pledges made with no payment received to date.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
|
NO
|
NO
|
DESIGNATION_TOTAL_GIFTS
|
Total amount of gifts received toward this designation, including pledge payments and outright gifts.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_TOTAL_GIFTS
|
NO
|
NO
|
DESIGNATION_TOTAL_GIFT_COUNT
|
Total number of gifts made to this designation. This includes both payments and outright gifts.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_TOTAL_GIFT_COUNT
|
NO
|
NO
|
DESIGNATION_TOTAL_PLEDGES
|
Total amount of pledges made to this designation.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_DESG_TOTAL_PLEDGES
|
NO
|
NO
|
DESIGNATION_USER_ID
|
Unique identification code of the user who entered or last touched the designation.
|
VARCHAR2(63)
|
ADBDESG
|
ADBDESG_USER
|
NO
|
NO
|
FINANCIAL_AID_FUND_IND
|
Indicates that at least one financial aid fund for the designation is active.
|
VARCHAR2(1)
|
FUNCTION
|
SUBSTR (MAKFUNC.F_DESG_FINAID_FUND_IND
|
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
|
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
|