Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

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 VALUE
CHART_OF_ACCOUNTS, FUND
ENTITY_UID
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND
INCOME_CR_CHART, INCOME_CR_FUND

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

FNBUNTH

FNBUNTH_ACCT_CODE

NO

NO
ACCOUNT_DESC Account code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
ACCOUNT_STATUS Status of the account. VARCHAR2(63)

FTVACCT

FTVACCT_STATUS_IND

NO

NO
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

NO

NO
ACCOUNT_TYPE_DESC Account type description or title. VARCHAR2(255)

FTVATYP

FTVATYP_TITLE

NO

NO
ACCOUNT_TYPE_STATUS Attribute type status associated with the set. VARCHAR2(63)

FTVACCT

FTVACCT_STATUS_IND

NO

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

NA

NA

NO

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

FNBUNTH

FNBUNTH_TRANS_AMT

NO

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

FNVENDW

FNVENDW_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_STATUS Status of the chart of accounts. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

NO

NO
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

NO

NO
ENDOWMENT_ESTABLISHED_DATE Date that the fund was established. DATE

FNVENDW

FNVENDW_EST_DATE

NO

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

FNVENDW

FNVENDW_LONG_FUND_TITLE

NO

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

FNVENDW

FNVENDW_ALPHA_TITLE

NO

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

FNVENDW

FNVENDW_POOL_CODE

NO

NO
ENDOWMENT_POOL_DESC Endowment pool description. VARCHAR2(255)

FNVPOOL

FNVPOOL_POOL_TITLE

NO

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

FNVENDW

FNVENDW_TERM_DATE

NO

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

FNVENDW

FNVENDW_ENDW_TYPE

NO

NO
ENDOWMENT_TYPE_DESC Retrieved description for endowment type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

NO

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

NO

NO

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

NO

NO

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

NO

NO

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

NO

NO

NO
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

NO

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

FNBUNTH

FNBUNTH_DONOR_PIDM

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)

FNVENDW

FNVENDW_FUND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
FUND_STATUS Current status of the associated fund. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

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

FNVPOOL

FNVPOOL_ACCI_CODE_DR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
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

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_COAS_GN_LS_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_RLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
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

NO

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

FNBUNTH

FNBUNTH_GIFT_NUM

NO

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

FNVENDW

FNVENDW_INCL_CODE

NO

NO
INCOME_CLASSIFICATION_DESC Extracts principal income class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FNVENDW

FNVENDW_ACCT_SPEND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVENDW

FNVENDW_ACTV_SPEND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVENDW

FNVENDW_COAS_SPEND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_COAS_CR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
INCOME_CR_CHART_STATUS Chart Of Account status credit for spendable income. VARCHAR2(63)

FTVACCT

FTVACCT_STATUS_IND

NO

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

FNVENDW

FNVENDW_FUND_SPEND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
INCOME_CR_FUND_STATUS Fund Status credit for spendable income. VARCHAR2(63)

FTVFUND

FTVFUND_STATUS_IND

NO

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

FNVENDW

FNVENDW_LOCN_SPEND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVENDW

FNVENDW_ORGN_SPEND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVENDW

FNVENDW_PROG_SPEND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_FREQ_DIST_SPEND

NO

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

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_COAS_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_SPEND

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

NA

NA

NO

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

NA

NA

NO

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

FNBUNTH

FNBUNTH_ORGN_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
ORGANIZATION_STATUS Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

NO

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

FNVPOOL

FNVPOOL_STATUS_IND

NO

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

CALCULATION

DECODE(FNVPOOL_STATUS_IND)

NO

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

FNVPOOL

FNVPOOL_TERM_DATE

NO

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

FNBUNTH

FNBUNTH_TRANS_DATE

NO

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

NA

NA

NO

NO
PROGRAM Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)

FNBUNTH

FNBUNTH_PROG_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

NO
PROGRAM_STATUS Current status of the associated program. VARCHAR2(63)

FTVPROG

FTVPROG_STATUS_IND

NO

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

FNVENDW

FNVENDW_REST_TYPE

NO

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

CALCULATION

DECODE(FNVENDW_REST_TYPE)

NO

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

FNVENDW

FNVENDW_INC_DIST_SPEC_INST

NO

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

FNVPOOL

FNVPOOL_FREQ_UNTZ

NO

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

FNBUNTH

FNBUNTH_UNTZ_END_DATE

NO

NO
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

NO

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

FNBUNTH

FNBUNTH_UNIT_MKT_VALUE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_COAS_GN_LS_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_URLD

NO

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

FNVPOOL

FNVPOOL_ACCI_CODE_DR_URLD

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACTV_CODE_DR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_LOCN_CODE_DR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_PROG_CODE_DR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPNDV

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FNVPOOL

FNVPOOL_COAS_SPND_POL_VAR

NO

NO
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

NO

NO


Ver: 9.2