Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 LASTNAME nvarchar(100)   Default = ''
 FIRSTNAME nvarchar(50)   Default = ''
 MIDDLENAME nvarchar(50)   Default = ''
 SUFFIX nvarchar(50)   Default = ''
 TITLE nvarchar(30)   Default = ''
 YEAROFBIRTH UDT_YEAR   Default = ((0))
 GENDERCODE tinyint   Default = 0 0=Unknown, 1=Male, 2=Female, 3=Business
 GENDER nvarchar(8) (Computed) CASE [GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' WHEN 3 THEN N'Business' END Provides a translation for the 'GENDERCODE' field.
 ADDRESS1 nvarchar(100)   Default = ''
 CITY1 nvarchar(50)   Default = ''
 STATE1 nvarchar(2)   Default = ''
 ZIP1 nvarchar(10)   Default = ''
 ADDRESS2 nvarchar(100)   Default = ''
 CITY2 nvarchar(50)   Default = ''
 STATE2 nvarchar(2)   Default = ''
 ZIP2 nvarchar(10)   Default = ''
 LASTDATE datetime
 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.
 SPOUSEFLAG bit   Default = 0
 FULLNAME nvarchar(206) (Computed) CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + LASTNAME + CASE SUFFIX WHEN '' THEN '' ELSE ', ' + SUFFIX END

Foreign Key Field Type Null Notes Description
 WPRELATIONSHIP_BO_ID uniqueidentifier   WPRELATIONSHIP_BO.ID FK to WPRELATIONSHIP_BO
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WPRELATIONSHIP_BO_IND_CONSTITUENTID CONSTITUENTID      
 IX_WPRELATIONSHIP_BO_IND_DATEADDED DATEADDED    
 IX_WPRELATIONSHIP_BO_IND_DATECHANGED DATECHANGED      
 IX_WPRELATIONSHIP_BO_IND_WPRELATIONSHIP_BO_ID WPRELATIONSHIP_BO_ID      
 PK_WPRELATIONSHIP_BO_IND ID  

Trigger Name Description
 TR_WPRELATIONSHIP_BO_IND_AUDIT_UPDATE
 TR_WPRELATIONSHIP_BO_IND_AUDIT_DELETE

Entity-Relationship diagram of this table