V_QUERY_WPBIOGRAPHICAL
Select all WealthPoint Biographical 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 |
| 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 | |
| GENDER | nvarchar(7) | yes | Gender |
| BIRTHDATE | datetime | yes | Birth date |
| CNOTES | nvarchar(1024) | Notes | |
| BIRTHPLACE | nvarchar(120) | Birthplace | |
| DECEASEDDATE | UDT_FUZZYDATE | Deceased date | |
| OCCUPATION | nvarchar(4000) | Occupation | |
| EDUCATION | nvarchar(max) | Education | |
| FAMILY | nvarchar(max) | Family | |
| POSITIONSHELD | nvarchar(max) | Positions held | |
| CERTIFICATIONS | nvarchar(max) | Certifications | |
| CAREER | nvarchar(max) | Career | |
| AWARDS | nvarchar(max) | Awards | |
| MEMBERSHIPS | nvarchar(max) | Memberships | |
| RESEARCHINTERESTS | nvarchar(max) | Avocations/Research/Interests | |
| POLITICALRELIGIOUSAFFILIATIONS | nvarchar(max) | Political/Religious affiliations | |
| CIVICMILITARYSERVICE | nvarchar(max) | Civic/Military service | |
| THOUGHTSONLIFE | nvarchar(max) | Thoughts on life | |
| LAW | nvarchar(max) | Law | |
| PERSONAL | 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 |
| VIEWED | bit | Viewed | |
| 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_WPBIOGRAPHICAL AS
select
WPBIOGRAPHICAL.ID,
WPBIOGRAPHICAL.WEALTHID,
WPBIOGRAPHICAL.CONFIRMED,
WPBIOGRAPHICAL.DATECONFIRMED,
WPBIOGRAPHICAL.CONFIRMEDBYAPPUSERID,
WPBIOGRAPHICAL.REJECTED,
WPBIOGRAPHICAL.DATEREJECTED,
WPBIOGRAPHICAL.REJECTEDBYAPPUSERID,
WPBIOGRAPHICAL.SOURCE,
WPBIOGRAPHICAL.MC,
dbo.UFN_WPMATCHCODE_DESCRIPTION(WPBIOGRAPHICAL.MC) MCDESCRIPTION,
WPBIOGRAPHICAL.FULLNAME,
WPBIOGRAPHICAL.LINE1,
WPBIOGRAPHICAL.CITY,
WPBIOGRAPHICAL.STATE,
WPBIOGRAPHICAL.ZIP,
WPBIOGRAPHICAL.A2LINE1,
WPBIOGRAPHICAL.A2CITY,
WPBIOGRAPHICAL.A2STATE,
WPBIOGRAPHICAL.A2ZIP,
WPBIOGRAPHICAL.GENDER,
WPBIOGRAPHICAL.BIRTHDATE,
WPBIOGRAPHICAL.CNOTES,
WPBIOGRAPHICAL.BIRTHPLACE,
WPBIOGRAPHICAL.DECEASEDDATE,
WPBIOGRAPHICAL.OCCUPATION,
WPBIOGRAPHICAL.EDUCATION,
WPBIOGRAPHICAL.FAMILY,
WPBIOGRAPHICAL.POSITIONSHELD,
WPBIOGRAPHICAL.CERTIFICATIONS,
WPBIOGRAPHICAL.CAREER,
WPBIOGRAPHICAL.AWARDS,
WPBIOGRAPHICAL.MEMBERSHIPS,
WPBIOGRAPHICAL.RESEARCHINTERESTS,
WPBIOGRAPHICAL.POLITICALRELIGIOUSAFFILIATIONS,
WPBIOGRAPHICAL.CIVICMILITARYSERVICE,
WPBIOGRAPHICAL.THOUGHTSONLIFE,
WPBIOGRAPHICAL.LAW,
WPBIOGRAPHICAL.PERSONAL,
WPBIOGRAPHICAL.DATEADDED,
WPBIOGRAPHICAL.DATECHANGED,
WPBIOGRAPHICAL.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
WPBIOGRAPHICAL.VIEWED,
WPBIOGRAPHICAL.RECURSIVEMATCH
/*#EXTENSION*/
from
dbo.WPBIOGRAPHICAL
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = WPBIOGRAPHICAL.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = WPBIOGRAPHICAL.CHANGEDBYID