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(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
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 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
DOCUMENT_NUMBER	Unique transaction id assigned from posting.	VARCHAR2(63)	FNBDSTH	FNBDSTH_DOC_NUM
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)	FNBDSTH	FNBDSTH_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
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	FNBDSTH	FNBDSTH_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
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)	FTVCOAS	FTVCOAS_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
INCOME_SPEND_AMOUNT	Amount of spendable income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_INC_AMT
INCOME_SPEND_END_DATE	Period end date for which distribution of spendable income was run.	DATE	FNBDSTH	FNBDSTH_SPND_INC_END_DATE
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
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
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	Amount of realized income distributed.	NUMBER	FNBDSTH	FNBDSTH_RLZD_GL_AMT
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	Amount of realized income distributed.	NUMBER	FNBDSTH	FNBDSTH_RLZD_GL_RATE
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
SPEND_VARIABLE_AMOUNT	Amount of spending policy variance income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_VAR_AMT
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	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_SPND_VAR_RATE
SUBMISSION_NUMBER	Submission number used for documents that utilized resubmission features.	NUMBER	FNBDSTH	FNBDSTH_SUBMISSION_NUMBER
UNITIZATION_FREQUENCY	Frequency at which unitization is run for this pool.	VARCHAR2(63)	FNVPOOL	FNVPOOL_FREQ_UNTZ
UNIT_SPEND_RATE	Spendable income amount per unit.	NUMBER	FNBDSTH	FNBDSTH_SPND_RATE
UNREAL_GAIN_LOSS_AMOUNT	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_URLZD_GL_AMT
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_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	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
UNREAL_GAIN_LOSS_RATE	Amount of unrealized income distributed.	NUMBER	FNBDSTH	FNBDSTH_URLZD_GL_RATE
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

Ver: 9.1