Reporting View Target: OUTCOME_DEPARTMENTAL

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

Banner Operational Data Store
Reporting View Target: OUTCOME_DEPARTMENTAL_HONOR

Description Contains details regarding honors granted by a department to a person for a qualifying academic outcome (award, degree, certificate, etc.).
Key & Frequency One row per person per outcome number per honor.
Recommended Search Columns PERSON_UID, OUTCOME_NUMBER

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

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

NA

COMMENCEMENT_IND Commencement Indicator Indicates whether this honor is printed in the commencement report. VARCHAR2(1)
SHRDGDH

SHRDGDH_COMMENCE_PRT_IND

DEGREE Degree Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme. VARCHAR2(63)
SHRDGMR

SHRDGMR_DEGC_CODE

DEGREE_DESC Degree Description Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

HONOR Honor Departmental honor code for a student. VARCHAR2(63)
SHRDGDH

SHRDGDH_HOND_CODE

HONOR_DESC Honor Description Departmental honor associated with the departmental honor code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

OUTCOME_NUMBER Outcome Number Outcome sequence number. NUMBER
SHRDGMR

SHRDGMR_SEQ_NO

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
SHRDGMR

SHRDGMR_PIDM

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

NA

TRANSCRIPT_IND Transcript Indicator Indicates whether this honor is printed on the transcript. VARCHAR2(1)
SHRDGDH

SHRDGDH_TRANSC_PRT_IND

Ver: 9.2

Description	Contains details regarding honors granted by a department to a person for a qualifying academic outcome (award, degree, certificate, etc.).
Key & Frequency	One row per person per outcome number per honor.
Recommended Search Columns	PERSON_UID, OUTCOME_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COMMENCEMENT_IND	Commencement Indicator	Indicates whether this honor is printed in the commencement report.	VARCHAR2(1)	SHRDGDH	SHRDGDH_COMMENCE_PRT_IND
DEGREE	Degree	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.	VARCHAR2(63)	SHRDGMR	SHRDGMR_DEGC_CODE
DEGREE_DESC	Degree Description	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HONOR	Honor	Departmental honor code for a student.	VARCHAR2(63)	SHRDGDH	SHRDGDH_HOND_CODE
HONOR_DESC	Honor Description	Departmental honor associated with the departmental honor code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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
OUTCOME_NUMBER	Outcome Number	Outcome sequence number.	NUMBER	SHRDGMR	SHRDGMR_SEQ_NO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SHRDGMR	SHRDGMR_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
TRANSCRIPT_IND	Transcript Indicator	Indicates whether this honor is printed on the transcript.	VARCHAR2(1)	SHRDGDH	SHRDGDH_TRANSC_PRT_IND