| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
PROSPECT_ID
|
Unique identification number assigned to a person or organization that is used externally for all communication and correspondence with the person.
|
VARCHAR2(255)
|
SPRIDEN
|
SPRIDEN_ID
|
NO
|
NO
|
ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE
|
|
PROSPECT_KEY
|
System generated, unique, internal primary key for a prospect.
|
NUMBER
|
|
|
|
NO
|
|
|
PROSPECT_NAME
|
Prospect Entity's name. For Banner this is the constituent's name. For Advance, In most cases this is the same as the Constituent name, but it may be different.
|
VARCHAR2(255)
|
EXPRESSION
|
PROSPECT_NAME_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE
|
|
PROSPECT_NAME_SORT
|
Prospect name used for sorting purposes.
|
VARCHAR2(255)
|
EXPRESSION
|
PROSPECT_NAME_SORT_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
SYSTEM_LOAD_PROCESS
|
'PROSPECT_D1B'
|
NO
|
NO
|
ANALYZE FUNDRAISING, ASSIGNMENT, CONSTITUENT EVALUATION, CONTACT REPORT, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, PROPOSAL, PROPOSAL PURPOSE, PROPOSAL PURPOSE RESULT, PROPOSAL PURPOSE STAGE, PROPOSAL STAGE, PROSPECT, PROSPECT ENTITY, PROSPECT INTEREST, PROSPECT STAGE
|
|
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
|
|