Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
DESIGNATION	Designation	User defined code for a designation.	VARCHAR2(63)			ADRDIDS	ADRDIDS_DESG	NO	NO
DESIGNATION_NAME	Designation Name	Designation description.	VARCHAR2(255)			ADBDESG	ADBDESG_NAME	NO	NO
DESG_TYPE	Designation Type	Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing.	VARCHAR2(63)			ADBDESG	ADBDESG_DSTP_CODE	NO	NO
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(255)			ATVDSTP	ATVDSTP_DESC	NO	NO
DESG_GROUP	Designation Group	User defined attribute associating designations of similar purpose or function. You can group similar designations together for institutional reporting. For example, designations by campaign objectives.	VARCHAR2(63)			ADBDESG	ADBDESG_DGRP_CODE	NO	NO
DESG_GROUP_DESC	Designation Group Description	Designation group description.	VARCHAR2(255)			ATVDGRP	ATVDGRP_DESC	NO	NO
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			ADRDIDS	ADRDIDS_PIDM	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)			FUNCTION	MAKFUNC.F_GET_ENTITY_IND	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ID_TYPE	ID Type	Type of designation ID.	VARCHAR2(63)			ADRDIDS	ADRDIDS_DITP_CODE	NO	NO
ID_TYPE_DESC	ID Type Description	Designation ID type description.	VARCHAR2(255)			ATVDITP	ATVDITP_DESC	NO	NO
ID_STATUS	ID Status	Designation ID status.	VARCHAR2(63)			ADRDIDS	ADRDIDS_DIST_CODE	NO	NO
ID_STATUS_DESC	ID Status Description	Designation ID status description.	VARCHAR2(255)			ATVDIST	ATVDIST_DESC	NO	NO
ID_START_DATE	ID Start Date	Date that the ID becomes active for the designation.	DATE			ADRDIDS	ADRDIDS_START_DATE	NO	NO
ID_END_DATE	ID End Date	Date that the ID is no longer active for the designation.	DATE			ADRDIDS	ADRDIDS_END_DATE	NO	NO
ID_COMMENT	ID Comment	Free-form comments regarding the designation ID.	VARCHAR2(2000)			ADRDIDS	ADRDIDS_COMMENT	NO	NO
DESIGNATION_ID_USER_ID	Designation ID User ID	Unique identification code of the user who entered or last touched the designation ID.	VARCHAR2(63)			ADRDIDS	ADRDIDS_USER	NO	NO
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE			ADRDIDS	ADRDIDS_ACTIVITY_DATE	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ACTIVE_ID_IND	Active Id Indicator	Designation ID status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)			ATVDIST	ATVDIST_ACTIVE_IND	NO	NO

Ver: 9.2