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(3)		SHREVNT	SHREVNT_EVEN_CODE
ACADEMIC_HISTORY_EVENT_DESC	Academic History Event Description	Description of the Transcript event code associated with the student.	VARCHAR2(30)		STVEVEN	STVEVEN_DESC
ACTIVITY_DATE	Date	Specifies the date record was created or updated.	DATE		SHREVNT	SHREVNT_ACTIVITY_DATE
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	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	Date on which event may print on students transcript.	DATE		SHREVNT	SHREVNT_EFFECTIVE_DATE
EVENT_DECISION	Decision	Free format used to show decision data.	VARCHAR2(10)		SHREVNT	SHREVNT_DECISION
EVENT_GRADE	Grade	Free format used to show grade data.	VARCHAR2(6)		SHREVNT	SHREVNT_GRADE
EVENT_INFORMATION	Information	Description of the event entered only if the event code is 999.	VARCHAR2(30)		SHREVNT	SHREVNT_DESC
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	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	Description	The description of the originator code of person/office who entered the event code.	VARCHAR2(30)		STVORIG	STVORIG_DESC
PERSON_UID	UID	Internal Identification Number of Student.	NUMBER(8)		SHREVNT	SHREVNT_PIDM
STUDENT_LEVEL	Level	Students transcript level for the event.	VARCHAR2(2)		SHREVNT	SHREVNT_LEVL_CODE
STUDENT_LEVEL_DESC	Level Description	The description of the students transcript level for the event.	VARCHAR2(30)		STVLEVL	STVLEVL_DESC
TRANSCRIPT_IND	Indicator	Indicates if the event is to print on the transcript. Values are Y or N.	VARCHAR2(1)
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: