| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ACTIVITY_DATE
 | 
Activity Date 
 | 
Date record was inserted or updated
 | 
DATE
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_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
 
 | 
| 
AUXILIARY_CLASS_YEAR
 | 
Auxiliary Class Year 
 | 
Class year to which this pledge amount should be credited.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_PREF_CLAS
 
 | 
| 
AUXILIARY_COMMENT
 | 
Auxiliary Comment 
 | 
Free format comment field.
 | 
CLOB
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_TRIM_LONGS
 
 | 
| 
AUXILIARY_DONOR_CATEGORY
 | 
Auxiliary Donor Category 
 | 
Donor category code to which this pledge amount should be credited.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_DONR_CODE
 
 | 
| 
AUXILIARY_DONOR_CATEGORY_DESC
 | 
Auxiliary Donor Category Description 
 | 
Pledge donor category description.
 | 
VARCHAR2(255)
 | 
 
 | 
 ATVDONR
 
 | 
 ATVDONR_DESC
 
 | 
| 
AUXILIARY_ISSUE_DATE
 | 
Auxiliary Issue Date 
 | 
Date the Pledge Auxiliary data was issued.
 | 
DATE
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_ISSUE_DATE
 
 | 
| 
AUXILIARY_TYPE
 | 
Auxiliary Type 
 | 
Type of auxiliary information detailed in this record. Examples include specified donor categories or class years, details related to quid pro quo benefits/premiums or the face/market values of the pledge.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_AUXL_CODE
 
 | 
| 
AUXILIARY_TYPE_DESC
 | 
Auxiliary Type Description 
 | 
Auxiliary type description.
 | 
VARCHAR2(255)
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_AUXL_DESC
 
 | 
| 
AUXILIARY_VALUE
 | 
Auxiliary Value 
 | 
Dependant on the corresponding auxiliary code. May include the fair market value of an associated benefit/premium or the present market value of a pledge.
 | 
NUMBER
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_AUXL_AMOUNT
 
 | 
| 
ENTITY_IND
 | 
Entity Indicator 
 | 
Indicates whether entity is a person or an organization.
 | 
VARCHAR2(1)
 | 
 
 | 
 FUNCTION
 
 | 
 F_FORMAT_NAME
 
 | 
| 
ENTITY_UID
 | 
Entity UID 
 | 
Unique identifying number of person making Pledge.
 | 
NUMBER
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_PIDM
 
 | 
| 
ID
 | 
ID 
 | 
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
 | 
VARCHAR2(63)
 | 
 
 | 
 SPRIDEN
 
 | 
 SPRIDEN_ID
 
 | 
| 
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
 
 | 
 F_FORMAT_NAME
 
 | 
| 
PLEDGE_ADJUSTMENT_IND
 | 
Pledge Adjustment Indicator 
 | 
Indicates if adjustments have been made to the gift/payment amount.
 | 
VARCHAR2(1)
 | 
 
 | 
 CALCULATION
 
 | 
 DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)
 
 | 
| 
PLEDGE_NUMBER
 | 
Pledge Number 
 | 
Number of the pledge.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_PLEDGE_NO
 
 | 
| 
PLEDGE_VOID_IND
 | 
Pledge Void Indicator 
 | 
Indicates if the gift has been voided.
 | 
VARCHAR2(1)
 | 
 
 | 
 CALCULATION
 
 | 
 DECODE(AGRPAUX_PLDG_ADJ_VOID_IND)
 
 | 
| 
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
 
 | 
| 
USER_ID
 | 
User ID 
 | 
Unique identification code of the user who entered or last touched the transaction.
 | 
VARCHAR2(63)
 | 
 
 | 
 AGRPAUX
 
 | 
 AGRPAUX_USER
 
 |