Dimension Table Target: WDT_DESIGNATION

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Advancement Gift Star Analyze Fundraising Star Assignment Star Designation Attribute Star Gift Star Manage Prospect Pipeline B Star Matching Claim Star Pledge Star Proposal Purpose Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_DESIGNATION_DETAIL

Description Designation detail dimension table provides information about a designation, including name, type, status and purpose. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

ATHLETICS_DESIGNATION_IND Indicates whether this designation is for some type of athletics funding. NUMBER
CONSTANT

0

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

ATHLETICS_DESIGNATION_IND_LD Athletics designation indicator long description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

ATHLETICS_DESIGNATION_IND_SD Athletics designation indicator short description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

CAE_MATCH_GIFT_PURPOSE Designation purpose matching gift Voluntary Support of Education. VARCHAR2(63)
ATVCFAE

ATVCFAE_MG_PURPOSE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_MATCH_GIFT_PURPOSE_LD Designation purpose matching gift Voluntary Support of Education purpose short description. VARCHAR2(255)
EXPRESSION

CAE_MATCH_GIFT_PURPOSE_LD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_MATCH_GIFT_PURPOSE_SD Designation purpose matching gift Voluntary Support of Education purpose long description. VARCHAR2(255)
EXPRESSION

CAE_MATCH_GIFT_PURPOSE_SD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_PURPOSE Designation purpose for giving as defined for Council for Aid to Education Voluntary Support of Education (VSE) reporting. VARCHAR2(63)
ADBDESG

ADBDESG_CFAE_CODE

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_PURPOSE_LD Designation purpose Voluntary Support of Education long description. VARCHAR2(255)
ATVCFAE

ATVCFAE_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_PURPOSE_SD Designation purpose Voluntary Support of Education short description. VARCHAR2(255)
ATVCFAE

ATVCFAE_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_REPORT_LINE Predefined number representing the specific line of the VSE report where gifts to this designation will appear. Each number corresponds to a specific CAE Purpose. VARCHAR2(63)
EXPRESSION

CAE_REPORT_LINE_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_REPORT_LINE_LD CAE Purpose for the Report Line number long description. VARCHAR2(255)
EXPRESSION

CAE_REPORT_LINE_LD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

CAE_REPORT_LINE_SD CAE Purpose for the Report Line number short description. VARCHAR2(255)
EXPRESSION

CAE_REPORT_LINE_SD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION Designation. VARCHAR2(63)
ADBDESG

ADBDESG_DESG

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_ACTIVE_IND Indicates whether the designation is active. NUMBER
EXPRESSION

DESIGNATION_ACTIVE_IND_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_ACTIVE_IND_LD Designation active indicator long description. VARCHAR2(255)
EXPRESSION

DESIGNATION_ACTIVE_IND_LD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_ACTIVE_IND_SD Designation active indicator short description. VARCHAR2(255)
EXPRESSION

DESIGNATION_ACTIVE_IND_SD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_AGENCY An area or agency associated with the designation. VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

DESIGNATION_AGENCY_LD Designation agency long description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

DESIGNATION_AGENCY_SD Designation agency short description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

DESIGNATION_DETAIL_KEY NUMBER NO

DESIGNATION_FEE_REQUIRED Indicates whether a fee applies to this designation (Y or N) or optionally the type of fee, as applicable. Note, a blank space in Advance = N in EDW. VARCHAR2(63) NO

DESIGNATION_FEE_REQUIRED_LD Designation fee required long description. VARCHAR2(255) NO

DESIGNATION_FEE_REQUIRED_SD Designation fee required short description. VARCHAR2(255) NO

DESIGNATION_FINAID_FUND_IND Indicates whether one or more financial aid funds exist for the designation. NUMBER
EXPRESSION

DESIGNATION_FINAID_FUND_IND_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_FINAID_FUND_IND_LD Designation financial aid fund indicator long description. VARCHAR2(255)
EXPRESSION

DESIGNATION_FINAID_FUND_IND_LD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_FINAID_FUND_IND_SD Designation financial aid fund indicator short description. VARCHAR2(255)
EXPRESSION

DESIGNATION_FINAID_FUND_IND_SD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_FULL_DESC Additional space to further describe the designation. VARCHAR2(255) NO

