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

Banner Operational Data Store
Composite View Target: AF_ENDOWMENT_DIST

Description Source composite view contains endowment distribution and its associated information.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FNBDSTH

FNBDSTH_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
DOCUMENT_NUMBER Unique transaction id assigned from posting. VARCHAR2(8)

FNBDSTH

FNBDSTH_DOC_NUM

NO

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

NA

NA

NO

NO
ENDOWMENT_POOL User assigned code for a unitized pool of funds. VARCHAR2(2)

FNBDSTH

FNBDSTH_POOL_CODE

NO

NO
ENDOWMENT_POOL_DESC Endowment pool description. VARCHAR2(30)

FNVPOOL

FNVPOOL_POOL_TITLE

NO

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

FNBDSTH

FNBDSTH_FUND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
INCOME_SPEND_AMOUNT Amount of spendable income distributed. NUMBER

FNBDSTH

FNBDSTH_SPND_INC_AMT

NO

NO
INCOME_SPEND_END_DATE Period end date for which distribution of spendable income was run. DATE

FNBDSTH

FNBDSTH_SPND_INC_END_DATE

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
REAL_GAIN_LOSS_AMOUNT Amount of realized income distributed. NUMBER

FNBDSTH

FNBDSTH_RLZD_GL_AMT

NO

NO
REAL_GAIN_LOSS_END_DATE Period end date for which distribution of gains and losses and spending policy variance was run. DATE

FNBDSTH

FNBDSTH_RLZD_GL_END_DATE

NO

NO
REAL_GAIN_LOSS_RATE Amount of realized income distributed. NUMBER

FNBDSTH

FNBDSTH_RLZD_GL_RATE

NO

NO
SPEND_VARIABLE_AMOUNT Amount of spending policy variance income distributed. NUMBER

FNBDSTH

FNBDSTH_SPND_VAR_AMT

NO

NO
SPEND_VARIABLE_END_DATE Period end date for which distribution of gains and losses and spending policy variance was run. DATE

FNBDSTH

FNBDSTH_SPND_VAR_END_DATE

NO

NO
SPEND_VARIABLE_RATE Amount of unrealized income distributed. NUMBER

FNBDSTH

FNBDSTH_SPND_VAR_RATE

NO

NO
SUBMISSION_NUMBER Submission number used for documents that utilized resubmission features. NUMBER

FNBDSTH

FNBDSTH_SUBMISSION_NUMBER

NO

NO
UNIT_SPEND_RATE Spendable income amount per unit. NUMBER

FNBDSTH

FNBDSTH_SPND_RATE

NO

NO
UNREAL_GAIN_LOSS_AMOUNT Amount of unrealized income distributed. NUMBER

FNBDSTH

FNBDSTH_URLZD_GL_AMT

NO

NO
UNREAL_GAIN_LOSS_END_DATE Period end date for which distribution of gains and losses and spending policy variance was run. DATE

FNBDSTH

FNBDSTH_URLZD_GL_END_DATE

NO

NO
UNREAL_GAIN_LOSS_RATE Amount of unrealized income distributed. NUMBER

FNBDSTH

FNBDSTH_URLZD_GL_RATE

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: