Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
|
This table contains data regarding the employees of Xtreme Mountain Bikes.
| Field Name | Data Type | Field Size/Format | Description |
|---|---|---|---|
| Employee ID | Number | Long Integer | Unique identification number assigned to each employee. |
| Supervisor ID | Number | Long Integer | Unique identification number assigned to the employee's supervisor. |
| Last Name | Text | 20 | Last name of the employee. |
| First Name | Text | 10 | First name of the employee. |
| Position | Text | 30 | Employee's position. |
| Birth Date | Date/Time | Short Date (MM/DD/YYYY) | Employee's birth date. |
| Hire Date | Date/Time | Short Date (MM/DD/YYYY) | Employee's hire date. |
| Home Phone | Text | 20 | Phone number includes country code or area code. |
| Extension | Text | 4 | Internal telephone extension number. |
| Photo | OLE Object | (N/A) | Picture of employee. |
| Notes | Memo | 64,000 | General information about employee's background. |
| Reports To | Number | Long Integer | Employee's supervisor. |
| Salary | Currency | Currency | Employee's salary. |
| SSN | Text | 12 | Employee's social security number. |
| Emergency Contact First Name | Text | 20 | First name of the employee's emergency contact. |
| Emergency Contact Last Name | Text | 20 | Last name of the employee's emergency contact. |
| Emergency Contact Relationship | Text | 20 | Relationship between the employee and the emergency contact. |
| Emergency Contact Phone | Text | 20 | The emergency contact's phone number. |
|