V_QUERY_WPLEXISNEXIS
WPLexisNexis
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 | |
| CNOTES | nvarchar(1024) | Notes | |
| MC | nvarchar(2) | Match code | |
| MCDESCRIPTION | nvarchar(100) | yes | Match code description |
| DEEDTYPE | nvarchar(100) | Deed type | |
| DOCUMENTNUMBER | nvarchar(200) | Document number | |
| SALEPRICE | money | Sale price | |
| RECORDEDDATE | nvarchar(200) | Recorded date | |
| SALEDATE | datetime | yes | Sale date |
| BUYERMAILINGADDRESS | nvarchar(200) | Buyer mailing address | |
| SELLERMAILINGADDRESS | nvarchar(200) | Seller mailing address | |
| SELLER | nvarchar(300) | Seller | |
| BUYER | nvarchar(300) | Buyer | |
| LEGALDESCRIPTION | nvarchar(2000) | Legal description | |
| PROPERTYUSE | nvarchar(100) | Property use | |
| LOTSIZE | nvarchar(50) | Lot size | |
| ROOF | nvarchar(30) | Roof | |
| FOUNDATION | nvarchar(30) | Foundation | |
| EXTERIORWALLS | nvarchar(30) | Exterior walls | |
| BASEMENT | nvarchar(30) | Basement | |
| CONSTRUCTION | nvarchar(30) | Construction | |
| HEATING | nvarchar(30) | Heating | |
| AIRCONDITIONING | nvarchar(30) | Air conditioning | |
| STYLE | nvarchar(30) | Style | |
| ELEVATOR | nvarchar(5) | Elevator | |
| NOOFBUILDINGS | nvarchar(5) | Number of buildings | |
| BUILDINGAREA | nvarchar(10) | Building area | |
| GARAGETYPE | nvarchar(30) | Garage type | |
| FIREPLACE | nvarchar(5) | Fireplace | |
| TOTALROOMS | nvarchar(5) | Total rooms | |
| PARTIALBATHS | nvarchar(5) | Partial baths | |
| BATHS | nvarchar(5) | Baths | |
| BEDROOMS | nvarchar(5) | Bedrooms | |
| UNITS | nvarchar(10) | Units | |
| STORIES | nvarchar(50) | Stories | |
| POOLSPA | nvarchar(30) | Pool/spa | |
| YEARBUILT | nvarchar(4) | Year built | |
| OWNER | nvarchar(300) | Owner | |
| BB_COUNTY | nvarchar(255) | County | |
| MAILINGADDRESS | nvarchar(200) | Mailing address | |
| TITLECOMPANY | nvarchar(50) | Title company | |
| TERM | nvarchar(20) | Term | |
| LOANAMOUNT | money | Loan amount | |
| TYPEOFMORTGAGE | nvarchar(100) | Type of mortgage | |
| LENDER | nvarchar(100) | Lender | |
| LENDERTYPE | nvarchar(50) | Lender type | |
| LOANTYPE | nvarchar(50) | Loan type | |
| DUEDATE | datetime | yes | Due date |
| ASSESSORSPARCELNUMBER | nvarchar(100) | Assessors parcel number | |
| LANDUSE | nvarchar(100) | Land use | |
| TAXRATECODE | nvarchar(50) | Tax rate code | |
| MARKETIMPROVEMENTVALUE | money | Market improvement value | |
| TOTALMARKETVALUE | money | Market total value | |
| MARKETLANDVALUE | money | Market land value | |
| MARKETVALUEYEAR | nvarchar(4) | Market value year | |
| ASSESSEDMULTIPLIER | nvarchar(5) | Assessed multiplier | |
| ASSESSMENTYEAR | nvarchar(4) | Assessment year | |
| ASSESSEDIMPROVEMENTVALUE | money | Assessed improvement value | |
| ASSESSEDTOTALVALUE | money | Assessed total value | |
| ASSESSEDLANDVALUE | money | Assessed land value | |
| PROPADDRESS | nvarchar(150) | Property address | |
| PROPCITY | nvarchar(50) | Property city | |
| PROPSTATE | nvarchar(100) | Property state | |
| PROPZIP | nvarchar(10) | Property zip | |
| PROPERTYRECORDFOR | nvarchar(50) | Property record for | |
| PROPERTYTRANSFERRECORDFOR | nvarchar(50) | Property transfer record for | |
| BORROWERS | nvarchar(200) | Borrowers | |
| MORTGAGERECORDFOR | nvarchar(50) | Mortgage record for | |
| VALUE | money | Value | |
| 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:14 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_WPLEXISNEXIS AS
select
WPLEXISNEXIS.ID,
WPLEXISNEXIS.WEALTHID,
WPLEXISNEXIS.CONFIRMED,
WPLEXISNEXIS.DATECONFIRMED,
WPLEXISNEXIS.CONFIRMEDBYAPPUSERID,
WPLEXISNEXIS.PUBLISHED,
WPLEXISNEXIS.SOURCE,
WPLEXISNEXIS.CNOTES,
WPLEXISNEXIS.MC,
dbo.UFN_WPMATCHCODE_DESCRIPTION(WPLEXISNEXIS.MC) MCDESCRIPTION,
WPLEXISNEXIS.DEEDTYPE,
WPLEXISNEXIS.DOCUMENTNUMBER,
WPLEXISNEXIS.SALEPRICE,
WPLEXISNEXIS.RECORDEDDATE,
WPLEXISNEXIS.SALEDATE,
WPLEXISNEXIS.BUYERMAILINGADDRESS,
WPLEXISNEXIS.SELLERMAILINGADDRESS,
WPLEXISNEXIS.SELLER,
WPLEXISNEXIS.BUYER,
WPLEXISNEXIS.LEGALDESCRIPTION,
WPLEXISNEXIS.PROPERTYUSE,
WPLEXISNEXIS.LOTSIZE,
WPLEXISNEXIS.ROOF,
WPLEXISNEXIS.FOUNDATION,
WPLEXISNEXIS.EXTERIORWALLS,
WPLEXISNEXIS.BASEMENT,
WPLEXISNEXIS.CONSTRUCTION,
WPLEXISNEXIS.HEATING,
WPLEXISNEXIS.AIRCONDITIONING,
WPLEXISNEXIS.STYLE,
WPLEXISNEXIS.ELEVATOR,
WPLEXISNEXIS.NOOFBUILDINGS,
WPLEXISNEXIS.BUILDINGAREA,
WPLEXISNEXIS.GARAGETYPE,
WPLEXISNEXIS.FIREPLACE,
WPLEXISNEXIS.TOTALROOMS,
WPLEXISNEXIS.PARTIALBATHS,
WPLEXISNEXIS.BATHS,
WPLEXISNEXIS.BEDROOMS,
WPLEXISNEXIS.UNITS,
WPLEXISNEXIS.STORIES,
WPLEXISNEXIS.POOLSPA,
WPLEXISNEXIS.YEARBUILT,
WPLEXISNEXIS.OWNER,
WPLEXISNEXIS.BB_COUNTY,
WPLEXISNEXIS.MAILINGADDRESS,
WPLEXISNEXIS.TITLECOMPANY,
WPLEXISNEXIS.TERM,
WPLEXISNEXIS.LOANAMOUNT,
WPLEXISNEXIS.TYPEOFMORTGAGE,
WPLEXISNEXIS.LENDER,
WPLEXISNEXIS.LENDERTYPE,
WPLEXISNEXIS.LOANTYPE,
WPLEXISNEXIS.DUEDATE,
WPLEXISNEXIS.ASSESSORSPARCELNUMBER,
WPLEXISNEXIS.LANDUSE,
WPLEXISNEXIS.TAXRATECODE,
WPLEXISNEXIS.MARKETIMPROVEMENTVALUE,
WPLEXISNEXIS.TOTALMARKETVALUE,
WPLEXISNEXIS.MARKETLANDVALUE,
WPLEXISNEXIS.MARKETVALUEYEAR,
WPLEXISNEXIS.ASSESSEDMULTIPLIER,
WPLEXISNEXIS.ASSESSMENTYEAR,
WPLEXISNEXIS.ASSESSEDIMPROVEMENTVALUE,
WPLEXISNEXIS.ASSESSEDTOTALVALUE,
WPLEXISNEXIS.ASSESSEDLANDVALUE,
WPLEXISNEXIS.PROPADDRESS,
WPLEXISNEXIS.PROPCITY,
WPLEXISNEXIS.PROPSTATE,
WPLEXISNEXIS.PROPZIP,
WPLEXISNEXIS.PROPERTYRECORDFOR,
WPLEXISNEXIS.PROPERTYTRANSFERRECORDFOR,
WPLEXISNEXIS.BORROWERS,
WPLEXISNEXIS.MORTGAGERECORDFOR,
WPLEXISNEXIS.VALUE,
WPLEXISNEXIS.DATEADDED,
WPLEXISNEXIS.DATECHANGED,
WPLEXISNEXIS.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
/*#EXTENSION*/
from
dbo.WPLEXISNEXIS
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = WPLEXISNEXIS.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = WPLEXISNEXIS.CHANGEDBYID