Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner Operational Data Store
Composite View Target: AS_ACADEMIC_HISTORY_EVENT

Description Contains data pertaining to a student's academic history events.
Key & Frequency One row per person

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

SHREVNT

SHREVNT_EVEN_CODE

NO

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

STVEVEN

STVEVEN_DESC

NO

NO
ACTIVITY_DATE Specifies the date record was created or updated. DATE

SHREVNT

SHREVNT_ACTIVITY_DATE

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

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

SHREVNT

SHREVNT_EFFECTIVE_DATE

NO

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

SHREVNT

SHREVNT_DECISION

NO

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

SHREVNT

SHREVNT_GRADE

NO

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

SHREVNT

SHREVNT_DESC

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

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

SHREVNT

SHREVNT_ORIG_CODE

NO

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

STVORIG

STVORIG_DESC

NO

NO
PERSON_UID Internal Identification Number of Student. NUMBER

SHREVNT

SHREVNT_PIDM

NO

NO
STUDENT_LEVEL Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(2)

SHREVNT

SHREVNT_LEVL_CODE

NO

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

STVLEVL

STVLEVL_DESC

NO

NO
TRANSCRIPT_IND Indicates if the event is to print on the transcript. Values are Y or N. VARCHAR2(1)       NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: