NAMES_STATIC

Description:

The table holds extracted data from the Non-Patient Person Name (EAM) master file. These records store name information (first/last, academic suffix, etc) for static master files referencing people (User (EMP), Provider (SER), and so forth).

Primary Key

Column Name	Ordinal Position
RECORD_ID	1

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	VARCHAR	No
	The unique identifier for the name record.
2	RECORD_NAME	VARCHAR	No
	Internationally formatted non-patient name of the person.
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
	Stores the initials for the person's given name.