Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ANNUAL_DESIGNATION_IND	Indicates whether this designation has annual giving credit.	NUMBER	DESIGNATION_ACCOUNT	0	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
ANNUAL_DESIGNATION_IND_LD	Annual designation indicator long description.	VARCHAR2(255)	DESIGNATION_ACCOUNT	'NO'	NO	NO
ANNUAL_DESIGNATION_IND_SD	Annual designation indicator short description.	VARCHAR2(255)	DESIGNATION_ACCOUNT	'NO'	NO	NO
DESIGNATION_ACCOUNT	Account number that corresponds to the general ledger account number used by the controller's or treasurer's office.	VARCHAR2(63)	DESIGNATION_ACCOUNT	'NOT APPLICABLE'	NO	NO
DESIGNATION_ACCOUNT2	Identifies a second general ledger account number associated with the designation, as applicable.	VARCHAR2(63)				NO
DESIGNATION_CAMPUS	Specifies the campus associated with the designation.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_CAMPUS_LD	Designation campus long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_CAMPUS_SD	Designation campus short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_COLLEGE	Specifies the college or institution structure associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_COLLEGE_LD	Long description for the designation college.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_COLLEGE_SD	Short description for the designation college.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_DEPARTMENT	Department associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DEPT_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_DEPARTMENT_LD	Designation department long description.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_DEPARTMENT_SD	Designation department short description.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_DIVISION	Specifies the division associated with the designation.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_DIVISION_LD	Designation division long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_DIVISION_SD	Designation division short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_FUND_NAME	Fund associated with the designation.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_FUND_NAME_LD	Designation fund long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_FUND_NAME_SD	Designation fund short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_KEY	System generated, unique, internal primary key for a designation.	NUMBER				NO
DESIGNATION_PURPOSE	Specifies the government organization code associated with the designation. This code specifies the purpose for the gifts and grants for this reporting purpose.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_PURPOSE_LD	Long descriptive text for the purpose of the gift.	VARCHAR2(255)	ATVDGRP	ATVDGRP_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_PURPOSE_SD	Short description defined in the cleansing process.	VARCHAR2(255)	ATVDGRP	ATVDGRP_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_SUB_DEPARTMENT	Tracks designation information at the sub-department level. For example, if the selected department is Romance Languages, this field may be used to further categorize the Romance Language (French, Italian, Spanish, etc.).	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_SUB_DEPARTMENT_LD	Designation sub department long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_SUB_DEPARTMENT_SD	Designation sub department short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'DESIGNATION_D1B'	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO

Ver: 9.0