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

Target Column Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

ADMINISTRATIVE_GROUP Administrative-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: 8.5

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	Administrative-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