Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONFIRMED bit   Default = 0
 DATECONFIRMED datetime
 SOURCE nvarchar(100)   Default = ''
 VIID 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 = ''
 FULLNAME nvarchar(60)   Default = ''
 CUSIP nvarchar(9)   Default = ''
 FILERID nvarchar(20)   Default = ''
 RELATIONSHIP nvarchar(50)   Default = ''
 TICKER nvarchar(8)   Default = ''
 ISSUERNAME nvarchar(60)   Default = ''
 REPORTDATEDIRECT datetime
 REPORTDATEINDIRECT datetime
 AMOUNTOWNEDDIRECT bigint   Default = ((0))
 AMOUNTOWNEDINDIRECT bigint   Default = ((0))
 PRICEDIRECT money   Default = 0
 PRICEINDIRECT money   Default = 0
 VALUEDIRECT money   Default = 0
 VALUEINDIRECT money   Default = 0
 UPDATEDVALUEDIRECT money   Default = 0
 UPDATEDVALUEINDIRECT money   Default = 0
 UPDATEDDATE datetime
 UPDATEDPRICE money   Default = 0
 ACTIVE bit   Default = 0
 VALUE money (Computed)   case when VALUEDIRECT>0 then VALUEDIRECT else VALUEINDIRECT end
 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.
 REJECTED bit   Default = 0
 DATEREJECTED datetime
 VIEWED bit   Default = 0
 RECURSIVEMATCH bit   Default = 0
 SECURITYID int   Default = 0
 SHARESHELDDATE datetime
 ISHISTORICAL bit   Default = 0

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

Index Name Field(s) Unique Primary Clustered
 IX_WPSECURITIES_DATEADDED DATEADDED    
 IX_WPSECURITIES_DATECHANGED DATECHANGED      
 IX_WPSECURITIES_ID ID      
 IX_WPSECURITIES_WEALTHID WEALTHID      
 IX_WPSECURITIES_WEALTHID_FULLHASH WEALTHID, FULLHASH      
 IX_WPSECURITIES_WEALTHID_PARTIALHASH WEALTHID, PARTIALHASH      
 PK_WPSECURITIES ID  

Trigger Name Description
 TR_WPSECURITIES_AUDIT_UPDATE
 TR_WPSECURITIES_AUDIT_DELETE

Referenced by Field
 WPSECURITIESHISTORY WPSECURITIESID
 WPSECURITIESTRANSACTION WPSECURITIESID

Entity-Relationship diagram of this table