Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE		ADRDIDS	ADRDIDS_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
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
DESG_GROUP_DESC	Designation Group Description	Designation group description.	VARCHAR2(255)		ATVDGRP	ATVDGRP_DESC
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
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(255)		ATVDSTP	ATVDSTP_DESC
DESIGNATION	Designation	User defined code for a designation.	VARCHAR2(63)		ADRDIDS	ADRDIDS_DESG
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
DESIGNATION_NAME	Designation Name	Designation description.	VARCHAR2(255)		ADBDESG	ADBDESG_NAME
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)		FUNCTION	MAKFUNC.F_GET_ENTITY_IND
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER		ADRDIDS	ADRDIDS_PIDM
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ID_COMMENT	ID Comment	Free-form comments regarding the designation ID.	VARCHAR2(2000)		ADRDIDS	ADRDIDS_COMMENT
ID_END_DATE	ID End Date	Date that the ID is no longer active for the designation.	DATE		ADRDIDS	ADRDIDS_END_DATE
ID_START_DATE	ID Start Date	Date that the ID becomes active for the designation.	DATE		ADRDIDS	ADRDIDS_START_DATE
ID_STATUS	ID Status	Designation ID status.	VARCHAR2(63)		ADRDIDS	ADRDIDS_DIST_CODE
ID_STATUS_DESC	ID Status Description	Designation ID status description.	VARCHAR2(255)		ATVDIST	ATVDIST_DESC
ID_TYPE	ID Type	Type of designation ID.	VARCHAR2(63)		ADRDIDS	ADRDIDS_DITP_CODE
ID_TYPE_DESC	ID Type Description	Designation ID type description.	VARCHAR2(255)		ATVDITP	ATVDITP_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA

Ver: 9.0