Go To View:  RETURN TO BANNER ODS META DATA 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, ENDOWMENT_POOL, FUND
CHART_OF_ACCOUNTS, FUND
INCOME_CR_CHART, INCOME_CR_FUND
ENTITY_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACCOUNT 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 Description Account code description or title. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_STATUS Account Status Status of the account. VARCHAR2(63)  

FTVACCT

FTVACCT_STATUS_IND

ACCOUNT_TYPE 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 Account type description or title. VARCHAR2(255)  

FTVATYP

FTVATYP_TITLE

ACCOUNT_TYPE_STATUS Account Type Status Attribute type status associated with the set VARCHAR2(63)  

FTVACCT

FTVACCT_STATUS_IND

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

NA

NA

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

FNBUNTH

FNBUNTH_TRANS_AMT

CHART_OF_ACCOUNTS 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 Description Chart of accounts code description or title. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Account Status Status of the chart of accounts. VARCHAR2(63)  

FTVCOAS

FTVCOAS_STATUS_IND

DISTRIBUTION_UNREALIZED_FREQ Distribution Unrealized Frequency 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 Endowment Established Date Date that the fund was established. DATE  

FNVENDW

FNVENDW_EST_DATE

ENDOWMENT_FUND_LD Endowment Fund Long Description Detailed endowment title of the fund. VARCHAR2(255)  

FNVENDW

FNVENDW_LONG_FUND_TITLE

ENDOWMENT_FUND_SD Endowment Fund Short Description Alpha title or short name for the fund. VARCHAR2(255)  

FNVENDW

FNVENDW_ALPHA_TITLE

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

FNVENDW

FNVENDW_POOL_CODE

ENDOWMENT_POOL_DESC Endowment Pool Description Endowment pool description. VARCHAR2(255)  

FNVPOOL

FNVPOOL_POOL_TITLE

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

FNVENDW

FNVENDW_TERM_DATE

ENDOWMENT_TYPE 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 Endowment Type Description Retrieved description for endowment type. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

ENTITY_LAST_NAME 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 Entity Middle Name Donor's current middle initial. VARCHAR2(63)  

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

ENTITY_NAME 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 Entity UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER  

FNBUNTH

FNBUNTH_DONOR_PIDM

FUND Fund Unique fiscal entity code. VARCHAR2(63)  

FNVENDW

FNVENDW_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FTVFUND

FTVFUND_STATUS_IND

GAIN_LOSS_ACCOUNT_INDEX 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 Gain Loss Account INDEX Description Retrieved description or title of the associated account index. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_CR_ACCT_POOL Gain Loss Cr Account Pool Account to credit for spendable income. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ACCT_CODE_CR_RLD

GAIN_LOSS_CR_ACCT_POOL_DESC Gain Loss Cr Account Pool Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DISTRIBUTION_FREQ Gain Loss Distribution Frequency 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 Gain Loss Dr Account Pool Account to debit for realized gains and losses. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ACCT_CODE_DR_RLD

GAIN_LOSS_DR_ACCT_POOL_DESC Gain Loss Dr Account Pool Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_ACTV_POOL 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 Gain Loss Dr Actv Pool Description Retrieved description or title of the associated activity. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_CHART_POOL 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 Gain Loss Dr Chart Pool Description Retrieved description or title of the associated organization. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_FUND_POOL 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 Gain Loss Dr Fund Pool Description Retrieved description or title of the associated fund. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_LOCN_POOL 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 Gain Loss Dr Locn Pool Description Retrieved description or title of the associated location. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_ORGN_POOL Gain Loss Dr Organization Pool Organization to debit for realized gains and losses. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ORGN_CODE_DR_RLD

GAIN_LOSS_DR_ORGN_POOL_DESC Gain Loss Dr Organization Pool Description Retrieved description or title of the associated organization. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GAIN_LOSS_DR_PROG_POOL 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 Gain Loss Dr Prog Pool Description Retrieved description or title of the associated program. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

GIFT_DATE 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 Gift number that is assigned when the gift is entered. VARCHAR2(63)  

