V_QUERY_WPINCOMECOMPENSATION
Select all WealthPoint Income/Compensation 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 |
| SOURCE | nvarchar(100) | Source | |
| CNOTES | nvarchar(1024) | Notes | |
| MC | nvarchar(3) | Match code | |
| MCDESCRIPTION | nvarchar(100) | yes | Match code description |
| BB_FULLNAME | nvarchar(100) | Name | |
| COMPANY | nvarchar(100) | Company | |
| LONGTITLE | nvarchar(100) | Job title | |
| TICKER | nvarchar(8) | Symbol | |
| AGE | int | Age | |
| BIOGRAPHY | nvarchar(1500) | Biography | |
| OFFICER_DIRECTORFLAG | nvarchar(35) | Officer/Director | |
| OFFSTARTY | UDT_YEAR | Officer start | |
| DIRSTARTY | UDT_YEAR | Director start | |
| LATESTCOMPENSATIONYEAR | UDT_YEAR | Year | |
| LATESTFISCALYEARSALARY | money | Salary | |
| LATESTFISCALYEARBONUS | money | Bonus | |
| LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION | money | Other short term compensation | |
| VALUEOFOPTIONSEXERCISED | money | Options exercised | |
| VALUEOFOPTIONSUNEXERCISED_EXERCISABLE | money | Options unexercised | |
| VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE | money | Options unexercisable | |
| LATESTFISCALYEAROTHERLONGTERMCOMPENSATION | money | Other long term compensation | |
| TOTALCOMPENSATION | money | yes | Total compensation |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| REJECTED | bit | Rejected | |
| DATEREJECTED | datetime | yes | Date rejected |
| REJECTEDBYAPPUSERID | uniqueidentifier | yes | REJECTEDBYBYAPPUSERID |
| 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 | ||
| HISTORIC | nvarchar(10) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 10/23/2017 7:39:22 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.173.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_WPINCOMECOMPENSATION AS
select
WPINCOMECOMPENSATION.ID,
WPINCOMECOMPENSATION.WEALTHID,
WPINCOMECOMPENSATION.CONFIRMED,
WPINCOMECOMPENSATION.DATECONFIRMED,
WPINCOMECOMPENSATION.CONFIRMEDBYAPPUSERID,
WPINCOMECOMPENSATION.SOURCE,
WPINCOMECOMPENSATION.CNOTES,
WPINCOMECOMPENSATION.MC,
dbo.UFN_WPMATCHCODE_DESCRIPTION(WPINCOMECOMPENSATION.MC) MCDESCRIPTION,
WPINCOMECOMPENSATION.BB_FULLNAME,
WPINCOMECOMPENSATION.COMPANY,
WPINCOMECOMPENSATION.LONGTITLE,
WPINCOMECOMPENSATION.TICKER,
WPINCOMECOMPENSATION.AGE,
WPINCOMECOMPENSATION.BIOGRAPHY,
WPINCOMECOMPENSATION.OFFICER_DIRECTORFLAG,
WPINCOMECOMPENSATION.OFFSTARTY,
WPINCOMECOMPENSATION.DIRSTARTY,
WPINCOMECOMPENSATION.LATESTCOMPENSATIONYEAR,
WPINCOMECOMPENSATION.LATESTFISCALYEARSALARY,
WPINCOMECOMPENSATION.LATESTFISCALYEARBONUS,
WPINCOMECOMPENSATION.LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION,
WPINCOMECOMPENSATION.VALUEOFOPTIONSEXERCISED,
WPINCOMECOMPENSATION.VALUEOFOPTIONSUNEXERCISED_EXERCISABLE,
WPINCOMECOMPENSATION.VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE,
WPINCOMECOMPENSATION.LATESTFISCALYEAROTHERLONGTERMCOMPENSATION,
WPINCOMECOMPENSATION.TOTALCOMPENSATION,
WPINCOMECOMPENSATION.DATEADDED,
WPINCOMECOMPENSATION.DATECHANGED,
WPINCOMECOMPENSATION.TSLONG,
WPINCOMECOMPENSATION.REJECTED,
WPINCOMECOMPENSATION.DATEREJECTED,
WPINCOMECOMPENSATION.REJECTEDBYAPPUSERID,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
WPINCOMECOMPENSATION.VIEWED,
WPINCOMECOMPENSATION.RECURSIVEMATCH,
WPINCOMECOMPENSATION.HISTORIC
/*#EXTENSION*/
from
dbo.WPINCOMECOMPENSATION
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = WPINCOMECOMPENSATION.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = WPINCOMECOMPENSATION.CHANGEDBYID