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: 3.1