Dimension Table Target: WDT_FUNDRAISING

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Analyze Fundraising Star Assignment Star Contact Report Star Gift Star Manage Prospect Pipeline A Star Manage Prospect Pipeline B Star Matching Claim Star Pledge Star Proposal Purpose Star Proposal Purpose Result Star Proposal Purpose Stage Star Prospect Interest Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FUNDRAISING_INITIATIVE

Description Fundraising initiative dimension table provides information about proposal projects/purposes/interests. It uses the cleansing rules in the EDW for the short and long descriptions.

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

ADVANCEMENT_CATEGORY1 First level used to categorize the prospect or program prospect proposal. VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY1_LD Advancement first category long description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY1_SD Advancement first category short description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY2 Second level used to categorize the prospect or program prospect proposal. This is dependent upon the first category level. VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY2_LD Advancement second category long description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY2_SD Advancement second category short description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY3 Third level used to categorize the prospect or program prospect proposal. This is dependent upon the second category level. VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY3_LD Advancement third category long description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_CATEGORY3_SD Advancement third category short description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

ADVANCEMENT_INTEREST Area of philanthropic interest for the prospect or program prospect. Example: Fellowships, Scholarships, Research. VARCHAR2(63)
AMRPRIN

AMRPRIN_PROJ_CODE

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

ADVANCEMENT_INTEREST_LD Project interest long description. VARCHAR2(255)
ATVPROJ

ATVPROJ_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

ADVANCEMENT_INTEREST_SD Project interest short description. VARCHAR2(255)
ATVPROJ

ATVPROJ_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

FUNDRAISING_INITIATIVE_KEY System generated, unique, internal primary key for a proposal and proposal purpose, prospect interest or contact purpose. NUMBER NO

PROJECT_GIVING_VEHICLE Giving vehicle is the method by which the prospect is expected to donate to the project or interest area. VARCHAR2(63)
AMRPRIN

AMRPRIN_GIVH_CODE

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

PROJECT_GIVING_VEHICLE_LD Giving vehicle long description. VARCHAR2(255)
ATVGIVH

ATVGIVH_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

PROJECT_GIVING_VEHICLE_SD Giving vehicle short description. VARCHAR2(255)
ATVGIVH

ATVGIVH_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

PROPOSAL_PURPOSE Intended 'purposes' or funding break-out for a proposal. It may be used to link a proposal to specific programs to which the prospect is assigned. VARCHAR2(63)
AMRPRIN

AMRPRIN_PROJ_CODE

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

PROPOSAL_PURPOSE_FUND Intended use or purpose of the proposed gift. If allocation is also used, this must be a valid fund for the allocation value provided. Example: Capital Building, Non-restrictive. VARCHAR2(63)
NO SOURCE

NO SOURCE

NO
NO

PROPOSAL_PURPOSE_FUND_LD Proposal purpose fund long description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

PROPOSAL_PURPOSE_FUND_SD Proposal purpose fund short description. VARCHAR2(255)
NO SOURCE

NO SOURCE

NO
NO

PROPOSAL_PURPOSE_LD Proposal purpose long description. VARCHAR2(255)
ATVPROJ

ATVPROJ_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

PROPOSAL_PURPOSE_SD Proposal purpose short description. VARCHAR2(255)
ATVPROJ

ATVPROJ_DESC

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

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

'FUNDRAISING_INITIATIVE_D1B'

NO
NO ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST

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
ADVANCEMENT_CATEGORY1	First level used to categorize the prospect or program prospect proposal.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY1_LD	Advancement first category long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY1_SD	Advancement first category short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY2	Second level used to categorize the prospect or program prospect proposal. This is dependent upon the first category level.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY2_LD	Advancement second category long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY2_SD	Advancement second category short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY3	Third level used to categorize the prospect or program prospect proposal. This is dependent upon the second category level.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY3_LD	Advancement third category long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_CATEGORY3_SD	Advancement third category short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
ADVANCEMENT_INTEREST	Area of philanthropic interest for the prospect or program prospect. Example: Fellowships, Scholarships, Research.	VARCHAR2(63)	AMRPRIN	AMRPRIN_PROJ_CODE	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
ADVANCEMENT_INTEREST_LD	Project interest long description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
ADVANCEMENT_INTEREST_SD	Project interest short description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
FUNDRAISING_INITIATIVE_KEY	System generated, unique, internal primary key for a proposal and proposal purpose, prospect interest or contact purpose.	NUMBER				NO
PROJECT_GIVING_VEHICLE	Giving vehicle is the method by which the prospect is expected to donate to the project or interest area.	VARCHAR2(63)	AMRPRIN	AMRPRIN_GIVH_CODE	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
PROJECT_GIVING_VEHICLE_LD	Giving vehicle long description.	VARCHAR2(255)	ATVGIVH	ATVGIVH_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
PROJECT_GIVING_VEHICLE_SD	Giving vehicle short description.	VARCHAR2(255)	ATVGIVH	ATVGIVH_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
PROPOSAL_PURPOSE	Intended 'purposes' or funding break-out for a proposal. It may be used to link a proposal to specific programs to which the prospect is assigned.	VARCHAR2(63)	AMRPRIN	AMRPRIN_PROJ_CODE	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
PROPOSAL_PURPOSE_FUND	Intended use or purpose of the proposed gift. If allocation is also used, this must be a valid fund for the allocation value provided. Example: Capital Building, Non-restrictive.	VARCHAR2(63)	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_PURPOSE_FUND_LD	Proposal purpose fund long description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_PURPOSE_FUND_SD	Proposal purpose fund short description.	VARCHAR2(255)	NO SOURCE	NO SOURCE	NO	NO
PROPOSAL_PURPOSE_LD	Proposal purpose long description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
PROPOSAL_PURPOSE_SD	Proposal purpose short description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	CONSTANT	'FUNDRAISING_INITIATIVE_D1B'	NO	NO	ANALYZE FUNDRAISING, ASSIGNMENT, CONTACT REPORT, GIFT, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, MATCHING CLAIM, PLEDGE, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROSPECT INTEREST
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