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.	TABLE	EXPRESSION	PLDG_INCLUDE_IN_GIVING_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLDG_INCLUDE_IN_GIVING_IND_LD	Pledge include in giving indicator long description.	TABLE	EXPRESSION	PLDG_INCLUDE_IN_GIVING_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLDG_INCLUDE_IN_GIVING_IND_SD	Pledge include in giving indicator short description.	TABLE	EXPRESSION	PLDG_INCLUDE_IN_GIVING_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ACTIVE_IND	Determines whether the pledge is active or inactive.	TABLE	EXPRESSION	PLEDGE_ACTIVE_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ACTIVE_IND_LD	Pledge active indicator long description.	TABLE	EXPRESSION	PLEDGE_ACTIVE_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ACTIVE_IND_SD	Pledge active indicator short description.	TABLE	EXPRESSION	PLEDGE_ACTIVE_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ADJUSTED_IND	Determines whether the pledge has been adjusted.	TABLE	EXPRESSION	PLEDGE_ADJUSTED_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ADJUSTED_IND_LD	Pledge adjusted indicator long description.	TABLE	EXPRESSION	PLEDGE_ADJUSTED_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ADJUSTED_IND_SD	Pledge adjusted indicator short description.	TABLE	EXPRESSION	PLEDGE_ADJUSTED_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ANONYMOUS_IND	Determines whether the pledge is anonymous.	TABLE	EXPRESSION	PLEDGE_ANONYMOUS_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ANONYMOUS_IND_LD	Pledge anonymous indicator long description.	TABLE	EXPRESSION	PLEDGE_ANONYMOUS_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_ANONYMOUS_IND_SD	Pledge anonymous indicator short description.	TABLE	EXPRESSION	PLEDGE_ANONYMOUS_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_BINDING_IND	Determine whether the pledge is binding.	TABLE	CONSTANT	0	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_BINDING_IND_LD	Pledge binding indicator long description.	TABLE	CONSTANT	'NO'	NO	NO
PLEDGE_BINDING_IND_SD	Pledge binding indicator short description.	TABLE	CONSTANT	'NO'	NO	NO
PLEDGE_CAE_TYPE	Predefined code describing the purpose for giving as defined for Voluntary Support of Education (VSE) reporting.	TABLE	ATVPLDG	ATVPLDG_CFAE_PLDG_CATG	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CAE_TYPE_LD	Pledge type for Voluntary Support of Education reporting long description.	TABLE	EXPRESSION	PLEDGE_CAE_TYPE_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CAE_TYPE_SD	Pledge type for Voluntary Support of Education reporting short description.	TABLE	EXPRESSION	PLEDGE_CAE_TYPE_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CATEGORY	Pledge category assigned to the pledge.	TABLE	AGBPLDG	AGBPLDG_PCAT_CODE	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CATEGORY_LD	Pledge category long description.	TABLE	ATVPCAT	ATVPCAT_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CATEGORY_SD	Pledge category short description.	TABLE	ATVPCAT	ATVPCAT_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_1	First pledge classification such as anonymous, memorial, etc..	TABLE	AGBPLDG	AGBPLDG_PCLS_CODE	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_1_LD	First pledge classification long description.	TABLE	ATVPCLS	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_1_SD	First pledge classification short description.	TABLE	ATVPCLS	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_2	Second pledge classification.	TABLE	AGBPLDG	AGBPLDG_PCLS_CODE	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_2_LD	Second pledge classification long description.	TABLE	ATVPCLS	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_2_SD	Second pledge classification short description.	TABLE	ATVPCLS	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_3	Third pledge classification.	TABLE	AGBPLDG	AGBPLDG_PCLS_CODE	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_3_LD	Third gift classification long description.	TABLE	ATVPCLS	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CLASS_3_SD	Third pledge classification short description.	TABLE	ATVPCLS	ATVPCLS_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CONDITIONAL_IND	Determines whether the pledge is conditional.	TABLE	EXPRESSION	PLEDGE_CONDITIONAL_IND_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CONDITIONAL_IND_LD	Pledge conditional indicator long description.	TABLE	EXPRESSION	PLEDGE_CONDITIONAL_IND_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_CONDITIONAL_IND_SD	Pledge conditional indicator short description.	TABLE	EXPRESSION	PLEDGE_CONDITIONAL_IND_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_EFT_TYPE	Pledge electronic funds transfer type.	TABLE	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_EFT_TYPE_LD	Pledge electronic funds transfer type long description.	TABLE	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_EFT_TYPE_SD	Pledge electronic funds transfer type short description.	TABLE	NO SOURCE	NO SOURCE	NO	NO
PLEDGE_INSTALLMENT_IND	Determines whether the pledge is an installment	TABLE	CONSTANT	0	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_INSTALLMENT_IND_LD	Pledge installment indicator long description.	TABLE	CONSTANT	'NO'	NO	NO
PLEDGE_INSTALLMENT_IND_SD	Pledge installment indicator short description.	TABLE	CONSTANT	'NO'	NO	NO
PLEDGE_KEY	System generated, unique, internal primary key for a pledge.	TABLE	ETL_GENERATED	TABLE_SEQUENCE	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_PAID_STATUS	Ppledge paid status. Values are (FP) - Pledge Fully Paid, (PP) - Pledge Partially Paid, and (NP) - Pledge Not Paid.	TABLE	EXPRESSION	PLEDGE_PAID_STATUS_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_PAID_STATUS_LD	Pledge paid status long description.	TABLE	EXPRESSION	PLEDGE_PAID_STATUS_LD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_PAID_STATUS_SD	Pledge paid status short description.	TABLE	EXPRESSION	PLEDGE_PAID_STATUS_SD_EXPRESSION	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_RECORDABLE_IND	Determines whether the pledge is recordable.	TABLE	CONSTANT	0	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_RECORDABLE_IND_LD	Pledge recordable indicator long description.	TABLE	CONSTANT	'NO'	NO	NO
PLEDGE_RECORDABLE_IND_SD	Pledge recordable indicator short description.	TABLE	CONSTANT	'NO'	NO	NO
PLEDGE_STATUS	Pledge status. Example values are (A)ctive, (I)nactive and (P)aid.	TABLE	AGBPLDG	AGBPLDG_PSTA_CODE	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_STATUS_LD	Pledge status long description.	TABLE	ATVPSTA	ATVPSTA_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_STATUS_SD	Pledge status short description.	TABLE	ATVPSTA	ATVPSTA_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_TYPE	Pledge type.	TABLE	AGBPLDG	AGBPLDG_PLDG_CODE	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_TYPE_LD	Pledge type indicator long description.	TABLE	ATVPLDG	ATVPLDG_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
PLEDGE_TYPE_SD	Pledge type indicator short description.	TABLE	ATVPLDG	ATVPLDG_DESC	NO	NO	ANALYZE FUNDRAISING, PLEDGE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	TABLE	SYSTEM_LOAD_PROCESS	'PLEDGE_D1B'	NO	NO	ANALYZE FUNDRAISING, PLEDGE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	TABLE	NA	SYSDATE	NO	NO	ANALYZE FUNDRAISING, PLEDGE

Ver: 8.2