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 Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

SHRDGDH

SHRDGDH_COMMENCE_PRT_IND

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 code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGDH

SHRDGDH_HOND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

OUTCOME_NUMBER Outcome sequence number. NUMBER

SHRDGMR

SHRDGMR_SEQ_NO

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

SHRDGMR

SHRDGMR_PIDM

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

NA

NA

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

SHRDGDH

SHRDGDH_TRANSC_PRT_IND



Ver: 8.5