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	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	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	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	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: 9.1