Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ALTERNATIVE_ID	Alternative ID	Alternative ID that may be used to cross reference the Banner ID to another system identification.	VARCHAR2(50)		GORADID	GORADID_ADDITIONAL_ID
ALTERNATIVE_ID_ACTIVITY_DATE	Alternative ID Activity Date	Date the last change were made to this record.	DATE		GORADID	GORADID_ACTIVITY_DATE
ALTERNATIVE_ID_DATA_ORIGIN	Alternative ID Data Origin	Source system that created or updated the row	VARCHAR2(30)		GORADID	GORADID_DATA_ORIGIN
ALTERNATIVE_ID_USER_ID	Alternative ID User ID	User who made the last updated to this record.	VARCHAR2(30)		GORADID	GORADID_USER_ID
ATERNATIVE_ID_TYPE	Aternative ID Type	Institution defined code that identifies the type or source for this alternative ID.	VARCHAR2(4)		GORADID	GORADID_ADID_CODE
ATERNATIVE_ID_TYPE_DESC	Aternative ID Type Description	Alternative ID type description.	VARCHAR2(30)		GTVADID	GTVADID_DESC
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. Institution defined.	VARCHAR2(6)		NA	NA
ENTITY_UID	Entity UID		NUMBER
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
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person or organization.	NUMBER		GORADID	GORADID_PIDM
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: