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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_HISTORY_EVENT Transcript event code associated with the student.    

SHREVNT

SHREVNT_EVEN_CODE

 
ACADEMIC_HISTORY_EVENT_DESC Description of the Transcript event code associated with the student.    

STVEVEN

STVEVEN_DESC

 
ACTIVITY_DATE Specifies the date record was created or updated.    

SHREVNT

SHREVNT_ACTIVITY_DATE

 
ADMINISTRATIVE_GROUP Domain column for future use, not currently populated.    

NA

NA

 
EFFECTIVE_DATE Date on which event may print on students transcript.    

SHREVNT

SHREVNT_EFFECTIVE_DATE

 
EVENT_DECISION Free format used to show decision data.    

SHREVNT

SHREVNT_DECISION

 
EVENT_GRADE Free format used to show grade data.    

SHREVNT

SHREVNT_GRADE

 
EVENT_INFORMATION Description of the event entered only if the event code is 999.    

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.    

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.    

NA

NA

 
ORIGINATOR Originator code of person/office who entered the event code.    

SHREVNT

SHREVNT_ORIG_CODE

 
ORIGINATOR_DESC The description of the originator code of person/office who entered the event code.    

STVORIG

STVORIG_DESC

 
PERSON_UID Internal Identification Number of Student.    

SHREVNT

SHREVNT_PIDM

 
PROCESS_GROUP Zone column for future use, not currently populated.    

NA

NA

 
STUDENT_LEVEL Students transcript level for the event.    

SHREVNT

SHREVNT_LEVL_CODE

 
STUDENT_LEVEL_DESC The description of the students transcript level for the event.    

STVLEVL

STVLEVL_DESC

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

CALCULATION

DECODE(STVEVEN_TRANS_IND)

 


Ver: 8.3