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	Unique identifying number of person making Pledge.	NUMBER			AGRPAUX	AGRPAUX_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)			SPRIDEN	SPRIDEN_ID	NO	NO
NAME	Name	Name of the person (LFMI) or organization.	VARCHAR2(255)			FUNCTION	F_FORMAT_NAME	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether entity is a person or an organization.	VARCHAR2(1)			FUNCTION	F_FORMAT_NAME	NO	NO
PLEDGE_NUMBER	Pledge Number	Number of the pledge.	VARCHAR2(63)			AGRPAUX	AGRPAUX_PLEDGE_NO	NO	NO
PLEDGE_ADJUSTMENT_IND	Pledge Adjustment Indicator	Indicates if adjustments have been made to the gift/payment amount.	VARCHAR2(1)			CALCULATION	DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)	NO	NO
PLEDGE_VOID_IND	Pledge Void Indicator	Indicates if the gift has been voided.	VARCHAR2(1)			CALCULATION	DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)	NO	NO
AUXILIARY_TYPE	Auxiliary Type	Type of auxiliary information detailed in this record. Examples include specified donor categories or class years, details related to quid pro quo benefits/premiums or the face/market values of the pledge.	VARCHAR2(63)			AGRPAUX	AGRPAUX_AUXL_CODE	NO	NO
AUXILIARY_TYPE_DESC	Auxiliary Type Description	Auxiliary type description.	VARCHAR2(255)			AGRPAUX	AGRPAUX_AUXL_DESC	NO	NO
AUXILIARY_VALUE	Auxiliary Value	Dependant on the corresponding auxiliary code. May include the fair market value of an associated benefit/premium or the present market value of a pledge.	NUMBER			AGRPAUX	AGRPAUX_AUXL_AMOUNT	NO	NO
AUXILIARY_ISSUE_DATE	Auxiliary Issue Date	Date the Pledge Auxiliary data was issued.	DATE			AGRPAUX	AGRPAUX_ISSUE_DATE	NO	NO
AUXILIARY_DONOR_CATEGORY	Auxiliary Donor Category	Donor category code to which this pledge amount should be credited.	VARCHAR2(63)			AGRPAUX	AGRPAUX_DONR_CODE	NO	NO
AUXILIARY_DONOR_CATEGORY_DESC	Auxiliary Donor Category Description	Pledge donor category description.	VARCHAR2(255)			ATVDONR	ATVDONR_DESC	NO	NO
AUXILIARY_CLASS_YEAR	Auxiliary Class Year	Class year to which this pledge amount should be credited.	VARCHAR2(63)			AGRPAUX	AGRPAUX_PREF_CLAS	NO	NO
AUXILIARY_COMMENT	Auxiliary Comment	Free format comment field.	CLOB			FUNCTION	GOKODSF.F_TRIM_LONGS	NO	NO
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)			AGRPAUX	AGRPAUX_USER	NO	NO
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE			AGRPAUX	AGRPAUX_ACTIVITY_DATE	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

Ver: 9.2