Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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		Unique fiscal entity code.	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: