| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ACTIVITY_DATE
 | 
Activity Date 
 | 
Date Pledge Condition was created or last updated.
 | 
DATE
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_ACTIVITY_DATE
 
 | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
CONDITION_COMMENT
 | 
Condition Comment 
 | 
Comments related to this pledge condition record.
 | 
CLOB
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_TRIM_LONGS
 
 | 
| 
CONDITION_DATE
 | 
Condition Date 
 | 
Date the Pledge Condition was met or complied with.
 | 
DATE
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_MET_DATE
 
 | 
| 
CONDITION_MET
 | 
Condition Met
 | 
Indicates if the Pledge Condition has been met.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_MET_IND
 
 | 
| 
CONDITION_MET_DESC
 | 
Condition Met Description
 | 
Pledge Condition met description.
 | 
VARCHAR2(255)
 | 
 
 | 
 CALCULATION
 
 | 
 DECODE(AGRPCON_MET_IND)
 
 | 
| 
CONDITION_TYPE
 | 
Condition Type 
 | 
Pledge Condition Type Code.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_CTYP_CODE
 
 | 
| 
CONDITION_TYPE_DESC
 | 
Condition Type Description 
 | 
Description of the Pledge condition type.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 ATVCTYP_DESC
 
 | 
| 
ENTITY_IND
 | 
Entity Indicator 
 | 
Indicates whether 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
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_PIDM
 
 | 
| 
EXPECTED_CONDITION_DATE
 | 
Expected Condition Date 
 | 
Date the Pledge Condition is expected to be met or complied with.
 | 
DATE
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_EXPECTED_DATE
 
 | 
| 
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 
 | 
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
 | 
VARCHAR2(63)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
NAME
 | 
Name 
 | 
Name of the person (LFMI) or organization.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
PLEDGE_NUMBER
 | 
Pledge Number 
 | 
Number of the pledge.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_PLEDGE_NO
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
The institution value of the process-oriented identifier for the record used to determine access authorization to this record.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
SEQUENCE_NUMBER
 | 
Sequence Number 
 | 
Sequence number of the condition of the Pledge.
 | 
NUMBER
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_SEQ
 
 | 
| 
USER_ID
 | 
User ID 
 | 
Unique identification code of the user who entered or last touched the transaction.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPCON
 
 | 
 AGRPCON_USER
 
 |