Reporting View Target: DESIGNATION

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

SGHE Banner Operational Data Store
Reporting View Target: DESIGNATION_ATTRIBUTE

Description Contains attribute information about a designation.
Key & Frequency One occurrence per designation per attribute.
Recommended Search Columns DESIGNATION
DESG_TYPE
DESG_GROUP
DESIGNATION, DESIGNATION_ATTRIBUTE
DESIGNATION_ATTRIBUTE, 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
ADRATTR

ADRATTR_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)
ADRATTR

ADRATTR_DESG

DESIGNATION_ATTRIBUTE Designation Attribute Institutionally defined designation attribute code. VARCHAR2(63)
ADRATTR

ADRATTR_DATR_CODE

DESIGNATION_ATTRIBUTE_DESC Designation Attribute Description Designation attribute code description. VARCHAR2(255)
ATVDATR

ATVDATR_DESC

DESIGNATION_ATTRIBUTE_USER_ID Designation Attribute User ID Unique identification code of the user who entered or last updated the designation attribute. VARCHAR2(63)
ADRATTR

ADRATTR_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 attribute information about a designation.
Key & Frequency	One occurrence per designation per attribute.
Recommended Search Columns	DESIGNATION DESG_TYPE DESG_GROUP DESIGNATION, DESIGNATION_ATTRIBUTE DESIGNATION_ATTRIBUTE, 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	ADRATTR	ADRATTR_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)	ADRATTR	ADRATTR_DESG
DESIGNATION_ATTRIBUTE	Designation Attribute	Institutionally defined designation attribute code.	VARCHAR2(63)	ADRATTR	ADRATTR_DATR_CODE
DESIGNATION_ATTRIBUTE_DESC	Designation Attribute Description	Designation attribute code description.	VARCHAR2(255)	ATVDATR	ATVDATR_DESC
DESIGNATION_ATTRIBUTE_USER_ID	Designation Attribute User ID	Unique identification code of the user who entered or last updated the designation attribute.	VARCHAR2(63)	ADRATTR	ADRATTR_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