Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AMOUNT_GIFT	Amount of gifts received from a constituent for a specific designation or campaign.	NUMBER	APRDHIS	APRDHIS_AMT_GIFT	NO	NO
AMOUNT_MATCHING_GIFT	Amount of donor campaign or designation matching gifts.	NUMBER	FUNCTION	F_DESIGNATION_MATCHING_GIFT	NO	NO
AMOUNT_MEMO_CREDIT	Amount of donor campaign or designation memo credit.	NUMBER	FUNCTION	F_DESIGNATION_MEMO_CREDIT	NO	NO
AMOUNT_MULTIPLE_CREDIT	Amount of multiple or hard credit received by the donor.	NUMBER	FUNCTION	AOKODSF.F_DESIGNATION_MULT_CREDIT	NO	NO
AMOUNT_PLEDGED	Amount the constituent pledged to a specific campaign or designation.	NUMBER	APRDHIS	APRDHIS_AMT_PLEDGED	NO	NO
AMOUNT_PLEDGE_PAYMENT	Amount of pledge payments received from the constituent for a specific campaign or designation.	NUMBER	APRDHIS	APRDHIS_AMT_PLEDGED_PAID	NO	NO
DESG_COLLEGE	College code associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
DESG_GROUP	User defined attribute associating designations of similar purpose or function. You can group similar designations together for institutional reporting. For example, designations by campaign objectives.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE	NO	NO
DESG_GROUP_DESC	Designation group description.	VARCHAR2(255)	ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_TYPE	Designation type for a specific pledge or gift designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE	NO	NO
DESG_TYPE_DESC	Designation type description.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC	NO	NO
DESG_VSE	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	Voluntary support of education code description.	VARCHAR2(255)	ATVCFAE	ATVCFAE_DESC	NO	NO
DESIGNATION	Designation associated with the gift.	VARCHAR2(63)	APRDHIS	APRDHIS_DESG	NO	NO
DESIGNATION_GIVING	Total amount given by the constituent by designation.	NUMBER	FUNCTION	F_DESIGNATION_GIVING	NO	NO
DESIGNATION_NAME	Designation description.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME	NO	NO
ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	CONSTANT CONSTANT	'O' 'P'	NO NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRDHIS	APRDHIS_PIDM	NO	NO
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(63)	APRDHIS	APRDHIS_FISC_CODE	NO	NO
FISCAL_YEAR_DESC	Fiscal year code description.	VARCHAR2(255)	ATVFISC	ATVFISC_DESC	NO	NO
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
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2