RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Operational Data Store
Reporting View Target: OUTCOME_INSTITUTIONAL_HONOR

Description Contains details regarding honors granted by the institution to a person for a qualifying academic outcome (award, degree, certificate, etc.).
Key & Frequency One 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 Organization-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)

SHRDGIH

SHRDGIH_COMMENCE_PRT_IND

DEGREE Degree or award code associated with the academic study. 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 Institutional honor code for a student. VARCHAR2(63)

SHRDGIH

SHRDGIH_HONR_CODE

HONOR_DESC Institutional honor description associated with the institutional 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)

SHRDGIH

SHRDGIH_TRANSC_PRT_IND



Ver: 3.1