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

Ver: