Item Field Name Data Type Description
1 CompanyName Varchar Company Name
2 CompanyID Int Unique ID field of Company
3 FirstName Varchar Employee First Name
4 LastName Varchar Employee Last Name
5 Department Varchar Department of Employee
6 Title Varchar Employee Title
7 Email Varchar Employee Email
8 Address1 Varchar Address 1
9 Address2 Varchar Address 2
10 City Varchar City
11 State Varchar State
12 Zip Varchar Zip
13 Phone Varchar Phone
14 Ext Varchar Extension
15 Fax Varchar Fax Number
16 Press Varchar Type of Press
17 NewsText Varchar Press Details
18 PressURL Varchar Url or press news
19 Small Varchar Industry Small Category
20 Industry Varchar Industry Main Category
21 DateCreated Date/Time Date Press Record was Created
22 EmployeeID Int Unique ID field of Employee
23 AboutCo LongText Paragraph about company
24 WebsiteJobOpenings Varchar How many jobs on Co website
25 YearlyRevRange Varchar Yearly Revenue Range
26 EmployeeRange Varchar Amount of employees Range