| 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 FUNCTION
|
NO NO
|
NO
|
ADVANCEMENT GIFT 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 FUNCTION
|
NO NO
|
NO
|
ADVANCEMENT GIFT ADVANCEMENT GIFT
|
|
ENTITY_TYPE_LD
|
Long description for the entity type.
|
VARCHAR2(255)
|
CONSTITUENT ORGANIZATIONAL_CONSTITUENT
|
FUNCTION FUNCTION
|
NO NO
|
NO
|
ADVANCEMENT GIFT ADVANCEMENT GIFT
|
|
ENTITY_TYPE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
CONSTITUENT ORGANIZATIONAL_CONSTITUENT
|
FUNCTION FUNCTION
|
NO NO
|
NO
|
ADVANCEMENT GIFT 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
|