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)
|