Open topic with navigation

ALIAS (4.0SP20)

This table contains aliases for constituents.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

CONSTITUENTID

uniqueidentifier

false

FK to CONSTITUENT

ALIASTYPECODEID

uniqueidentifier

true

FK to ALIASTYPECODE

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

TITLECODEID

uniqueidentifier

true

FK to TITLECODE

TITLE2CODEID

uniqueidentifier

true

FK to TITLECODE

SUFFIXCODEID

uniqueidentifier

true

FK to SUFFIXCODE

SUFFIX2CODEID

uniqueidentifier

true

FK to SUFFIXCODE
Fields
Field Field Type Null Notes Description

KEYNAME

nvarchar(100)

false

''

FIRSTNAME

nvarchar(50)

false

''

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

MIDDLENAME

nvarchar(50)

false

''

NAME

nvarchar(606) (Computed)

true

Indexes
Index Name Field(s) Unique Primary Clustered

IX_ALIAS_DATEADDED

DATEADDED

False

False

True

IX_ALIAS_DATECHANGED

DATECHANGED

False

False

False

IX_ALIAS_KEYNAME

KEYNAME

False

False

False

PK_ALIAS

ID

True

True

False

UIX_ALIAS_CONSTITUENTID_KEYNAME_FIRSTNAME_MIDDLENAME_TITLECODEID_TITLE2CODEID_SUFFIXCODEID_SUFFIX2CODEID

CONSTITUENTID

KEYNAME

FIRSTNAME

MIDDLENAME

TITLECODEID

TITLE2CODEID

SUFFIXCODEID

SUFFIX2CODEID

True

False

False
Triggers
Trigger Name Description

TR_ALIAS_AUDIT_UPDATE

TR_ALIAS_INSERT_SEARCHCONSTITUENT

TR_ALIAS_AUDIT_DELETE

TR_ALIAS_UPDATE_SEARCHCONSTITUENT

TR_ALIAS_DELETE_SEARCHCONSTITUENT

Referenced by
Referenced by Field

TAXDECLARATION

ALIASID

VENDOR1099SETTING

NAMEFIRSTLINEALIASTYPECODEID

VENDOR1099SETTING

NAMESECONDLINEALIASTYPECODEID