Go To View:  RETURN TO COMPOSITE VIEW 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.

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)

FNBUNTH

FNBUNTH_ACCT_CODE

ACCOUNT_DESC Account code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

BOOK_AMOUNT Amount of the transaction associated with this particular account distribution. NUMBER(17,2)

FNBUNTH

FNBUNTH_TRANS_AMT

CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FNBUNTH

FNBUNTH_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

NA

SYSDATE

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)

FNBUNTH

FNBUNTH_DONOR_PIDM

FUND Unique fiscal entity code. VARCHAR2(6)

FNBUNTH

FNBUNTH_FUND_CODE

FUND_DESC Description or title of the associated fund. VARCHAR2(35)

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

FNBUNTH

FNBUNTH_GIFT_DATE

GIFT_NUMBER Gift number that is assigned when the gift is entered. VARCHAR2(8)

FNBUNTH

FNBUNTH_GIFT_NUM

MIF_DESC Institution description 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

ORGANIZATION_CODE Identification accounting code used for the department on the gift transaction. VARCHAR2(6)

FNBUNTH

FNBUNTH_ORGN_CODE

ORGANIZATION_DESC Extracted description or title associated with the organization code. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

POSTING_DATE Date used to post the gift to the ledgers. DATE

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

FNBUNTH

FNBUNTH_PROG_CODE

PROGRAM_DESC Extracted description or title of the associated program. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

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

FNBUNTH

FNBUNTH_NUM_UNITS

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

FNBUNTH

FNBUNTH_UNIT_MKT_VALUE

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

NA

NA



Ver: 8.0