UPG_HRS_NMD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
3	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name
4	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
7	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
8	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
9	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
10	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix
11	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
12	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
13	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
15	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
16	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
17	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
18	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Name
19	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
20	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
21	PARTNER_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
22	PARTNER_ROY_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
23	LAST_NAME_PREF_NLD	Character(1)	VARCHAR2(1) NOT NULL	The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name. 1=Own Name 2=Name Partner 3=Name Partner + Own Name 4=Own Name + Name Partner
24	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
25	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.