RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE 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
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FNBDSTH

FNBDSTH_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

DOCUMENT_NUMBER Unique transaction id assigned from posting. VARCHAR2(8)

FNBDSTH

FNBDSTH_DOC_NUM

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

NA

NA

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

FNBDSTH

FNBDSTH_POOL_CODE

ENDOWMENT_POOL_DESC Endowment pool description. VARCHAR2(30)

FNVPOOL

FNVPOOL_POOL_TITLE

FUND Unique fiscal entity code. VARCHAR2(6)

FNBDSTH

FNBDSTH_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

INCOME_SPEND_AMOUNT Amount of spendable income distributed. NUMBER(12, 2)

FNBDSTH

FNBDSTH_SPND_INC_AMT

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

FNBDSTH

FNBDSTH_SPND_INC_END_DATE

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

REAL_GAIN_LOSS_AMOUNT Amount of realized income distributed. NUMBER(12, 2)

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

FNBDSTH

FNBDSTH_RLZD_GL_END_DATE

REAL_GAIN_LOSS_RATE Amount of realized income distributed. NUMBER

FNBDSTH

FNBDSTH_RLZD_GL_RATE

SPEND_VARIABLE_AMOUNT Amount of spending policy variance income distributed. NUMBER(12, 2)

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

FNBDSTH

FNBDSTH_SPND_VAR_END_DATE

SPEND_VARIABLE_RATE Amount of unrealized income distributed. NUMBER

FNBDSTH

FNBDSTH_SPND_VAR_RATE

SUBMISSION_NUMBER Submission number used for documents that utilized resubmission features. NUMBER(3)

FNBDSTH

FNBDSTH_SUBMISSION_NUMBER

UNIT_SPEND_RATE Spendable income amount per unit. NUMBER

FNBDSTH

FNBDSTH_SPND_RATE

UNREAL_GAIN_LOSS_AMOUNT Amount of unrealized income distributed. NUMBER(12, 2)

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

FNBDSTH

FNBDSTH_URLZD_GL_END_DATE

UNREAL_GAIN_LOSS_RATE Amount of unrealized income distributed. NUMBER

FNBDSTH

FNBDSTH_URLZD_GL_RATE

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

NA

NA



Ver: 3.1