ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
AMOUNT	Amount of the gift or pledge.			AGRGSOL AGRPSOL	AGRGSOL_AMT AGRPSOL_AMT
AMOUNT_PLEDGE_PAID	Amount paid toward the pledge.			AGRPSOL	AGRPSOL_AMT_PAID
CAMPAIGN	Campaign code associated with the gift or pledge.			AGRGSOL AGRPSOL	AGRGSOL_CAMPAIGN AGRPSOL_CAMPAIGN
CAMPAIGN_NAME	Campaign name.			AFBCAMP	AFBCAMP_NAME
CREDIT_UID	System generated, unique, internal identification number assigned to this person or organization entity.			AGRGSOL AGRPSOL	AGRGSOL_CREDIT_PIDM AGRPSOL_CREDIT_PIDM
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.			AGRGSOL AGRPSOL	AGRGSOL_PIDM AGRPSOL_PIDM
GIFT_NUMBER	Number of the gift.			AGRGSOL	AGRGSOL_GIFT_NO
GIFT_PLEDGE_IND	Indicates whether the solicitation was for a gift or pledge.			CONSTANT	SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P'
ID	Person's or organization's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied for this table/column.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLEDGE_NUMBER	System-assigned pledge number.			AGRGSOL AGRPSOL	AGRGSOL_PLEDGE_NO AGRPSOL_PLEDGE_NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
SOLICITATION_TYPE	Pledge solicitation type code.			AGRGSOL AGRPSOL	AGRGSOL_SOLC_CODE AGRPSOL_SOLC_CODE
SOLICITATION_TYPE_DESC	Solicitation code description.			FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_FIRST_NAME	Solicitor's first name.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_ID	Solicitor's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_LAST_NAME	Solicitor's last name.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_NAME	Name of the solicitor (last name, first name, middle initial) or organization name.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_ORGANIZATION	Solicitor organization code.			AGRGSOL AGRPSOL	AGRGSOL_SOL_ORG AGRPSOL_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.			ASBSORG	ASBSORG_NAME
SOLICITOR_UID	System generated, unique, internal identification number assigned to this solicitor.			AGRGSOL AGRPSOL	AGRGSOL_SOL_PIDM AGRPSOL_SOL_PIDM

Ver: 8.3