Reporting View Target: ACADEMIC_HISTORY

Go To View:	RETURN TO BANNER ODS META DATA 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 PERSON_UID
ACADEMIC_HISTORY_EVENT
TRANSCRIPT_IND, PERSON_UID

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

ACADEMIC_HISTORY_EVENT Academic History Event Transcript event code associated with the student. VARCHAR2(63)
SHREVNT

SHREVNT_EVEN_CODE

ACADEMIC_HISTORY_EVENT_DESC Academic History Event Description Description of the Transcript event code associated with the student. VARCHAR2(255)
STVEVEN

STVEVEN_DESC

ACTIVITY_DATE Activity Date Specifies the date record was created or updated. DATE
SHREVNT

SHREVNT_ACTIVITY_DATE

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

NA

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

SHREVNT_EFFECTIVE_DATE

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

SHREVNT_DECISION

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

SHREVNT_GRADE

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

SHREVNT_DESC

MULTI_SOURCE 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 Multi Source Description 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 Originator code of person/office who entered the event code. VARCHAR2(63)
SHREVNT

SHREVNT_ORIG_CODE

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

STVORIG_DESC

PERSON_UID Person UID Internal Identification Number of Student. NUMBER
SHREVNT

SHREVNT_PIDM

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

NA

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

SHREVNT_LEVL_CODE

STUDENT_LEVEL_DESC Student Level Description The description of the students transcript level for the event. VARCHAR2(255)
STVLEVL

STVLEVL_DESC

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

DECODE(STVEVEN_TRANS_IND)

Ver: 9.0

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

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_HISTORY_EVENT	Academic History Event	Transcript event code associated with the student.	VARCHAR2(63)	SHREVNT	SHREVNT_EVEN_CODE
ACADEMIC_HISTORY_EVENT_DESC	Academic History Event Description	Description of the Transcript event code associated with the student.	VARCHAR2(255)	STVEVEN	STVEVEN_DESC
ACTIVITY_DATE	Activity Date	Specifies the date record was created or updated.	DATE	SHREVNT	SHREVNT_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Domain column for future use, not currently populated.	VARCHAR2(255)	NA	NA
EFFECTIVE_DATE	Effective Date	Date on which event may print on students transcript.	DATE	SHREVNT	SHREVNT_EFFECTIVE_DATE
EVENT_DECISION	Event Decision	Free format used to show decision data.	VARCHAR2(10)	SHREVNT	SHREVNT_DECISION
EVENT_GRADE	Event Grade	Free format used to show grade data.	VARCHAR2(6)	SHREVNT	SHREVNT_GRADE
EVENT_INFORMATION	Event Information	Description of the event entered only if the event code is 999.	VARCHAR2(30)	SHREVNT	SHREVNT_DESC
MULTI_SOURCE	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	Multi Source Description	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	Originator code of person/office who entered the event code.	VARCHAR2(63)	SHREVNT	SHREVNT_ORIG_CODE
ORIGINATOR_DESC	Originator Description	The description of the originator code of person/office who entered the event code.	VARCHAR2(255)	STVORIG	STVORIG_DESC
PERSON_UID	Person UID	Internal Identification Number of Student.	NUMBER	SHREVNT	SHREVNT_PIDM
PROCESS_GROUP	Process Group	Zone column for future use, not currently populated.	VARCHAR2(255)	NA	NA
STUDENT_LEVEL	Student Level	Students transcript level for the event.	VARCHAR2(63)	SHREVNT	SHREVNT_LEVL_CODE
STUDENT_LEVEL_DESC	Student Level Description	The description of the students transcript level for the event.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
TRANSCRIPT_IND	Transcript Indicator	Indicates if the event is to print on the transcript. Values are Y or N.	VARCHAR2(1)	CALCULATION	DECODE(STVEVEN_TRANS_IND)