pecos_associate_name

Name information for PECOS associates.

Foreign Keys:

• pac_id => pecos_associate.pac_id

Indexes:

• pecos_associate_name_name_last_or_organization_idx - name_last_or_organization
• pecos_associate_name_uq (Unique) - pac_id, name_last_or_organization, name_first, name_middle

Column	Data Type	Nullable	Indexed	Description
pac_id	bigint	No	Yes	PECOS Associate Control ID - unique ID assigned to a unique SSN or EIN
name_last_or_organization	text	No	Yes	Last name or organization name
name_first	text	No	Yes	First / given name
name_middle	text	No	Yes	Middle name
first_seen_date	date	No	No	-
last_seen_date	date	No	No	-