RETURN TO DIMENSION TABLE REPORTS LIST
Advancement Gift Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CONSTITUENT

Description Constituent Dimension table provides information for the person or entity (organization) that has given or is being solicited for gifts to the institution. This information includes identification of whether this is an individual or organization, whether they have given in the time frame, and preferences identified for the constituent. 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
ACTIVE_CONSTITUENT_IND Indicates the constituent is alive and we have current contact information. VARCHAR2(63)

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

FUNCTION

NO

NO

ADVANCEMENT GIFT

CONSTITUENT_KEY Key for the constituent dimension NUMBER

ETL GENERATED

NA

NO

NO

ADVANCEMENT GIFT

ENTITY_TYPE Identifies the constituent as a person or an organization. Programmatically determines if the record was from the ODS CONSTITUENT or the ODS ORGANIZATIONAL_CONSTITUENT reporting view. VARCHAR2(63)

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

FUNCTION

NO

NO

ADVANCEMENT GIFT

ENTITY_TYPE_LD Long description for the entity type. VARCHAR2(255)

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

FUNCTION

NO

NO

ADVANCEMENT GIFT

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

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

FUNCTION

NO

NO

ADVANCEMENT GIFT

PREFERRED_CLASS_YEAR Specifies the year in that the constituent (if an individual not an organization) received the first award or degree or the year of expected graduation if the first degree has not yet been earned. VARCHAR2(63)

CONSTITUENT

PREF_CLASS

NO

NO

ADVANCEMENT GIFT

PREFERRED_CLASS_YEAR_LD Long description of the class code. VARCHAR2(255)

CONSTITUENT

PREF_CLASS_DESC

NO

NO

ADVANCEMENT GIFT

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

CONSTITUENT

PREF_CLASS_DESC

NO

NO

ADVANCEMENT GIFT

PREFERRED_COLLEGE Specifies the college within the institution that the constituent prefers to be associated. VARCHAR2(63)

CONSTITUENT

PREF_COLLEGE

NO

NO

ADVANCEMENT GIFT

PREFERRED_COLLEGE_LD Long description of the college association code. VARCHAR2(255)

CONSTITUENT

PREF_COLLEGE_DESC

NO

NO

ADVANCEMENT GIFT

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

CONSTITUENT

PREF_COLLEGE_DESC

NO

NO

ADVANCEMENT GIFT

PRIMARY_DONOR_CATEGORY Defined to identify the preferred or primary donor category associated with this constituent. VARCHAR2(63)

DONOR_CATEGORY

DONOR_CATEGORY

NO

NO

ADVANCEMENT GIFT

PRIMARY_DONOR_CATEGORY_LD Long description of the primary donor category. VARCHAR2(255)

DONOR_CATEGORY

DONOR_CATEGORY_DESC

NO

NO

ADVANCEMENT GIFT

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

DONOR_CATEGORY

DONOR_CATEGORY_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