Entity Definition

Logical Name : NameSuffix
Physical Name : PA_NM_SFX

Additional information, typically provided with a name, to indicate an honor, position, degree, or office. Examples include: - B. Sc. - Ph.D - ISP - KBE - Esq. - Sr. - Jr. - III

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
NameSuffixCode (PK) A code that describes a name suffix. For example, junior, senior, III, Ph.D., etc. LU_NM_SFX Code6 char(6)
SuffixName A name of a person name suffix. NM_SFX Name varchar(40)
SuffixDescription A short description of a person name suffix. DE_SFX DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
NameSuffix is used by PersonNameSuffix

Logical Views containing NameSuffix

Logical View
Logical 06315 - Party - Person Names View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 07010 - Customer Account Information Extended