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			AGRGDES AGRGMLT	AGRGDES_PIDM AGRGMLT_XREF_PIDM	NO NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			SPRIDEN	SPRIDEN_ID	NO	NO
NAME	Name	Name of the person (LFMI) or organization.	VARCHAR2(255)			FUNCTION SPRIDEN	F_FORMAT_NAME SPRIDEN_LAST_NAME	NO NO	NO
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)			CONSTANT CONSTANT	'O' 'P'	NO NO	NO
DECEASED_STATUS	Deceased Status	Indicates whether a person is deceased.	VARCHAR2(1)			SPBPERS	SPBPERS_DEAD_IND	NO	NO
DECEASED_DATE	Deceased Date	Date the person died.	DATE			SPBPERS	SPBPERS_DEAD_DATE	NO	NO
GIFT_NUMBER	Gift Number	Number of the gift.	VARCHAR2(63)			AGRGDES AGRGMLT	AGRGDES_GIFT_NO AGRGMLT_GIFT_NO	NO NO	NO
PLEDGE_NUMBER	Pledge Number	Number of the pledge.	VARCHAR2(63)			AGRGDES	AGRGDES_PLEDGE_NO	NO	NO
CAMPAIGN	Campaign	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)			AGRGDES AGRGMLT	AGRGDES_CAMPAIGN AGRGMLT_CAMPAIGN	NO NO	NO
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)			AFBCAMP	AFBCAMP_NAME	NO	NO
DESIGNATION	Designation	Designation associated with the gift.	VARCHAR2(63)			AGRGDES AGRGMLT	AGRGDES_DESG AGRGMLT_DESG	NO NO	NO
DESIGNATION_NAME	Designation Name	Designation description.	VARCHAR2(255)			ADBDESG	ADBDESG_NAME	NO	NO
RESTRICTED_IND	Restricted Indicator	Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.	VARCHAR2(1)			ADBDESG	ADBDESG_RESTR_IND	NO	NO
GIFT_AMOUNT	Gift Amount	Gift designation amount.	NUMBER			AGRGDES	AGRGDES_AMT	NO	NO
GIFT_CREDIT_AMOUNT	Gift Credit Amount	Amount of the gift/payment designation credited to the primary donor or received by a multi-credit recipient donor.	NUMBER			CALCULATION	AGRGDES_AMT-F_GIFT_HARD_CREDIT	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 this gift amount.	VARCHAR2(1)			AGBGIFT	AGBGIFT_ADJ_IND	NO	NO
FISCAL_YEAR	Fiscal Year	Unique identifier or 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 class.	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 class.	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	Pledge gift vehicle code description.	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 this gift 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 transaction was entered on the account.	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	Voluntary support of education code description.	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
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)			AFBCAMP	AFBCAMP_CMTP_CODE	NO	NO
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)			ATVCMTP	ATVCMTP_DESC	NO	NO
DESG_TYPE	Desg Type	Designation type for a specific pledge or gift designation.	VARCHAR2(63)			ADBDESG	ADBDESG_DSTP_CODE	NO	NO
DESG_TYPE_DESC	Desg Type Description	Designation type description.	VARCHAR2(255)			ATVDSTP	ATVDSTP_DESC	NO	NO
DESG_GROUP	Desg Group	User defined attribute for associating designations of similar purpose or function.	VARCHAR2(63)			ADBDESG	ADBDESG_DGRP_CODE	NO	NO
DESG_GROUP_DESC	Desg Group Description	Description of the designation group.	VARCHAR2(255)			ATVDGRP	ATVDGRP_DESC	NO	NO
DESG_COLLEGE	Desg College	College code associated with the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_COLLEGE_DESC	Desg College Description	College, faculty or school name.	VARCHAR2(255)			STVCOLL	STVCOLL_DESC	NO	NO
DESG_DEPARTMENT	Desg Department	Department associated with the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_DEPT_CODE	NO	NO
DESG_DEPARTMENT_DESC	Desg Department Description	Name of the department.	VARCHAR2(255)			STVDEPT	STVDEPT_DESC	NO	NO
DESG_VSE	Desg VSE - Voluntary Support of Education	Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting.	VARCHAR2(63)			ADBDESG	ADBDESG_CFAE_CODE	NO	NO
DESG_VSE_DESC	Desg VSE - Voluntary Support of Education Description	Voluntary support of education code description.	VARCHAR2(255)			ATVCFAE	ATVCFAE_DESC	NO	NO
DESG_STATUS	Desg Status	The current status of the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_DSTA_CODE	NO	NO
DESG_STATUS_DESC	Desg Status Description	Description of the designation status.	VARCHAR2(255)			ATVDSTA	ATVDSTA_DESC	NO	NO
SOLICITATION_TYPE	Solicitation Type	Type of solicitation for the highest solicitation amount associated with this gift/payment campaign designation amount.	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 campaign designation amount.	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 campaign designation amount.	VARCHAR2(63)			SPRIDEN	SPRIDEN_ID	NO	NO
SOLICITOR_LAST_NAME	Solicitor Last Name	Solicitor's current last name.	VARCHAR2(63)			SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
SOLICITOR_FIRST_NAME	Solicitor First Name	Solicitor's current first name.	VARCHAR2(63)			SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
SOLICITOR_ORG	Solicitor Organization	Solicitor organization for the highest solicitation amount associated with this gift/payment campaign designation amount.	VARCHAR2(63)			AGRGSOL	AGRGSOL_SOL_ORG	NO	NO
SOLICITATION_COUNT	Solicitation Count	Count of all solicitations associated with the 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	Constituent's preferred class description.	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	College, faculty or school name.	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
DESG_GENERAL_LEDGER_NUMBER	Designation General Ledger Number	General ledger credit account number associated with the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_GL_NO_CREDIT	NO	NO
DESG_CHART_OF_ACCOUNT	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(63)			ADBDESG	ADBDESG_COAS_CODE	NO	NO
DESG_CHART_OF_ACCOUNT_DESC	Desg Chart Of Account Description	Designation chart of accounts code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_ACCOUNT_INDEX	Desg Account INDEX	User-defined value representing a summarization of any combination of chart of accounts information.	VARCHAR2(63)			ADBDESG	ADBDESG_ACCI_CODE	NO	NO
DESG_ACCOUNT_INDEX_DESC	Desg Account INDEX Description	Designation account index code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_FUND	Desg Fund	Unique fiscal entity code.	VARCHAR2(63)			ADBDESG	ADBDESG_FUND_CODE	NO	NO
DESG_FUND_DESC	Desg Fund Description	Designation fund code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_ORGANIZATION	Desg Organization	Individual organization code that appears on a transaction.	VARCHAR2(63)			ADBDESG	ADBDESG_ORGN_CODE	NO	NO
DESG_ORGANIZATION_DESC	Desg Organization Description	Designation organization code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_ACCOUNT	Desg Account	User defined value representing an account. Accounts are assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(63)			ADBDESG	ADBDESG_ACCT_CODE	NO	NO
DESG_ACCOUNT_DESC	Desg Account Description	Designation account code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_PROGRAM	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(63)			ADBDESG	ADBDESG_PROG_CODE	NO	NO
DESG_PROGRAM_DESC	Desg Program Description	Designation program code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_ACTIVITY	Desg Activity	User-defined code attribute that may be used to identify accounting data by activity.	VARCHAR2(63)			ADBDESG	ADBDESG_ACTV_CODE	NO	NO
DESG_ACTIVITY_DESC	Desg Activity Description	Designation activity code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_LOCATION	Desg Location	Physical location of the institution's financial manager. For example, vice president, finance, suite 10, Adams Hall, main campus.	VARCHAR2(63)			ADBDESG	ADBDESG_LOCN_CODE	NO	NO
DESG_LOCATION_DESC	Desg Location Description	Designation location code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	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			AGRGDES	AGRGDES_ACTIVITY_DATE	NO	NO

Ver: 9.2