EMPLOYEES_LNG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	BUSINESS_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Business Title
5	JOBTITLE	Character(30)	VARCHAR2(30) NOT NULL	Job Title
6	JOBTITLE_ABBRV	Character(10)	VARCHAR2(10) NOT NULL	Short Name
7	DEPTNAME	Character(30)	VARCHAR2(30) NOT NULL	Department Name
8	DEPTNAME_ABBRV	Character(10)	VARCHAR2(10) NOT NULL	Short Name
9	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
10	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
12	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
13	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
14	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.
15	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
16	PREF_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred Last Name
17	PREF_MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred Middle Name
18	PREF_SEC_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred Second Last Name
19	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
20	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
21	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
22	NAME_FORMAL_PSF	Character(60)	VARCHAR2(60) NOT NULL	Preferred Name (PS FORMAT)
23	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
24	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
25	MIDDLE_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Middle Name uppercase search field
26	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
27	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
28	PARTN_LAST_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of partner last name to improve performance on searches.
29	PREF_FIRST_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
30	PREF_LAST_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of preferred last name to improve performance on searches.
31	PREF_MIDL_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of preferred middle name to improve performance on searches.
32	PREF_LAST_SEC_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of preferred second last name to improve performance on searches.
33	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
34	NAME_FORMAL_SRCH	Character(60)	VARCHAR2(60) NOT NULL	Uppercase version of formal name to improve performance on searches.