RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Advancement Reporting View Reports

SGHE 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 ENTITY_UID
ENTITY_UID, ENTITY_IND
ENTITY_IND
FISCAL_YEAR
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, CAMPAIGN, DESIGNATION
GIFT_DATE
ENTITY_UID, PLEDGE_NUMBER
SOLICITOR_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

AGRGDES

AGRGMLT

AGRGDES_CAMPAIGN

AGRGMLT_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DECEASED_DATE Date the person died. DATE

SPBPERS

SPBPERS_DEAD_DATE

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

SPBPERS

SPBPERS_DEAD_IND

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 Designation account code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Designation account index code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Designation activity code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Designation chart of accounts code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_FUND Unique fiscal entity code. VARCHAR2(63)

ADBDESG

ADBDESG_FUND_CODE

DESG_FUND_DESC Designation fund code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_GL_NO_CREDIT

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

ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Description of the designation group. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Designation location code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_ORGN_CODE

DESG_ORGANIZATION_DESC Designation organization code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Designation program code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Description of the designation status. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_VSE 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 Voluntary support of education code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESIGNATION Designation associated with the gift. VARCHAR2(63)

AGRGDES

AGRGMLT

AGRGDES_DESG

AGRGMLT_DESG

DESIGNATION_NAME Designation description. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

ENTITY_IND Indicates whether the 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

AGRGDES

AGRGMLT

AGRGDES_PIDM

AGRGMLT_XREF_PIDM

ENTRY_DATE Date the transaction was entered on the account. 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 Unique identifier or code for the fiscal year. NUMBER

AGBGIFT

AGBGIFT_FISC_CODE

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

FUNCTION

GOKODSF.F_GET_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 this gift amount. VARCHAR2(1)

AGBGIFT

AGBGIFT_ADJ_IND

GIFT_AMOUNT Gift designation amount. NUMBER

AGRGDES

AGRGDES_AMT

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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

GIFT_COMMENT Comment related to the gift. VARCHAR2(400)

AGBGIFT

AGBGIFT_COMMENT

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

AGRGDES

AGRGMLT

AGRGDES_GIFT_NO

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

FUNCTION

GOKODSF.F_GET_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_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 Pledge gift vehicle code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ATVGIFT

ATVGIFT_CFAE_GIFT_CATG

GIFT_VSE_DESC Voluntary support of education code description. VARCHAR2(255)

CALCULATION

DECODE(ATVGIFT_CFAE_GIFT_CATG)

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

SPRIDEN

SPRIDEN_ID

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

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

FUNCTION

SPRIDEN

F_FORMAT_NAME

SPRIDEN_LAST_NAME

PLEDGE_NUMBER Number of the pledge. VARCHAR2(63)

AGRGDES

AGRGDES_PLEDGE_NO

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 this gift 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 Constituent's preferred class description. 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 College, faculty or school name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

APBCONS

APBCONS_PREF_CLAS

PRIMARY_DONOR_CATEGORY_DESC Description of the primary donor category. 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

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

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

ADBDESG

ADBDESG_RESTR_IND

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

FUNCTION

MAKFUNC.F_COUNT_GIFT_SOLICITOR

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

FUNCTION

GOKODSF.F_GET_DESC

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

SPRIDEN

SPRIDEN_FIRST_NAME

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's current last name. VARCHAR2(60)

SPRIDEN

SPRIDEN_LAST_NAME

SOLICITOR_ORG Solicitor organization for the highest solicitation amount associated with this gift/payment campaign designation amount. 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 campaign designation amount. NUMBER

AGRGSOL

AGRGSOL_SOL_PIDM



Ver: 3.1