Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ACADEMIC_HISTORY_EVENT

Description Contains data pertaining to a student's academic history events.
Key & Frequency One row per person.
Recommended Search Columns ACADEMIC_HISTORY_EVENT
TRANSCRIPT_IND
PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_HISTORY_EVENT Transcript event code associated with the student. VARCHAR2(63)

SHREVNT

SHREVNT_EVEN_CODE

ACADEMIC_HISTORY_EVENT_DESC Description of the Transcript event code associated with the student. VARCHAR2(255)

STVEVEN

STVEVEN_DESC

ACTIVITY_DATE Specifies the date record was created or updated. DATE

SHREVNT

SHREVNT_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Domain column for future use, not currently populated. VARCHAR2(255)

NA

NA

EFFECTIVE_DATE Date on which event may print on students transcript. DATE

SHREVNT

SHREVNT_EFFECTIVE_DATE

EVENT_DECISION Free format used to show decision data. VARCHAR2(10)

SHREVNT

SHREVNT_DECISION

EVENT_GRADE Free format used to show grade data. VARCHAR2(6)

SHREVNT

SHREVNT_GRADE

EVENT_INFORMATION Description of the event entered only if the event code is 999. VARCHAR2(30)

SHREVNT

SHREVNT_DESC

MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(255)

NA

NA

ORIGINATOR Originator code of person/office who entered the event code. VARCHAR2(63)

SHREVNT

SHREVNT_ORIG_CODE

ORIGINATOR_DESC The description of the originator code of person/office who entered the event code. VARCHAR2(255)

STVORIG

STVORIG_DESC

PERSON_UID Internal Identification Number of Student. NUMBER

SHREVNT

SHREVNT_PIDM

PROCESS_GROUP Zone column for future use, not currently populated. VARCHAR2(255)

NA

NA

STUDENT_LEVEL Students transcript level for the event. VARCHAR2(63)

SHREVNT

SHREVNT_LEVL_CODE

STUDENT_LEVEL_DESC The description of the students transcript level for the event. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

TRANSCRIPT_IND Indicates if the event is to print on the transcript. Values are Y or N. VARCHAR2(1)

CALCULATION

DECODE(STVEVEN_TRANS_IND)



Ver: 8.0