Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Specifies the date this record was created or updated.	VARCHAR2(54)
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(123)
CAMPAIGN	Campaign code associated with the gift.	VARCHAR2(39)
CAMPAIGN_NAME	Campaign name.	VARCHAR2(14)
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(26)
CAMPAIGN_TYPE_DESC	Campaign type description.	VARCHAR2(26)
DECEASED_DATE	Date the person died.	VARCHAR2(21)
DECEASED_STATUS	Indicates whether a person is deceased.	VARCHAR2(39)
DESG_ACCOUNT	User defined value representing an account. Accounts are assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(139)
DESG_ACCOUNT_DESC	Designation account code description.	VARCHAR2(37)
DESG_ACCOUNT_INDEX	User-defined value representing a summarization of any combination of chart of accounts information.	VARCHAR2(100)
DESG_ACCOUNT_INDEX_DESC	Designation account index code description.	VARCHAR2(43)
DESG_ACTIVITY	User-defined code attribute that may be used to identify accounting data by activity.	VARCHAR2(85)
DESG_ACTIVITY_DESC	Designation activity code description.	VARCHAR2(38)
DESG_CHART_OF_ACCOUNT	Primary identification code for any chart of accounts that is used to uniquely identify that chart from any other in a multi-chart environment.	VARCHAR2(143)
DESG_CHART_OF_ACCOUNT_DESC	Designation chart of accounts code description.	VARCHAR2(47)
DESG_COLLEGE	College code associated with the designation.	VARCHAR2(45)
DESG_COLLEGE_DESC	College, faculty or school name.	VARCHAR2(32)
DESG_DEPARTMENT	Department associated with the designation.	VARCHAR2(43)
DESG_DEPARTMENT_DESC	Name of the department.	VARCHAR2(23)
DESG_FUND	Unique fiscal entity code.	VARCHAR2(26)
DESG_FUND_DESC	Designation fund code description.	VARCHAR2(34)
DESG_GENERAL_LEDGER_NUMBER	General ledger credit account number associated with the designation.	VARCHAR2(69)
DESG_GROUP	User defined attribute for associating designations of similar purpose or function.	VARCHAR2(83)
DESG_GROUP_DESC	Description of the designation group.	VARCHAR2(37)
DESG_LOCATION	Physical location of the institution's financial manager. For example, vice president, finance, suite 10, Adams Hall, main campus.	VARCHAR2(130)
DESG_LOCATION_DESC	Designation location code description.	VARCHAR2(38)
DESG_ORGANIZATION	Individual organization code that appears on a transaction.	VARCHAR2(59)
DESG_ORGANIZATION_DESC	Designation organization code description.	VARCHAR2(42)
DESG_PROGRAM	User-defined value to the program classification structure code, or a subset of that structure, as defined by the national council of higher education management systems.	VARCHAR2(170)
DESG_PROGRAM_DESC	Designation program code description.	VARCHAR2(37)
DESG_STATUS	The current status of the designation.	VARCHAR2(38)
DESG_STATUS_DESC	Description of the designation status.	VARCHAR2(38)
DESG_TYPE	Designation type for a specific pledge or gift designation.	VARCHAR2(59)
DESG_TYPE_DESC	Designation type description.	VARCHAR2(29)
DESG_VSE	Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting.	VARCHAR2(132)
DESG_VSE_DESC	Voluntary support of education code description.	VARCHAR2(48)
DESIGNATION	Designation associated with the gift.	VARCHAR2(37)
DESIGNATION_NAME	Designation description.	VARCHAR2(24)
ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(60)
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	VARCHAR2(104)
ENTRY_DATE	Date the transaction was entered on the account.	VARCHAR2(48)
FINANCE_FEED_IND	Indicates if the gift /payment has been fed to the finance system.	VARCHAR2(66)
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(46)
FISCAL_YEAR_DESC	Description of the fiscal year code.	VARCHAR2(36)
GIFT_ACKNOWLEDGED_IND	Indicates if a gift acknowledgement was generated by the system.	VARCHAR2(64)
GIFT_ADJUSTMENT_IND	Indicates if adjustments have been made to this gift amount.	VARCHAR2(60)
GIFT_AMOUNT	Gift designation amount.	VARCHAR2(24)
GIFT_ASSOCIATED_ENTITY_COUNT	Count of entities associated with this gift/payment.	VARCHAR2(52)
GIFT_AUXILIARY_COUNT	Count of auxiliary gift records associated with this gift/payment.	VARCHAR2(66)
GIFT_CLASS	First classification of the gift/payment - anonymous, memorial, etc.	VARCHAR2(68)
GIFT_CLASS2	Second classification of the gift/payment - anonymous, memorial, etc	VARCHAR2(68)
GIFT_CLASS3	Third classification of the gift/payment - anonymous, memorial, etc	VARCHAR2(67)
GIFT_CLASS_DESC	Description of the first gift/payment classification.	VARCHAR2(53)
GIFT_CLASS_DESC2	Description of the second gift class.	VARCHAR2(37)
GIFT_CLASS_DESC3	Description of the third gift class.	VARCHAR2(36)
GIFT_COMMENT	Comment related to the gift.	VARCHAR2(28)
GIFT_CREDIT_AMOUNT	Amount of the gift/payment designation credited to the primary donor or received by a multi-credit recipient donor.	VARCHAR2(115)
GIFT_DATE	Date a gift is received. Date defaults to the system date if no date is entered.	VARCHAR2(80)
GIFT_DEBIT_ACCOUNT_NUMBER	Additional debit account number.	VARCHAR2(32)
GIFT_NUMBER	Number of the gift.	VARCHAR2(19)
GIFT_RANGE	Gift range classification associated with the total gift/payment amount.	VARCHAR2(72)
GIFT_RANGE_DESC	Description of the gift range.	VARCHAR2(30)
GIFT_RULE_CLASS	Rule class code.	VARCHAR2(16)
GIFT_RULE_CLASS_DESC	Unique title assigned to a rule class.	VARCHAR2(38)
GIFT_TYPE	Type of gift or method of payment, i.e., check, credit card, bequest, property.	VARCHAR2(79)
GIFT_TYPE_DESC	Description of the gift/payment type.	VARCHAR2(37)
GIFT_VEHICLE	Pledge gift vehicle code associated with this gift.	VARCHAR2(51)
GIFT_VEHICLE_DESC	Pledge gift vehicle code description.	VARCHAR2(37)
GIFT_VSE	Gift voluntary support of education category.	VARCHAR2(45)
GIFT_VSE_DESC	Voluntary support of education code description.	VARCHAR2(48)
ID	Person's or organization's current identification number.	VARCHAR2(57)
MATCHING_GIFT_COUNT	Count of all expected or paid matching gifts associated to this gift/payment. Inactive match gifts are excluded from this count.	VARCHAR2(128)
MATCHING_GIFT_IND	Indicates if one or more expected or paid matching gifts are associated with this gift/payment. Inactive match gifts are excluded.	VARCHAR2(130)
MATCHING_GIFT_PAYMENT_IND	Indicates if this gift was applied as matching gift payment(s).	VARCHAR2(63)
MATCH_GIFT_FORM_RECEIVED_IND	Indicates if at least one matching gift form has been received for any associated matching gifts.	VARCHAR2(97)
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(103)
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(94)
NAME	Name of the person (LFMI) or organization.	VARCHAR2(42)
PLEDGE_NUMBER	Number of the pledge.	VARCHAR2(21)
POSTING_DATE	Gift feed date is the date the gift was fed to finance.	VARCHAR2(55)
POST_BATCH_ID	Gift feed document code.	VARCHAR2(24)
POST_CASHIER	User name.	VARCHAR2(10)
POST_CASHIER_SESSION_NUMBER	Cashier session number under which this gift was posted.	VARCHAR2(56)
PREFER_CLASS_YEAR	Year in which the constituent received the first degree or the year of expected graduation if the first degree has not yet been earned.	VARCHAR2(135)
PREFER_CLASS_YEAR_DESC	Constituent's preferred class description.	VARCHAR2(42)
PREFER_COLLEGE	College within the institution with which the constituent prefers to be associated.	VARCHAR2(83)
PREFER_COLLEGE_DESC	College, faculty or school name.	VARCHAR2(32)
PRIMARY_DONOR_CATEGORY	Primary donor category associated with this donor.	VARCHAR2(50)
PRIMARY_DONOR_CATEGORY_DESC	Description of the primary donor category.	VARCHAR2(42)
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(118)
RECEIPT_DATE	Date receipt was generated by the system.	VARCHAR2(41)
RECEIPT_REQUIRED_IND	Indicates if a receipt is required for this gift/payment.	VARCHAR2(57)
RESTRICTED_IND	Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.	VARCHAR2(104)
SOLICITATION_COUNT	Count of all solicitations associated with the gift/payment transaction.	VARCHAR2(72)
SOLICITATION_TYPE	Type of solicitation for the highest solicitation amount associated with this gift/payment campaign designation amount.	VARCHAR2(119)
SOLICITATION_TYPE_DESC	Description of the pledge/gift solicitation type.	VARCHAR2(49)
SOLICITOR_FIRST_NAME	Solicitor's current first name.	VARCHAR2(31)
SOLICITOR_ID	Current identification number of the solicitor for the highest solicitation amount associated with this gift/payment campaign designation amount.	VARCHAR2(145)
SOLICITOR_LAST_NAME	Solicitor's current last name.	VARCHAR2(30)
SOLICITOR_ORG	Solicitor organization for the highest solicitation amount associated with this gift/payment campaign designation amount.	VARCHAR2(121)
SOLICITOR_UID	System generated unique internal identification number assigned to the solicitor for the highest solicitation amount associated with this gift/payment campaign designation amount.	VARCHAR2(179)

Ver: 8.5