| 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.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
ADVANCEMENT_CATEGORY1_LD
|
Advancement first category long description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
ADVANCEMENT_CATEGORY1_SD
|
Advancement first category short description.
|
TABLE
|
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.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
ADVANCEMENT_CATEGORY2_LD
|
Advancement second category long description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
ADVANCEMENT_CATEGORY2_SD
|
Advancement second category short description.
|
TABLE
|
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.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
ADVANCEMENT_CATEGORY3_LD
|
Advancement third category long description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
ADVANCEMENT_CATEGORY3_SD
|
Advancement third category short description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
ADVANCEMENT_INTEREST
|
Area of philanthropic interest for the prospect or program prospect. Example: Fellowships, Scholarships, Research.
|
TABLE
|
AMRCONT AMRCONT AMRCONT AMRCONT
|
AMRCONT_PROJ_CODE AMRCONT_PROJ_CODE_2 AMRCONT_PROJ_CODE_3 AMRCONT_PROJ_CODE_4
|
NO NO NO 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
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
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
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.
|
TABLE
|
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.
|
TABLE
|
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.
|
TABLE
|
ETL_GENERATED
|
TABLE_SEQUENCE
|
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
|
Giving vehicle is the method by which the prospect is expected to donate to the project or interest area.
|
TABLE
|
CONSTANT_0
|
NULL
|
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.
|
TABLE
|
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.
|
TABLE
|
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.
|
TABLE
|
AMRCONT AMRCONT AMRCONT AMRCONT
|
AMRCONT_PROJ_CODE AMRCONT_PROJ_CODE_2 AMRCONT_PROJ_CODE_3 AMRCONT_PROJ_CODE_4
|
NO NO NO 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
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
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
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.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_PURPOSE_FUND_LD
|
Proposal purpose fund long description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_PURPOSE_FUND_SD
|
Proposal purpose fund short description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_PURPOSE_LD
|
Proposal purpose long description.
|
TABLE
|
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.
|
TABLE
|
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.
|
TABLE
|
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.
|
TABLE
|
NA
|
SYSDATE
|
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
|