V_QUERY_WPAFFLUENCEINDICATOR
Select all WealthPoint Affluence Indicator data.
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 |
| REJECTED | bit | Rejected | |
| DATEREJECTED | datetime | yes | Date rejected |
| REJECTEDBYAPPUSERID | uniqueidentifier | yes | REJECTEDBYBYAPPUSERID |
| SOURCE | nvarchar(100) | Source | |
| MC | nvarchar(3) | Match code | |
| MCDESCRIPTION | nvarchar(100) | yes | Match code description |
| PHONE | nvarchar(20) | Phone | |
| GENDER | nvarchar(7) | yes | Gender |
| MULTIMILLN | nvarchar(25) | Millionaire code | |
| WEALTHIND | nvarchar(1000) | Wealth indicators | |
| RPASSETS | money | Retirement plan assets | |
| FULLNAME | nvarchar(100) | Full name | |
| CNOTES | nvarchar(1024) | Notes | |
| 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 |
| VIEWED | bit | Viewed | |
| ADDRESSTYPE | nvarchar(25) | Address type | |
| LINE1 | nvarchar(100) | Address | |
| CITY | nvarchar(25) | City | |
| STATE | nvarchar(2) | State | |
| ZIP | nvarchar(5) | ZIP | |
| COUNTY | nvarchar(20) | County | |
| TITLE | nvarchar(50) | Job title | |
| COMPANY | nvarchar(50) | Company | |
| WEBSITE | nvarchar(200) | Website | |
| SALES | money | Sales | |
| EMPLOYMENT | int | Employees | |
| NAICS | nvarchar(100) | NAICS | |
| AGE | nvarchar(7) | Age | |
| DONOR | nvarchar(250) | Donor type | |
| MARITAL | nvarchar(25) | Marital status | |
| CHILDRENINDICATOR | nvarchar(200) | Children | |
| INCOME | nvarchar(25) | Income | |
| CONTRIBUTOR | nvarchar(35) | Contributor type | |
| POLITICALAFFILIATION | nvarchar(25) | Political affiliation | |
| RELIGIOUSAFFILIATION | nvarchar(25) | Religious affiliation | |
| ETHNIC | nvarchar(50) | Ethnicity | |
| RECURSIVEMATCH | bit |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:09:26 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_WPAFFLUENCEINDICATOR AS
select
WPAFFLUENCEINDICATOR.ID,
WPAFFLUENCEINDICATOR.WEALTHID,
WPAFFLUENCEINDICATOR.CONFIRMED,
WPAFFLUENCEINDICATOR.DATECONFIRMED,
WPAFFLUENCEINDICATOR.CONFIRMEDBYAPPUSERID,
WPAFFLUENCEINDICATOR.REJECTED,
WPAFFLUENCEINDICATOR.DATEREJECTED,
WPAFFLUENCEINDICATOR.REJECTEDBYAPPUSERID,
WPAFFLUENCEINDICATOR.SOURCE,
WPAFFLUENCEINDICATOR.MC,
dbo.UFN_WPMATCHCODE_DESCRIPTION(WPAFFLUENCEINDICATOR.MC) MCDESCRIPTION,
WPAFFLUENCEINDICATOR.PHONE,
WPAFFLUENCEINDICATOR.GENDER,
WPAFFLUENCEINDICATOR.MULTIMILLN,
WPAFFLUENCEINDICATOR.WEALTHIND,
WPAFFLUENCEINDICATOR.RPASSETS,
WPAFFLUENCEINDICATOR.FULLNAME,
WPAFFLUENCEINDICATOR.CNOTES,
WPAFFLUENCEINDICATOR.DATEADDED,
WPAFFLUENCEINDICATOR.DATECHANGED,
WPAFFLUENCEINDICATOR.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
WPAFFLUENCEINDICATOR.VIEWED,
WPAFFLUENCEINDICATOR.ADDRESSTYPE,
WPAFFLUENCEINDICATOR.LINE1,
WPAFFLUENCEINDICATOR.CITY,
WPAFFLUENCEINDICATOR.STATE,
WPAFFLUENCEINDICATOR.ZIP ,
WPAFFLUENCEINDICATOR.COUNTY,
WPAFFLUENCEINDICATOR.TITLE,
WPAFFLUENCEINDICATOR.COMPANY,
WPAFFLUENCEINDICATOR.WEBSITE,
WPAFFLUENCEINDICATOR.SALES,
WPAFFLUENCEINDICATOR.EMPLOYMENT,
WPAFFLUENCEINDICATOR.NAICS,
WPAFFLUENCEINDICATOR.AGE,
WPAFFLUENCEINDICATOR.DONOR,
WPAFFLUENCEINDICATOR.MARITAL,
WPAFFLUENCEINDICATOR.CHILDRENINDICATOR,
WPAFFLUENCEINDICATOR.INCOME,
WPAFFLUENCEINDICATOR.CONTRIBUTOR,
WPAFFLUENCEINDICATOR.POLITICALAFFILIATION,
WPAFFLUENCEINDICATOR.RELIGIOUSAFFILIATION,
WPAFFLUENCEINDICATOR.ETHNIC,
WPAFFLUENCEINDICATOR.RECURSIVEMATCH
/*#EXTENSION*/
from
dbo.WPAFFLUENCEINDICATOR
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = WPAFFLUENCEINDICATOR.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = WPAFFLUENCEINDICATOR.CHANGEDBYID