FNBUNTH

FNBUNTH_GIFT_NUM

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

FNVENDW

FNVENDW_INCL_CODE

INCOME_CLASSIFICATION_DESC Income Classification Description Extracts principal income class description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

FNVENDW

FNVENDW_ACCT_SPEND_CODE

INCOME_CR_ACCOUNT_DESC Income Cr Account Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPEND

INCOME_CR_ACCOUNT_POOL_DESC Income Cr Account Pool Description Retrieved description or title of the associated organization. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_ACTV_SPEND_CODE

INCOME_CR_ACTIVITY_DESC Income Cr Activity Description Retrieved description or title of the associated activity. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_COAS_SPEND_CODE

INCOME_CR_CHART_DESC Income Cr Chart Description Retrieved description or title of the associated chart of accounts. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_COAS_CR_SPEND

INCOME_CR_CHART_POOL_DESC Income Cr Chart Pool Description Retrieved description or title of the associated chart of accounts. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

INCOME_CR_CHART_STATUS Income CR Chart Status Chart Of Account status credit for spendable income. VARCHAR2(63)  

FTVACCT

FTVACCT_STATUS_IND

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

FNVENDW

FNVENDW_FUND_SPEND_CODE

INCOME_CR_FUND_DESC Income Cr Fund Description Retrieved description or title of the associated fund. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FTVFUND

FTVFUND_STATUS_IND

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

FNVENDW

FNVENDW_LOCN_SPEND_CODE

INCOME_CR_LOCATION_DESC Income Cr Location Description Retrieved description or title of the associated location. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_ORGN_SPEND_CODE

INCOME_CR_ORGANIZATION_DESC Income Cr Organization Description Retrieved description or title of the associated organization. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVENDW

FNVENDW_PROG_SPEND_CODE

INCOME_CR_PROGRAM_DESC Income Cr Program Description Retrieved description or title of the associated program. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FREQ_DIST_SPEND

INCOME_DR_ACCOUNT_INDEX Income Dr Account INDEX Index to debit for spendable income. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPEND

INCOME_DR_ACCOUNT_INDEX_DESC Income Dr Account INDEX Description Retrieved description or title of the associated account index. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPEND

INCOME_DR_ACCT_POOL_DESC Income Dr Account Pool Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_ACTV_POOL Income Dr Actv Pool Activity to debit for spendable income. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ACTV_CODE_DR_SPEND

INCOME_DR_ACTV_POOL_DESC Income Dr Actv Pool Description Retrieved description or title of the associated activity. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_COAS_DR_SPEND

INCOME_DR_CHART_POOL_DESC Income Dr Chart Pool Description Retrieved description or title of the associated chart of accounts. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_FUND_CODE_DR_SPEND

INCOME_DR_FUND_POOL_DESC Income Dr Fund Pool Description Retrieved description or title of the associated fund. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_LOCN_POOL Income Dr Locn Pool Location to debit for spendable income. VARCHAR2(63)  

FNVPOOL

FNVPOOL_LOCN_CODE_DR_SPEND

INCOME_DR_LOCN_POOL_DESC Income Dr Locn Pool Description Retrieved description or title of the associated location. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPEND

INCOME_DR_ORGN_POOL_DESC Income Dr Organization Pool Description Retrieved description or title of the associated organization. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

INCOME_DR_PROG_POOL Income Dr Prog Pool Program to debit for spendable income. VARCHAR2(63)  

FNVPOOL

FNVPOOL_PROG_CODE_DR_SPEND

INCOME_DR_PROG_POOL_DESC Income Dr Prog Pool Description Retrieved description or title of the associated program. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

NA

NA

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

NA

NA

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

FNBUNTH

FNBUNTH_ORGN_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FTVORGN

FTVORGN_STATUS_IND

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

FNVPOOL

FNVPOOL_STATUS_IND

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

CALCULATION

DECODE(FNVPOOL_STATUS_IND)

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

FNVPOOL

FNVPOOL_TERM_DATE

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

