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

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 Local Source Local Target
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)

FNBUNTH

FNBUNTH_ACCT_CODE

NO

NO
ACCOUNT_DESC Account code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNBUNTH

FNBUNTH_TRANS_AMT

NO

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

FNBUNTH

FNBUNTH_COAS_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

NA

SYSDATE

NO

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

NA

NA

NO

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

FNBUNTH

FNBUNTH_DONOR_PIDM

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

FNBUNTH

FNBUNTH_FUND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
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

NO

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

FNBUNTH

FNBUNTH_GIFT_NUM

NO

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

NA

NA

NO

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

NA

NA

NO

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

FNBUNTH

FNBUNTH_ORGN_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNBUNTH

FNBUNTH_TRANS_DATE

NO

NO
PROGRAM Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(6)

FNBUNTH

FNBUNTH_PROG_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNBUNTH

FNBUNTH_UNTZ_END_DATE

NO

NO
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

NO

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

FNBUNTH

FNBUNTH_UNIT_MKT_VALUE

NO

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

NA

NA

NO

NO


Ver: