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