V_QUERY_WPBIOGRAPHICALDEMOGRAPHIC
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| WEALTHID | uniqueidentifier | ||
| CONFIRMED | bit | ||
| DATECONFIRMED | datetime | yes | |
| CONFIRMEDBYAPPUSERID | uniqueidentifier | yes | |
| REJECTED | bit | ||
| DATEREJECTED | datetime | yes | |
| REJECTEDBYAPPUSERID | uniqueidentifier | yes | |
| SOURCE | nvarchar(100) | ||
| MC | nvarchar(3) | ||
| MCDESCRIPTION | nvarchar(100) | yes | |
| FULLNAME | nvarchar(500) | ||
| BIRTHDATE | UDT_FUZZYDATE | ||
| MARITALSTATUS | nvarchar(100) | yes | |
| OCCUPATION | nvarchar(100) | ||
| CNOTES | nvarchar(1024) | ||
| HOUSEHOLD_MOSAIC | nvarchar(100) | ||
| HOUSEHOLD_INCOME | nvarchar(100) | yes | |
| DISCRETIONARY_SPEND | money | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | |
| VIEWED | bit |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:12:57 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_WPBIOGRAPHICALDEMOGRAPHIC AS
select
WPBD.ID,
WPBD.WEALTHID,
WPBD.CONFIRMED,
WPBD.DATECONFIRMED,
WPBD.CONFIRMEDBYAPPUSERID,
WPBD.REJECTED,
WPBD.DATEREJECTED,
WPBD.REJECTEDBYAPPUSERID,
WPBD.SOURCE,
WPBD.MC,
dbo.UFN_WPMATCHCODE_DESCRIPTION(WPBD.MC) MCDESCRIPTION,
WPBD.FULLNAME,
WPBD.BIRTHDATE,
WPBD.MARITALSTATUS,
WPBD.OCCUPATION,
WPBD.CNOTES,
WPBD.HOUSEHOLD_MOSAIC,
HHINCOME.DESCRIPTION as HOUSEHOLD_INCOME,
WPBD.DISCRETIONARY_SPEND,
WPBD.DATEADDED,
WPBD.DATECHANGED,
WPBD.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
WPBD.VIEWED
/*#EXTENSION*/
from
dbo.WPBIOGRAPHICALDEMOGRAPHIC WPBD
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = WPBD.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = WPBD.CHANGEDBYID
left join dbo.HOUSEHOLDINCOMEESTIMATECODE HHINCOME on WPBD.HOUSEHOLD_INCOMECODEID = HHINCOME.ID