DESIGNATION_LD Designation long description. VARCHAR2(255)
ADBDESG

ADBDESG_NAME

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_RESTRICTED_IND Indicates whether there is any type of restriction associated with the designation. NUMBER
EXPRESSION

DESIGNATION_RESTRICTED_IND_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_RESTRICTED_IND_LD Designation restricted indicator long description. VARCHAR2(255)
EXPRESSION

DESIGNATION_RESTRICTED_IND_LD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_RESTRICTED_IND_SD Designation restricted indicator short description. VARCHAR2(255)
EXPRESSION

DESIGNATION_RESTRICTED_IND_SD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_RESTRICTION Indicates the type of restriction associated with the designation. VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

DESIGNATION_RESTRICTION_LD Designation restriction long description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

DESIGNATION_RESTRICTION_SD Designation restriction short description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

DESIGNATION_SD Designation short description. VARCHAR2(255)
ADBDESG

ADBDESG_NAME

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_SORT Designation sort can be used to enter a coding sequence for reporting purposes. For example, if the designation code value is numeric, this field could be used to indicate the alpha sequence for certain reports. VARCHAR2(255)
ADBDESG

ADBDESG_DSTP_CODE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_STATUS User defined designation status. VARCHAR2(63)
ADBDESG

ADBDESG_DSTA_CODE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_STATUS_LD Designation status long description. VARCHAR2(255)
ATVDSTA

ATVDSTA_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_STATUS_SD Designation status short description. VARCHAR2(255)
ATVDSTA

ATVDSTA_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_TYPE Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing. VARCHAR2(63)
ADBDESG

ADBDESG_DSTP_CODE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_TYPE_LD Designation type long description. VARCHAR2(255)
ATVDSTP

ATVDSTP_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_TYPE_SD Designation type short description. VARCHAR2(255)
ATVDSTP

ATVDSTP_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

DESIGNATION_USER_GROUP User group associated with this designation. VARCHAR2(63) NO

DESIGNATION_USER_GROUP_LD Designation user group long description. VARCHAR2(255) NO

DESIGNATION_USER_GROUP_SD Designation user group short description. VARCHAR2(255) NO

EXTRAMURAL_ATHLETICS_IND Indicates whether transactions with this designation code should be included in the CAE report for the section dealing with extra mural athletics. NUMBER
CONSTANT

0

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE

EXTRAMURAL_ATHLETICS_IND_LD Extramural athletics indicator long description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

EXTRAMURAL_ATHLETICS_IND_SD Extramural athletics indicator short description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)
SYSTEM_LOAD_PROCESS

