| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
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 code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
ACCOUNT_STATUS
|
Status of the account.
|
VARCHAR2(63)
|
FTVACCT
|
FTVACCT_STATUS_IND
|
|
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 or title.
|
VARCHAR2(255)
|
FTVATYP
|
FTVATYP_TITLE
|
|
ACCOUNT_TYPE_STATUS
|
Attribute type status associated with the set.
|
VARCHAR2(63)
|
FTVACCT
|
FTVACCT_STATUS_IND
|
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
BOOK_AMOUNT
|
Amount of the transaction associated with this particular account distribution.
|
NUMBER
|
FNBUNTH
|
FNBUNTH_TRANS_AMT
|
|
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 code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
CHART_OF_ACCOUNTS_STATUS
|
Status of the chart of accounts.
|
VARCHAR2(63)
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
|
DISTRIBUTION_UNREALIZED_FREQ
|
Frequency at which the distribution of unrealized gains and losses is run for this pool.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_FREQ_GN_LS_URLD
|
|
ENDOWMENT_ESTABLISHED_DATE
|
Date that the fund was established.
|
DATE
|
FNVENDW
|
FNVENDW_EST_DATE
|
|
ENDOWMENT_FUND_LD
|
Detailed endowment title of the fund.
|
VARCHAR2(255)
|
FNVENDW
|
FNVENDW_LONG_FUND_TITLE
|
|
ENDOWMENT_FUND_SD
|
Alpha title or short name for the fund.
|
VARCHAR2(255)
|
FNVENDW
|
FNVENDW_ALPHA_TITLE
|
|
ENDOWMENT_POOL
|
User assigned code for a unitized pool of funds.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_POOL_CODE
|
|
ENDOWMENT_POOL_DESC
|
Endowment pool description.
|
VARCHAR2(255)
|
FNVPOOL
|
FNVPOOL_POOL_TITLE
|
|
ENDOWMENT_TERMINATION_DATE
|
Date when the endowment is no longer in effect.
|
DATE
|
FNVENDW
|
FNVENDW_TERM_DATE
|
|
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
|
Retrieved description for endowment type.
|
VARCHAR2(255)
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
ENTITY_FIRST_NAME
|
Donor's current first name.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME
|
|
ENTITY_ID_NUMBER
|
Donor's current identification number.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
|
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
|
Donor's current middle initial.
|
VARCHAR2(63)
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI
|
|
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
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
FNBUNTH
|
FNBUNTH_DONOR_PIDM
|
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_FUND_CODE
|
|
FUND_DESC
|
Description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
FUND_STATUS
|
Current status of the associated fund.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_STATUS_IND
|
|
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
|
Retrieved description or title of the associated account index.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
GAIN_LOSS_CR_ACCT_POOL
|
Account to credit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_CR_RLD
|
|
GAIN_LOSS_CR_ACCT_POOL_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
GAIN_LOSS_DISTRIBUTION_FREQ
|
Frequency at which the distribution of gains and losses is run for this pool.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_FREQ_GN_LS_RLD
|
|
GAIN_LOSS_DR_ACCT_POOL
|
Account to debit for realized gains and losses.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_DR_RLD
|
|
GAIN_LOSS_DR_ACCT_POOL_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated activity.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
GAIN_LOSS_DR_ORGN_POOL
|
Organization to debit for realized gains and losses.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ORGN_CODE_DR_RLD
|
|
GAIN_LOSS_DR_ORGN_POOL_DESC
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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 that is assigned when the gift is entered.
|
VARCHAR2(63)
|
FNBUNTH
|
FNBUNTH_GIFT_NUM
|
|
INCOME_CLASSIFICATION
|
Categorization of endowment fund by income restriction.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_INCL_CODE
|
|
INCOME_CLASSIFICATION_DESC
|
Extracts principal income class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
INCOME_CR_ACCOUNT
|
Account to credit for spendable income.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_ACCT_SPEND_CODE
|
|
INCOME_CR_ACCOUNT_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_ACCOUNT_POOL
|
Account to credit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_CR_SPEND
|
|
INCOME_CR_ACCOUNT_POOL_DESC
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_ACTIVITY
|
Activity to credit for spendable income.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_ACTV_SPEND_CODE
|
|
INCOME_CR_ACTIVITY_DESC
|
Retrieved description or title of the associated activity.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_CHART
|
Chart to credit for spendable income.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_COAS_SPEND_CODE
|
|
INCOME_CR_CHART_DESC
|
Retrieved description or title of the associated chart of accounts.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_CHART_POOL
|
Chart to credit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_COAS_CR_SPEND
|
|
INCOME_CR_CHART_POOL_DESC
|
Retrieved description or title of the associated chart of accounts.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_CHART_STATUS
|
Chart Of Account status credit for spendable income.
|
VARCHAR2(63)
|
FTVACCT
|
FTVACCT_STATUS_IND
|
|
INCOME_CR_FUND
|
Fund to credit for spendable income.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_FUND_SPEND_CODE
|
|
INCOME_CR_FUND_DESC
|
Retrieved description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_FUND_STATUS
|
Fund Status credit for spendable income.
|
VARCHAR2(63)
|
FTVFUND
|
FTVFUND_STATUS_IND
|
|
INCOME_CR_LOCATION
|
Location to credit for spendable income.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_LOCN_SPEND_CODE
|
|
INCOME_CR_LOCATION_DESC
|
Retrieved description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_ORGANIZATION
|
Organization to credit for spendable income.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_ORGN_SPEND_CODE
|
|
INCOME_CR_ORGANIZATION_DESC
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_CR_PROGRAM
|
Program to credit for spendable income.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_PROG_SPEND_CODE
|
|
INCOME_CR_PROGRAM_DESC
|
Retrieved description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DISTRIBUTION_FREQ
|
Frequency at which the distribution of spendable income is run for this pool.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_FREQ_DIST_SPEND
|
|
INCOME_DR_ACCOUNT_INDEX
|
Index to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCI_CODE_DR_SPEND
|
|
INCOME_DR_ACCOUNT_INDEX_DESC
|
Retrieved description or title of the associated account index.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DR_ACCT_POOL
|
Account to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_DR_SPEND
|
|
INCOME_DR_ACCT_POOL_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DR_ACTV_POOL
|
Activity to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACTV_CODE_DR_SPEND
|
|
INCOME_DR_ACTV_POOL_DESC
|
Retrieved description or title of the associated activity.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DR_CHART_POOL
|
Chart to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_COAS_DR_SPEND
|
|
INCOME_DR_CHART_POOL_DESC
|
Retrieved description or title of the associated chart of accounts.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DR_FUND_POOL
|
Fund to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_FUND_CODE_DR_SPEND
|
|
INCOME_DR_FUND_POOL_DESC
|
Retrieved description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DR_LOCN_POOL
|
Location to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_LOCN_CODE_DR_SPEND
|
|
INCOME_DR_LOCN_POOL_DESC
|
Retrieved description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DR_ORGN_POOL
|
Organization to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ORGN_CODE_DR_SPEND
|
|
INCOME_DR_ORGN_POOL_DESC
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
INCOME_DR_PROG_POOL
|
Program to debit for spendable income.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_PROG_CODE_DR_SPEND
|
|
INCOME_DR_PROG_POOL_DESC
|
Retrieved description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
ORGANIZATION_CODE
|
Identification accounting code used for the department on the gift transaction.
|
VARCHAR2(63)
|
FNBUNTH
|
FNBUNTH_ORGN_CODE
|
|
ORGANIZATION_DESC
|
Extracted description or title associated with the organization code.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
ORGANIZATION_STATUS
|
Current status of the associated organization.
|
VARCHAR2(63)
|
FTVORGN
|
FTVORGN_STATUS_IND
|
|
POOL_STATUS
|
Current status of this pool as active or inactive.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_STATUS_IND
|
|
POOL_STATUS_DESC
|
Deciphers status of this endowment pool as active or inactive.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(FNVPOOL_STATUS_IND)
|
|
POOL_TERMINATION_DATE
|
Date when this pool is no longer in effect.
|
DATE
|
FNVPOOL
|
FNVPOOL_TERM_DATE
|
|
POSTING_DATE
|
Date used to post the gift to the ledgers.
|
DATE
|
FNBUNTH
|
FNBUNTH_TRANS_DATE
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
PROGRAM
|
Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.
|
VARCHAR2(63)
|
FNBUNTH
|
FNBUNTH_PROG_CODE
|
|
PROGRAM_DESC
|
Extracted description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
PROGRAM_STATUS
|
Current status of the associated program.
|
VARCHAR2(63)
|
FTVPROG
|
FTVPROG_STATUS_IND
|
|
RESTRICTION_TYPE
|
Indicates whether a fund is R, U or does not apply.
|
VARCHAR2(63)
|
FNVENDW
|
FNVENDW_REST_TYPE
|
|
RESTRICTION_TYPE_DESC
|
Deciphers fund as restricted, unrestricted or does not apply.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(FNVENDW_REST_TYPE)
|
|
SPECIAL_INSTRUCTIONS
|
Detailed description of any special instruction for managing the fund.
|
VARCHAR2(255)
|
FNVENDW
|
FNVENDW_INC_DIST_SPEC_INST
|
|
UNITIZATION_FREQUENCY
|
Frequency at which unitization is run for this pool.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_FREQ_UNTZ
|
|
UNITIZATION_PERIOD_END_DATE
|
End date of the unitization period for which the gift purchased units.
|
DATE
|
FNBUNTH
|
FNBUNTH_UNTZ_END_DATE
|
|
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
|
Price per unit at which the units of this gift was purchased.
|
NUMBER
|
FNBUNTH
|
FNBUNTH_UNIT_MKT_VALUE
|
|
UNREAL_GAIN_LOSS_CR_ACCT_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
UNREAL_GAIN_LOSS_CR_ACCT_POOL
|
Account to credit for unrealized gains and losses.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_CR_URLD
|
|
UNREAL_GAIN_LOSS_DR_ACCT_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
UNREAL_GAIN_LOSS_DR_ACCT_POOL
|
Account to debit for unrealized gains and losses.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_DR_URLD
|
|
UNREAL_GAIN_LOSS_DR_ACTV_DESC
|
Retrieved description or title of the associated activity.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated chart of accounts.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
UNREAL_GAIN_LOSS_DR_ORGN_POOL
|
Organization to debit for unrealized gains and losses.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ORGN_CODE_DR_URLD
|
|
UNREAL_GAIN_LOSS_DR_PROG_DESC
|
Retrieved description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Index to debit for unrealized gains and losses.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCI_CODE_DR_URLD
|
|
UNREAL_GAIN_LOSS_INDEX_DESC
|
Retrieved description or title of the associated account index.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
VARIANCE_CR_ACCT_POOL
|
Account to credit for distribution of spending policy variance.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_CR_SPNDV
|
|
VARIANCE_CR_ACCT_POOL_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
VARIANCE_DR_ACCT_POOL
|
Account to debit for distribution of spending policy variance.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCT_CODE_DR_SPNDV
|
|
VARIANCE_DR_ACCT_POOL_DESC
|
Retrieved description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated activity.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
VARIANCE_DR_ORGN_POOL
|
Organization to debit for distribution of spending policy variance.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ORGN_CODE_DR_SPNDV
|
|
VARIANCE_DR_ORGN_POOL_DESC
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
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
|
Retrieved description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
VARIANCE_SPEND_ACCT_INDEX
|
Index to debit for distribution of spending policy variance.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_ACCI_CODE_DR_SPNDV
|
|
VARIANCE_SPEND_ACCT_INDEX_DESC
|
Retrieved description or title of the associated account index.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
VARIANCE_SPEND_DR_CHART_DESC
|
Retrieved description or title of the associated chart of accounts.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
VARIANCE_SPEND_DR_CHART_POOL
|
Chart to debit for distribution of spending policy variance.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_COAS_SPND_POL_VAR
|
|
VARIANCE_SPEND_FREQ
|
Frequency at which the distribution of spending policy variance is run for this pool.
|
VARCHAR2(63)
|
FNVPOOL
|
FNVPOOL_FREQ_SPND_POL_VAR
|