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
|