Target Column	Business Definition	Database Data Type	Source Name	Source Column
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	Date the last change were made to this record.	DATE	GORADID	GORADID_ACTIVITY_DATE
ALTERNATIVE_ID_DATA_ORIGIN	Source system that created or updated the row	VARCHAR2(30)	GORADID	GORADID_DATA_ORIGIN
ALTERNATIVE_ID_USER_ID	User who made the last updated to this record.	VARCHAR2(30)	GORADID	GORADID_USER_ID
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	Alternative ID type description.	VARCHAR2(30)	GTVADID	GTVADID_DESC
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. Institution defined.	VARCHAR2(6)	NA	NA
ENTITY_UID		NUMBER
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
PERSON_UID	System generated, unique, internal identification number assigned to this person or organization.	NUMBER	GORADID	GORADID_PIDM
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: