RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Operational Data Store
Reporting View Target: ENDOWMENT_DISTRIBUTION

Description Contains historical distributed spendable income for endowments. Additional reporting by income accounting distribution, unrealized gain and loss accounting distribution, and gain and loss accounting distribution with each of their distribution frequencies.
Key & Frequency One row per document number per submission number per chart of accounts per endowment fund.
Recommended Search Columns CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND
DOCUMENT_NUMBER, SUBMISSION_NUMBER, CHART_OF_ACCOUNTS, FUND

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_TYPE User-defined value classifying an account to be assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(63)

FNVPOOL

FNVPOOL_EXT_ATYP_CODE

ACCOUNT_TYPE_DESC Account type description or title. VARCHAR2(255)

FTVATYP

FTVATYP_TITLE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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(255)

FUNCTION

F_GET_FINANCE_DESC

DISTRIBUTION_UNREALIZED_FREQ Frequency at which the distribution of unrealized gains and losses is run for this pool. VARCHAR2(63)

FNVPOOL

FNVPOOL_FREQ_GN_LS_URLD

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

FNBDSTH

FNBDSTH_DOC_NUM

ENDOWMENT_ESTABLISHED_DATE Date that the fund was established. DATE

FNVENDW

FNVENDW_EST_DATE

ENDOWMENT_FUND_LD Detailed endowment title of the fund. VARCHAR2(255)

FNVENDW

FNVENDW_LONG_FUND_TITLE

ENDOWMENT_FUND_SD Alpha title or short name for the fund. VARCHAR2(255)

FNVENDW

FNVENDW_ALPHA_TITLE

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

FNBDSTH

FNBDSTH_POOL_CODE

ENDOWMENT_POOL_DESC Endowment pool description. VARCHAR2(255)

FNVPOOL

FNVPOOL_POOL_TITLE

ENDOWMENT_TERMINATION_DATE Date when the endowment is no longer in effect. DATE

FNVENDW

FNVENDW_TERM_DATE

ENDOWMENT_TYPE Type of the endowment such as True, Quasi, or any other user defined type. VARCHAR2(63)

FNVENDW

FNVENDW_ENDW_TYPE

ENDOWMENT_TYPE_DESC Retrieved description for endowment type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

FUND Unique fiscal entity code. VARCHAR2(6)

FNBDSTH

FNBDSTH_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_ACCOUNT_INDEX Index to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCI_CODE_DR_RLD

GAIN_LOSS_ACCOUNT_INDEX_DESC Retrieved description or title of the associated account index. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_CR_ACCT_POOL Account to credit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_CR_RLD

GAIN_LOSS_CR_ACCT_POOL_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DISTRIBUTION_FREQ Frequency at which the distribution of gains and losses is run for this pool. VARCHAR2(63)

FNVPOOL

FNVPOOL_FREQ_GN_LS_RLD

GAIN_LOSS_DR_ACCT_POOL Account to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_DR_RLD

GAIN_LOSS_DR_ACCT_POOL_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_ACTV_POOL Activity to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACTV_CODE_DR_RLD

GAIN_LOSS_DR_ACTV_POOL_DESC Retrieved description or title of the associated activity. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_CHART_POOL Chart to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_COAS_GN_LS_RLD

GAIN_LOSS_DR_CHART_POOL_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_FUND_POOL Fund to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_FUND_CODE_DR_RLD

GAIN_LOSS_DR_FUND_POOL_DESC Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_LOCN_POOL Location to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_LOCN_CODE_DR_RLD

GAIN_LOSS_DR_LOCN_POOL_DESC Retrieved description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_ORGN_POOL Organization to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ORGN_CODE_DR_RLD

GAIN_LOSS_DR_ORGN_POOL_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_PROG_POOL Program to debit for realized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_PROG_CODE_DR_RLD

GAIN_LOSS_DR_PROG_POOL_DESC Retrieved description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CLASSIFICATION Categorization of endowment fund by income restriction. VARCHAR2(63)

FNVENDW

FNVENDW_INCL_CODE

INCOME_CLASSIFICATION_DESC Extracts principal income class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

INCOME_CR_ACCOUNT Account to credit for spendable income. VARCHAR2(63)

FNVENDW

FNVENDW_ACCT_SPEND_CODE

INCOME_CR_ACCOUNT_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_ACCOUNT_POOL Account to credit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPEND

INCOME_CR_ACCOUNT_POOL_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_ACTIVITY Activity to credit for spendable income. VARCHAR2(63)

FNVENDW

FNVENDW_ACTV_SPEND_CODE

INCOME_CR_ACTIVITY_DESC Retrieved description or title of the associated activity. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_CHART Chart to credit for spendable income. VARCHAR2(63)

FNVENDW

FNVENDW_COAS_SPEND_CODE

INCOME_CR_CHART_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_CHART_POOL Chart to credit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_COAS_CR_SPEND

INCOME_CR_CHART_POOL_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_FUND Fund to credit for spendable income. VARCHAR2(63)

FNVENDW

FNVENDW_FUND_SPEND_CODE

INCOME_CR_FUND_DESC Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_LOCATION Location to credit for spendable income. VARCHAR2(63)

FNVENDW

FNVENDW_LOCN_SPEND_CODE

INCOME_CR_LOCATION_DESC Retrieved description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_ORGANIZATION Organization to credit for spendable income. VARCHAR2(63)

FNVENDW

FNVENDW_ORGN_SPEND_CODE

INCOME_CR_ORGANIZATION_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_PROGRAM Program to credit for spendable income. VARCHAR2(63)

FNVENDW

FNVENDW_PROG_SPEND_CODE

INCOME_CR_PROGRAM_DESC Retrieved description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DISTRIBUTION_FREQ Frequency at which the distribution of spendable income is run for this pool. VARCHAR2(63)

FNVPOOL

FNVPOOL_FREQ_DIST_SPEND

INCOME_DR_ACCOUNT_INDEX Index to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPEND

INCOME_DR_ACCOUNT_INDEX_DESC Retrieved description or title of the associated account index. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_ACCT_POOL Account to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPEND

INCOME_DR_ACCT_POOL_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_ACTV_POOL Activity to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACTV_CODE_DR_SPEND

INCOME_DR_ACTV_POOL_DESC Retrieved description or title of the associated activity. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_CHART_POOL Chart to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_COAS_DR_SPEND

INCOME_DR_CHART_POOL_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_FUND_POOL Fund to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_FUND_CODE_DR_SPEND

INCOME_DR_FUND_POOL_DESC Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_LOCN_POOL Location to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_LOCN_CODE_DR_SPEND

INCOME_DR_LOCN_POOL_DESC Retrieved description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_ORGN_POOL Organization to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPEND

INCOME_DR_ORGN_POOL_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_PROG_POOL Program to debit for spendable income. VARCHAR2(63)

FNVPOOL

FNVPOOL_PROG_CODE_DR_SPEND

INCOME_DR_PROG_POOL_DESC Retrieved description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

INCOME_SPEND_AMOUNT Amount of spendable income distributed. NUMBER

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

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

POOL_STATUS Current status of this pool as active or inactive. VARCHAR2(63)

FNVPOOL

FNVPOOL_STATUS_IND

POOL_STATUS_DESC Deciphers status of this endowment pool as active or inactive. VARCHAR2(255)

CALCULATION

DECODE(FNVPOOL_STATUS_IND)

POOL_TERMINATION_DATE Date when this pool is no longer in effect. DATE

FNVPOOL

FNVPOOL_TERM_DATE

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

NA

NA

REAL_GAIN_LOSS_AMOUNT Amount of realized income distributed. NUMBER

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

RESTRICTION_TYPE Indicates whether a fund is R, U or does not apply. VARCHAR2(63)

FNVENDW

FNVENDW_REST_TYPE

RESTRICTION_TYPE_DESC Deciphers fund as restricted, unrestricted or does not apply. VARCHAR2(255)

CALCULATION

DECODE(FNVENDW_REST_TYPE)

SPECIAL_INSTRUCTIONS Detailed description of any special instruction for managing the fund. VARCHAR2(255)

FNVENDW

FNVENDW_INC_DIST_SPEC_INST

SPEND_VARIABLE_AMOUNT Amount of spending policy variance income distributed. NUMBER

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

FNBDSTH

FNBDSTH_SUBMISSION_NUMBER

UNITIZATION_FREQUENCY Frequency at which unitization is run for this pool. VARCHAR2(63)

FNVPOOL

FNVPOOL_FREQ_UNTZ

UNIT_SPEND_RATE Spendable income amount per unit. NUMBER

FNBDSTH

FNBDSTH_SPND_RATE

UNREAL_GAIN_LOSS_AMOUNT Amount of unrealized income distributed. NUMBER

FNBDSTH

FNBDSTH_URLZD_GL_AMT

UNREAL_GAIN_LOSS_CR_ACCT_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_CR_ACCT_POOL Account to credit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_CR_URLD

UNREAL_GAIN_LOSS_DR_ACCT_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_ACCT_POOL Account to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_DR_URLD

UNREAL_GAIN_LOSS_DR_ACTV_DESC Retrieved description or title of the associated activity. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_ACTV_POOL Activity to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACTV_CODE_DR_URLD

UNREAL_GAIN_LOSS_DR_CHART_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_CHART_POOL Chart to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_COAS_GN_LS_URLD

UNREAL_GAIN_LOSS_DR_FUND_DESC Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_FUND_POOL Fund to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_FUND_CODE_DR_URLD

UNREAL_GAIN_LOSS_DR_LOCN_DESC Retrieved description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_LOCN_POOL Location to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_LOCN_CODE_DR_URLD

UNREAL_GAIN_LOSS_DR_ORGN_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_ORGN_POOL Organization to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ORGN_CODE_DR_URLD

UNREAL_GAIN_LOSS_DR_PROG_DESC Retrieved description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_PROG_POOL Program to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_PROG_CODE_DR_URLD

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_INDEX Index to debit for unrealized gains and losses. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCI_CODE_DR_URLD

UNREAL_GAIN_LOSS_INDEX_DESC Retrieved description or title of the associated account index. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_RATE Amount of unrealized income distributed. NUMBER

FNBDSTH

FNBDSTH_URLZD_GL_RATE

VARIANCE_CR_ACCT_POOL Account to credit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPNDV

VARIANCE_CR_ACCT_POOL_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_ACCT_POOL Account to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPNDV

VARIANCE_DR_ACCT_POOL_DESC Retrieved description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_ACTV_POOL Activity to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACTV_CODE_DR_SPNDV

VARIANCE_DR_ACTV_POOL_DESC Retrieved description or title of the associated activity. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_FUND_POOL Fund to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_FUND_CODE_DR_SPNDV

VARIANCE_DR_FUND_POOL_DESC Retrieved description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_LOCN_POOL Location to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_LOCN_CODE_DR_SPNDV

VARIANCE_DR_LOCN_POOL_DESC Retrieved description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_ORGN_POOL Organization to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPNDV

VARIANCE_DR_ORGN_POOL_DESC Retrieved description or title of the associated organization. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_PROG_POOL Program to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_PROG_CODE_DR_SPNDV

VARIANCE_DR_PROG_POOL_DESC Retrieved description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_SPEND_ACCT_INDEX Index to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPNDV

VARIANCE_SPEND_ACCT_INDEX_DESC Retrieved description or title of the associated account index. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_SPEND_DR_CHART_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_SPEND_DR_CHART_POOL Chart to debit for distribution of spending policy variance. VARCHAR2(63)

FNVPOOL

FNVPOOL_COAS_SPND_POL_VAR

VARIANCE_SPEND_FREQ Frequency at which the distribution of spending policy variance is run for this pool. VARCHAR2(63)

FNVPOOL

FNVPOOL_FREQ_SPND_POL_VAR



Ver: 3.1