ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACTIVITY_DATE	Date record was inserted or updated			AGRPAUX	AGRPAUX_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.			NA	NA
AUXILIARY_CLASS_YEAR	Class year to which this pledge amount should be credited.			AGRPAUX	AGRPAUX_PREF_CLAS
AUXILIARY_COMMENT	Free format comment field.			FUNCTION	GOKODSF.F_TRIM_LONGS
AUXILIARY_DONOR_CATEGORY	Donor category code to which this pledge amount should be credited.			AGRPAUX	AGRPAUX_DONR_CODE
AUXILIARY_DONOR_CATEGORY_DESC	Pledge donor category description.			ATVDONR	ATVDONR_DESC
AUXILIARY_ISSUE_DATE	Date the Pledge Auxiliary data was issued.			AGRPAUX	AGRPAUX_ISSUE_DATE
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.			AGRPAUX	AGRPAUX_AUXL_CODE
AUXILIARY_TYPE_DESC	Auxiliary type description.			AGRPAUX	AGRPAUX_AUXL_DESC
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.			AGRPAUX	AGRPAUX_AUXL_AMOUNT
ENTITY_IND	Indicates whether entity is a person or an organization.			FUNCTION	F_FORMAT_NAME
ENTITY_UID	Unique identifying number of person making Pledge.			AGRPAUX	AGRPAUX_PIDM
ID	Person's or organization's current identification number.			SPRIDEN	SPRIDEN_ID
MULTI_SOURCE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
MULTI_SOURCE_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
NAME	Name of the person (LFMI) or organization.			FUNCTION	F_FORMAT_NAME
PLEDGE_ADJUSTMENT_IND	Indicates if adjustments have been made to the gift/payment amount.			CALCULATION	DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)
PLEDGE_NUMBER	Number of the pledge.			AGRPAUX	AGRPAUX_PLEDGE_NO
PLEDGE_VOID_IND	Indicates if the gift has been voided.			CALCULATION	DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)
PROCESS_GROUP	The institution value of the process-oriented identifier for the record used to determine access authorization to this record.			NA	NA
USER_ID	Unique identification code of the user who entered or last touched the transaction.			AGRPAUX	AGRPAUX_USER

Ver: 8.3