TI_PERS_INFO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	TI_REQUISITION_NBR	Character(20)	VARCHAR2(20) NOT NULL	Taleo Requisition Number
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
6	EMAIL_ADDRESS	Long Character	CLOB	Email Addresses
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
9	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
10	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
11	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
14	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
15	HOME_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Home Phone #
16	WORK_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Work Phone #
17	MOBILE_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Mobile Phone Number
18	TI_PAGER_NUMBER	Character(24)	VARCHAR2(24) NOT NULL	Pager Phone number field for Taleo Integration Project.
19	BIRTH_DT	Date(10)	DATE	Actual Birth Date
20	TI_DVM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Taleo-DVM Identifier
21	TI_PERS_JOB_FLAG	Character(1)	VARCHAR2(1) NOT NULL	TI_PERS_JOB_FLAG