Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_ENDOWMENT_UNITS

Description Source composite view contains endowment fund unitization history.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.    

FNBUNTH

FNBUNTH_ACCT_CODE

 
ACCOUNT_DESC Account code description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
BOOK_AMOUNT Amount of the transaction associated with this particular account distribution.    

FNBUNTH

FNBUNTH_TRANS_AMT

 
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment.    

FNBUNTH

FNBUNTH_COAS_CODE

 
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title.    

FUNCTION

F_GET_FINANCE_DESC

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

NA

SYSDATE

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

NA

NA

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

FNBUNTH

FNBUNTH_DONOR_PIDM

 
FUND Unique fiscal entity code.    

FNBUNTH

FNBUNTH_FUND_CODE

 
FUND_DESC Description or title of the associated fund.    

FUNCTION

F_GET_FINANCE_DESC

 
GIFT_DATE Date of the gift for IRS valuation purposes. Used to obtain purchase price per unit in the unitization process in endowment management.    

FNBUNTH

FNBUNTH_GIFT_DATE

 
GIFT_NUMBER Gift number that is assigned when the gift is entered.    

FNBUNTH

FNBUNTH_GIFT_NUM

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
ORGANIZATION_CODE Identification accounting code used for the department on the gift transaction.    

FNBUNTH

FNBUNTH_ORGN_CODE

 
ORGANIZATION_DESC Extracted description or title associated with the organization code.    

FUNCTION

F_GET_FINANCE_DESC

 
POSTING_DATE Date used to post the gift to the ledgers.    

FNBUNTH

FNBUNTH_TRANS_DATE

 
PROGRAM Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.    

FNBUNTH

FNBUNTH_PROG_CODE

 
PROGRAM_DESC Extracted description or title of the associated program.    

FUNCTION

F_GET_FINANCE_DESC

 
UNITIZATION_PERIOD_END_DATE End date of the unitization period for which the gift purchased units.    

FNBUNTH

FNBUNTH_UNTZ_END_DATE

 
UNITS_PURCHASED Number of units that the gift purchased in the pool based on the unit value for the period of the gift date.    

FNBUNTH

FNBUNTH_NUM_UNITS

 
UNIT_MARKET_VALUE Price per unit at which the units of this gift was purchased.    

FNBUNTH

FNBUNTH_UNIT_MKT_VALUE

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

NA

NA

 


Ver: 8.3