Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_HISTORY_EVENT	Transcript event code associated with the student.	VARCHAR2(3)	SHREVNT	SHREVNT_EVEN_CODE
ACADEMIC_HISTORY_EVENT_DESC	Description of the Transcript event code associated with the student.	VARCHAR2(30)	STVEVEN	STVEVEN_DESC
ACTIVITY_DATE	Specifies the date record was created or updated.	DATE	SHREVNT	SHREVNT_ACTIVITY_DATE
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	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
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
ORIGINATOR	Originator code of person/office who entered the event code.	VARCHAR2(4)	SHREVNT	SHREVNT_ORIG_CODE
ORIGINATOR_DESC	The description of the originator code of person/office who entered the event code.	VARCHAR2(30)	STVORIG	STVORIG_DESC
PERSON_UID	Internal Identification Number of Student.	NUMBER	SHREVNT	SHREVNT_PIDM
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
STUDENT_LEVEL_DESC	The description of the students transcript level for the event.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC
TRANSCRIPT_IND	Indicates if the event is to print on the transcript. Values are Y or N.	VARCHAR2(1)
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: