V_QUERY_WPWHOSWHO
Prospect Wealth Biographical
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| WEALTHID | uniqueidentifier | Wealth ID | |
| CONFIRMED | bit | Confirmed | |
| DATECONFIRMED | datetime | yes | Date confirmed |
| CONFIRMEDBYAPPUSERID | uniqueidentifier | yes | CONFIRMEDBYAPPUSERID |
| PUBLISHED | bit | Published | |
| SOURCE | nvarchar(100) | Source | |
| MC | nvarchar(2) | Match code | |
| MCDESCRIPTION | nvarchar(100) | yes | Match code description |
| FULLNAME | nvarchar(100) | Name | |
| LINE1 | nvarchar(4000) | Home address | |
| CITY | nvarchar(4000) | Home address city | |
| STATE | nvarchar(4000) | Home address state | |
| ZIP | nvarchar(50) | Home address zip | |
| A2LINE1 | nvarchar(4000) | Business address | |
| A2CITY | nvarchar(4000) | Business address city | |
| A2STATE | nvarchar(4000) | Business address state | |
| A2ZIP | nvarchar(50) | Business address zip | |
| SX | nvarchar(6) | Gender | |
| DOB | datetime | yes | Birth date |
| CNOTES | nvarchar(1024) | Notes | |
| BP | nvarchar(120) | Birthplace | |
| DT | UDT_FUZZYDATE | Deceased date | |
| OCC | nvarchar(4000) | Occupation | |
| ED | nvarchar(max) | Education | |
| PR | nvarchar(max) | Family | |
| PO | nvarchar(max) | Positions held | |
| CE | nvarchar(max) | Certifications | |
| CR | nvarchar(max) | Career | |
| HA | nvarchar(max) | Awards | |
| MEMINFO | nvarchar(max) | Memberships | |
| RI | nvarchar(max) | Advocations/Research/Interests | |
| AF | nvarchar(max) | Political/Religious affiliations | |
| CP | nvarchar(max) | Civic/Military service | |
| TH | nvarchar(max) | Thoughts on life | |
| LW | nvarchar(max) | Law | |
| TR | nvarchar(max) | Personal | |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 12/17/2008 2:12:15 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_WPWHOSWHO AS
select
WPWHOSWHO.ID,
WPWHOSWHO.WEALTHID,
WPWHOSWHO.CONFIRMED,
WPWHOSWHO.DATECONFIRMED,
WPWHOSWHO.CONFIRMEDBYAPPUSERID,
WPWHOSWHO.PUBLISHED,
WPWHOSWHO.SOURCE,
WPWHOSWHO.MC,
dbo.UFN_WPMATCHCODE_DESCRIPTION(WPWHOSWHO.MC) MCDESCRIPTION,
WPWHOSWHO.FULLNAME,
WPWHOSWHO.LINE1,
WPWHOSWHO.CITY,
WPWHOSWHO.STATE,
WPWHOSWHO.ZIP,
WPWHOSWHO.A2LINE1,
WPWHOSWHO.A2CITY,
WPWHOSWHO.A2STATE,
WPWHOSWHO.A2ZIP,
WPWHOSWHO.SX,
WPWHOSWHO.DOB,
WPWHOSWHO.CNOTES,
WPWHOSWHO.BP,
WPWHOSWHO.DT,
WPWHOSWHO.OCC,
WPWHOSWHO.ED,
WPWHOSWHO.PR,
WPWHOSWHO.PO,
WPWHOSWHO.CE,
WPWHOSWHO.CR,
WPWHOSWHO.HA,
WPWHOSWHO.MEMINFO,
WPWHOSWHO.RI,
WPWHOSWHO.AF,
WPWHOSWHO.CP,
WPWHOSWHO.TH,
WPWHOSWHO.LW,
WPWHOSWHO.TR,
WPWHOSWHO.DATEADDED,
WPWHOSWHO.DATECHANGED,
WPWHOSWHO.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
/*#EXTENSION*/
from
dbo.WPWHOSWHO
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = WPWHOSWHO.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = WPWHOSWHO.CHANGEDBYID