Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVITY_DATE
|
Date Pledge Condition was created or last updated.
|
DATE
|
AGRPCON
|
AGRPCON_ACTIVITY_DATE
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
CONDITION_COMMENT
|
Comments related to this pledge condition record.
|
CLOB
|
FUNCTION
|
GOKODSF.F_TRIM_LONGS
|
NO
|
NO
|
CONDITION_DATE
|
Date the Pledge Condition was met or complied with.
|
DATE
|
AGRPCON
|
AGRPCON_MET_DATE
|
NO
|
NO
|
CONDITION_MET
|
Indicates if the Pledge Condition has been met.
|
VARCHAR2(63)
|
AGRPCON
|
AGRPCON_MET_IND
|
NO
|
NO
|
CONDITION_MET_DESC
|
Pledge Condition met description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(AGRPCON_MET_IND)
|
NO
|
NO
|
CONDITION_TYPE
|
Pledge Condition Type Code.
|
VARCHAR2(63)
|
AGRPCON
|
AGRPCON_CTYP_CODE
|
NO
|
NO
|
CONDITION_TYPE_DESC
|
Description of the Pledge condition type.
|
VARCHAR2(255)
|
FUNCTION
|
ATVCTYP_DESC
|
NO
|
NO
|
ENTITY_IND
|
Indicates whether entity is a person or an organization.
|
VARCHAR2(1)
|
FUNCTION
|
MAKFUNC.F_GET_ENTITY_IND
|
NO
|
NO
|
ENTITY_UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
AGRPCON
|
AGRPCON_PIDM
|
NO
|
NO
|
EXPECTED_CONDITION_DATE
|
Date the Pledge Condition is expected to be met or complied with.
|
DATE
|
AGRPCON
|
AGRPCON_EXPECTED_DATE
|
NO
|
NO
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
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
|
NO
|
NO
|
NAME
|
Name of the person (LFMI) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PLEDGE_NUMBER
|
Number of the pledge.
|
VARCHAR2(63)
|
AGRPCON
|
AGRPCON_PLEDGE_NO
|
NO
|
NO
|
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
|
NO
|
NO
|
SEQUENCE_NUMBER
|
Sequence number of the condition of the Pledge.
|
NUMBER
|
AGRPCON
|
AGRPCON_SEQ
|
NO
|
NO
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
AGRPCON
|
AGRPCON_USER
|
NO
|
NO
|