F2_CONTACT_TAO

#	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	RPT_FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Reporting Year
3	RPT_FISCAL_MONTH	Number(2,0)	SMALLINT NOT NULL	Reporting Month
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	PHONE_NUM	Character(12)	VARCHAR2(12) NOT NULL	Phone Number
7	F2_PHONE_EXTENSION	Character(5)	VARCHAR2(5) NOT NULL	Phone Extension
8	AGENCY_NAME_1	Character(40)	VARCHAR2(40) NOT NULL	Agency Name Line 1
9	AGENCY_NAME_2	Character(40)	VARCHAR2(40) NOT NULL	Agency Name Line 2
10	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
11	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
14	ZIP	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
15	SUPERVISORS_NAME	Character(40)	VARCHAR2(40) NOT NULL	Supervisor Name
16	SUPERVISORS_PHONE	Character(12)	VARCHAR2(12) NOT NULL	Supervisor's phone number
17	SUPERVISORS_EXT	Character(5)	VARCHAR2(5) NOT NULL	Supervisor's Phone Ext
18	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
19	FAX_NUM	Character(12)	VARCHAR2(12) NOT NULL	Fax Number
20	F2_MOMS_MAIDN_NAME	Character(30)	VARCHAR2(30) NOT NULL	Mother's Maiden Name