DEP_BEN_NAMELNG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Default Value: 01
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
7	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
10	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First 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	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
14	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
15	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
16	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.
17	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
18	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
19	BEN_ENTITY_NAME	Character(100)	VARCHAR2(100) NOT NULL	Dependent Beneficiary Entity Name