WPRELATIONSHIP_NPA_IND (4.0SP20)

ID

uniqueidentifier

WPRELATIONSHIP_NPA_ID

uniqueidentifier

false

FK to WPRELATIONSHIP_NPA

CONSTITUENTID

uniqueidentifier

true

FK to CONSTITUENT

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

LASTNAME

nvarchar(100)

false

FIRSTNAME

nvarchar(50)

false

MIDDLE

nvarchar(50)

false

SUFFIX

nvarchar(50)

false

TITLE

nvarchar(70)

false

CITY

nvarchar(50)

false

STATE

nvarchar(2)

false

ZIP

nvarchar(10)

false

LASTDATE

datetime

true

YROBSERVE

nvarchar(100)

false

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

SPOUSEFLAG

bit

false

FULLNAME

nvarchar(206) (Computed)

true

IX_WPRELATIONSHIP_NPA_IND_CONSTITUENTID

False

False

False

IX_WPRELATIONSHIP_NPA_IND_DATEADDED

False

False

True

IX_WPRELATIONSHIP_NPA_IND_DATECHANGED

False

False

False

IX_WPRELATIONSHIP_NPA_IND_WPRELATIONSHIP_NPA_ID

False

False

False

PK_WPRELATIONSHIP_NPA_IND

True

True

False

TR_WPRELATIONSHIP_NPA_IND_AUDIT_DELETE

TR_WPRELATIONSHIP_NPA_IND_AUDIT_UPDATE