Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date this record was entered or last updated in the system.	DATE	AGRPASC	AGRPASC_ACTIVITY_DATE	NO	NO
ASSOCIATED_ADDRESS_TYPE	The Address Type Code associated with this association.	VARCHAR2(2)	AGRPASC	AGRPASC_ATYP_CODE	NO	NO
ASSOCIATED_ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(30)	STVATYP	STVATYP_DESC	NO	NO
ASSOCIATED_ENTITY_UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER	AGRPASC	AGRPASC_ASSC_PIDM	NO	NO
ASSOCIATION	The type of pledge association related to this entity.	VARCHAR2(5)	AGRPASC	AGRPASC_ASSC_CODE	NO	NO
ASSOCIATION_COMMENT	Comments related to the pledge association.	VARCHAR2(240)	AGRPASC	AGRPASC_COMMENT	NO	NO
ASSOCIATION_DATE	Date the gift was associated to this entity.	DATE	AGRPASC	AGRPASC_ASSC_DATE	NO	NO
ASSOCIATION_DESC	Pledge association description.	VARCHAR2(30)	ATVASSC	ATVASSC_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
ENTITY_UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER	AGRPASC	AGRPASC_PIDM	NO	NO
MIF_DESC	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	NO	NO
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	NO	NO
PLEDGE_NUMBER	Pledge number to which the entity is associated.	VARCHAR2(7)	AGRPASC	AGRPASC_PLEDGE_NO	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	AGRPASC	AGRPASC_USER	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: