Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 JOBID nvarchar(50)   Default = '' The job ID returned for this result from the Prospect Quick Search service.
 DUNSNUM int   Default = 0 The duns number of the business ownership result.
 CONFIDENCE tinyint   Default = 0 The confidence of the business ownership result.
 FIRSTNAME nvarchar(50)   Default = '' The first name for the business ownership result.
 MIDDLENAME nvarchar(50)   Default = '' The middle name for the business ownership result.
 LASTNAME nvarchar(50)   Default = '' The last name for the business ownership result.
 SUFFIX nvarchar(50)   Default = '' The suffix for the business ownership result.
 COMPANY nvarchar(30)   Default = '' The company for the business ownership result.
 ADDRESS nvarchar(25)   Default = '' The address for the business ownership result.
 CITY nvarchar(20)   Default = '' The city for the business ownership result.
 STATE nvarchar(2)   Default = '' The state for the business ownership result.
 ZIP nvarchar(10)   Default = '' The zip for the business ownership result.
 PHONE nvarchar(20)   Default = '' The phone numer for the business ownership result.
 MATCHTYPE nvarchar(300)   Default = '' The match type for the business ownership result.
 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.
 FULLNAME nvarchar(300)   Default = '' Full name of the business ownership result.

Foreign Key Field Type Null Notes Description
 PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier   PARTIALINFORMATIONSEARCHCRITERIA.ID The ID of the Prospect Quick Search criteria that returned the business ownership result.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_DATEADDED DATEADDED    
 IX_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_DATECHANGED DATECHANGED      
 IX_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_DUNSNUM DUNSNUM      
 IX_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_PARTIALINFORMATIONSEARCHCRITERIAID PARTIALINFORMATIONSEARCHCRITERIAID      
 PK_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP ID  

Trigger Name Description
 TR_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_AUDIT_UPDATE
 TR_PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP_AUDIT_DELETE

Referenced by Field
 PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID

Entity-Relationship diagram of this table