Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ALUM_IND		Indicates whether a donor is an alumna/us.	VARCHAR2(1)		ATVDONR	ATVDONR_ALUM_IND
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
DONOR_CATEGORY		Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.	VARCHAR2(4)		APRCATG	APRCATG_DONR_CODE
DONOR_CATEGORY_DESC		Donor description.	VARCHAR2(30)		ATVDONR	ATVDONR_DESC
ENTITY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		APRCATG	APRCATG_PIDM
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
REPORTING_PRIORITY		Priority assigned to a donor category for reporting purposes.	NUMBER(2)		ATVDONR	ATVDONR_RPT_SEQ_IND
SPOUSE_ONLY_IND		Indicates that a spouse is a non-constituent.	VARCHAR2(1)		ATVDONR	ATVDONR_SPOUSE_ONLY_IND
VSE_1		Values that correspond to voluntary support of education reporting categories.	VARCHAR2(1)		ATVDONR	ATVDONR_CFAE_1
VSE_2		Values that correspond to voluntary support of education reporting categories.	VARCHAR2(1)		ATVDONR	ATVDONR_CFAE_2
VSE_DESC_1		This field specifies the description of the Voluntary Support of Education code.	VARCHAR2(35)
VSE_DESC_2		This field specifies the description of the Voluntary Support of Education code.	VARCHAR2(35)		CALCULATION	DECODE(ATVDONR_CFAE_2)
VSE_TYPE_1		Type 1 value for the voluntary support of education reporting category.	VARCHAR2(1)		ATVDONR	ATVDONR_CFAE_1
VSE_TYPE_2		Type 2 value for the voluntary support of education reporting category.	VARCHAR2(1)		ATVDONR	ATVDONR_CFAE_2
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: