RETURN TO BANNER EDW META DATA 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)

FUNCTION

IF ADV_GIFT_REC.ACTIVE_CONSTITUENT_TMP ='Y' AND PERS_DEMO_REC.DECEASED_IND ='Y' THEN RET_ROW.ACTIVE_CONSTITUENT_IND :='N'; ELSE RET_ROW.ACTIVE_CONSTITUENT_IND := ADV_GIFT_REC.ACTIVE_CONSTITUENT_TMP; END IF

NO

NO ADVANCEMENT GIFT
ALUMNI_IND Identifies the constituent as a person who attended the institution. That is the person has a primary donor type specified as alumni. NUMBER

CONSTITUENT_ENTITY

MAT_CONSTITUENT_ENTITY-EDW_ADV_GIFT_EXTR.F_GET_ADVANCEMENT_GIFT:IF PRIMARY_DONOR_CATEGORY IS CLASSIFIED AS ALUMNI IN MTVPARM THEN ALUMNI_IND = 1, ELSE = 0;

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_ENTITY

ENTITY_IND

NO

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

ETL GENERATED

NA

NO

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

ETL GENERATED

NA

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