| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACTIVE_PROPOSAL_IND
|
Indicates whether the proposal is active or inactive.
|
NUMBER
|
EXPRESSION
|
ACTIVE_PROPOSAL_IND_EXPRESSION
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
ACTIVE_PROPOSAL_IND_LD
|
Active proposal indicator long description.
|
VARCHAR2(255)
|
EXPRESSION
|
ACTIVE_PROPOSAL_IND_LD_EXPRESSION
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
ACTIVE_PROPOSAL_IND_SD
|
Active proposal indicator short description.
|
VARCHAR2(255)
|
EXPRESSION
|
ACTIVE_PROPOSAL_IND_SD_EXPRESSION
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
PROPOSAL_ATTRIBUTE_KEY
|
System generated, unique, internal primary key for donor proposal attributes.
|
NUMBER
|
|
|
|
NO
|
|
|
PROPOSAL_FUNDING_TYPE
|
Funding type determines the method of funding for the prospect or program prospect. Example: Multi-year pledge, Gift-in-kind, Bequest, One-time gift.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_FUNDING_TYPE_LD
|
Proposal funding type long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_FUNDING_TYPE_SD
|
Proposal funding type short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_PLAN_GIFT_IND
|
Indicates whether this proposal is a planned gift.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
PROPOSAL_PLAN_GIFT_IND_LD
|
Proposal planned gift indicator long description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
PROPOSAL_PLAN_GIFT_IND_SD
|
Proposal planned gift indicator short description.
|
VARCHAR2(255)
|
CONSTANT
|
'NO'
|
NO
|
NO
|
|
|
PROPOSAL_STATUS
|
Proposal status. Examples: Needs internal approval, pending, denied by donor, approved by donor.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_STATUS_LD
|
Proposal status long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_STATUS_SD
|
Proposal status short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_SUBMIT_TYPE
|
Submit type qualifies the proposal type for a corporate or foundation proposal (e.g., 'New', 'Renewal', 'Continuing', 'Preliminary', etc.).
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_SUBMIT_TYPE_LD
|
Proposal submit type long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_SUBMIT_TYPE_SD
|
Proposal submit type short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
PROPOSAL_TYPE
|
Type of proposal linked to a prospect or program prospect. Examples: specified area of interest, planned giving, grant, or verbal, written proposal.
|
VARCHAR2(63)
|
AMBPROP
|
AMBPROP_PROP_CODE
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
PROPOSAL_TYPE_LD
|
Proposal type long description.
|
VARCHAR2(255)
|
ATVPROP
|
ATVPROP_DESC
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
PROPOSAL_TYPE_SD
|
Proposal type short description.
|
VARCHAR2(255)
|
ATVPROP
|
ATVPROP_DESC
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
SYSTEM_LOAD_PROCESS
|
'PROPOSAL_ATTRIBUTE_D1B'
|
NO
|
NO
|
CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL
|
|
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
|
|