Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AGGREGATE_BOOK_AMOUNT
|
Aggregate Book Amount
|
Aggregation of all the transaction amounts up to and including this unitization period end date associated with this particular chart of accounts and fund.
|
NUMBER
|
FUNCTION
|
MFKFUNC.F_GET_BOOK_AMOUNT
|
AGGREGATE_UNITS_PURCHASED
|
Aggregate Units Purchased
|
Aggregation of all the number of units that the gift purchased in the pool up to and including this unitzation period end date based on the unit value for the period of the gift date for this specific chart of accounts and fund.
|
NUMBER
|
FUNCTION
|
MFKFUNC.F_GET_UNITS_PURCHASED
|
BOOK_AMOUNT
|
Book Amount
|
Summarized amount of the transactions associated with this particular chart of accounts and fund.
|
NUMBER
|
FUNCTION
|
MFKFUNC.F_SUM_BOOK_AMOUNT
|
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 Accounts Status
|
Status of the chart of accounts.
|
VARCHAR2(63)
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
ENDOWMENT_FUND_LD
|
Endowment Fund Long Description
|
Detailed endowment title of the fund.
|
VARCHAR2(255)
|
FNVENDW
|
FNVENDW_LONG_FUND_TITLE
|
ENDOWMENT_POOL
|
Endowment Pool
|
User assigned code for a unitized pool of funds.
|
VARCHAR2(63)
|
FNRUCTR
|
FNRUCTR_POOL_CODE
|
ENDOWMENT_POOL_DESC
|
Endowment Pool Description
|
Endowment pool description.
|
VARCHAR2(255)
|
FNVPOOL
|
FNVPOOL_POOL_TITLE
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
FNBUNTH
|
FNBUNTH_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
|
MARKET_PURCHASE_UNIT_PRICE
|
Market Purchase Unit Price
|
Market price per unit at which the units of this pool is to be purchased.
|
NUMBER
|
FNRUCTR
|
FNRUCTR_PUR_PRICE_VAL_UNIT
|
MARKET_VALUATION_DATE
|
Market Valuation Date
|
Date this market unit price is valid.
|
DATE
|
FNRUCTR
|
FNRUCTR_VALUATION_DATE
|
MARKET_VALUE
|
Market Value
|
Number of units that the gift purchased in the pool based on the unit value for the period of the gift date.
|
NUMBER
|
CALCULATION
|
MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE
|
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
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
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
|
Summarized number of units that the gift purchased in the pool based on the unit value for the period of the gift date for this specific chart of accounts and fund.
|
NUMBER
|
FUNCTION
|
MFKFUNC.F_SUM_UNITS_PURCHASED
|