Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date this record was entered or last updated in the system.	DATE		AGRPASC	AGRPASC_ACTIVITY_DATE
ASSOCIATED_ADDRESS_TYPE	Associated Address Type	The Address Type Code associated with this association.	VARCHAR2(2)		AGRPASC	AGRPASC_ATYP_CODE
ASSOCIATED_ADDRESS_TYPE_DESC	Associated Address Type Description	Address type description.	VARCHAR2(30)		STVATYP	STVATYP_DESC
ASSOCIATED_ENTITY_UID	Associated Entity UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER(8)		AGRPASC	AGRPASC_ASSC_PIDM
ASSOCIATION	Association	The type of pledge association related to this entity.	VARCHAR2(5)		AGRPASC	AGRPASC_ASSC_CODE
ASSOCIATION_COMMENT	Association Comment	Comments related to the pledge association.	VARCHAR2(240)		AGRPASC	AGRPASC_COMMENT
ASSOCIATION_DATE	Association Date	Date the gift was associated to this entity.	DATE		AGRPASC	AGRPASC_ASSC_DATE
ASSOCIATION_DESC	Association Description	Pledge association description.	VARCHAR2(30)		ATVASSC	ATVASSC_DESC
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	System generated unique internal identification number assigned to this person or organization entity.	NUMBER(8)		AGRPASC	AGRPASC_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_NUMBER	Pledge Number	Pledge number to which the entity is associated.	VARCHAR2(7)		AGRPASC	AGRPASC_PLEDGE_NO
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		AGRPASC	AGRPASC_USER
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: