Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT_TYPE	User-defined value classifying an account to be assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(2)	FNVPOOL	FNVPOOL_EXT_ATYP_CODE
ACCOUNT_TYPE_DESC	Account type description or title.	VARCHAR2(35)	FTVATYP	FTVATYP_TITLE
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FNVENDW	FNVENDW_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DISTRIBUTION_UNREALIZED_FREQ	Frequency at which the distribution of unrealized gains and losses is run for this pool.	VARCHAR2(1)	FNVPOOL	FNVPOOL_FREQ_GN_LS_URLD
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
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(30)	FNVENDW	FNVENDW_ALPHA_TITLE
ENDOWMENT_POOL	User assigned code for a unitized pool of funds.	VARCHAR2(2)	FNVENDW	FNVENDW_POOL_CODE
ENDOWMENT_POOL_DESC	Endowment pool description.	VARCHAR2(30)	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(2)	FNVENDW	FNVENDW_ENDW_TYPE
ENDOWMENT_TYPE_DESC	Retrieved description for endowment type.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FNVENDW	FNVENDW_FUND_CODE
FUND_DESC	Description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_ACCOUNT_INDEX	Index to debit for realized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCI_CODE_DR_RLD
GAIN_LOSS_ACCOUNT_INDEX_DESC	Retrieved description or title of the associated account index.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_CR_ACCT_POOL	Account to credit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_CR_RLD
GAIN_LOSS_CR_ACCT_POOL_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_DISTRIBUTION_FREQ	Frequency at which the distribution of gains and losses is run for this pool.	VARCHAR2(1)	FNVPOOL	FNVPOOL_FREQ_GN_LS_RLD
GAIN_LOSS_DR_ACCT_POOL	Account to debit for realized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_DR_RLD
GAIN_LOSS_DR_ACCT_POOL_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_DR_ACTV_POOL	Activity to debit for realized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACTV_CODE_DR_RLD
GAIN_LOSS_DR_ACTV_POOL_DESC	Retrieved description or title of the associated activity.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_DR_CHART_POOL	Chart to debit for realized gains and losses.	VARCHAR2(1)	FNVPOOL	FNVPOOL_COAS_GN_LS_RLD
GAIN_LOSS_DR_CHART_POOL_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_DR_FUND_POOL	Fund to debit for realized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_FUND_CODE_DR_RLD
GAIN_LOSS_DR_FUND_POOL_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_DR_LOCN_POOL	Location to debit for realized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_LOCN_CODE_DR_RLD
GAIN_LOSS_DR_LOCN_POOL_DESC	Retrieved description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_DR_ORGN_POOL	Organization to debit for realized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ORGN_CODE_DR_RLD
GAIN_LOSS_DR_ORGN_POOL_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
GAIN_LOSS_DR_PROG_POOL	Program to debit for realized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_PROG_CODE_DR_RLD
GAIN_LOSS_DR_PROG_POOL_DESC	Retrieved description or title of the associated program.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CLASSIFICATION	Categorization of endowment fund by income restriction.	VARCHAR2(2)	FNVENDW	FNVENDW_INCL_CODE
INCOME_CLASSIFICATION_DESC	Extracts principal income class description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC
INCOME_CR_ACCOUNT	Account to credit for spendable income.	VARCHAR2(6)	FNVENDW	FNVENDW_ACCT_SPEND_CODE
INCOME_CR_ACCOUNT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_ACCOUNT_POOL	Account to credit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_CR_SPEND
INCOME_CR_ACCOUNT_POOL_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_ACTIVITY	Activity to credit for spendable income.	VARCHAR2(6)	FNVENDW	FNVENDW_ACTV_SPEND_CODE
INCOME_CR_ACTIVITY_DESC	Retrieved description or title of the associated activity.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_CHART	Chart to credit for spendable income.	VARCHAR2(1)	FNVENDW	FNVENDW_COAS_SPEND_CODE
INCOME_CR_CHART_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_CHART_POOL	Chart to credit for spendable income.	VARCHAR2(1)	FNVPOOL	FNVPOOL_COAS_CR_SPEND
INCOME_CR_CHART_POOL_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_FUND	Fund to credit for spendable income.	VARCHAR2(6)	FNVENDW	FNVENDW_FUND_SPEND_CODE
INCOME_CR_FUND_DESC	Hierarchy description or title appropriate for this fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_LOCATION	Retrieved description or title of the associated fund.	VARCHAR2(6)	FNVENDW	FNVENDW_LOCN_SPEND_CODE
INCOME_CR_LOCATION_DESC	Retrieved description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_ORGANIZATION	Organization to credit for spendable income.	VARCHAR2(6)	FNVENDW	FNVENDW_ORGN_SPEND_CODE
INCOME_CR_ORGANIZATION_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_CR_PROGRAM	Program to credit for spendable income.	VARCHAR2(6)	FNVENDW	FNVENDW_PROG_SPEND_CODE
INCOME_CR_PROGRAM_DESC	Retrieved description or title of the associated program.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DISTRIBUTION_FREQ	Frequency at which the distribution of spendable income is run for this pool.	VARCHAR2(1)	FNVPOOL	FNVPOOL_FREQ_DIST_SPEND
INCOME_DR_ACCOUNT_INDEX	Index to debit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCI_CODE_DR_SPEND
INCOME_DR_ACCOUNT_INDEX_DESC	Retrieved description or title of the associated account index.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DR_ACCT_POOL	Account to debit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_DR_SPEND
INCOME_DR_ACCT_POOL_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DR_ACTV_POOL	Activity to debit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACTV_CODE_DR_SPEND
INCOME_DR_ACTV_POOL_DESC	Retrieved description or title of the associated activity.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DR_CHART_POOL	Chart to debit for spendable income.	VARCHAR2(1)	FNVPOOL	FNVPOOL_COAS_DR_SPEND
INCOME_DR_CHART_POOL_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DR_FUND_POOL	Fund to debit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_FUND_CODE_DR_SPEND
INCOME_DR_FUND_POOL_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DR_LOCN_POOL	Location to debit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_LOCN_CODE_DR_SPEND
INCOME_DR_LOCN_POOL_DESC	Retrieved description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DR_ORGN_POOL	Organization to debit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ORGN_CODE_DR_SPEND
INCOME_DR_ORGN_POOL_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
INCOME_DR_PROG_POOL	Program to debit for spendable income.	VARCHAR2(6)	FNVPOOL	FNVPOOL_PROG_CODE_DR_SPEND
INCOME_DR_PROG_POOL_DESC	Retrieved description or title of the associated program.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
POOL_STATUS	Current status of this pool as active or inactive.	VARCHAR2(1)	FNVPOOL	FNVPOOL_STATUS_IND
POOL_STATUS_DESC	Current status of this pool, Active or Inactive.	VARCHAR2(30)
POOL_TERMINATION_DATE	Date when this pool is no longer in effect.	DATE	FNVPOOL	FNVPOOL_TERM_DATE
RESTRICTION_TYPE	Indicates whether a fund is R, U or does not apply.	VARCHAR2(1)	FNVENDW	FNVENDW_REST_TYPE
RESTRICTION_TYPE_DESC	Indicates whether a fund is R - restricted, U - unrestricted or does not apply.	VARCHAR2(30)	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(1)	FNVPOOL	FNVPOOL_FREQ_UNTZ
UNREAL_GAIN_LOSS_CR_ACCT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_CR_ACCT_POOL	Account to credit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_CR_URLD
UNREAL_GAIN_LOSS_DR_ACCT_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_DR_ACCT_POOL	Account to debit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_DR_URLD
UNREAL_GAIN_LOSS_DR_ACTV_DESC	Retrieved description or title of the associated activity.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_DR_ACTV_POOL	Activity to debit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACTV_CODE_DR_URLD
UNREAL_GAIN_LOSS_DR_CHART_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_DR_CHART_POOL	Chart to debit for unrealized gains and losses.	VARCHAR2(1)	FNVPOOL	FNVPOOL_COAS_GN_LS_URLD
UNREAL_GAIN_LOSS_DR_FUND_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_DR_FUND_POOL	Fund to debit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_FUND_CODE_DR_URLD
UNREAL_GAIN_LOSS_DR_LOCN_DESC	Retrieved description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_DR_LOCN_POOL	Location to debit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_LOCN_CODE_DR_URLD
UNREAL_GAIN_LOSS_DR_ORGN_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_DR_ORGN_POOL	Organization to debit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ORGN_CODE_DR_URLD
UNREAL_GAIN_LOSS_DR_PROG_DESC	Retrieved description or title of the associated program.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
UNREAL_GAIN_LOSS_DR_PROG_POOL	Program to debit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_PROG_CODE_DR_URLD
UNREAL_GAIN_LOSS_INDEX	Index to debit for unrealized gains and losses.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCI_CODE_DR_URLD
UNREAL_GAIN_LOSS_INDEX_DESC	Retrieved description or title of the associated account index.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_CR_ACCT_POOL	Account to credit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_CR_SPNDV
VARIANCE_CR_ACCT_POOL_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_DR_ACCT_POOL	Account to debit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCT_CODE_DR_SPNDV
VARIANCE_DR_ACCT_POOL_DESC	Retrieved description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_DR_ACTV_POOL	Activity to debit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACTV_CODE_DR_SPNDV
VARIANCE_DR_ACTV_POOL_DESC	Retrieved description or title of the associated activity.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_DR_FUND_POOL	Fund to debit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_FUND_CODE_DR_SPNDV
VARIANCE_DR_FUND_POOL_DESC	Retrieved description or title of the associated fund.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_DR_LOCN_POOL	Location to debit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_LOCN_CODE_DR_SPNDV
VARIANCE_DR_LOCN_POOL_DESC	Retrieved description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_DR_ORGN_POOL	Organization to debit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ORGN_CODE_DR_SPNDV
VARIANCE_DR_ORGN_POOL_DESC	Retrieved description or title of the associated organization.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_DR_PROG_POOL	Program to debit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_PROG_CODE_DR_SPNDV
VARIANCE_DR_PROG_POOL_DESC	Retrieved description or title of the associated program.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_SPEND_ACCT_INDEX	Index to debit for distribution of spending policy variance.	VARCHAR2(6)	FNVPOOL	FNVPOOL_ACCI_CODE_DR_SPNDV
VARIANCE_SPEND_ACCT_INDEX_DESC	Retrieved description or title of the associated account index.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_SPEND_DR_CHART_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
VARIANCE_SPEND_DR_CHART_POOL	Chart to debit for distribution of spending policy variance.	VARCHAR2(1)	FNVPOOL	FNVPOOL_COAS_SPND_POL_VAR
VARIANCE_SPEND_FREQ	Frequency at which the distribution of spending policy variance is run for this pool.	VARCHAR2(1)	FNVPOOL	FNVPOOL_FREQ_SPND_POL_VAR
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: