Reporting View Target: DESIGNATION_CLASS

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

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, DESIGNATION_CLASS_YEAR
DESIGNATION_CLASS_YEAR, DESIGNATION
DESG_TYPE
DESG_GROUP

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

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

ADRYEAR_DESG

NO
NO

DESIGNATION_NAME Designation Name Designation name. VARCHAR2(255)
ADBDESG

ADBDESG_NAME

NO
NO

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

NO
NO

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

ATVDSTP_DESC

NO
NO

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

NO
NO

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

ATVDGRP_DESC

NO
NO

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

ADRYEAR_YEAR

NO
NO

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

NO
NO

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

ADRYEAR_ACTIVITY_DATE

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NA

NO
NO

Ver: 9.2

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

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
DESIGNATION	Designation	User defined code for a designation.	VARCHAR2(63)	ADRYEAR	ADRYEAR_DESG	NO	NO
DESIGNATION_NAME	Designation Name	Designation name.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME	NO	NO
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	NO	NO
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC	NO	NO
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	NO	NO
DESG_GROUP_DESC	Designation Group Description	Designation group description.	VARCHAR2(255)	ATVDGRP	ATVDGRP_DESC	NO	NO
DESIGNATION_CLASS_YEAR	Designation Class Year	Unique identifier code for the class year.	VARCHAR2(63)	ADRYEAR	ADRYEAR_YEAR	NO	NO
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	NO	NO
ACTIVITY_DATE	Activity Date	Date information for this record in the table was entered or last updated.	DATE	ADRYEAR	ADRYEAR_ACTIVITY_DATE	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO