| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACTIVE_PROSPECT_IND
|
Indicates whether the prospect status is active.
|
NUMBER
|
EXPRESSION
|
ACTIVE_PROSPECT_IND_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
ACTIVE_PROSPECT_IND_LD
|
Active prospect indicator long description.
|
VARCHAR2(255)
|
AMRPRRT
|
ACTIVE_PROSPECT_IND_LD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
ACTIVE_PROSPECT_IND_SD
|
Active prospect indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
ACTIVE_PROSPECT_IND_SD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
MAJOR_PROSPECT
|
User-defined value for the type of major prospect.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MAJOR_PROSPECT_IND
|
Indicates whether the prospect is currently flagged as a major prospect under cultivation.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
MAJOR_PROSPECT_IND_LD
|
Major prospect indicator long description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
MAJOR_PROSPECT_IND_SD
|
Major prospect indicator short description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
MAJOR_PROSPECT_LD
|
Major prospect long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
MAJOR_PROSPECT_SD
|
Major prospect short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PLANNED_GIVING_PROSPECT_IND
|
Indicates whether the prospect is currently flagged as a planned giving prospect.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PLANNED_GIVING_PROSPECT_IND_LD
|
Planned giving prospect indicator long description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
PLANNED_GIVING_PROSPECT_IND_SD
|
Planned giving prospect indicator short description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
PROSPECT_COMMITTEE
|
Groups program-prospects in a hierarchical structure by committee.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_COMMITTEE_LD
|
Prospect committee long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_COMMITTEE_SD
|
Prospect committee short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_CONTACT_RESULT
|
Determines result of the solicitation contact.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_CONTACT_RESULT_IND
|
Indicates whether the contact produced a solicitation result.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_CONTACT_RESULT_IND_LD
|
Prospect contact result indicator long description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
PROSPECT_CONTACT_RESULT_IND_SD
|
Prospect contact result indicator short description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
PROSPECT_CONTACT_RESULT_LD
|
Prospect contact result long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_CONTACT_RESULT_SD
|
Prospect contact result short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_RATING
|
General rating assigned to the prospect during cultivation. Example: $1,000 - 10,000, or High, Medium, Low.
|
VARCHAR2(63)
|
AMRPRRT
|
PROSPECT_RATING_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_RATING_LD
|
Prospect rating long description.
|
VARCHAR2(255)
|
EXPRESSION
|
PROSPECT_RATING_LD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_RATING_SD
|
Prospect rating short description.
|
VARCHAR2(255)
|
EXPRESSION
|
PROSPECT_RATING_SD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_RATING_STATUS
|
Provides a clearance for the rating range for which a prospect has been identified for cultivation/solicitation. Example: Rating in Research, Rating Approved.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_RATING_STATUS_LD
|
Prospect rating status long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_RATING_STATUS_SD
|
Prospect rating status short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_REGION
|
Groups program-prospects in a hierarchical structure by region.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_REGION_LD
|
Prospect region long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_REGION_SD
|
Prospect region short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_SHARED_ATTRIBUTE_KEY
|
|
NUMBER
|
|
|
|
NO
|
|
|
PROSPECT_TEAM
|
Groups program-prospects in a hierarchical structure by team.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_TEAM_LD
|
Prospect team long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_TEAM_SD
|
Prospect team short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RATED_PROSPECT_IND
|
Indicates whether the prospect is currently rated.
|
NUMBER
|
EXPRESSION
|
RATED_PROSPECT_IND_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
RATED_PROSPECT_IND_LD
|
Rated prospect indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
RATED_PROSPECT_IND_LD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
RATED_PROSPECT_IND_SD
|
Rated prospect indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
RATED_PROSPECT_IND_SD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
SOLICITATION_PRIORITY
|
Specifies the period during which active cultivation of the prospect is to begin.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
SOLICITATION_PRIORITY_LD
|
Solicitation priority long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
SOLICITATION_PRIORITY_SD
|
Solicitation priority short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
SOLICITOR_ASSIGNED_IND
|
Indicates whether the prospect has an assigned solicitor.
|
NUMBER
|
EXPRESSION
|
SOLICITOR_ASSIGNED_IND_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
SOLICITOR_ASSIGNED_IND_LD
|
Solicitor assigned indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
SOLICITOR_ASSIGNED_IND_LD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
SOLICITOR_ASSIGNED_IND_SD
|
Solicitor assigned indicator short description.
|
VARCHAR2(255)
|
AMRPRRT
|
SOLICITOR_ASSIGNED_IND_SD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
SYSTEM_LOAD_PROCESS
|
'PROSPECT_SHARED_ATTRIBUTE_D1B'
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
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
|
|