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(63)	SHREVNT	SHREVNT_EVEN_CODE	NO	NO
ACADEMIC_HISTORY_EVENT_DESC	Description of the Transcript event code associated with the student.	VARCHAR2(255)	STVEVEN	STVEVEN_DESC	NO	NO
ACTIVITY_DATE	Specifies the date record was created or updated.	DATE	SHREVNT	SHREVNT_ACTIVITY_DATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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
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	NO	NO
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	NO	NO
ORIGINATOR	Originator code of person/office who entered the event code.	VARCHAR2(63)	SHREVNT	SHREVNT_ORIG_CODE	NO	NO
ORIGINATOR_DESC	The description of the originator code of person/office who entered the event code.	VARCHAR2(255)	STVORIG	STVORIG_DESC	NO	NO
PERSON_UID	Internal Identification Number of Student.	NUMBER	SHREVNT	SHREVNT_PIDM	NO	NO
PROCESS_GROUP	Zone column for future use, not currently populated.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
STUDENT_LEVEL_DESC	The description of the students transcript level for the event.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO
TRANSCRIPT_IND	Indicates if the event is to print on the transcript. Values are Y or N.	VARCHAR2(1)	CALCULATION	DECODE(STVEVEN_TRANS_IND)	NO	NO

Ver: 9.2