Dimension Table Target: WDT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Advancement Gift Star Analyze Fundraising Star Pledge Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_PLEDGE

Description Pledge Dimension table provides information on whether the gift was the result of a pledge. This information includes type of pledge, method of pledge and amount of pledge, etc.. It uses the cleansing rules in the EDW for the short and long descriptions and for the ranges for the original and outstanding pledge amounts.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

PLDG_INCLUDE_IN_GIVING_IND Determines whether the pledge amount is to be included in giving totals. NUMBER
EXPRESSION

PLDG_INCLUDE_IN_GIVING_IND_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLDG_INCLUDE_IN_GIVING_IND_LD Pledge include in giving indicator long description. VARCHAR2(255)
EXPRESSION

PLDG_INCLUDE_IN_GIVING_IND_LD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLDG_INCLUDE_IN_GIVING_IND_SD Pledge include in giving indicator short description. VARCHAR2(255)
EXPRESSION

PLDG_INCLUDE_IN_GIVING_IND_SD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ACTIVE_IND Determines whether the pledge is active or inactive. NUMBER
EXPRESSION

PLEDGE_ACTIVE_IND_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ACTIVE_IND_LD Pledge active indicator long description. VARCHAR2(255)
EXPRESSION

PLEDGE_ACTIVE_IND_LD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ACTIVE_IND_SD Pledge active indicator short description. VARCHAR2(255)
EXPRESSION

PLEDGE_ACTIVE_IND_SD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ADJUSTED_IND Determines whether the pledge has been adjusted. NUMBER
EXPRESSION

PLEDGE_ADJUSTED_IND_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ADJUSTED_IND_LD Pledge adjusted indicator long description. VARCHAR2(255)
EXPRESSION

PLEDGE_ADJUSTED_IND_LD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ADJUSTED_IND_SD Short description for the pledge active indicator. VARCHAR2(255)
EXPRESSION

PLEDGE_ADJUSTED_IND_SD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ANONYMOUS_IND Determines whether the pledge is anonymous. NUMBER
EXPRESSION

PLEDGE_ANONYMOUS_IND_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ANONYMOUS_IND_LD Pledge anonymous indicator long description. VARCHAR2(255)
EXPRESSION

PLEDGE_ANONYMOUS_IND_LD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_ANONYMOUS_IND_SD Pledge anonymous indicator short description. VARCHAR2(255)
EXPRESSION

PLEDGE_ANONYMOUS_IND_SD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_BINDING_IND Determine whether the pledge is binding. NUMBER
CONSTANT

0

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_BINDING_IND_LD Pledge binding indicator long description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

PLEDGE_BINDING_IND_SD Pledge binding indicator short description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

PLEDGE_CAE_TYPE Predefined code describing the purpose for giving as defined for Voluntary Support of Education (VSE) reporting. VARCHAR2(63)
ATVPLDG

ATVPLDG_CFAE_PLDG_CATG

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CAE_TYPE_LD Pledge type for Voluntary Support of Education reporting long description. VARCHAR2(255)
EXPRESSION

PLEDGE_CAE_TYPE_LD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CAE_TYPE_SD Pledge type for Voluntary Support of Education reporting short description. VARCHAR2(255)
EXPRESSION

PLEDGE_CAE_TYPE_SD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CATEGORY Pledge category assigned to the pledge. VARCHAR2(63)
AGBPLDG

AGBPLDG_PCAT_CODE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CATEGORY_LD Pledge category long description. VARCHAR2(255)
ATVPCAT

ATVPCAT_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CATEGORY_SD Pledge category short description. VARCHAR2(255)
ATVPCAT

ATVPCAT_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_1 First pledge classification such as anonymous, memorial, etc.. VARCHAR2(63)
AGBPLDG

AGBPLDG_PCLS_CODE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_1_LD First pledge classification long description. VARCHAR2(255)
ATVPCLS_3

ATVPCLS_DESC

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_1_SD First pledge classification short description. VARCHAR2(255)
ATVPCLS_3

ATVPCLS_DESC

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_2 Second pledge classification. VARCHAR2(63)
AGBPLDG

AGBPLDG_PCLS_CODE_2

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_2_LD Second pledge classification long description. VARCHAR2(255)
ATVPCLS_3

ATVPCLS_DESC

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_2_SD Short description for the pledge second classification description. VARCHAR2(255)
ATVPCLS_3

ATVPCLS_DESC

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_3 Third pledge classification. VARCHAR2(63)
AGBPLDG

AGBPLDG_PCLS_CODE_3

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_3_LD Third gift classification long description. VARCHAR2(255)
ATVPCLS_3

ATVPCLS_DESC

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CLASS_3_SD Third pledge classification short description. VARCHAR2(255)
ATVPCLS_3

ATVPCLS_DESC

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CONDITIONAL_IND Identifies whether the pledge is conditional. NUMBER
EXPRESSION

PLEDGE_CONDITIONAL_IND_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CONDITIONAL_IND_LD Pledge conditional indicator long description. VARCHAR2(255)
EXPRESSION

PLEDGE_CONDITIONAL_IND_LD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_CONDITIONAL_IND_SD Pledge conditional indicator short description. VARCHAR2(255)
EXPRESSION

PLEDGE_CONDITIONAL_IND_SD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_EFT_TYPE Pledge electronic funds transfer type. VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

PLEDGE_EFT_TYPE_LD Pledge electronic funds transfer type long description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

PLEDGE_EFT_TYPE_SD Pledge electronic funds transfer type short description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

PLEDGE_INSTALLMENT_IND Determines whether the pledge is an installment. NUMBER
EXPRESSION

PLEDGE_INSTALLMENT_IND_EXPRESSION

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_INSTALLMENT_IND_LD Pledge installment indicator long description. VARCHAR2(255)
EXPRESSION

PLEDGE_INSTALLMENT_IND_LD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_INSTALLMENT_IND_SD Pledge installment indicator short description. VARCHAR2(255)
EXPRESSION

PLEDGE_INSTALLMENT_IND_SD_EXPRESSION

NO
NO ANALYZE FUNDRAISING, PLEDGE

PLEDGE_KEY NUMBER NO

PLEDGE_PAID_STATUS Ppledge paid status. Values are (FP) - Pledge Fully Paid, (PP) - Pledge Partially Paid, and (NP) - Pledge Not Paid. VARCHAR2(63)
EXPRESSION

PLEDGE_PAID_STATUS_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_PAID_STATUS_LD Pledge paid status long description. VARCHAR2(255)
EXPRESSION

PLEDGE_PAID_STATUS_LD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_PAID_STATUS_SD Pledge paid status short description. VARCHAR2(255)
EXPRESSION

PLEDGE_PAID_STATUS_SD_EXPRESSION

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_RECORDABLE_IND Determines whether the pledge is recordable. NUMBER
CONSTANT

0

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_RECORDABLE_IND_LD Pledge recordable indicator long description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

PLEDGE_RECORDABLE_IND_SD Pledge recordable indicator short description. VARCHAR2(255)
CONSTANT

'NO'

NO
NO

PLEDGE_STATUS Pledge status. Example values are (A)ctive, (I)nactive and (P)aid. VARCHAR2(63)
AGBPLDG

AGBPLDG_PSTA_CODE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_STATUS_LD Long description for the pledge status. VARCHAR2(255)
ATVPSTA

ATVPSTA_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_STATUS_SD Pledge status short description. VARCHAR2(255)
ATVPSTA

ATVPSTA_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_TYPE Specifies the type of pledge recorded. VARCHAR2(63)
AGBPLDG

AGBPLDG_PLDG_CODE

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_TYPE_LD Pledge type indicator long description. VARCHAR2(255)
ATVPLDG

ATVPLDG_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

PLEDGE_TYPE_SD Short description defined in the cleansing process. VARCHAR2(255)
ATVPLDG

