ALIAS

This table contains aliases for constituents.

For the full definition of the ALIAS table, see ALIAS.

Fields

Field	Change	Field Type	Null	Notes	Description
NAME	Changed	nvarchar(606) (Computed)	yes	rtrim( case when TITLECODEID is not null then dbo.UFN_TITLECODE_GETDESCRIPTION(TITLECODEID) + ' ' else '' end + case when TITLE2CODEID is not null then dbo.UFN_TITLECODE_GETDESCRIPTION(TITLE2CODEID) + ' ' else '' end + case when FIRSTNAME <> '' then FIRSTNAME + ' ' else '' end + case when MIDDLENAME <> '' then MIDDLENAME + ' ' else '' end + 'KEYNAME + ' ' + case when SUFFIXCODEID is not null then dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIXCODEID) + ' ' else '' end + case when SUFFIX2CODEID is not null then dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIX2CODEID) else '' end)	Expression changed from rtrim( case when TITLECODEID is not null then dbo.UFN_TITLECODE_GETDESCRIPTION(TITLECODEID) + ' ' else '' end + case when TITLE2CODEID is not null then dbo.UFN_TITLECODE_GETDESCRIPTION(TITLE2CODEID) + ' ' else '' end + case when FIRSTNAME <> '' then FIRSTNAME + ' ' else '' end + case when MIDDLENAME <> '' then MIDDLENAME + ' ' else '' end + 'KEYNAME + ' ' + case when SUFFIXCODEID is not null then dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIXCODEID) + ' ' else '' end + case when SUFFIX2CODEID is not null then dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIX2CODEID) else '' end) to rtrim( case when TITLECODEID is not null then dbo.UFN_TITLECODE_GETDESCRIPTION(TITLECODEID) + ' ' else '' end + case when TITLE2CODEID is not null then dbo.UFN_TITLECODE_GETDESCRIPTION(TITLE2CODEID) + ' ' else '' end + case when FIRSTNAME <> '' then FIRSTNAME + ' ' else '' end + case when MIDDLENAME <> '' then MIDDLENAME + ' ' else '' end + 'KEYNAME + ' ' + case when SUFFIXCODEID is not null then dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIXCODEID) + ' ' else '' end + case when SUFFIX2CODEID is not null then dbo.UFN_SUFFIXCODE_GETDESCRIPTION(SUFFIX2CODEID) else '' end)