NAMES

Description: |
The table extracts data from the Person Name (EAN) master file. These records store name information (first/last, academic suffix, etc).

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | VARCHAR | No |
The is the internal ID of the record
2 | RECORD_NAME | VARCHAR | No |
This is the name of the record
3 | LAST_NAME | VARCHAR | No |
Stores the person's last name.
4 | LAST_NAME_SPOUSE | VARCHAR | No |
Stores the part of the person's last name from their spouse.
5 | FIRST_NAME | VARCHAR | No |
Stores the person's first name.
6 | MIDDLE_NAME | VARCHAR | No |
Stores the person's middle name.
7 | LAST_NAME_PREFIX | VARCHAR | No |
Stores the person's last name prefix.
8 | PREFERRED_NAME | VARCHAR | No |
Stores the name the person prefers to be called.
9 | GIVEN_NAME_INITIALS | VARCHAR | No |
The initials for the person's given names.
10 | FATHER_NAME | VARCHAR | No |
Stores the person's father's name.
11 | GRANDFATHER_NAME | VARCHAR | No |
Stores the person's grandfather's name.