'DESIGNATION_DETAIL_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

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ATHLETICS_DESIGNATION_IND	Indicates whether this designation is for some type of athletics funding.	NUMBER	CONSTANT	0	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
ATHLETICS_DESIGNATION_IND_LD	Athletics designation indicator long description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
ATHLETICS_DESIGNATION_IND_SD	Athletics designation indicator short description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
CAE_MATCH_GIFT_PURPOSE	Designation purpose matching gift Voluntary Support of Education.	VARCHAR2(63)	ATVCFAE	ATVCFAE_MG_PURPOSE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_MATCH_GIFT_PURPOSE_LD	Designation purpose matching gift Voluntary Support of Education purpose short description.	VARCHAR2(255)	EXPRESSION	CAE_MATCH_GIFT_PURPOSE_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_MATCH_GIFT_PURPOSE_SD	Designation purpose matching gift Voluntary Support of Education purpose long description.	VARCHAR2(255)	EXPRESSION	CAE_MATCH_GIFT_PURPOSE_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_PURPOSE	Designation purpose for giving as defined for Council for Aid to Education Voluntary Support of Education (VSE) reporting.	VARCHAR2(63)	ADBDESG	ADBDESG_CFAE_CODE	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_PURPOSE_LD	Designation purpose Voluntary Support of Education long description.	VARCHAR2(255)	ATVCFAE	ATVCFAE_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_PURPOSE_SD	Designation purpose Voluntary Support of Education short description.	VARCHAR2(255)	ATVCFAE	ATVCFAE_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_REPORT_LINE	Predefined number representing the specific line of the VSE report where gifts to this designation will appear. Each number corresponds to a specific CAE Purpose.	VARCHAR2(63)	EXPRESSION	CAE_REPORT_LINE_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_REPORT_LINE_LD	CAE Purpose for the Report Line number long description.	VARCHAR2(255)	EXPRESSION	CAE_REPORT_LINE_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
CAE_REPORT_LINE_SD	CAE Purpose for the Report Line number short description.	VARCHAR2(255)	EXPRESSION	CAE_REPORT_LINE_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION	Designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DESG	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_ACTIVE_IND	Indicates whether the designation is active.	NUMBER	EXPRESSION	DESIGNATION_ACTIVE_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_ACTIVE_IND_LD	Designation active indicator long description.	VARCHAR2(255)	EXPRESSION	DESIGNATION_ACTIVE_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_ACTIVE_IND_SD	Designation active indicator short description.	VARCHAR2(255)	EXPRESSION	DESIGNATION_ACTIVE_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_AGENCY	An area or agency associated with the designation.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_AGENCY_LD	Designation agency long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_AGENCY_SD	Designation agency short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_DETAIL_KEY		NUMBER				NO
DESIGNATION_FEE_REQUIRED	Indicates whether a fee applies to this designation (Y or N) or optionally the type of fee, as applicable. Note, a blank space in Advance = N in EDW.	VARCHAR2(63)				NO
DESIGNATION_FEE_REQUIRED_LD	Designation fee required long description.	VARCHAR2(255)				NO
DESIGNATION_FEE_REQUIRED_SD	Designation fee required short description.	VARCHAR2(255)				NO
DESIGNATION_FINAID_FUND_IND	Indicates whether one or more financial aid funds exist for the designation.	NUMBER	EXPRESSION	DESIGNATION_FINAID_FUND_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_FINAID_FUND_IND_LD	Designation financial aid fund indicator long description.	VARCHAR2(255)	EXPRESSION	DESIGNATION_FINAID_FUND_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_FINAID_FUND_IND_SD	Designation financial aid fund indicator short description.	VARCHAR2(255)	EXPRESSION	DESIGNATION_FINAID_FUND_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_FULL_DESC	Additional space to further describe the designation.	VARCHAR2(255)				NO
DESIGNATION_LD	Designation long description.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_RESTRICTED_IND	Indicates whether there is any type of restriction associated with the designation.	NUMBER	EXPRESSION	DESIGNATION_RESTRICTED_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_RESTRICTED_IND_LD	Designation restricted indicator long description.	VARCHAR2(255)	EXPRESSION	DESIGNATION_RESTRICTED_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_RESTRICTED_IND_SD	Designation restricted indicator short description.	VARCHAR2(255)	EXPRESSION	DESIGNATION_RESTRICTED_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_RESTRICTION	Indicates the type of restriction associated with the designation.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_RESTRICTION_LD	Designation restriction long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_RESTRICTION_SD	Designation restriction short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
DESIGNATION_SD	Designation short description.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_SORT	Designation sort can be used to enter a coding sequence for reporting purposes. For example, if the designation code value is numeric, this field could be used to indicate the alpha sequence for certain reports.	VARCHAR2(255)	ADBDESG	ADBDESG_DSTP_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_STATUS	User defined designation status.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTA_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_STATUS_LD	Designation status long description.	VARCHAR2(255)	ATVDSTA	ATVDSTA_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_STATUS_SD	Designation status short description.	VARCHAR2(255)	ATVDSTA	ATVDSTA_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_TYPE	Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_TYPE_LD	Designation type long description.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_TYPE_SD	Designation type short description.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
DESIGNATION_USER_GROUP	User group associated with this designation.	VARCHAR2(63)				NO
DESIGNATION_USER_GROUP_LD	Designation user group long description.	VARCHAR2(255)				NO
DESIGNATION_USER_GROUP_SD	Designation user group short description.	VARCHAR2(255)				NO
EXTRAMURAL_ATHLETICS_IND	Indicates whether transactions with this designation code should be included in the CAE report for the section dealing with extra mural athletics.	NUMBER	CONSTANT	0	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, ASSIGNMENT, DESIGNATION ATTRIBUTE, GIFT, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE
EXTRAMURAL_ATHLETICS_IND_LD	Extramural athletics indicator long description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
EXTRAMURAL_ATHLETICS_IND_SD	Extramural athletics indicator short description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'DESIGNATION_DETAIL_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