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

SGHE Banner 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, ENDOWMENT_POOL, FUND
CHART_OF_ACCOUNTS, FUND
INCOME_CR_CHART, INCOME_CR_FUND
DOCUMENT_NUMBER, SUBMISSION_NUMBER, CHART_OF_ACCOUNTS, FUND

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
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

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

FNBDSTH

FNBDSTH_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

DOCUMENT_NUMBER Document Number Unique transaction id assigned from posting. VARCHAR2(63)  

FNBDSTH

FNBDSTH_DOC_NUM

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)  

FNBDSTH

FNBDSTH_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

FUND Fund Unique fiscal entity code. VARCHAR2(63)  

FNBDSTH

FNBDSTH_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

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)  

FTVCOAS

FTVCOAS_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

INCOME_SPEND_AMOUNT Income Spend Amount Amount of spendable income distributed. NUMBER  

FNBDSTH

FNBDSTH_SPND_INC_AMT

INCOME_SPEND_END_DATE Income Spend End Date Period end date for which distribution of spendable income was run. DATE  

FNBDSTH

FNBDSTH_SPND_INC_END_DATE

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

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

PROCESS_GROUP 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 Real Gain Loss Amount Amount of realized income distributed. NUMBER  

FNBDSTH

FNBDSTH_RLZD_GL_AMT

REAL_GAIN_LOSS_END_DATE 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 Real Gain Loss Rate Amount of realized income distributed. NUMBER  

FNBDSTH

FNBDSTH_RLZD_GL_RATE

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

SPEND_VARIABLE_AMOUNT Spend Variable Amount Amount of spending policy variance income distributed. NUMBER  

FNBDSTH

FNBDSTH_SPND_VAR_AMT

SPEND_VARIABLE_END_DATE 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 Spend Variable Rate Amount of unrealized income distributed. NUMBER  

FNBDSTH

FNBDSTH_SPND_VAR_RATE

SUBMISSION_NUMBER Submission Number Submission number used for documents that utilized resubmission features. NUMBER  

FNBDSTH

FNBDSTH_SUBMISSION_NUMBER

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

FNVPOOL

FNVPOOL_FREQ_UNTZ

UNIT_SPEND_RATE Unit Spendable Rate Spendable income amount per unit. NUMBER  

FNBDSTH

FNBDSTH_SPND_RATE

UNREAL_GAIN_LOSS_AMOUNT Unreal Gain Loss Amount Amount of unrealized income distributed. NUMBER  

FNBDSTH

FNBDSTH_URLZD_GL_AMT

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

UNREAL_GAIN_LOSS_RATE Unreal Gain Loss Rate Amount of unrealized income distributed. NUMBER  

FNBDSTH

FNBDSTH_URLZD_GL_RATE

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