Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
AMOUNT		Amount of the gift or pledge.	NUMBER(11, 2)		AGRGSOL AGRPSOL	AGRGSOL_AMT AGRPSOL_AMT
AMOUNT_PLEDGE_PAID		Amount paid toward the pledge.	NUMBER		AGRPSOL	AGRPSOL_AMT_PAID
CAMPAIGN		Campaign code associated with the gift or pledge.	VARCHAR2(5)		AGRGSOL AGRPSOL	AGRGSOL_CAMPAIGN AGRPSOL_CAMPAIGN
CREDIT_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		AGRGSOL AGRPSOL	AGRGSOL_CREDIT_PIDM AGRPSOL_CREDIT_PIDM
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENTITY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		AGRGSOL AGRPSOL	AGRGSOL_PIDM AGRPSOL_PIDM
GIFT_NUMBER		Number of the gift.	VARCHAR2(7)		AGRGSOL	AGRGSOL_GIFT_NO
GIFT_PLEDGE_IND		Indicates whether the solicitation was for a gift or pledge.	VARCHAR2(1)		CONSTANT	SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P'
MIF_DESC		Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PLEDGE_NUMBER		System-assigned pledge number.	VARCHAR2(7)		AGRGSOL AGRPSOL	AGRGSOL_PLEDGE_NO AGRPSOL_PLEDGE_NO
SOLICITATION_TYPE		Pledge solicitation type code.	VARCHAR2(15)		AGRGSOL AGRPSOL	AGRGSOL_SOLC_CODE AGRPSOL_SOLC_CODE
SOLICITATION_TYPE_DESC		Solicitation code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_ORGANIZATION		Solicitor organization code.	VARCHAR2(5)		AGRGSOL AGRPSOL	AGRGSOL_SOL_ORG AGRPSOL_SOL_ORG
SOLICITOR_ORGANIZATION_NAME		Solicitor organization name.	VARCHAR2(30)		ASBSORG	ASBSORG_NAME
SOLICITOR_UID		System generated, unique, internal identification number assigned to the person.	NUMBER(8)		AGRGSOL AGRPSOL	AGRGSOL_SOL_PIDM AGRPSOL_SOL_PIDM
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: