RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Operational Data Store
Reporting View Target: DONOR_CATEGORY_SLOT

Description Uses data from the DONOR_CATEGORY reporting view. Displays the category code, description and alumni indicator for up to 4 donor categories associated to a constituent. The categories displayed are selected based on reporting priority, starting with the highest priority. There are currently no associated display rules.
Key & Frequency One row per entity.
Recommended Search Columns ENTITY_UID
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated DATE

NA

SYSDATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ALUM_IND1 Indicates whether a donor is an alumna/us. VARCHAR2(1)

ATVDONR

ATVDONR_ALUM_IND

ALUM_IND2 Indicates whether a donor is an alumna/us. VARCHAR2(1)

ATVDONR

ATVDONR_ALUM_IND

ALUM_IND3 Indicates whether a donor is an alumna/us. VARCHAR2(1)

ATVDONR

ATVDONR_ALUM_IND

ALUM_IND4 Indicates whether a donor is an alumna/us. VARCHAR2(1)

ATVDONR

ATVDONR_ALUM_IND

DONOR_CATEGORY1 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories. VARCHAR2(63)

APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY2 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories. VARCHAR2(63)

APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY3 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories. VARCHAR2(63)

APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY4 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories. VARCHAR2(63)

APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY_DESC1 Donor description. VARCHAR2(255)

ATVDONR

ATVDONR_DESC

DONOR_CATEGORY_DESC2 Donor description. VARCHAR2(255)

ATVDONR

ATVDONR_DESC

DONOR_CATEGORY_DESC3 Donor description. VARCHAR2(255)

ATVDONR

ATVDONR_DESC

DONOR_CATEGORY_DESC4 Donor description. VARCHAR2(255)

ATVDONR

ATVDONR_DESC

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

APRCATG

APRCATG_PIDM

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA



Ver: 3.1