| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
COMMENT_ACTIVITY_DATE
 | 
Activity Date 
 | 
Date information for this record in the table was entered or last updated.
 | 
DATE
 | 
 
 | 
 AMRCONF
 
 | 
 AMRCONF_ACTIVITY_DATE
 
 | 
| 
COMMENT_CONFIDENTIALITY_IND
 | 
Comment Confidentiality Indicator 
 | 
Indicates whether the person has requested the institution keep their comment confidential.
 | 
VARCHAR2(1)
 | 
 
 | 
 CALCULATION
 
 | 
 NVL(AMRCONF_CONFID_IND)
 
 | 
| 
COMMENT_ENTRY_DATE
 | 
Comment Entry Date 
 | 
Date the comment was made.
 | 
DATE
 | 
 
 | 
 AMRCONF
 
 | 
 AMRCONF_ENTRY_DATE
 
 | 
| 
COMMENT_GROUP_SEQUENCE
 | 
Comment Group Sequence 
 | 
One-up system assigned number use to sequence comments for the prospect.
 | 
NUMBER
 | 
 
 | 
 AMRCONF
 
 | 
 AMRCONF_GRP_SEQ_NO
 
 | 
| 
COMMENT_USER_ID
 | 
Last Update User ID 
 | 
Unique identification code of the user who entered or last updated the prospect comment.
 | 
VARCHAR2(63)
 | 
 
 | 
 AMRCONF
 
 | 
 AMRCONF_USER
 
 | 
| 
ENTITY_IND
 | 
Entity Indicator 
 | 
Indicates whether the entity is a person or an organization.
 | 
VARCHAR2(1)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
ENTITY_UID
 | 
Entity UID 
 | 
System generated, unique, internal identification number assigned to this person or organization entity.
 | 
NUMBER
 | 
 
 | 
 AMRCONF
 
 | 
 AMRCONF_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
 
 | 
| 
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
 
 | 
| 
PROSPECT_COMMENT
 | 
Prospect Comment 
 | 
Free-form comment regarding the prospect.
 | 
CLOB
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_TRIM_LONGS
 
 | 
| 
STAFF_IDEN
 | 
Staff ID 
 | 
Abbreviation that uniquely identifies the user.
 | 
VARCHAR2(63)
 | 
 
 | 
 AMRCONF
 
 | 
 AMRCONF_IDEN_CODE
 
 | 
| 
STAFF_IDEN_NAME
 | 
Staff ID Name 
 | 
Name of the person who made the comment.
 | 
VARCHAR2(255)
 | 
 
 | 
 GURIDEN
 
 | 
 GURIDEN_DESC
 
 | 
| 
STAFF_IDEN_USER_ID
 | 
Staff ID User ID 
 | 
Unique identification code belonging to the person who made the comment.
 | 
VARCHAR2(63)
 | 
 
 | 
 AMRCONF
 
 | 
 AMRCONF_USER_ID
 
 |