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.