Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONFIRMED bit   Default = 0
 DATECONFIRMED datetime
 REJECTED bit   Default = 0
 DATEREJECTED datetime
 SOURCE nvarchar(100)   Default = ''
 MGID int   Default = 0
 REVISION int   Default = 0
 ORIGINALID int   Default = 0
 NEWROW bit   Default = 0
 CDATE datetime
 CVALUE money   Default = 0
 CNOTES nvarchar(1024)   Default = ''
 FULLHASH nvarchar(32)   Default = ''
 PARTIALHASH nvarchar(32)   Default = ''
 MC nvarchar(3)   Default = ''
 BB_FULLNAME nvarchar(100)   Default = ''
 COMPANY nvarchar(100)   Default = ''
 LONGTITLE nvarchar(100)   Default = ''
 TICKER nvarchar(8)   Default = ''
 AGE int   Default = 0
 BIOGRAPHY nvarchar(1500)   Default = ''
 OFFICER_DIRECTORFLAG nvarchar(35)   Default = ''
 OFFSTARTY UDT_YEAR   Default = ((0))
 DIRSTARTY UDT_YEAR   Default = ((0))
 LATESTCOMPENSATIONYEAR UDT_YEAR   Default = ((0))
 LATESTFISCALYEARSALARY money   Default = 0
 LATESTFISCALYEARBONUS money   Default = 0
 LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION money   Default = 0
 VALUEOFOPTIONSEXERCISED money   Default = 0
 VALUEOFOPTIONSUNEXERCISED_EXERCISABLE money   Default = 0
 VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE money   Default = 0
 LATESTFISCALYEAROTHERLONGTERMCOMPENSATION money   Default = 0
 VIEWED bit   Default = 0
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 TOTALCOMPENSATION money (Computed) LATESTFISCALYEARSALARY+LATESTFISCALYEARBONUS
 RECURSIVEMATCH bit   Default = 0

Foreign Key Field Type Null Notes Description
 WEALTHID uniqueidentifier   WEALTH.ID FK to WEALTH
 CONFIRMEDBYAPPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 REJECTEDBYAPPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WPINCOMECOMPENSATION_DATEADDED DATEADDED    
 IX_WPINCOMECOMPENSATION_DATECHANGED DATECHANGED      
 IX_WPINCOMECOMPENSATION_WEALTHID WEALTHID      
 PK_WPINCOMECOMPENSATION ID  

Trigger Name Description
 TR_WPINCOMECOMPENSATION_AUDIT_UPDATE
 TR_WPINCOMECOMPENSATION_AUDIT_DELETE

Entity-Relationship diagram of this table