HRS_APP_NAMES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name
3	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types Default Value: 001 Prompt Table: NAME_FORMAT_TBL
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
6	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix Prompt Table: NAME_PREFIX_TBL
7	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix Prompt Table: NAME_SUFFIX_TBL
8	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix Prompt Table: NM_ROYPREF_GBL
9	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix Prompt Table: NM_ROYSUFF_GBL
10	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title Prompt Table: TITLE_TBL
11	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
12	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
13	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
14	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
15	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
16	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
17	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Name
18	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
19	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
20	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.
21	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. Prompt Table: NM_ROYPREF_GBL
22	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 Default Value: 1
23	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
24	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
25	NAME_DEFAULT_FMT	Character(1)	VARCHAR2(1) NOT NULL	Field used to control the Group Box for the Default Name Field Selection and formatting
26	BEL	Character(1)	VARCHAR2(1) NOT NULL	BEL - Belgium
27	DEU	Character(1)	VARCHAR2(1) NOT NULL	DEU - Germany
28	ESP	Character(1)	VARCHAR2(1) NOT NULL	ESP - Spain
29	NLD	Character(1)	VARCHAR2(1) NOT NULL	NLD - Netherlands
30	JPN	Character(1)	VARCHAR2(1) NOT NULL	JPN - Japan
31	ITA	Character(1)	VARCHAR2(1) NOT NULL	Italian HR Functionality/ Person name/ Name
32	HKG	Character(1)	VARCHAR2(1) NOT NULL	HKG - Hong Kong
33	BRA	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify the Brazilian Functionality in HRMS
34	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
35	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
36	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
37	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id