| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
PROSPECT_AFFILIATION
|
Information about a prospect's affiliations, both inside and outside of the institution.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_AFFILIATION_LD
|
Prospect affiliation long description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_AFFILIATION_SD
|
Prospect affiliation short description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_ATTRIBUTE_KEY
|
System generated, unique, internal primary key for a prospect attribute.
|
TABLE
|
ETL_GENERATED
|
TABLE_SEQUENCE
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_CLASSIFICATION
|
Classifies the prospect in a subcategory. Example: Top 100 prospects, VIP prospects, Chancellor's Circle. NOTE: this does not replace or replicate information supported by program.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_CLASSIFICATION_LD
|
Prospect classification long description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_CLASSIFICATION_SD
|
Prospect classification short description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_GROUP
|
Prospect group affiliation within the institution to which the prospect is assigned. This can be used for prospect security.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_GROUP_LD
|
Prospect group short description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_GROUP_SD
|
Prospect group short description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_REFERRAL
|
Determines how the constituent became a prospect.
|
TABLE
|
AMRINFO
|
AMRINFO_REFR_CODE
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_REFERRAL_LD
|
Prospect referral long description.
|
TABLE
|
ATVREFR
|
ATVREFR_DESC
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_REFERRAL_SD
|
Prospect referral short description.
|
TABLE
|
ATVREFR
|
ATVREFR_DESC
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_STATUS
|
Identifies the reference assessment of the current state of the prospect.
|
TABLE
|
AMRINFO
|
AMRINFO_STATUS
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_STATUS_LD
|
Prospect status long description.
|
TABLE
|
EXPRESSION
|
PROSPECT_STATUS_LD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_STATUS_SD
|
Prospect status short description.
|
TABLE
|
EXPRESSION
|
PROSPECT_STATUS_SD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
PROSPECT_TYPE
|
Prospect type used to categorize prospects for cultivation. Example: Individual, Joint, Family, Corporate, Foundation, Government.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_TYPE_LD
|
Prospect type long description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROSPECT_TYPE_SD
|
Prospect type short description.
|
TABLE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
STRATEGY_PLAN_EXISTS_IND
|
Indicates whether a strategy plan exists for the prospect.
|
TABLE
|
EXPRESSION
|
STRATEGY_PLAN_EXISTS_IND_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
STRATEGY_PLAN_EXISTS_IND_LD
|
Strategy plan exists indicator long description.
|
TABLE
|
EXPRESSION
|
STRATEGY_PLAN_EXISTS_IND_LD_EXPRESSION
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
STRATEGY_PLAN_EXISTS_IND_SD
|
Strategy plan exists indicator short description.
|
TABLE
|
EXPRESSION
|
STRATEGY_PLAN_EXISTS_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.
|
TABLE
|
SYSTEM_LOAD_PROCESS
|
'PROSPECT_ATTRIBUTE_D1B'
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
TABLE
|
NA
|
SYSDATE
|
NO
|
NO
|
MANAGE PROSPECT PIPELINE, PROSPECT
|