RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE Operational Data Store
Composite View Target: AA_GIFT

Description Source composite view contains information on all gifts or payments made by a person or organization including campaign, designation, associated pledge details, matching gift information, preferred class, solicitation and recognition details.

Target Column Business Definition Database Data Type Source Name Source Column
CAMPAIGN Campaign code associated with the gift. VARCHAR2(5)

AGRGDES

AGRGMLT

AGRGDES_CAMPAIGN

AGRGMLT_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(30)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(2)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

ADBDESG

ADBDESG_ACCT_CODE

DESG_ACCOUNT_DESC Designation account code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_ACCOUNT_INDEX User-defined value representing a summarization of any combination of chart of accounts information. VARCHAR2(6)

ADBDESG

ADBDESG_ACCI_CODE

DESG_ACCOUNT_INDEX_DESC Designation account index code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_ACTV_CODE

DESG_ACTIVITY_DESC Designation activity code description. VARCHAR2(35)

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

ADBDESG

ADBDESG_COAS_CODE

DESG_CHART_OF_ACCOUNT_DESC Designation chart of accounts code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(4)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DESG_FUND Unique fiscal entity code. VARCHAR2(6)

ADBDESG

ADBDESG_FUND_CODE

DESG_FUND_DESC Designation fund code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_GL_NO_CREDIT

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

ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Description of the designation group. VARCHAR2(30)

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

ADBDESG

ADBDESG_LOCN_CODE

DESG_LOCATION_DESC Designation location code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_ORGN_CODE

DESG_ORGANIZATION_DESC Designation organization code description. VARCHAR2(35)

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

ADBDESG

ADBDESG_PROG_CODE

DESG_PROGRAM_DESC Designation program code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Description of the designation status. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(30)

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

ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Voluntary support of education code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

DESIGNATION Designation associated with the gift. VARCHAR2(10)

AGRGDES

AGRGMLT

AGRGDES_DESG

AGRGMLT_DESG

DESIGNATION_NAME Designation description. VARCHAR2(60)

ADBDESG

ADBDESG_NAME

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

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)    
FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER(4)

AGBGIFT

AGBGIFT_FISC_CODE

FISCAL_YEAR_DESC Description of the fiscal year code. VARCHAR2(30)    
GIFT_ACKNOWLEDGED_IND Indicates if a gift acknowledgement was generated by the system. VARCHAR2(1)    
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_CLASS First classification of the gift/payment - anonymous, memorial, etc. VARCHAR2(4)

AGBGIFT

AGBGIFT_GCLS_CODE

GIFT_CLASS2 Second category of the gift - anonymous, memorial, etc. VARCHAR2(4)

AGBGIFT

AGBGIFT_GCLS_CODE_2

GIFT_CLASS3 Third category of the gift - anonymous, memorial, etc. VARCHAR2(4)

AGBGIFT

AGBGIFT_GCLS_CODE_3

GIFT_CLASS_DESC Description of the first gift/payment classification. VARCHAR2(30)    
GIFT_CLASS_DESC2 Description of the second gift class. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

GIFT_COMMENT Comment related to the gift. VARCHAR2(300)

AGBGIFT

AGBGIFT_COMMENT

GIFT_CREDIT_AMOUNT This is the gift credit amount. NUMBER    
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(60)

ATVGIFT

ATVGIFT_DB_GL_ACCT

GIFT_NUMBER Number of the gift. VARCHAR2(7)

AGRGDES

AGRGMLT

AGRGDES_GIFT_NO

AGRGMLT_GIFT_NO

GIFT_RANGE Gift range classification associated with the total gift/payment amount. VARCHAR2(2)    
GIFT_RANGE_DESC Description of the gift range. VARCHAR2(30)    
GIFT_RULE_CLASS Rule class code. VARCHAR2(4)

ATVGIFT

ATVGIFT_RUCL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

GIFT_TRANSACTION_AMOUNT This is the gift total amount. NUMBER    
GIFT_TYPE Type of gift or payment method, i.e., check, credit card, bequest, property. VARCHAR2(2)

AGBGIFT

AGBGIFT_GIFT_CODE

GIFT_TYPE_DESC Description of the gift type. VARCHAR2(60)

AGBGIFT

AGBGIFT_GIFT_DESC

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

AGBGIFT

AGBGIFT_PGVE_CODE

GIFT_VEHICLE_DESC Pledge gift vehicle code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

ATVGIFT

ATVGIFT_CFAE_GIFT_CATG

GIFT_VSE_DESC This field specifies the description of the Voluntary Support of Education code. VARCHAR2(50)

CALCULATION

DECODE(ATVGIFT_CFAE_GIFT_CATG)

MATCHING_GIFT Matching gift. VARCHAR2(1)

FUNCTION

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

MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

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

NA

NA

PLEDGE_NUMBER Number of the pledge. VARCHAR2(7)

AGRGDES

AGRGMLT

AGRGDES_PLEDGE_NO

AGRGMLT_PLEDGE_NO

POST_BATCH_ID Gift feed document code. VARCHAR2(8)

AGBGIFT

AGBGIFT_FEED_DOC_CODE

POST_CASHIER_SESSION_NUMBER Cashier session number under which the gift/payment was posted. NUMBER    
POST_DATE Gift feed date is the date the gift was fed to finance. DATE

AGBGIFT

AGBGIFT_FEED_DATE

POST_USER User name. VARCHAR2(30)

AGBGIFT

AGBGIFT_USER

RECEIPT_DATE Date receipt was generated by the system. DATE    
RECEIPT_REQUIRED_IND Indicates if a receipt is required for this gift/payment. VARCHAR2(1)    
RESTRICTED_IND Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years. VARCHAR2(1)

ADBDESG

ADBDESG_RESTR_IND

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

NA

NA



Ver: 3.1