Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE		AGRPAUX	AGRPAUX_ACTIVITY_DATE
AUXILIARY_CLASS_YEAR	Auxiliary Class Year	Class year to which this pledge amount should be credited.	VARCHAR2(4)		AGRPAUX	AGRPAUX_PREF_CLAS
AUXILIARY_COMMENT	Auxiliary Comment	Free format comment field.	CLOB		FUNCTION	GOKODSF.F_TRIM_LONGS
AUXILIARY_DONOR_CATEGORY	Auxiliary Donor Category	Donor category code to which this pledge amount should be credited.	VARCHAR2(4)		AGRPAUX	AGRPAUX_DONR_CODE
AUXILIARY_DONOR_CATEGORY_DESC	Auxiliary Donor Category Description	Pledge donor category description.	VARCHAR2(30)		ATVDONR	ATVDONR_DESC
AUXILIARY_ISSUE_DATE	Auxiliary Issue Date	Date the Pledge Auxiliary data was issued.	DATE		AGRPAUX	AGRPAUX_ISSUE_DATE
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(5)		AGRPAUX	AGRPAUX_AUXL_CODE
AUXILIARY_TYPE_DESC	Auxiliary Type Description	Auxiliary type description.	VARCHAR2(60)		AGRPAUX	AGRPAUX_AUXL_DESC
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(11,2)		AGRPAUX	AGRPAUX_AUXL_AMOUNT
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
ENTITY_UID	Entity UID	Unique identifying number of person making Pledge.	NUMBER(8)		AGRPAUX	AGRPAUX_PIDM
MIF_DESC	MIF Description	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)		NA	NA
PLEDGE_ADJUSTMENT_IND	Pledge Adjustment Indicator	Indicates if adjustments have been made to the pledge amount.	VARCHAR2(1)		CALCULATION	DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)
PLEDGE_NUMBER	Pledge Number	Number of the pledge.	VARCHAR2(7)		AGRPAUX	AGRPAUX_PLEDGE_NO
PLEDGE_VOID_IND	Pledge Void Indicator	Indicates if the pledge has been voided.	VARCHAR2(1)		CALCULATION	DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		AGRPAUX	AGRPAUX_USER
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: