| Item |
Field Name |
Data Type |
Description |
| 1 |
CompanyName |
Varchar |
Company Name |
| 2 |
CompanyID |
Int |
Unique ID field of
Company |
| 3 |
EmployeeID |
int |
Unique ID field of
Employee |
| 4 |
FirstName |
Varchar |
Employee First Name |
| 5 |
LastName |
Varchar |
Employee Last Name |
| 6 |
Department |
Varchar |
Department of
Employee |
| 7 |
Title |
Varchar |
Employee Title |
| 8 |
Email |
Varchar |
Employee Email |
| 9 |
Address1 |
Varchar |
Address |
| 10 |
Address2 |
Varchar |
Address2 |
| 11 |
City |
Varchar |
City |
| 12 |
State |
Varchar |
State |
| 13 |
Zip |
Varchar |
Zip |
| 14 |
Extension |
Varchar |
Telephone Extension |
| 15 |
Fax |
Varchar |
Fax Number |
| 16 |
Phone |
Varchar |
Phone Number |
| 17 |
Small |
Varchar |
Narrowed Industry
Category |
| 18 |
Industry |
Varchar |
Broad Industry
Category |
| 19 |
DateCreated |
Date/Time |
Date Record Was
Created |
| 20 |
AboutCompany |
Long Text |
Information about
Company |
| 21 |
WebsiteJobOpenings |
Varchar |
Num Job Openings on
Web |
| 22 |
YearlyRevenues |
Varchar |
Yearly Revenues |
| 23 |
NumberofEmployees |
Varchar |
Number of Employees |
|
|
|
|