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

SGHE 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 Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-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 Degree or award code associated with the academic study. 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.0