Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ALTERNATIVE_ID	Alternative ID that may be used to cross reference the Banner ID to another system identification.	VARCHAR2(50)	GORADID	GORADID_ADDITIONAL_ID	NO	NO
ALTERNATIVE_ID_ACTIVITY_DATE	Date the last change were made to this record.	DATE	GORADID	GORADID_ACTIVITY_DATE	NO	NO
ALTERNATIVE_ID_DATA_ORIGIN	Source system that created or updated the row	VARCHAR2(30)	GORADID	GORADID_DATA_ORIGIN	NO	NO
ALTERNATIVE_ID_TYPE	Institution defined code that identifies the type or source for this alternative ID.	VARCHAR2(4)	GORADID	GORADID_ADID_CODE	NO	NO
ALTERNATIVE_ID_TYPE_DESC	Alternative ID type description.	VARCHAR2(30)	GTVADID	GTVADID_DESC	NO	NO
ALTERNATIVE_ID_USER_ID	User who made the last updated to this record.	VARCHAR2(30)	GORADID	GORADID_USER_ID	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ENTITY_UID		NUMBER				NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person or organization.	NUMBER	GORADID	GORADID_PIDM	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: