Employee Addresses


The Employee Addresses table contains data regarding the address information of Xtreme Mountain Bikes' employees.

Table B-4: Employee address data

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.




Mastering Business Analysis with Crystal Reports 9
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors: Chris Tull

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net