Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GIFT_TRANSACTION

Description Contains transaction level information for each individual gift/payment received from a donor with supplemental information related to donor attributes, associated matching gifts and solicitations.
Key & Frequency One row per entity per gift number.
Recommended Search Columns ENTITY_UID
ENTITY_UID, GIFT_NUMBER
SOLICITOR_UID
ENTITY_UID, ENTITY_IND
ENTITY_IND
FISCAL_YEAR
GIFT_DATE

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

AGBGIFT

AGBGIFT_ACTIVITY_DATE

ADMINISTRATIVE_GROUP The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

DECEASED_DATE Date the person died. DATE

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

DECEASED_STATUS Indicates whether or not a person is deceased. VARCHAR2(1)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

CONSTANT

'O'

'P'

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

AGBGIFT

AGBGIFT_PIDM

ENTRY_DATE Date the gift is entered. DATE

AGBGIFT

AGBGIFT_ENTRY_DATE

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

AGBGIFT

AGBGIFT_FEED_IND

FISCAL_YEAR Code for the fiscal year. NUMBER

AGBGIFT

AGBGIFT_FISC_CODE

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

ATVFISC

ATVFISC_DESC

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

AGBGIFT

AGBGIFT_GACK_IND

GIFT_ADJUSTMENT_IND Indicates if adjustments have been made to the original gift/payment transaction amount. VARCHAR2(1)

AGBGIFT

AGBGIFT_ADJ_IND

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

FUNCTION

MAKFUNC.F_COUNT_GIFT_ASSOCIATED_ENTITY

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

FUNCTION

MAKFUNC.F_COUNT_GIFT_AUXILIARY

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

AGBGIFT

AGBGIFT_GCLS_CODE

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

AGBGIFT

AGBGIFT_GCLS_CODE_2

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

AGBGIFT

AGBGIFT_GCLS_CODE_3

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

ATVGCLS

ATVGCLS_DESC

GIFT_CLASS_DESC2 Description of the second gift/payment classification. VARCHAR2(255)

ATVGCLS

ATVGCLS_DESC

GIFT_CLASS_DESC3 Description of the third gift/payment classification. VARCHAR2(255)

ATVGCLS

ATVGCLS_DESC

GIFT_COMMENT Comment related to the gift. VARCHAR2(400)

AGBGIFT

AGBGIFT_COMMENT

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 Additional debit account number. VARCHAR2(63)

ATVGIFT

ATVGIFT_DB_GL_ACCT

GIFT_NUMBER Number of the gift. VARCHAR2(63)

AGBGIFT

AGBGIFT_GIFT_NO

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

AGBGIFT

AGBGIFT_GACK_CODE

GIFT_RANGE_DESC Description of the gift range. VARCHAR2(255)

ATVGACK

ATVGACK_DESC

GIFT_RULE_CLASS Rule class code. VARCHAR2(63)

ATVGIFT

ATVGIFT_RUCL_CODE

GIFT_RULE_CLASS_DESC Unique title assigned to a rule class. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

GIFT_TRANSACTION_AMOUNT Total transaction amount of the individual gift/payment received. NUMBER

AGBGIFT

AGBGIFT_AMT_TOT

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 Description of the gift/payment type. VARCHAR2(255)

AGBGIFT

AGBGIFT_GIFT_DESC

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

AGBGIFT

AGBGIFT_PGVE_CODE

GIFT_VEHICLE_DESC Description of the pledge gift vehicle code. VARCHAR2(255)

ATVPGVE

ATVPGVE_DESC

GIFT_VSE Gift voluntary support of education category. VARCHAR2(63)

ATVGIFT

ATVGIFT_CFAE_GIFT_CATG

GIFT_VSE_DESC Description of the voluntary support of education code. VARCHAR2(255)

CALCULATION

DECODE(ATVGIFT_CFAE_GIFT_CATG)

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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 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 Indicates if this gift was applied as matching gift payment(s). VARCHAR2(1)

FUNCTION

AOKODSF.F_MATCH_GIFT_PAY

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

AGBGIFT

AGBGIFT_MATCH_RECEIVED

MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

AGBGIFT

AGBGIFT_FEED_DATE

POST_BATCH_ID Gift feed document code. VARCHAR2(63)

AGBGIFT

AGBGIFT_FEED_DOC_CODE

POST_CASHIER User name. VARCHAR2(255)

AGBGIFT

AGBGIFT_USER

POST_CASHIER_SESSION_NUMBER Cashier session number under which the gift/payment was posted. NUMBER

FUNCTION

AOKODSF.F_GET_SESSION_NUMBER

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 Description of the preferred class of the constituent. VARCHAR2(255)

NA

NA

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

APBCONS

APBCONS_COLL_CODE_PREF

PREFER_COLLEGE_DESC Name of the college, faculty or school. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

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

NA

NA

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

NA

NA

PROCESS_GROUP The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

RECEIPT_DATE Date receipt was generated by the system. DATE

AGBGIFT

AGBGIFT_RECEIPT_DATE

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

AGBGIFT

AGBGIFT_RECEIPT_IND

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

AGRGSOL

AGRGSOL_SOLC_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

SOLICITOR_COUNT Count of all solicitations associated with this gift/payment transaction. NUMBER

FUNCTION

MAKFUNC.F_COUNT_GIFT_SOLICITOR

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

AGRGSOL

AGRGSOL_SOL_ORG

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

AGRGSOL

AGRGSOL_SOL_PIDM



Ver: 8.0