GPTH_BENEF_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GP_ELN_SET	Character(15)	VARCHAR2(15) NOT NULL	Element Set
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
4	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Default Value: 01
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
7	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
8	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
9	BIRTHDATE	Date(10)	DATE	Date of Birth
10	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
11	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
12	GPTH_NAME1	Character(80)	VARCHAR2(80) NOT NULL	Tax-Payee's First Name
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
15	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description