Dimension Table Target: WDT

	RETURN TO DIMENSION TABLE REPORTS LIST
	Advancement Gift Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_DESIGNATION

Description Designation Dimension table provides information regarding the reasons a gift was given to the institution. This information includes the type, intended receiving college, purpose, etc. 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

DESIGNATION Specifies the designation associated with the gift and/or pledge payment. VARCHAR2(63)
DESIGNATION_GIVING_HISTORY

DESIGNATION

NO
NO ADVANCEMENT GIFT

DESIGNATION_COLLEGE Specifies the college or institution structure associated with the designation. VARCHAR2(63)
DESIGNATION_GIVING_HISTORY

DESG_COLLEGE

NO
NO ADVANCEMENT GIFT

DESIGNATION_COLLEGE_LD Descriptive name of the college for the designation. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESG_COLLEGE_DESC

NO
NO ADVANCEMENT GIFT

DESIGNATION_COLLEGE_SD Short description defined in the cleansing process. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESG_COLLEGE_DESC

NO
NO ADVANCEMENT GIFT

DESIGNATION_KEY Key for the designation dimension. NUMBER
ETL GENERATED

NA

NO
NO ADVANCEMENT GIFT

DESIGNATION_LD Long descriptive name for the designation for the gift. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESIGNATION_NAME

NO
NO ADVANCEMENT GIFT

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)
DESIGNATION_GIVING_HISTORY

DESG_VSE

NO
NO ADVANCEMENT GIFT

DESIGNATION_PURPOSE_LD Long descriptive text for the purpose of the gift. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESG_VSE_DESC

NO
NO ADVANCEMENT GIFT

DESIGNATION_PURPOSE_SD Short description defined in the cleansing process. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESG_VSE_DESC

NO
NO ADVANCEMENT GIFT

DESIGNATION_SD Short description defined in the cleansing process. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESIGNATION_NAME

NO
NO ADVANCEMENT GIFT

DESIGNATION_TYPE Specifies the type of designation identified with the gift. VARCHAR2(63)
DESIGNATION_GIVING_HISTORY

DESG_TYPE

NO
NO ADVANCEMENT GIFT

DESIGNATION_TYPE_LD Descriptive text for the type of designation. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESG_TYPE_DESC

NO
NO ADVANCEMENT GIFT

DESIGNATION_TYPE_SD Short description defined in the cleansing process. VARCHAR2(255)
DESIGNATION_GIVING_HISTORY

DESG_TYPE_DESC

NO
NO ADVANCEMENT GIFT

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

NA

NO
NO ADVANCEMENT GIFT

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
ETL GENERATED

NA

NO
NO ADVANCEMENT GIFT

Ver: 8.1

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
DESIGNATION	Specifies the designation associated with the gift and/or pledge payment.	VARCHAR2(63)	DESIGNATION_GIVING_HISTORY	DESIGNATION	NO	NO	ADVANCEMENT GIFT
DESIGNATION_COLLEGE	Specifies the college or institution structure associated with the designation.	VARCHAR2(63)	DESIGNATION_GIVING_HISTORY	DESG_COLLEGE	NO	NO	ADVANCEMENT GIFT
DESIGNATION_COLLEGE_LD	Descriptive name of the college for the designation.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESG_COLLEGE_DESC	NO	NO	ADVANCEMENT GIFT
DESIGNATION_COLLEGE_SD	Short description defined in the cleansing process.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESG_COLLEGE_DESC	NO	NO	ADVANCEMENT GIFT
DESIGNATION_KEY	Key for the designation dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
DESIGNATION_LD	Long descriptive name for the designation for the gift.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESIGNATION_NAME	NO	NO	ADVANCEMENT GIFT
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)	DESIGNATION_GIVING_HISTORY	DESG_VSE	NO	NO	ADVANCEMENT GIFT
DESIGNATION_PURPOSE_LD	Long descriptive text for the purpose of the gift.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESG_VSE_DESC	NO	NO	ADVANCEMENT GIFT
DESIGNATION_PURPOSE_SD	Short description defined in the cleansing process.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESG_VSE_DESC	NO	NO	ADVANCEMENT GIFT
DESIGNATION_SD	Short description defined in the cleansing process.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESIGNATION_NAME	NO	NO	ADVANCEMENT GIFT
DESIGNATION_TYPE	Specifies the type of designation identified with the gift.	VARCHAR2(63)	DESIGNATION_GIVING_HISTORY	DESG_TYPE	NO	NO	ADVANCEMENT GIFT
DESIGNATION_TYPE_LD	Descriptive text for the type of designation.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESG_TYPE_DESC	NO	NO	ADVANCEMENT GIFT
DESIGNATION_TYPE_SD	Short description defined in the cleansing process.	VARCHAR2(255)	DESIGNATION_GIVING_HISTORY	DESG_TYPE_DESC	NO	NO	ADVANCEMENT GIFT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ADVANCEMENT GIFT