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_DIST

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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment.    

FNBDSTH

FNBDSTH_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

 
DOCUMENT_NUMBER Unique transaction id assigned from posting.    

FNBDSTH

FNBDSTH_DOC_NUM

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

NA

NA

 
ENDOWMENT_POOL User assigned code for a unitized pool of funds.    

FNBDSTH

FNBDSTH_POOL_CODE

 
ENDOWMENT_POOL_DESC Endowment pool description.    

FNVPOOL

FNVPOOL_POOL_TITLE

 
FUND Unique fiscal entity code.    

FNBDSTH

FNBDSTH_FUND_CODE

 
FUND_DESC Description or title of the associated fund.    

FUNCTION

F_GET_FINANCE_DESC

 
INCOME_SPEND_AMOUNT Amount of spendable income distributed.    

FNBDSTH

FNBDSTH_SPND_INC_AMT

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

FNBDSTH

FNBDSTH_SPND_INC_END_DATE

 
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

 
REAL_GAIN_LOSS_AMOUNT Amount of realized income distributed.    

FNBDSTH

FNBDSTH_RLZD_GL_AMT

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

FNBDSTH

FNBDSTH_RLZD_GL_END_DATE

 
REAL_GAIN_LOSS_RATE Amount of realized income distributed.    

FNBDSTH

FNBDSTH_RLZD_GL_RATE

 
SPEND_VARIABLE_AMOUNT Amount of spending policy variance income distributed.    

FNBDSTH

FNBDSTH_SPND_VAR_AMT

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

FNBDSTH

FNBDSTH_SPND_VAR_END_DATE

 
SPEND_VARIABLE_RATE Amount of unrealized income distributed.    

FNBDSTH

FNBDSTH_SPND_VAR_RATE

 
SUBMISSION_NUMBER Submission number used for documents that utilized resubmission features.    

FNBDSTH

FNBDSTH_SUBMISSION_NUMBER

 
UNIT_SPEND_RATE Spendable income amount per unit.    

FNBDSTH

FNBDSTH_SPND_RATE

 
UNREAL_GAIN_LOSS_AMOUNT Amount of unrealized income distributed.    

FNBDSTH

FNBDSTH_URLZD_GL_AMT

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

FNBDSTH

FNBDSTH_URLZD_GL_END_DATE

 
UNREAL_GAIN_LOSS_RATE Amount of unrealized income distributed.    

FNBDSTH

FNBDSTH_URLZD_GL_RATE

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

NA

NA

 


Ver: 8.3