Target Column	Business Definition	Database Data Type	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	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	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: