RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Operational Data Store
Composite View Target: AF_ENDOWMENT

Description Source composite view contains endowment funds and their associated information including associated pool.

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

FNVPOOL

FNVPOOL_EXT_ATYP_CODE

ACCOUNT_TYPE_DESC Account type description or title. VARCHAR2(35)

FTVATYP

FTVATYP_TITLE

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

FNVENDW

FNVENDW_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

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

FNVPOOL

FNVPOOL_FREQ_GN_LS_URLD

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

NA

NA

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

FNVENDW

FNVENDW_ALPHA_TITLE

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

FNVENDW

FNVENDW_POOL_CODE

ENDOWMENT_POOL_DESC Endowment pool description. VARCHAR2(30)

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

FNVENDW

FNVENDW_ENDW_TYPE

ENDOWMENT_TYPE_DESC Retrieved description for endowment type. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

FUND Unique fiscal entity code. VARCHAR2(6)

FNVENDW

FNVENDW_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCI_CODE_DR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FREQ_GN_LS_RLD

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_COAS_GN_LS_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_RLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_INCL_CODE

INCOME_CLASSIFICATION_DESC Extracts principal income class description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

FNVENDW

FNVENDW_ACCT_SPEND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_ACTV_SPEND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_COAS_SPEND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_COAS_CR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_FUND_SPEND_CODE

INCOME_CR_FUND_DESC Hierarchy description or title appropriate for this fund. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_LOCATION Retrieved description or title of the associated fund. VARCHAR2(6)

FNVENDW

FNVENDW_LOCN_SPEND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_ORGN_SPEND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_PROG_SPEND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FREQ_DIST_SPEND

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

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_COAS_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_SPEND

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

FUNCTION

F_GET_FINANCE_DESC

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

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

FNVPOOL

FNVPOOL_STATUS_IND

POOL_STATUS_DESC Current status of this pool, Active or Inactive. VARCHAR2(30)

CALCULATION

DECODE(FNVPOOL_STATUS)

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

FNVPOOL

FNVPOOL_TERM_DATE

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

FNVENDW

FNVENDW_REST_TYPE

RESTRICTION_TYPE_DESC Indicates whether a fund is R - restricted, U - unrestricted or does not apply. VARCHAR2(30)

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

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

FNVPOOL

FNVPOOL_FREQ_UNTZ

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_COAS_GN_LS_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_URLD

UNREAL_GAIN_LOSS_INDEX Index to debit for unrealized gains and losses. VARCHAR2(6)

FNVPOOL

FNVPOOL_ACCI_CODE_DR_URLD

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPNDV

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

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_COAS_SPND_POL_VAR

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

FNVPOOL

FNVPOOL_FREQ_SPND_POL_VAR

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