ATVPLDG_DESC

NO
NO ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)
SYSTEM_LOAD_PROCESS

'PLEDGE_D1B'

NO
NO ANALYZE FUNDRAISING, PLEDGE

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_01 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_01_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_01_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_02 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_02_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_02_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_03 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_03_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_03_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_04 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_04_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_04_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_05 VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_05_LD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

USER_ATTRIBUTE_05_SD VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
PLDG_INCLUDE_IN_GIVING_IND	Determines whether the pledge amount is to be included in giving totals.	NUMBER	EXPRESSION	PLDG_INCLUDE_IN_GIVING_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLDG_INCLUDE_IN_GIVING_IND_LD	Pledge include in giving indicator long description.	VARCHAR2(255)	EXPRESSION	PLDG_INCLUDE_IN_GIVING_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLDG_INCLUDE_IN_GIVING_IND_SD	Pledge include in giving indicator short description.	VARCHAR2(255)	EXPRESSION	PLDG_INCLUDE_IN_GIVING_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ACTIVE_IND	Determines whether the pledge is active or inactive.	NUMBER	EXPRESSION	PLEDGE_ACTIVE_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ACTIVE_IND_LD	Pledge active indicator long description.	VARCHAR2(255)	EXPRESSION	PLEDGE_ACTIVE_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ACTIVE_IND_SD	Pledge active indicator short description.	VARCHAR2(255)	EXPRESSION	PLEDGE_ACTIVE_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ADJUSTED_IND	Determines whether the pledge has been adjusted.	NUMBER	EXPRESSION	PLEDGE_ADJUSTED_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ADJUSTED_IND_LD	Pledge adjusted indicator long description.	VARCHAR2(255)	EXPRESSION	PLEDGE_ADJUSTED_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ADJUSTED_IND_SD	Short description for the pledge active indicator.	VARCHAR2(255)	EXPRESSION	PLEDGE_ADJUSTED_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ANONYMOUS_IND	Determines whether the pledge is anonymous.	NUMBER	EXPRESSION	PLEDGE_ANONYMOUS_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ANONYMOUS_IND_LD	Pledge anonymous indicator long description.	VARCHAR2(255)	EXPRESSION	PLEDGE_ANONYMOUS_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ANONYMOUS_IND_SD	Pledge anonymous indicator short description.	VARCHAR2(255)	EXPRESSION	PLEDGE_ANONYMOUS_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_BINDING_IND	Determine whether the pledge is binding.	NUMBER	CONSTANT	0	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_BINDING_IND_LD	Pledge binding indicator long description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
PLEDGE_BINDING_IND_SD	Pledge binding indicator short description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
PLEDGE_CAE_TYPE	Predefined code describing the purpose for giving as defined for Voluntary Support of Education (VSE) reporting.	VARCHAR2(63)	ATVPLDG	ATVPLDG_CFAE_PLDG_CATG	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CAE_TYPE_LD	Pledge type for Voluntary Support of Education reporting long description.	VARCHAR2(255)	EXPRESSION	PLEDGE_CAE_TYPE_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CAE_TYPE_SD	Pledge type for Voluntary Support of Education reporting short description.	VARCHAR2(255)	EXPRESSION	PLEDGE_CAE_TYPE_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CATEGORY	Pledge category assigned to the pledge.	VARCHAR2(63)	AGBPLDG	AGBPLDG_PCAT_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CATEGORY_LD	Pledge category long description.	VARCHAR2(255)	ATVPCAT	ATVPCAT_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CATEGORY_SD	Pledge category short description.	VARCHAR2(255)	ATVPCAT	ATVPCAT_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_1	First pledge classification such as anonymous, memorial, etc..	VARCHAR2(63)	AGBPLDG	AGBPLDG_PCLS_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_1_LD	First pledge classification long description.	VARCHAR2(255)	ATVPCLS_3	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_1_SD	First pledge classification short description.	VARCHAR2(255)	ATVPCLS_3	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_2	Second pledge classification.	VARCHAR2(63)	AGBPLDG	AGBPLDG_PCLS_CODE_2	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_2_LD	Second pledge classification long description.	VARCHAR2(255)	ATVPCLS_3	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_2_SD	Short description for the pledge second classification description.	VARCHAR2(255)	ATVPCLS_3	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_3	Third pledge classification.	VARCHAR2(63)	AGBPLDG	AGBPLDG_PCLS_CODE_3	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_3_LD	Third gift classification long description.	VARCHAR2(255)	ATVPCLS_3	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_3_SD	Third pledge classification short description.	VARCHAR2(255)	ATVPCLS_3	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CONDITIONAL_IND	Identifies whether the pledge is conditional.	NUMBER	EXPRESSION	PLEDGE_CONDITIONAL_IND_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CONDITIONAL_IND_LD	Pledge conditional indicator long description.	VARCHAR2(255)	EXPRESSION	PLEDGE_CONDITIONAL_IND_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CONDITIONAL_IND_SD	Pledge conditional indicator short description.	VARCHAR2(255)	EXPRESSION	PLEDGE_CONDITIONAL_IND_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_EFT_TYPE	Pledge electronic funds transfer type.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_EFT_TYPE_LD	Pledge electronic funds transfer type long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_EFT_TYPE_SD	Pledge electronic funds transfer type short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_INSTALLMENT_IND	Determines whether the pledge is an installment.	NUMBER	EXPRESSION	PLEDGE_INSTALLMENT_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_INSTALLMENT_IND_LD	Pledge installment indicator long description.	VARCHAR2(255)	EXPRESSION	PLEDGE_INSTALLMENT_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_INSTALLMENT_IND_SD	Pledge installment indicator short description.	VARCHAR2(255)	EXPRESSION	PLEDGE_INSTALLMENT_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_KEY		NUMBER				NO
PLEDGE_PAID_STATUS	Ppledge paid status. Values are (FP) - Pledge Fully Paid, (PP) - Pledge Partially Paid, and (NP) - Pledge Not Paid.	VARCHAR2(63)	EXPRESSION	PLEDGE_PAID_STATUS_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_PAID_STATUS_LD	Pledge paid status long description.	VARCHAR2(255)	EXPRESSION	PLEDGE_PAID_STATUS_LD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_PAID_STATUS_SD	Pledge paid status short description.	VARCHAR2(255)	EXPRESSION	PLEDGE_PAID_STATUS_SD_EXPRESSION	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_RECORDABLE_IND	Determines whether the pledge is recordable.	NUMBER	CONSTANT	0	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_RECORDABLE_IND_LD	Pledge recordable indicator long description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
PLEDGE_RECORDABLE_IND_SD	Pledge recordable indicator short description.	VARCHAR2(255)	CONSTANT	'NO'	NO	NO
PLEDGE_STATUS	Pledge status. Example values are (A)ctive, (I)nactive and (P)aid.	VARCHAR2(63)	AGBPLDG	AGBPLDG_PSTA_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_STATUS_LD	Long description for the pledge status.	VARCHAR2(255)	ATVPSTA	ATVPSTA_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_STATUS_SD	Pledge status short description.	VARCHAR2(255)	ATVPSTA	ATVPSTA_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_TYPE	Specifies the type of pledge recorded.	VARCHAR2(63)	AGBPLDG	AGBPLDG_PLDG_CODE	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_TYPE_LD	Pledge type indicator long description.	VARCHAR2(255)	ATVPLDG	ATVPLDG_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
PLEDGE_TYPE_SD	Short description defined in the cleansing process.	VARCHAR2(255)	ATVPLDG	ATVPLDG_DESC	NO	NO	ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	SYSTEM_LOAD_PROCESS	'PLEDGE_D1B'	NO	NO	ANALYZE FUNDRAISING, PLEDGE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_01_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_02_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_03_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_04_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05		VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_LD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
USER_ATTRIBUTE_05_SD		VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO