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

SGHE Banner Operational Data Store
Reporting View Target: GIFT

Description Contains detail information for all gift/payments received from or multiple credit awarded to donors at the designation level with supplemental information related to donor attributes, associated matching gifts and solicitations.
Key & Frequency One row per entity per gift number per pledge number per campaign per designation.
Recommended Search Columns CAMPAIGN_TYPE
ENTITY_UID, ENTITY_IND
ENTITY_IND
DESIGNATION
DESG_TYPE
DESG_GROUP
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, CAMPAIGN, DESIGNATION
GIFT_DATE
FISCAL_YEAR
CAMPAIGN, PLEDGE_NUMBER
ENTITY_UID, PLEDGE_NUMBER
SOLICITOR_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY_DATE Activity Date Specifies the date this record was created or updated. DATE  

AGRGDES

AGRGDES_ACTIVITY_DATE

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

NA

NA

CAMPAIGN Campaign Campaign code associated with the gift. VARCHAR2(63)  

AGRGDES

AGRGMLT

AGRGDES_CAMPAIGN

AGRGMLT_CAMPAIGN

CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)  

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)  

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)  

ATVCMTP

ATVCMTP_DESC

DECEASED_DATE Deceased Date Date the person died. DATE  

SPBPERS

SPBPERS_DEAD_DATE

DECEASED_STATUS Deceased Status Indicates whether a person is deceased. VARCHAR2(1)  

SPBPERS

SPBPERS_DEAD_IND

DESG_ACCOUNT Desg Account User defined value representing an account. Accounts are assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(63)  

ADBDESG

ADBDESG_ACCT_CODE

DESG_ACCOUNT_DESC Desg Account Description Designation account code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_ACCOUNT_INDEX Desg Account INDEX User-defined value representing a summarization of any combination of chart of accounts information. VARCHAR2(63)  

ADBDESG

ADBDESG_ACCI_CODE

DESG_ACCOUNT_INDEX_DESC Desg Account INDEX Description Designation account index code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_ACTIVITY Desg Activity User-defined code attribute that may be used to identify accounting data by activity. VARCHAR2(63)  

ADBDESG

ADBDESG_ACTV_CODE

DESG_ACTIVITY_DESC Desg Activity Description Designation activity code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_CHART_OF_ACCOUNT Desg Chart Of Account Primary identification code for any chart of accounts that is used to uniquely identify that chart from any other in a multi-chart environment. VARCHAR2(63)  

ADBDESG

ADBDESG_COAS_CODE

DESG_CHART_OF_ACCOUNT_DESC Desg Chart Of Account Description Designation chart of accounts code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_COLLEGE Desg College College code associated with the designation. VARCHAR2(63)  

ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC Desg College Description College, faculty or school name. VARCHAR2(255)  

STVCOLL

STVCOLL_DESC

DESG_DEPARTMENT Desg Department Department associated with the designation. VARCHAR2(63)  

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Desg Department Description Name of the department. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

DESG_FUND Desg Fund Unique fiscal entity code. VARCHAR2(63)  

ADBDESG

ADBDESG_FUND_CODE

DESG_FUND_DESC Desg Fund Description Designation fund code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_GENERAL_LEDGER_NUMBER Designation General Ledger Number General ledger credit account number associated with the designation. VARCHAR2(63)  

ADBDESG

ADBDESG_GL_NO_CREDIT

DESG_GROUP Desg Group User defined attribute for associating designations of similar purpose or function. VARCHAR2(63)  

ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Desg Group Description Description of the designation group. VARCHAR2(255)  

ATVDGRP

ATVDGRP_DESC

DESG_LOCATION Desg Location Physical location of the institution's financial manager. For example, vice president, finance, suite 10, Adams Hall, main campus. VARCHAR2(63)  

ADBDESG

ADBDESG_LOCN_CODE

DESG_LOCATION_DESC Desg Location Description Designation location code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_ORGANIZATION Desg Organization Individual organization code that appears on a transaction. VARCHAR2(63)  

ADBDESG

ADBDESG_ORGN_CODE

DESG_ORGANIZATION_DESC Desg Organization Description Designation organization code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_PROGRAM Desg Program User-defined value to the program classification structure code, or a subset of that structure, as defined by the national council of higher education management systems. VARCHAR2(63)  

ADBDESG

ADBDESG_PROG_CODE

DESG_PROGRAM_DESC Desg Program Description Designation program code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DESG_STATUS Desg Status The current status of the designation. VARCHAR2(63)  

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Desg Status Description Description of the designation status. VARCHAR2(255)  

ATVDSTA

ATVDSTA_DESC

DESG_TYPE Desg Type Designation type for a specific pledge or gift designation. VARCHAR2(63)  

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Desg Type Description Designation type description. VARCHAR2(255)  

ATVDSTP

ATVDSTP_DESC

DESG_VSE Desg VSE - Voluntary Support of Education Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting. VARCHAR2(63)  

ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Desg VSE - Voluntary Support of Education Description Voluntary support of education code description. VARCHAR2(255)  

ATVCFAE

ATVCFAE_DESC

DESIGNATION Designation Designation associated with the gift. VARCHAR2(63)  

AGRGDES

AGRGMLT

AGRGDES_DESG

AGRGMLT_DESG

DESIGNATION_NAME Designation Name Designation description. VARCHAR2(255)  

ADBDESG

ADBDESG_NAME

ENTITY_IND Entity Indicator Indicates whether the entity is a person or an organization. VARCHAR2(1)  

CONSTANT

CONSTANT

'O'

'P'

ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER  

AGRGDES

AGRGMLT

AGRGDES_PIDM

AGRGMLT_XREF_PIDM

ENTRY_DATE Entry Date Date the transaction was entered on the account. DATE  

AGBGIFT

AGBGIFT_ENTRY_DATE

FINANCE_FEED_IND Finance Feed Indicator Indicates if the gift /payment has been fed to the finance system. VARCHAR2(1)  

AGBGIFT

AGBGIFT_FEED_IND

FISCAL_YEAR Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(63)  

AGBGIFT

AGBGIFT_FISC_CODE

FISCAL_YEAR_DESC Fiscal Year Description Description of the fiscal year code. VARCHAR2(255)  

ATVFISC

ATVFISC_DESC

GIFT_ACKNOWLEDGED_IND Gift Acknowledged Indicator Indicates if a gift acknowledgement was generated by the system. VARCHAR2(1)  

AGBGIFT

AGBGIFT_GACK_IND

GIFT_ADJUSTMENT_IND Gift Adjustment Indicator Indicates if adjustments have been made to this gift amount. VARCHAR2(1)  

AGBGIFT

AGBGIFT_ADJ_IND

GIFT_AMOUNT Gift Amount Gift designation amount. NUMBER  

AGRGDES

AGRGDES_AMT

GIFT_ASSOCIATED_ENTITY_COUNT Gift Associated Entity Count Count of entities associated with this gift/payment. NUMBER  

FUNCTION

MAKFUNC.F_COUNT_GIFT_ASSOCIATED_ENTITY

GIFT_AUXILIARY_COUNT Gift Auxiliary Count Count of auxiliary gift records associated with this gift/payment. NUMBER  

FUNCTION

MAKFUNC.F_COUNT_GIFT_AUXILIARY

GIFT_CLASS Gift Class First classification of the gift/payment - anonymous, memorial, etc. VARCHAR2(63)  

AGBGIFT

AGBGIFT_GCLS_CODE

GIFT_CLASS2 Gift Class 2 Second classification of the gift/payment - anonymous, memorial, etc VARCHAR2(63)  

AGBGIFT

AGBGIFT_GCLS_CODE_2

GIFT_CLASS3 Gift Class 3 Third classification of the gift/payment - anonymous, memorial, etc VARCHAR2(63)  

AGBGIFT

AGBGIFT_GCLS_CODE_3

GIFT_CLASS_DESC Gift Class Description Description of the first gift/payment classification. VARCHAR2(255)  

ATVGCLS

ATVGCLS_DESC

GIFT_CLASS_DESC2 Gift Class Description 2 Description of the second gift class. VARCHAR2(255)  

ATVGCLS

ATVGCLS_DESC

GIFT_CLASS_DESC3 Gift Class Description 3 Description of the third gift class. VARCHAR2(255)  

ATVGCLS

ATVGCLS_DESC

GIFT_COMMENT Gift Comment Comment related to the gift. VARCHAR2(400)  

AGBGIFT

AGBGIFT_COMMENT

GIFT_CREDIT_AMOUNT Gift Credit Amount Amount of the gift/payment designation credited to the primary donor or received by a multi-credit recipient donor. NUMBER  

CALCULATION

AGRGDES_AMT-F_GIFT_HARD_CREDIT

GIFT_DATE Gift Date Date a gift is received. Date defaults to the system date if no date is entered. DATE  

AGBGIFT

AGBGIFT_GIFT_DATE

GIFT_DEBIT_ACCOUNT_NUMBER Gift Debit Account Number Additional debit account number. VARCHAR2(63)  

ATVGIFT

ATVGIFT_DB_GL_ACCT

GIFT_NUMBER Gift Number Number of the gift. VARCHAR2(63)  

AGRGDES

AGRGMLT

AGRGDES_GIFT_NO

AGRGMLT_GIFT_NO

GIFT_RANGE Gift Range Gift range classification associated with the total gift/payment amount. VARCHAR2(63)  

AGBGIFT

AGBGIFT_GACK_CODE

GIFT_RANGE_DESC Gift Range Description Description of the gift range. VARCHAR2(255)  

ATVGACK

ATVGACK_DESC

GIFT_RULE_CLASS Gift Rule Class Rule class code. VARCHAR2(63)  

ATVGIFT

ATVGIFT_RUCL_CODE

GIFT_RULE_CLASS_DESC Gift Rule Class Description Unique title assigned to a rule class. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

GIFT_TYPE Gift Type Type of gift or method of payment, i.e., check, credit card, bequest, property. VARCHAR2(63)  

AGBGIFT

AGBGIFT_GIFT_CODE

GIFT_TYPE_DESC Gift Type Description Description of the gift/payment type. VARCHAR2(255)  

AGBGIFT

AGBGIFT_GIFT_DESC

GIFT_VEHICLE Gift Vehicle Pledge gift vehicle code associated with this gift. VARCHAR2(63)  

AGBGIFT

AGBGIFT_PGVE_CODE

GIFT_VEHICLE_DESC Gift Vehicle Description Pledge gift vehicle code description. VARCHAR2(255)  

ATVPGVE

ATVPGVE_DESC

GIFT_VSE Gift VSE - Voluntary Support of Education Gift voluntary support of education category. VARCHAR2(63)  

ATVGIFT

ATVGIFT_CFAE_GIFT_CATG

GIFT_VSE_DESC Gift VSE - Voluntary Support of Education Description Voluntary support of education code description. VARCHAR2(255)  

CALCULATION

DECODE(ATVGIFT_CFAE_GIFT_CATG)

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

MATCHING_GIFT_COUNT Matching Gift Count Count of all expected or paid matching gifts associated to this gift/payment. Inactive match gifts are excluded from this count. NUMBER  

FUNCTION

MAKFUNC.F_COUNT_MATCH_GIFT

MATCHING_GIFT_IND Matching Gift Indicator Indicates if one or more expected or paid matching gifts are associated with this gift/payment. Inactive match gifts are excluded. VARCHAR2(1)  

FUNCTION

AOKODSF.F_MATCH_GIFT

MATCHING_GIFT_PAYMENT_IND Matching Gift Payment Indicator Indicates if this gift was applied as matching gift payment(s). VARCHAR2(1)  

FUNCTION

AOKODSF.F_MATCH_GIFT_PAY

MATCH_GIFT_FORM_RECEIVED_IND Match Gift Form Received Indicator Indicates if at least one matching gift form has been received for any associated matching gifts. VARCHAR2(1)  

AGBGIFT

AGBGIFT_MATCH_RECEIVED

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

NA

NA

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

NA

NA

NAME Name Name of the person (LFMI) or organization. VARCHAR2(255)  

FUNCTION

SPRIDEN

F_FORMAT_NAME

SPRIDEN_LAST_NAME

PLEDGE_NUMBER Pledge Number Number of the pledge. VARCHAR2(63)  

AGRGDES

AGRGDES_PLEDGE_NO

POSTING_DATE Posting Date Gift feed date is the date the gift was fed to finance. DATE  

AGBGIFT

AGBGIFT_FEED_DATE

POST_BATCH_ID Post Batch ID Gift feed document code. VARCHAR2(63)  

AGBGIFT

AGBGIFT_FEED_DOC_CODE

POST_CASHIER Post Cashier User name. VARCHAR2(255)  

AGBGIFT

AGBGIFT_USER

POST_CASHIER_SESSION_NUMBER Post Cashier Session Number Cashier session number under which this gift was posted. NUMBER  

FUNCTION

AOKODSF.F_GET_SESSION_NUMBER

PREFER_CLASS_YEAR Prefer Class Year Year in which the constituent received the first degree or the year of expected graduation if the first degree has not yet been earned. VARCHAR2(63)  

APBCONS

APBCONS_PREF_CLAS

PREFER_CLASS_YEAR_DESC Prefer Class Year Description Constituent's preferred class description. VARCHAR2(255)  

NA

NA

PREFER_COLLEGE Prefer College College within the institution with which the constituent prefers to be associated. VARCHAR2(63)  

APBCONS

APBCONS_COLL_CODE_PREF

PREFER_COLLEGE_DESC Prefer College Description College, faculty or school name. VARCHAR2(255)  

STVCOLL

STVCOLL_DESC

PRIMARY_DONOR_CATEGORY Primary Donor Category Primary donor category associated with this donor. VARCHAR2(63)  

APRCATG

APRCATG_DONR_CODE

PRIMARY_DONOR_CATEGORY_DESC Primary Donor Category Description Description of the primary donor category. VARCHAR2(255)  

ATVDONR

ATVDONR_DESC

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

NA

NA

RECEIPT_DATE Receipt Date Date receipt was generated by the system. DATE  

AGBGIFT

AGBGIFT_RECEIPT_DATE

RECEIPT_REQUIRED_IND Receipt Required Indicator Indicates if a receipt is required for this gift/payment. VARCHAR2(1)  

AGBGIFT

AGBGIFT_RECEIPT_IND

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

SOLICITATION_COUNT Solicitation Count Count of all solicitations associated with the gift/payment transaction. NUMBER  

FUNCTION

MAKFUNC.F_COUNT_GIFT_SOLICITOR

SOLICITATION_TYPE Solicitation Type Type of solicitation for the highest solicitation amount associated with this gift/payment campaign designation amount. VARCHAR2(63)  

AGRGSOL

AGRGSOL_SOLC_CODE

SOLICITATION_TYPE_DESC Solicitation Type Description Description of the pledge/gift solicitation type. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SOLICITOR_FIRST_NAME Solicitor First Name Solicitor's current first name. VARCHAR2(63)  

SPRIDEN

SPRIDEN_FIRST_NAME

SOLICITOR_ID Solicitor ID Current identification number of the solicitor for the highest solicitation amount associated with this gift/payment campaign designation amount. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

SOLICITOR_LAST_NAME Solicitor Last Name Solicitor's current last name. VARCHAR2(63)  

SPRIDEN

SPRIDEN_LAST_NAME

SOLICITOR_ORG Solicitor Organization Solicitor organization for the highest solicitation amount associated with this gift/payment campaign designation amount. VARCHAR2(63)  

AGRGSOL

AGRGSOL_SOL_ORG

SOLICITOR_UID Solicitor UID System generated unique internal identification number assigned to the solicitor for the highest solicitation amount associated with this gift/payment campaign designation amount. NUMBER  

AGRGSOL

AGRGSOL_SOL_PIDM



Ver: 9.0