pecos_associate_name
Name information for PECOS associates.
Foreign Keys:pac_id=>pecos_associate.pac_id
pecos_associate_name_name_last_or_organization_idx-name_last_or_organizationpecos_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 Generated through expression: |
name_last_or_organization | text | No | Yes | Last name or organization name Generated through expression: |
name_first | text | No | Yes | First / given name Generated through expression: |
name_middle | text | No | Yes | Middle name Generated through expression: |
first_seen_date | date | No | No | - Generated through expression: |
last_seen_date | date | No | No | - Generated through expression: |