Reporting View Target: DONOR_CATEGORY

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Advancement Reporting View Reports

SGHE Banner 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name

ACTIVITY_DATE Date record was inserted or updated
NA

SYSDATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
NA

NA

ALUM_IND1 Indicates whether a donor is an alumna/us.
ATVDONR

ATVDONR_ALUM_IND

ALUM_IND2 Indicates whether a donor is an alumna/us.
ATVDONR

ATVDONR_ALUM_IND

ALUM_IND3 Indicates whether a donor is an alumna/us.
ATVDONR

ATVDONR_ALUM_IND

ALUM_IND4 Indicates whether a donor is an alumna/us.
ATVDONR

ATVDONR_ALUM_IND

DONOR_CATEGORY1 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.
APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY2 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.
APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY3 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.
APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY4 Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.
APRCATG

APRCATG_DONR_CODE

DONOR_CATEGORY_DESC1 Donor description.
ATVDONR

ATVDONR_DESC

DONOR_CATEGORY_DESC2 Donor description.
ATVDONR

ATVDONR_DESC

DONOR_CATEGORY_DESC3 Donor description.
ATVDONR

ATVDONR_DESC

DONOR_CATEGORY_DESC4 Donor description.
ATVDONR

ATVDONR_DESC

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

APRCATG_PIDM

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.
NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.
NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
NA

NA

Ver: 8.3

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

ODS Column	ODS Business Definition	Banner Source Name	Banner Source Column
ACTIVITY_DATE	Date record was inserted or updated	NA	SYSDATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	NA	NA
ALUM_IND1	Indicates whether a donor is an alumna/us.	ATVDONR	ATVDONR_ALUM_IND
ALUM_IND2	Indicates whether a donor is an alumna/us.	ATVDONR	ATVDONR_ALUM_IND
ALUM_IND3	Indicates whether a donor is an alumna/us.	ATVDONR	ATVDONR_ALUM_IND
ALUM_IND4	Indicates whether a donor is an alumna/us.	ATVDONR	ATVDONR_ALUM_IND
DONOR_CATEGORY1	Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.	APRCATG	APRCATG_DONR_CODE
DONOR_CATEGORY2	Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.	APRCATG	APRCATG_DONR_CODE
DONOR_CATEGORY3	Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.	APRCATG	APRCATG_DONR_CODE
DONOR_CATEGORY4	Constituent's donor classification's. This allows the institution to classify a constituent in multiple categories.	APRCATG	APRCATG_DONR_CODE
DONOR_CATEGORY_DESC1	Donor description.	ATVDONR	ATVDONR_DESC
DONOR_CATEGORY_DESC2	Donor description.	ATVDONR	ATVDONR_DESC
DONOR_CATEGORY_DESC3	Donor description.	ATVDONR	ATVDONR_DESC
DONOR_CATEGORY_DESC4	Donor description.	ATVDONR	ATVDONR_DESC
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	APRCATG	APRCATG_PIDM
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	NA	NA
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	NA	NA