| 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
|
|
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(1)
|
AGRPCON
|
AGRPCON_MET_IND
|
NO
|
NO
|
|
CONDITION_MET_DESC
|
Description of the condition met.
|
VARCHAR2(6)
|
CALCULATION
|
DECODE(AGRPCON_MET_IND)
|
NO
|
NO
|
|
CONDITION_TYPE
|
Pledge Condition Type Code.
|
VARCHAR2(5)
|
AGRPCON
|
AGRPCON_CTYP_CODE
|
NO
|
NO
|
|
CONDITION_TYPE_DESC
|
Description of the Pledge condition type.
|
VARCHAR2(30)
|
FUNCTION
|
ATVCTYP_DESC
|
NO
|
NO
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
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
|
|
MIF_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
|
PLEDGE_NUMBER
|
Number of the pledge.
|
VARCHAR2(7)
|
AGRPCON
|
AGRPCON_PLEDGE_NO
|
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(30)
|
AGRPCON
|
AGRPCON_USER
|
NO
|
NO
|
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|