WPPHILANTHROPICGIFT (4.0SP17)

Contains WealthPoint Philanthropic Gift data.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
WEALTHID	uniqueidentifier	false	WEALTH.ID	FK to WEALTH
CONFIRMEDBYAPPUSERID	uniqueidentifier	true	APPUSER.ID	FK to APPUSER
REJECTEDBYAPPUSERID	uniqueidentifier	true	APPUSER.ID	FK to APPUSER
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.

Fields
Field	Field Type	Null	Notes	Description
CONFIRMED	bit	false	0
DATECONFIRMED	datetime	true
REJECTED	bit	false	0
DATEREJECTED	datetime	true
SOURCE	nvarchar(100)	false	''
WMID	int	false	0
REVISION	int	false	0
ORIGINALID	int	false	0
NEWROW	bit	false	0
CDATE	datetime	true
CVALUE	money	false	0
CNOTES	nvarchar(1024)	false	''
FULLHASH	nvarchar(32)	false	''
PARTIALHASH	nvarchar(32)	false	''
MC	nvarchar(3)	false	''
ORGANIZATION	nvarchar(200)	false	''
LOCATION	nvarchar(100)	false	''
GIFTYEAR	UDT_YEAR	false	((0))
GIFTRANGE	nvarchar(50)	false	''
TYPE	nvarchar(75)	false	''
CATEGORY	nvarchar(500)	false	''
LO	money	false	0
HI	money	false	0
NAME	nvarchar(200)	false	''
ORGANIZATIONWEBADDRESS	nvarchar(2000)	false	''
SOURCEMATERIAL	nvarchar(2000)	false	''
GIFTYEARHI	UDT_YEAR	false	((0))
GIFTYEARLO	UDT_YEAR	false	((0))
TYPECODE	int	false	0
EIN	nvarchar(50)	false	''
VIEWED	bit	false	0
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
RECURSIVEMATCH	bit	false	0
MATCHHASH	nvarchar(32)	false	''
PHILANTHROPICGIFTID	int	false	0
HOUSEHOLDID	nvarchar(30)	false	''
TASCORE	int	false	0
MATCHADDRESS	nvarchar(100)	false	''
MATCHCITY	nvarchar(20)	false	''
MATCHSTATE	nvarchar(2)	false	''
MATCHZIP	nvarchar(5)	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_WPPHILANTHROPICGIFT_DATEADDED	DATEADDED	False	False	True
IX_WPPHILANTHROPICGIFT_DATECHANGED	DATECHANGED	False	False	False
IX_WPPHILANTHROPICGIFT_WEALTHID	WEALTHID	False	False	False
IX_WPPHILANTHROPICGIFT_WEALTHID_FULLHASH	WEALTHID FULLHASH	False	False	False
IX_WPPHILANTHROPICGIFT_WEALTHID_MATCHHASH	WEALTHID MATCHHASH	False	False	False
PK_WPPHILANTHROPICGIFT	ID	True	True	False

Triggers
Trigger Name	Description
TR_WPPHILANTHROPICGIFT_AUDIT_UPDATE
TR_WPPHILANTHROPICGIFT_AUDIT_DELETE

Referenced by
Referenced by	Field
WPPHILANTHROPICGIFTCATEGORY	WPPHILANTHROPICGIFTID