Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ENDOWMENT_UNITS

Description Contains gifts that were added to endowed funds at the document level and unitized.
Key & Frequency One row per chart of accounts per endowment pool per endowment fund per organization code per account per program per unitization period end date.
Recommended Search Columns CHART_OF_ACCOUNTS, FUND
ENTITY_UID
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(63)

FNBUNTH

FNBUNTH_ACCT_CODE

ACCOUNT_DESC Account code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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

BOOK_AMOUNT Amount of the transaction associated with this particular account distribution. NUMBER

FNBUNTH

FNBUNTH_TRANS_AMT

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

FNVENDW

FNVENDW_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

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

FNVENDW

FNVENDW_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

ENTITY_FIRST_NAME Donor's current first name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

ENTITY_ID_NUMBER Donor's current identification number. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

ENTITY_LAST_NAME Donor's company name or person current last name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

ENTITY_MIDDLE_NAME Donor's current middle initial. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

ENTITY_NAME Entity name or combination of a person's last name, first name, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

FNBUNTH

FNBUNTH_DONOR_PIDM

FUND Unique fiscal entity code. VARCHAR2(63)

FNVENDW

FNVENDW_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

GIFT_DATE Date of the gift for IRS valuation purposes. Used to get purchase price per unit in the Unitization process in endowment management. DATE

FNBUNTH

FNBUNTH_GIFT_DATE

GIFT_NUMBER Gift number that is assigned when the gift is entered. VARCHAR2(63)

FNBUNTH

FNBUNTH_GIFT_NUM

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

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

ORGANIZATION_CODE Identification accounting code used for the department on the gift transaction. VARCHAR2(63)

FNBUNTH

FNBUNTH_ORGN_CODE

ORGANIZATION_DESC Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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

POSTING_DATE Date used to post the gift to the ledgers. DATE

FNBUNTH

FNBUNTH_TRANS_DATE

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

NA

NA

PROGRAM Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems. VARCHAR2(63)

FNBUNTH

FNBUNTH_PROG_CODE

PROGRAM_DESC Extracted description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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

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

FNVPOOL

FNVPOOL_FREQ_UNTZ

UNITIZATION_PERIOD_END_DATE End date of the unitization period for which the gift purchased units. DATE

FNBUNTH

FNBUNTH_UNTZ_END_DATE

UNITS_PURCHASED Number of units that the gift purchased in the pool based on the unit value for the period of the gift date. NUMBER

FNBUNTH

FNBUNTH_NUM_UNITS

UNIT_MARKET_VALUE Price per unit at which the units of this gift was purchased. NUMBER

FNBUNTH

FNBUNTH_UNIT_MKT_VALUE

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_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

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: 8.0