Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER			AGBGIFT	AGBGIFT_PIDM	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether entity is a person or an organization.	VARCHAR2(1)			CONSTANT CONSTANT	'O' 'P'	NO NO	NO
DECEASED_STATUS	Deceased Status	Indicates whether or not a person is deceased.	VARCHAR2(1)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
DECEASED_DATE	Deceased Date	Date the person died.	DATE			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
GIFT_NUMBER	Gift Number	Number of the gift.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
GIFT_TRANSACTION_AMOUNT	Gift Transaction Amount	Total transaction amount of the individual gift/payment received.	NUMBER			AGBGIFT	AGBGIFT_AMT_TOT	NO	NO
GIFT_DATE	Gift Date	Date a gift is received. Date defaults to the system date if no date is entered.	DATE			AGBGIFT	AGBGIFT_GIFT_DATE	NO	NO
GIFT_ADJUSTMENT_IND	Gift Adjustment Indicator	Indicates if adjustments have been made to the original gift/payment transaction amount.	VARCHAR2(1)			AGBGIFT	AGBGIFT_ADJ_IND	NO	NO
FISCAL_YEAR	Fiscal Year	Code for the fiscal year.	VARCHAR2(63)			AGBGIFT	AGBGIFT_FISC_CODE	NO	NO
FISCAL_YEAR_DESC	Fiscal Year Description	Description of the fiscal year code.	VARCHAR2(255)			ATVFISC	ATVFISC_DESC	NO	NO
GIFT_TYPE	Gift Type	Gift vehicle for example in honor of, In memory of, anonymous.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GIFT_CODE	NO	NO
GIFT_TYPE_DESC	Gift Type Description	Description of the gift/payment type.	VARCHAR2(255)			AGBGIFT	AGBGIFT_GIFT_DESC	NO	NO
GIFT_CLASS	Gift Class	First classification of the gift/payment - anonymous, memorial, etc.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GCLS_CODE	NO	NO
GIFT_CLASS_DESC	Gift Class Description	Description of the first gift/payment classification.	VARCHAR2(255)			ATVGCLS	ATVGCLS_DESC	NO	NO
GIFT_CLASS2	Gift Class 2	Second classification of the gift/payment - anonymous, memorial, etc.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GCLS_CODE_2	NO	NO
GIFT_CLASS_DESC2	Gift Class Description 2	Description of the second gift/payment classification.	VARCHAR2(255)			ATVGCLS	ATVGCLS_DESC	NO	NO
GIFT_CLASS3	Gift Class 3	Third classification of the gift/payment - anonymous, memorial, etc.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GCLS_CODE_3	NO	NO
GIFT_CLASS_DESC3	Gift Class Description 3	Description of the third gift/payment classification.	VARCHAR2(255)			ATVGCLS	ATVGCLS_DESC	NO	NO
GIFT_VEHICLE	Gift Vehicle	Pledge gift vehicle code associated with this gift.	VARCHAR2(63)			AGBGIFT	AGBGIFT_PGVE_CODE	NO	NO
GIFT_VEHICLE_DESC	Gift Vehicle Description	Description of the pledge gift vehicle code.	VARCHAR2(255)			ATVPGVE	ATVPGVE_DESC	NO	NO
MATCHING_GIFT_IND	Matching Gift Indicator	Indicates if one or more expected or paid matching gifts are associated with this gift/payment. Inactive match gifts are excluded.	VARCHAR2(1)			FUNCTION	AOKODSF.F_MATCH_GIFT	NO	NO
MATCHING_GIFT_PAYMENT_IND	Matching Gift Payment Indicator	Indicates if this gift was applied as matching gift payment(s).	VARCHAR2(1)			FUNCTION	AOKODSF.F_MATCH_GIFT_PAY	NO	NO
MATCH_GIFT_FORM_RECEIVED_IND	Match Gift Form Received Indicator	Indicates if at least one matching gift form has been received for any associated matching gifts.	VARCHAR2(1)			AGBGIFT	AGBGIFT_MATCH_RECEIVED	NO	NO
MATCHING_GIFT_COUNT	Matching Gift Count	Count of all expected or paid matching gifts associated to this gift/payment. Inactive match gifts are excluded from this count.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_MATCH_GIFT	NO	NO
POSTING_DATE	Posting Date	Gift feed date is the date the gift was fed to finance.	DATE			AGBGIFT	AGBGIFT_FEED_DATE	NO	NO
POST_BATCH_ID	Post Batch ID	Gift feed document code.	VARCHAR2(63)			AGBGIFT	AGBGIFT_FEED_DOC_CODE	NO	NO
POST_CASHIER	Post Cashier	User name.	VARCHAR2(255)			AGBGIFT	AGBGIFT_USER	NO	NO
POST_CASHIER_SESSION_NUMBER	Post Cashier Session Number	Cashier session number under which the gift/payment was posted.	NUMBER			FUNCTION	AOKODSF.F_GET_SESSION_NUMBER	NO	NO
FINANCE_FEED_IND	Finance Feed Indicator	Indicates if the gift /payment has been fed to the finance system.	VARCHAR2(1)			AGBGIFT	AGBGIFT_FEED_IND	NO	NO
ENTRY_DATE	Entry Date	Date the gift is entered.	DATE			AGBGIFT	AGBGIFT_ENTRY_DATE	NO	NO
RECEIPT_REQUIRED_IND	Receipt Required Indicator	Indicates if a receipt is required for this gift/payment.	VARCHAR2(1)			AGBGIFT	AGBGIFT_RECEIPT_IND	NO	NO
RECEIPT_DATE	Receipt Date	Date receipt was generated by the system.	DATE			AGBGIFT	AGBGIFT_RECEIPT_DATE	NO	NO
GIFT_ACKNOWLEDGED_IND	Gift Acknowledged Indicator	Indicates if a gift acknowledgement was generated by the system.	VARCHAR2(1)			AGBGIFT	AGBGIFT_GACK_IND	NO	NO
GIFT_RANGE	Gift Range	Gift range classification associated with the total gift/payment amount.	VARCHAR2(63)			AGBGIFT	AGBGIFT_GACK_CODE	NO	NO
GIFT_RANGE_DESC	Gift Range Description	Description of the gift range.	VARCHAR2(255)			ATVGACK	ATVGACK_DESC	NO	NO
GIFT_DEBIT_ACCOUNT_NUMBER	Gift Debit Account Number	Additional debit account number.	VARCHAR2(63)			ATVGIFT	ATVGIFT_DB_GL_ACCT	NO	NO
GIFT_RULE_CLASS	Gift Rule Class	Rule class code.	VARCHAR2(63)			ATVGIFT	ATVGIFT_RUCL_CODE	NO	NO
GIFT_RULE_CLASS_DESC	Gift Rule Class Description	Unique title assigned to a rule class.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_VSE	Gift VSE - Voluntary Support of Education	Gift voluntary support of education category.	VARCHAR2(63)			ATVGIFT	ATVGIFT_CFAE_GIFT_CATG	NO	NO
GIFT_VSE_DESC	Gift VSE - Voluntary Support of Education Description	Description of the voluntary support of education code.	VARCHAR2(255)			CALCULATION	DECODE(ATVGIFT_CFAE_GIFT_CATG)	NO	NO
GIFT_COMMENT	Gift Comment	Comment related to the gift.	VARCHAR2(400)			AGBGIFT	AGBGIFT_COMMENT	NO	NO
SOLICITATION_TYPE	Solicitation Type	Type of solicitation for the highest solicitation amount associated with this gift/payment transaction.	VARCHAR2(63)			AGRGSOL	AGRGSOL_SOLC_CODE	NO	NO
SOLICITATION_TYPE_DESC	Solicitation Type Description	Description of the pledge/gift solicitation type.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITOR_UID	Solicitor UID	System generated unique internal identification number assigned to the solicitor for the highest solicitation amount associated with this gift/payment transaction.	NUMBER			AGRGSOL	AGRGSOL_SOL_PIDM	NO	NO
SOLICITOR_ID	Solicitor ID	Current identification number of the solicitor for the highest solicitation amount associated with this gift/payment transaction.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_LAST_NAME	Solicitor Last Name	Solicitor's current last name.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_FIRST_NAME	Solicitor First Name	Solicitor's current first name.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_ORG	Solicitor Organization	Solicitor organization for the highest solicitation amount associated with this gift/payment transaction.	VARCHAR2(63)			AGRGSOL	AGRGSOL_SOL_ORG	NO	NO
SOLICITOR_COUNT	Solicitor Count	Count of all solicitations associated with this gift/payment transaction.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_GIFT_SOLICITOR	NO	NO
PRIMARY_DONOR_CATEGORY	Primary Donor Category	Primary donor category associated with this donor.	VARCHAR2(63)			APRCATG	APRCATG_DONR_CODE	NO	NO
PRIMARY_DONOR_CATEGORY_DESC	Primary Donor Category Description	Description of the primary donor category.	VARCHAR2(255)			ATVDONR	ATVDONR_DESC	NO	NO
PREFER_CLASS_YEAR	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(63)			APBCONS	APBCONS_PREF_CLAS	NO	NO
PREFER_CLASS_YEAR_DESC	Prefer Class Year Description	Description of the preferred class of the constituent.	VARCHAR2(255)			NA	NA	NO	NO
PREFER_COLLEGE	Prefer College	College within the institution with which the constituent prefers to be associated.	VARCHAR2(63)			APBCONS	APBCONS_COLL_CODE_PREF	NO	NO
PREFER_COLLEGE_DESC	Prefer College Description	Name of the college, faculty or school.	VARCHAR2(255)			STVCOLL	STVCOLL_DESC	NO	NO
GIFT_AUXILIARY_COUNT	Gift Auxiliary Count	Count of auxiliary gift records associated with this gift/payment.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_GIFT_AUXILIARY	NO	NO
GIFT_ASSOCIATED_ENTITY_COUNT	Gift Associated Entity Count	Count of entities associated with this gift/payment.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_GIFT_ASSOCIATED_ENTITY	NO	NO
MULTI_SOURCE	Multi Source	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	The institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ACTIVITY_DATE	Activity Date	Specifies the date this record was created or updated.	DATE			AGBGIFT	AGBGIFT_ACTIVITY_DATE	NO	NO

Ver: 9.2