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
|
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(1)
|
|
AGRPCON
|
AGRPCON_MET_IND
|
CONDITION_MET_DESC
|
Condition Met Description
|
Description of the condition met.
|
VARCHAR2(6)
|
|
CALCULATION
|
DECODE(AGRPCON_MET_IND)
|
CONDITION_TYPE
|
Condition Type
|
Pledge Condition Type Code.
|
VARCHAR2(5)
|
|
AGRPCON
|
AGRPCON_CTYP_CODE
|
CONDITION_TYPE_DESC
|
Condition Type Description
|
Description of the Pledge condition type.
|
VARCHAR2(30)
|
|
FUNCTION
|
ATVCTYP_DESC
|
CURRENT_DATE
|
Current Date
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
|
NA
|
SYSDATE
|
DOMAIN_VALUE
|
Domain Value
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
|
NA
|
NA
|
ENTITY_UID
|
Entity UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER(8)
|
|
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
|
MIF_DESC
|
MIF Description
|
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
|
MIF_VALUE
|
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
|
PLEDGE_NUMBER
|
Pledge Number
|
Number of the pledge.
|
VARCHAR2(7)
|
|
AGRPCON
|
AGRPCON_PLEDGE_NO
|
SEQUENCE_NUMBER
|
Sequence Number
|
Sequence number of the condition of the Pledge.
|
NUMBER(5)
|
|
AGRPCON
|
AGRPCON_SEQ
|
USER_ID
|
User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
|
AGRPCON
|
AGRPCON_USER
|
ZONE_VALUE
|
Zone Value
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
|
NA
|
NA
|