Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
|
The Employee Addresses table contains data regarding the address information of Xtreme Mountain Bikes' employees.
| Field Name | Data Type | Length | Description |
|---|---|---|---|
| Employee ID | Number | Long Integer | Number automatically assigned to a new employee. |
| Address1 | Text | 60 | The primary street address information for the employee. |
| Address2 | Text | 20 | A line for secondary address information for the employee. |
| City | Text | 15 | The city of the employee's address. |
| Region | Text | 15 | The region with which the employee is associated. |
| Country | Text | 15 | The country of the employee's address. |
| Postal Code | Text | 10 | The postal code of the employee's address. |
| Emergency Contact Address1 | Text | 60 | The primary street address information for the employee's emergency contact. |
| Emergency Contact Address2 | Text | 20 | The secondary address information for the employee's emergency contact. |
| Emergency Contact City | Text | 15 | The city of the emergency contact's address. |
| Emergency Contact Region | Text | 15 | The region with which the emergency contact is associated. |
| Emergency Contact Country | Text | 15 | The country of the emergency contact's address. |
| Emergency Contact Postal Code | Text | 10 | The postal code of the emergency contact's address. |
|