WPBIOGRAPHICALHHMEMBER

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
FULLNAME	nvarchar(500)		Default = ''
FIRSTNAME	nvarchar(100)		Default = ''
MIDDLENAME	nvarchar(100)		Default = ''
LASTNAME	nvarchar(100)		Default = ''
SUFFIX	nvarchar(100) (Computed)	yes	dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIXCODEID)
AGE	int (Computed)	yes	dbo.UFN_AGEFROMFUZZYDATE(birthdate, getdate())
BIRTHDATE	UDT_FUZZYDATE		Default = '00000000'
MARITALSTATUS	nvarchar(100) (Computed)	yes	dbo.UFN_MARITALSTATUSCODE_GETDESCRIPTION(MARITALSTATUSCODEID)
OCCUPATION	nvarchar(100)		Default = ''
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
TITLE	nvarchar(100) (Computed)	yes	dbo.UFN_TITLECODE_GETDESCRIPTION(TITLECODEID)
SEQUENCE	int		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
WPBIOGRAPHICALDEMOGRAPHICID	uniqueidentifier		WPBIOGRAPHICALDEMOGRAPHIC.ID
SUFFIXCODEID	uniqueidentifier	yes	SUFFIXCODE.LOCALID
MARITALSTATUSCODEID	uniqueidentifier	yes	MARITALSTATUSCODE.LOCALID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID
TITLECODEID	uniqueidentifier	yes	TITLECODE.LOCALID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_WPBIOGRAPHICALHHMEMBER_DATEADDED	DATEADDED			yes
IX_WPBIOGRAPHICALHHMEMBER_DATECHANGED	DATECHANGED
IX_WPBIOGRAPHICALHHMEMBER_WPBIOGRAPHICALDEMOGRAPHICID	WPBIOGRAPHICALDEMOGRAPHICID
PK_WPBIOGRAPHICALHHMEMBER	ID	yes	yes

Triggers

Trigger Name	Description
TR_WPBIOGRAPHICALHHMEMBER_AUDIT_UPDATE
TR_WPBIOGRAPHICALHHMEMBER_AUDIT_DELETE