|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|