FNBUNTH

FNBUNTH_TRANS_DATE

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

NA

NA

PROGRAM 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 Program Description Extracted description or title of the associated program. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FTVPROG

FTVPROG_STATUS_IND

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

FNVENDW

FNVENDW_REST_TYPE

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

CALCULATION

DECODE(FNVENDW_REST_TYPE)

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

FNVENDW

FNVENDW_INC_DIST_SPEC_INST

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

FNVPOOL

FNVPOOL_FREQ_UNTZ

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

FNBUNTH

FNBUNTH_UNTZ_END_DATE

UNITS_PURCHASED 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 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 Unreal Gain Loss Cr Account Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_CR_ACCT_POOL Unreal Gain Loss Cr Account Pool Account to credit for unrealized gains and losses. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ACCT_CODE_CR_URLD

UNREAL_GAIN_LOSS_DR_ACCT_DESC Unreal Gain Loss Dr Account Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_ACCT_POOL Unreal Gain Loss Dr Account Pool Account to debit for unrealized gains and losses. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ACCT_CODE_DR_URLD

UNREAL_GAIN_LOSS_DR_ACTV_DESC Unreal Gain Loss Dr Actv Description Retrieved description or title of the associated activity. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_ACTV_POOL 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 Unreal Gain Loss Dr Chart Description Retrieved description or title of the associated chart of accounts. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_CHART_POOL 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 Unreal Gain Loss Dr Fund Description Retrieved description or title of the associated fund. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_FUND_POOL 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 Unreal Gain Loss Dr Locn Description Retrieved description or title of the associated location. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_LOCN_POOL 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 Unreal Gain Loss Dr Organization Description Retrieved description or title of the associated organization. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_ORGN_POOL Unreal Gain Loss Dr Organization Pool Organization to debit for unrealized gains and losses. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ORGN_CODE_DR_URLD

UNREAL_GAIN_LOSS_DR_PROG_DESC Unreal Gain Loss Dr Prog Description Retrieved description or title of the associated program. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

UNREAL_GAIN_LOSS_DR_PROG_POOL 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 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 Unreal Gain Loss INDEX Description Retrieved description or title of the associated account index. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_CR_SPNDV

VARIANCE_CR_ACCT_POOL_DESC Variance Cr Account Pool Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ACCT_CODE_DR_SPNDV

VARIANCE_DR_ACCT_POOL_DESC Variance Dr Account Pool Description Retrieved description or title of the associated account. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_ACTV_POOL 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 Variance Dr Actv Pool Description Retrieved description or title of the associated activity. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_FUND_POOL 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 Variance Dr Fund Pool Description Retrieved description or title of the associated fund. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_LOCN_POOL 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 Variance Dr Locn Pool Description Retrieved description or title of the associated location. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

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

FNVPOOL

FNVPOOL_ORGN_CODE_DR_SPNDV

VARIANCE_DR_ORGN_POOL_DESC Variance Dr Organization Pool Description Retrieved description or title of the associated organization. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_DR_PROG_POOL 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 Variance Dr Prog Pool Description Retrieved description or title of the associated program. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_SPEND_ACCT_INDEX Variance Spending Account INDEX Index to debit for distribution of spending policy variance. VARCHAR2(63)  

FNVPOOL

FNVPOOL_ACCI_CODE_DR_SPNDV

VARIANCE_SPEND_ACCT_INDEX_DESC Variance Spending Account INDEX Description Retrieved description or title of the associated account index. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_SPEND_DR_CHART_DESC Variance Spending Debit Chart Description Retrieved description or title of the associated chart of accounts. VARCHAR2(255)  

FUNCTION

F_GET_FINANCE_DESC

VARIANCE_SPEND_DR_CHART_POOL Variance Spending Debit Chart Pool Chart to debit for distribution of spending policy variance. VARCHAR2(63)  

FNVPOOL

FNVPOOL_COAS_SPND_POL_VAR

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

FNVPOOL

FNVPOOL_FREQ_SPND_POL_VAR



Ver: 9.0