pecos_associate_address

Address information for PECOS associates.

Primary Key:

• pac_id
• address_id

Foreign Keys:

• address_id => address_seen.address_id
• pac_id => pecos_associate.pac_id

Indexes:

• pecos_associate_address_address_id_idx - address_id
• pecos_associate_address_pac_id_idx - pac_id

Column	Data Type	Nullable	Indexed	Description
pac_id	bigint	No	Yes	PECOS Associate Control ID - unique ID assigned to a unique SSN or EIN Generated through expression:
address_id	bigint	No	Yes	Address provided for the associate Generated through expression:
first_seen_date	date	No	No	- Generated through expression:
last_seen_date	date	No	No	- Generated through expression: