F2_CONTACT_INFO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	PHONE_NUM	Character(12)	VARCHAR2(12) NOT NULL	Phone Number
5	F2_PHONE_EXTENSION	Character(5)	VARCHAR2(5) NOT NULL	Phone Extension
6	AGENCY_NAME_1	Character(40)	VARCHAR2(40) NOT NULL	Agency Name Line 1
7	AGENCY_NAME_2	Character(40)	VARCHAR2(40) NOT NULL	Agency Name Line 2
8	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
9	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
10	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
11	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
12	ZIP	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: INSTALLATION.COUNTRY Prompt Table: COUNTRY_TBL
14	SUPERVISORS_NAME	Character(40)	VARCHAR2(40) NOT NULL	Supervisor Name
15	SUPERVISORS_PHONE	Character(12)	VARCHAR2(12) NOT NULL	Supervisor's phone number
16	SUPERVISORS_EXT	Character(5)	VARCHAR2(5) NOT NULL	Supervisor's Phone Ext
17	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
18	FAX_NUM	Character(12)	VARCHAR2(12) NOT NULL	Fax Number
19	F2_MOMS_MAIDN_NAME	Character(30)	VARCHAR2(30) NOT NULL	Mother's Maiden Name
20	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.