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
|