Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: DESIGNATION

Description Contains data about a designation. This contains designation information, total pledges, pledge payments and gifts with matching information and various counts for the designation.
Key & Frequency One occurrence per designation.
Recommended Search Columns DESIGNATION
DESG_TYPE
DESG_GROUP

Target Column Business Definition Database Data Type Source Name Source Column
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

ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

ADBDESG

ADBDESG_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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')

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')

DESG_COLLEGE Specific college to which the fund is allocated or designated. VARCHAR2(63)

ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC College description. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Designation department description. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

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

DESG_GROUP_DESC Designation group description. VARCHAR2(255)

ATVDGRP

ATVDGRP_DESC

DESG_MATCH_GIFTS_ANTICIPATED Total amount of anticipated matching gifts toward this designation. NUMBER

FUNCTION

MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED

DESG_OUTRIGHT_GIFT_COUNT Total number of outright gifts made to this designation. NUMBER

FUNCTION

MAKFUNC.F_DESG_OUTRIGHT_GIFT_COUNT

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

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

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

DESG_STATUS Current designation status. VARCHAR2(63)

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Designation status description. VARCHAR2(255)

ATVSDTA

ATVDSTA_DESC

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

DESG_TYPE_DESC Designation type description. VARCHAR2(255)

ATVDSTP

ATVDSTP_DESC

DESG_VSE Predefined code determining the purpose for giving as defined for Council for Aid to Education reporting. VARCHAR2(63)

ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Voluntary Support of Education purpose description. VARCHAR2(255)

ATVCFAE

ATVCFAE_DESC

DESG_VSE_PURPOSE_TYPE Voluntary Support of Education purpose type as defined for Council for Aid to Education reporting. NUMBER

ATVCFAE

ATVCFAE_TYPE

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.

DESIGNATION User defined code for a designation. VARCHAR2(63)

ADBDESG

ADBDESG_DESG

DESIGNATION_END_DATE Date the designation is no longer active. DATE

ADBDESG

ADBDESG_END_DATE

DESIGNATION_NAME Designation name. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

DESIGNATION_OUTRIGHT_GIFTS Total amount received toward this designation for outright gifts. NUMBER

FUNCTION

MAKFUNC.F_DESG_OUTRIGHT_GIFTS

DESIGNATION_PLEDGE_BALANCE Total amount of outstanding pledges for this designation. NUMBER

FUNCTION

MAKFUNC.F_DESG_PLEDGE_BALANCE

DESIGNATION_PLEDGE_COUNT Total number of pledges made to this designation. NUMBER

FUNCTION

MAKFUNC.F_DESG_PLEDGE_COUNT

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

DESIGNATION_PLEDGE_PAYMENTS Total amount of pledge payments made to this designation. NUMBER

FUNCTION

MAKFUNC.F_DESG_PLEDGE_PAYMENT

DESIGNATION_PROJECT Project to which this designation is assigned. VARCHAR2(63)

AMRDESG

AMRDESG_PROJ_CODE

DESIGNATION_PROJECT_DESC Designation project description. VARCHAR2(255)

ATVPROJ

ATVPROJ_DESC

DESIGNATION_START_DATE Date the designation becomes active. DATE

ADBDESG

ADBDESG_START_DATE

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

DESIGNATION_TOTAL_GIFTS Total amount of gifts received toward this designation, including pledge payments and outright gifts. NUMBER

FUNCTION

MAKFUNC.F_DESG_TOTAL_GIFTS

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

DESIGNATION_TOTAL_PLEDGES Total amount of pledges made to this designation. NUMBER

FUNCTION

MAKFUNC.F_DESG_TOTAL_PLEDGES

DESIGNATION_USER_ID Unique identification code of the user who entered or last touched the designation. VARCHAR2(63)

ADBDESG

ADBDESG_USER

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

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

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.)

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RESTRICTED_IND Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years. VARCHAR2(1)

ADBDESG

ADBDESG_RESTR_IND



Ver: 9.1