Reporting View Target: DESIGNATION_CLASS

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

SGHE Banner Operational Data Store
Reporting View Target: DESIGNATION_CLASS_YEAR

Description Contains information about class years associated to a designation.
Key & Frequency Multiple occurrences per designation per class year.
Recommended Search Columns DESIGNATION
DESG_TYPE
DESG_GROUP
DESIGNATION, DESIGNATION_CLASS_YEAR
DESIGNATION_CLASS_YEAR, DESIGNATION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACTIVITY_DATE Activity Date Date information for this record in the table was entered or last updated. DATE
ADRYEAR

ADRYEAR_ACTIVITY_DATE

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

NA

DESG_GROUP Designation Group Group associated with the designation. You can group similar designations together for institutional reporting. For example, designations by campaign objectives. VARCHAR2(63)
ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Designation Group Description Designation group description. VARCHAR2(255)
ATVDGRP

ATVDGRP_DESC

DESG_TYPE Designation Type Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing. VARCHAR2(63)
ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation Type Description Designation type description. VARCHAR2(255)
ATVDSTP

ATVDSTP_DESC

DESIGNATION Designation User defined code for a designation. VARCHAR2(63)
ADRYEAR

ADRYEAR_DESG

DESIGNATION_CLASS_YEAR Designation Class Year Unique identifier code for the class year. VARCHAR2(63)
ADRYEAR

ADRYEAR_YEAR

DESIGNATION_CLASS_YEAR_USER_ID Designation Class Year User ID Unique identification code of the user who entered or last touched the designation class year. VARCHAR2(63)
ADRYEAR

ADRYEAR_USER

DESIGNATION_NAME Designation Name Designation name. VARCHAR2(255)
ADBDESG

ADBDESG_NAME

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

NA

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

NA

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

NA

Ver: 9.0

Description	Contains information about class years associated to a designation.
Key & Frequency	Multiple occurrences per designation per class year.
Recommended Search Columns	DESIGNATION DESG_TYPE DESG_GROUP DESIGNATION, DESIGNATION_CLASS_YEAR DESIGNATION_CLASS_YEAR, DESIGNATION

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date information for this record in the table was entered or last updated.	DATE	ADRYEAR	ADRYEAR_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
DESG_GROUP	Designation Group	Group associated with the designation. You can group similar designations together for institutional reporting. For example, designations by campaign objectives.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE
DESG_GROUP_DESC	Designation Group Description	Designation group description.	VARCHAR2(255)	ATVDGRP	ATVDGRP_DESC
DESG_TYPE	Designation Type	Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC
DESIGNATION	Designation	User defined code for a designation.	VARCHAR2(63)	ADRYEAR	ADRYEAR_DESG
DESIGNATION_CLASS_YEAR	Designation Class Year	Unique identifier code for the class year.	VARCHAR2(63)	ADRYEAR	ADRYEAR_YEAR
DESIGNATION_CLASS_YEAR_USER_ID	Designation Class Year User ID	Unique identification code of the user who entered or last touched the designation class year.	VARCHAR2(63)	ADRYEAR	ADRYEAR_USER
DESIGNATION_NAME	Designation Name	Designation name.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA