| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
|
ACCOUNT
|
Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.
|
VARCHAR2(6)
|
FNBUNTH
|
FNBUNTH_ACCT_CODE
|
NO
|
NO
|
|
ACCOUNT_DESC
|
Account code description or title.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
NO
|
NO
|
|
BOOK_AMOUNT
|
Amount of the transaction associated with this particular account distribution.
|
NUMBER
|
FNBUNTH
|
FNBUNTH_TRANS_AMT
|
NO
|
NO
|
|
CHART_OF_ACCOUNTS
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(1)
|
FNBUNTH
|
FNBUNTH_COAS_CODE
|
NO
|
NO
|
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts code description or title.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
NO
|
NO
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
|
ENTITY_UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
FNBUNTH
|
FNBUNTH_DONOR_PIDM
|
NO
|
NO
|
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(6)
|
FNBUNTH
|
FNBUNTH_FUND_CODE
|
NO
|
NO
|
|
FUND_DESC
|
Description or title of the associated fund.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
NO
|
NO
|
|
GIFT_DATE
|
Date of the gift for IRS valuation purposes. Used to obtain purchase price per unit in the unitization process in endowment management.
|
DATE
|
FNBUNTH
|
FNBUNTH_GIFT_DATE
|
NO
|
NO
|
|
GIFT_NUMBER
|
Gift number that is assigned when the gift is entered.
|
VARCHAR2(8)
|
FNBUNTH
|
FNBUNTH_GIFT_NUM
|
NO
|
NO
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
|
ORGANIZATION_CODE
|
Identification accounting code used for the department on the gift transaction.
|
VARCHAR2(6)
|
FNBUNTH
|
FNBUNTH_ORGN_CODE
|
NO
|
NO
|
|
ORGANIZATION_DESC
|
Extracted description or title associated with the organization code.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
NO
|
NO
|
|
POSTING_DATE
|
Date used to post the gift to the ledgers.
|
DATE
|
FNBUNTH
|
FNBUNTH_TRANS_DATE
|
NO
|
NO
|
|
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(6)
|
FNBUNTH
|
FNBUNTH_PROG_CODE
|
NO
|
NO
|
|
PROGRAM_DESC
|
Extracted description or title of the associated program.
|
VARCHAR2(35)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
NO
|
NO
|
|
UNITIZATION_PERIOD_END_DATE
|
End date of the unitization period for which the gift purchased units.
|
DATE
|
FNBUNTH
|
FNBUNTH_UNTZ_END_DATE
|
NO
|
NO
|
|
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
|
NO
|
NO
|
|
UNIT_MARKET_VALUE
|
Price per unit at which the units of this gift was purchased.
|
NUMBER
|
FNBUNTH
|
FNBUNTH_UNIT_MKT_VALUE
|
NO
|
NO
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|